Principal Engineer

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 Lo! Foods

India is the Diabetes capital of the world, with 75 Million currently and headed to 100 Million+ within 3-5 years. In addition, between 70-100 Million people are pre-diabetic. This is consequently one of the biggest health problems faced by India, that needs to be addressed at a War footing. 

Lo! Foods, started in 2019, has been a pioneer in cutting down Carbohydrates from Food. They started with a range of Ultra Low Carbohydrate products, that is used by those on a Ketogenic diet or those with Severe Diabetes issues and Type 1 Diabetes. 

Building on their expertise in Cutting down Carbs; while retaining nutrition, flavor and texture; Lo! Foods has also launched a specialist range of daily food products specially formulated for Diabetics. 

Job Role

We are looking for a Medical Sales Representative to promote and sell our diabetic range products. Customers can include doctors, pharmacists, and direct consumers. The medical representative will increase product awareness, answer queries, provide advice and introduce new products.

Key responsibilities include:

• Organizing appointments and meetings with community- and hospital-based healthcare staff
• Identifying and establishing new business
• Negotiating contracts
• Demonstrating or presenting products to healthcare staff including doctors, nurses and pharmacists
• Undertaking relevant research
• Meeting both the business and scientific needs of healthcare professionals
• Maintaining detailed records
• Attending and organising trade exhibitions, conferences and meetings
• Managing budgets
• Reviewing sales performance
• Writing reports and other documents.

Key Skills

• Experience of 5 to 8 years in a medical representative field.
• Should have Commercial awareness. It is good to have experience of handling diabetic products earlier
• Required good Presentation and Research skills
• Should have the ability to negotiate and collaborate contracts and business               deals
• Strong interpersonal and communication skills
• Organisational skills.

We are seeking a skilled MERN Full Stack Developer to join our dynamic team. The ideal candidate will be proficient in both front-end and back-end technologies and possess a passion for developing high-quality web applications. As a MERN Full Stack Developer, you will be responsible for designing, developing, and maintaining robust web applications using the MERN stack.

Responsibilities:

• Collaborate with cross-functional teams to define, design, and ship new features.
• Develop user-facing features using React.js.
• Build reusable components and front-end libraries for future use.
• Design and implement responsive user interfaces.
• Develop and maintain server-side architecture using Node.js and Express.js.
• Integrate data storage solutions using MongoDB.
• Implement RESTful APIs and GraphQL for efficient communication between front-end and back-end systems.
• Optimize applications for maximum speed and scalability.
• Implement security and data protection measures.
• Troubleshoot and debug issues across the entire stack.
• Stay up-to-date with emerging technologies and best practices.

Requirements:

• Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent work experience).
• Proven experience as a Full Stack Developer or similar role.
• Strong proficiency in JavaScript and its modern ES6+ syntax.
• Extensive experience with React.js and its core principles.
• Experience with popular React.js workflows (such as Flux or Redux).
• Solid understanding of server-side development using Node.js and Express.js.
• Experience with NoSQL databases, particularly MongoDB.
• Familiarity with RESTful APIs and GraphQL.
• Knowledge of authentication and authorization mechanisms.
• Experience with version control systems (e.g., Git).
• Excellent communication and collaboration skills.
• Ability to work independently and as part of a team in a fast-paced environment.
• Strong problem-solving skills and attention to detail.

Preferred:

• Experience with cloud platforms (e.g., AWS, Azure, Google Cloud).
• Knowledge of containerization and orchestration technologies (e.g., Docker, Kubernetes).
• Familiarity with CI/CD pipelines.
• Experience with testing frameworks (e.g., Jest, Mocha).
• Understanding of Agile methodologies.

• You have experience with two or more development languages preferably Java or Python and React, etc 
• You can skillfully write high-quality, well-tested code and you are comfortable with Object-Oriented programming
• Comfortability with Agile methods, such as Extreme Programming (XP), Scrum and/or Kanban
• Bonus points if you have working knowledge of cloud technology such as AWS, Azure, Kubernetes and Docker

Job Description: 

Handling desktop issues 

Need to configure, implement, maintain develop and support. 

Network trouble shooting and hardware configuration. 

Should have good working experience on DNS etc, 

Networking design and implementation. 

Hands on experience working on servers will be an added advantage. 

Good communication skills. 

Should be able to join immediately or in a week.