Executive- Reservation

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.

Role: Java Backend developer

Location: Bangalore

• 4+ years of industrial experience
• Experience in Core Java 1.8 and above, Data Structures, OOPS, Multithreading, Microservices, Spring, Kafka
• Should have the ability to analyse, design, develop and test complex, low-latency client-facing applications.
• Good development experience with RDBMS
• Good knowledge of multi-threading and high volume server side development
• Excellent problem solving and coding skills in Java
• Strong interpersonal, communication and analytical skills.

1. Developing HMI application in Qt or similar UI frameworks
2. Develop C++ or Rust backends for the HMI
3. Understand and optimize potential performance bottlenecks

About Us

Welthungerhilfe (WHH) is an international aid agency headquartered in Germany with its vision for “Zero Hunger by 2030”, the second sustainable development goal set by the UN. It has thousands of programs fighting hunger in more than 30 countries. (https://www.welthungerhilfe.org/">https://www.welthungerhilfe.org)  (https://www.childgrowthmonitor.org/">https://www.childgrowthmonitor.org).

Child Growth Monitor (CGM) is Welthungerhilfe’s digital innovation project leveraging AI to fight child malnutrition. Around 200 million children around the world are suffering from malnutrition. Malnutrition contributes to one-third of deaths of children under the age of five. In the fight against malnutrition, detection is the first important step, but this is not an easy task: Measuring children with traditional methods is still a complex, slow, and expensive task, frequently resulting in poor data and wrong assessments of the child’s health. Early detection of malnutrition becomes the key to initiating treatment, minimizing the risk of complications,

and saving lives by reducing the chances of death to a great extent.

Our solution to measure children replaces hardware (bulky measuring boards and physical scales) with off-the-shelf cell phones and AI. CGM uses augmented reality-enabled smartphones to record 3D scans of children. Artificial Intelligence is used to predict their height, weight, and middle upper-arm circumference needed to know the nutritional status of the children.

What you would do to help us save millions of children's lives

We are looking for you as an experienced Sr Software Engineer who works collaboratively with the dedicated team of tech specialists (AI, ML & Data Scientists) distributed globally have a shared responsibility for ensuring high quality and

Scalable health care product in an agile approach.

This posting concerns a full-time assignment working for Welthungerhilfe’s CGM in a freelance capacity but Full-time employment (payroll) is scheduled for the end of 2022 latest. We are in the process of setting up CGM as a registered social business from mostly January 2023 and moving all the consultants on CGM payrolls.

Responsibilities

• Designing, developing features, refinement/improving and implementing the CGM product in a secure, well-tested, and performant way.
• De-bugging of the current issues
• Collaborate with Product Management and other stakeholders within Engineering (Frontend, UX, etc.) to maintain a high bar for quality in a fast-paced, iterative environment.
• Advocate for improvements to product quality, security, and performance.
• Solve technical problems of moderate scope and complexity.
• Craft code that meets our internal standards for style, maintainability, and best practices for a high-scale Mobile app environment. Maintain and advocate for these standards through code review.
• Provide mentorship for Junior and Intermediate Engineers on your team to help them grow in their technical responsibilities and remove blockers to their autonomy.

 Requirements and skills

• Comfort working in a highly agile, intensely iterative software development process.
• Demonstrated capacity to clearly and concisely communicate about complex technical, architectural, and/or organizational problems and propose thorough iterative solutions.
• Experience with performance and optimization problems and a demonstrated ability to both diagnose and prevent these problems.
• Extensive experience in core Python (3-7yrs)
• Should have worked on Azure or any Cloud and Azure data factory or any similar data platforms
• Experience using Flask/Flutter framework
• Experience working on mobile applications/Web applications (writing flask framework)
• Knowledge of DevOps Pipeline
• Good experience in SQL database
• Working knowledge in Data engineering (ETL pipelines Result Generation Module)
• Basic understanding of front-end technologies such as Vue JS
• Working knowledge in creating predictive models for AI and ML-based features
• Tech /BE in Computer Science with a total of 7 years of software development/Programming experience.

Desired skills

• Good to have an experience in Kubernetes (opensource system)
• Good to have experience working on healthcare mobile apps (predictive analytics and image diagnostics)
• Experience owning a project from concept to production, including proposal, discussion, and execution.
• Proficient understanding of code versioning tools

Soft/Human Skills

• Positive and solution-oriented mindset.
• Excellent communication & interpersonal skills
• Self-motivated and self-managing, with excellent organizational skills.
• Ability to thrive in a fully remote organization

What you need to have:

• 5 to 8 years of hands-on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA
• 5 plus years of experience in the design, development, and implementation of programming code
• Experience in database development
• VBA - Should have good experience in developing efficient logic/algorithms using VBA
• Solid understanding of SDLC concepts
• Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
• Must be good at all excel features and excel formulas
• Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
• Work both independently and as part of a team
• Experience in requirements gathering, effort estimate, designing and implementation, and creating mock-up screens
• Experience in databases like MS SQL Server(2005 to 2012,2014), MySQL, and MS Access
• Must have strong database concepts and DB designing skills
• SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates
• Experience in writing Stored procedures, Triggers and T-SQL
• Nice to have programming knowledge in C# coding should be MANDATORY
• working with C# DLL development and integration with Excel VBA

Interpersonal

• Strong analytical and problem-solving skills
• Excellent interpersonal and communication skills
• Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance
• Should be able to work independently
• Must be Proactive and Self-motivated
• Must have the ability to prioritize the work, execute tasks and meet the deadline without fail
• Effective time management skills
• Customer Focus, Willing to learn and self-teach any new technology
• Strong business and collaboration skills, and responsive to service needs and operational demands

What you bring to the table

• Education: Bachelor's degree in IT, computer science or related
• Experience: 5-9 years of relevant experience for SSE role
• Exposure to microservices, API management tools like Swagger
• Must have experience in working on Agile Scrum teams in the past and exposure to any of the Agile project management tools like Jira, Mingle, RTC, TFS etc.
• Proficient in application log analysis.
• Experience Java/JEE Development - especially EJB 2.1 / 3.0, JDBC
• Experience with application servers such as JBoss AS or IBM WAS is an advantage
• Experience in SQL programing using PostgreSQL / MySQL /Maria DB and JPA (Annotation Based)
• Knowledge of build tools such as Maven or Gradle and of continuous integration tools such as Jenkins, Nexus
• Basic knowledge of web services (SOAP or REST) and web technologies (HTML, CSS, JS)
• Basic knowledge of containers like Dockers, basic knowledge of cloud infrastructure
• Ability to interact and coordinate with employees at different levels, different groups, and different geographical locations within the company
• Ability to support multiple existing applications as well as work on building new ones
• Ability to provide accurate project estimates and make recommendations on specific technologies to use based on business requirements
• Good verbal and written Communication.
• Readiness for short term Domestic and International Travels

Preferred

• Industry knowledge with respect to payments systems and processing in the Debit/Credit and Account based payments (EFT Switching) from different channels like POS, ATM or ecommerce, Card Management System and Real Time Payment Systems.
• Exposure to the Interchange Interfaces like Visa Net, MasterCard, BankNet
• Exposure to Interchange Simulators and Mandates Management.