Product Designer

Job Title : Lead Database Engineer

Location : Gurgaon Sector-43

Experience Required : 4+ Years

Employment Type : Full-Time

Summary :

We are seeking a highly skilled Lead Database Engineer with expertise in managing and optimizing database systems, primarily focusing on Amazon Aurora PostgreSQL, MySQL, and NoSQL databases. The ideal candidate will have in-depth knowledge of AWS services, database architecture, performance tuning, and security practices.

Key Responsibilities :

1. Database Administration :

• Manage and administer Amazon Aurora PostgreSQL, MySQL, and NoSQL database systems to ensure high availability, performance, and security.
• Implement robust backup and recovery procedures to maintain data integrity.

2. Optimization and Performance:

• Develop and execute optimization strategies at the database, query, collection, and table levels.
• Proactively monitor performance and fine-tune RDS parameter groups for optimal database operations.
• Conduct root cause analysis and resolve complex database performance issues.

3. AWS Services and Architecture :

• Leverage AWS services such as RDS, Aurora, and DMS to ensure seamless database operations.
• Perform database version upgrades for PostgreSQL and MySQL, integrating new features and performance enhancements.

4. Replication and Scalability:

• Implement and manage various replication strategies, including master-master and master-slave replication, ensuring data consistency and scalability.

5. Security and Access Control:

• Manage user permissions and roles, maintaining strict security protocols and access controls.

6. Collaboration:

• Work closely with development teams to optimize database design and queries, aligning database performance with application requirements.

Required Skills :

• Strong Expertise: Amazon Aurora PostgreSQL, MySQL, and NoSQL databases.
• AWS Services: Experience with RDS, Aurora, and DMS.
• Optimization: Hands-on experience in query optimization, database tuning, and performance monitoring.
• Replication Strategies: Knowledge of master-master and master-slave replication setups.
• Problem Solving: Proven ability to troubleshoot and resolve complex database issues, including root cause analysis.
• Security: Strong understanding of data security and access control practices.
• Collaboration: Ability to work with cross-functional teams and provide database-related guidance.

Preferred Qualifications :

• Certification in AWS or database management tools.
• Experience with other NoSQL databases like MongoDB or Cassandra.
• Familiarity with Agile and DevOps methodologies.

About Us:

Plastic Granules India is a leading manufacturer, exporter, and supplier of high-quality plastic granules, including HDPE, LDPE, LLDPE, ABS, and PE granules. Established in 2015, we export to major international markets, including the UAE, the US, and the UK. We are committed to innovation, quality, and sustainable business practices.

Summary:

We are seeking a highly motivated and creative Digital Marketing Executive to join our team. The ideal candidate will be responsible for managing and optimizing our online presence, driving lead generation, and enhancing brand awareness in the global market. The role requires a deep understanding of SEO, social media marketing, email campaigns, and content strategy to help promote our products and services effectively.

Key Responsibilities:

• Develop and execute digital marketing strategies to promote Plastic Granules India's products globally.
• Manage SEO (Search Engine Optimization) to improve website rankings and organic traffic.
• Create and manage PPC (Pay-Per-Click) campaigns on Google, LinkedIn, and other platforms.
• Oversee social media accounts and create content that aligns with the brand's objectives.
• Monitor website analytics and campaign performance using tools like Google Analytics.
• Design and implement email marketing campaigns to engage with existing and potential customers.
• Collaborate with the design team to create visual content, including banners, graphics, and videos.
• Conduct market research to identify new trends and opportunities in the plastic granules industry.
• Optimize landing pages and user funnels to improve conversion rates.
• Stay up to date with the latest digital marketing trends and best practices.

If you are passionate about digital marketing and want to be a part of a growing industry, we encourage you to apply!

Job Qualifications

