Lead Consultant - Production DBA Engineer

*

Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose the relentless pursuit of a world that works better for people we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.

Inviting applications for the role of Lead Consultant Production DBA Engineer

Ability to work individually or mentor and train a small group in a development and migration environment.
Communicate effectively with global customers and collaborate well within a team environment to drive results.

Responsibilities

1. Having eyes on glass 24/7 to enable swift response to any alerts or anomalies
2. Should be open to work in shift timings to support production environments (S1 - 11:00 PM - 8:00 AM CST/ 10:30 AM - 7:30 PM IST; Shift 2 - 7:00 AM - 4:00 PM CST /6:30 PM - 3:30 AM IST ; Shift 3 - 9:00 AM - 6:00 PM CST/8:30 PM - 5:30 AM IST ; Shift 4 - 3:00 PM - 12:00 AM CST /2:30 AM - 11:30 AM IST)
3. Database maintenance (Install, configure, and upgrade database software, performing regular backups. Monitoring databases, file growth disk space usage, implementing monitoring alerts and notifications to proactively identify and address potential issues)
4. Performance tuning optimization (Identifying resolving performance bottlenecks using monitoring tools techniques, analyzing query execution optimizing T-SQL queries for enhanced performance, data archiving, purging as per mutually agreed data retention policy)
5. Troubleshooting and Support (Diagnosing and resolving database-related issues, such as performance degradation, deadlock analysis etc.)
6. Collaborating with other IT teams to troubleshoot cross-functional issues providing technical support and guidance to data engineers
7. Automation and Scripting (e.g. Automating routine tasks such as database backups, index maintenance, and database health checks)
8. Security Management
9. High Availability Disaster recovery
10. Documentation and Knowledge Sharing

Qualifications we seek in you

Minimum Qualifications / Skills

1. Bachelor s degree in computer science, Information Technology, or related field
2. 4-8 years of experience in Data Engineering areas with minimum hands-on coding experience of 5 years mandatory experience in leading production support environments
3. TSQL Expert with in-depth knowledge of monitoring optimization databases
4. Proficient on OLTP / OLAP / ER Diagrams / Internal Engine / Index Tuning / Statistics / Execution Plans / SP Optimization / Partitioning / Normalization / Denormalization
5. Agile Development Process, Release Management Continuous Integration deployment knowledge
6. Knowledge of SSIS, SSRS, Snowflake are good to have
7. Having been in Pager duty and/or managed people in pager duty is a good to have

Preferred Qualifications/ Skills

1. Bachelor s degree in computer science, Information Technology, or related field
2. 4-8 years of experience in Data Engineering areas with minimum hands-on coding experience of 5 years mandatory experience in leading production support environments
3. TSQL Expert with in-depth knowledge of monitoring optimization databases
4. Proficient on OLTP / OLAP / ER Diagrams / Internal Engine / Index Tuning / Statistics / Execution Plans / SP Optimization / Partitioning / Normalization / Denormalization
5. Agile Development Process, Release Management Continuous Integration deployment knowledge
6. Knowledge of SSIS, SSRS, Snowflake are good to have
7. Having been in Pager duty and/or managed people in pager duty is a good to have


Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. Get to know us at genpact.com and on LinkedIn, X, YouTube, and Facebook.
Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit, paying to apply, or purchasing equipment or training.