• B.E (CS,IT and EC), BCA , MCA , BSC( with Computer Science).
• Skills Required : PHP, Word Press, CMS, Code Igniter.
• Experience in strong PHP Programming skills.
• Good understanding of JavaScript / AJAX is a must.
• Exposure to Agile Methodologies Preferably SCRUM Experience.
• Excellent knowledge in Core PHP & MySQL.
• CMS frameworks like WP, Joomla, Drupal
• Development frameworks like Zend, CakePHP, CodeIgniter, YII etc. will be a plus point
• Strong Knowledge on OOPS and MVC Concept.
• Must have a strong logical & analytical mind.
• Candidate’s are required to adhere and enforce the security policies of the organization.

Job Description

• Interact with clients to determine and analyze the scope of a project.
• Solve complex UX design problems across web, mobile and tablet.
• Experience designing and architecting UI/UX features, interactions on mobile and web.
• Review final layouts to make needed suggestions for improvement
• Recommend to clients strategies to reach a certain audience.
• Design graphics that identify a product or communicate an idea
• Determine colors, images, text style, and shapes to create layout.
• Act as instructor to team of workers that arrange and prepare layout for printing.
• Create electronic version of designs using computer software
• Study information and materials to plan concepts for design.
• Perform administrative duties, such as managing information and assigning tasks to subordinates.

Description of Skills/abilities:

We are looking for a Python Web Developer responsible for managing the interchange of data between the server and the users. Your primary focus will be the development of all server-side logic, ensuring high performance and responsiveness to requests from the front-end. You will also be responsible for integrating the front-end elements built by your co-workers into the application; therefore, a basic understanding of front-end technologies is necessary as well.

Responsibilities:

1. Writing reusable, testable, and efficient code.
2. Design and implementation of low-latency, high-availability, and performant applications.
3. Integration of user-facing elements developed by front-end developers with server side logic.
4. Implementation of security and data protection.
5. Integration of data storage solutions may include databases, key-value stores, blob stores, etc. Experience administering innovation with methodologies such as design thinking.
6. Experience working on Agile Scrum and DevOps aligned delivery teams.
7. Interest and ability to learn other coding languages as needed.
8. Strong communication skills and great product sense.
9. Proficient communication skills verbal and written.
10. Understanding of accessibility and security compliance depending on the specific project.
11. Knowledge of user authentication and authorization between multiple systems, servers, and environments.
12. Understanding of fundamental design principles behind a scalable application.
13. Familiarity with event-driven programming in Python, using of Pycham.
14. Understanding of the differences between multiple deliveries platforms, such as mobile vs desktop, and optimizing output to match the specific platform.
15. Able to create database schemas that represent and support business processes.
16. Strong unit test and debugging skills.

Skills:

1. Expert in Python, with knowledge in Python web framework such as Django, Flask depending on technology stack.
2. Familiarity with some ORM (Object Relational Mapper) libraries.
3. Able to integrate multiple data sources and databases into one system.
4. Understanding of the threading limitations of Python, and multi-process architecture.
5. Good understanding of server-side templating languages such as Jinja 2, Mako, etc depending on your technology stack.
6. Basic understanding of front-end technologies, such as JavaScript, Typescript, react, react hooks, HTML5, and CSS3.
7. Proficient understanding of code versioning tools such as Git, Mercurial or SVN.

Skill Set:

1. 4+Years Full stack Python Developer - exposure to web frameworks like Django, Flask and Falcon.
2. Experience building APIs for a rapidly iterating product and restful APIs and development of services layer using Pythons Flask framework and should be proficient in writing unit test cases using Pytest package.
3. Database level programming using both SQL (MySQL, PostgreSQL, Oracle) and No SQL (Mongo DB/Casandra) and designing the database level stored procedures and persistence logic.
4. HTML/CSS/JavaScript and JavaScript framework and knowledge on React JS is a plus.
5. Experience in developing Arduino libraries is an added advantage.
6. Experience working with two or more from the following: Web Application development, Unix/Linux environments, mobile application development, distributed and parallel systems, machine learning, information retrieval, natural language processing, networking, developing large software systems, and/or security software development

What you need to have: