Lead Consultant – SQL DBA
Genpact
5 - 10 years
nan
Posted: 4/15/2025
Job Description
Responsibilities
Diagnose and Resolve problems around database performance, capacity, replication, T-SQL, etc.
Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB on-going issues on all CAI environments DEV/QA/PROD.
Maintain/Monitor systems On-Prem or in AWS/Azure.
Coordinate and schedule DB downtimes to perform DB maintenance procedures. i.e. DB patching, upgrades, etc.
Define Backup and Recovery strategies using technologies used at CAI: Netapp Snapshots, SnapCenter/SnapManager for SQL, Idera SQLSafe or Native SQL Server Backup/recovery Tools.
Perform advanced database administration activities including but not limited to: DB Performance Tuning, T-SQL tuning, Backup and recovery and DB disaster recovery solutions.
Create/update CAIs database documentation about standard procedures, DB technology features, or production issue troubleshooting.
Stay current with changes in the technical area of expertise.
Support highly available production systems using the following technologies: Database Mirroring, Log Shipping, Windows/SQL clustering, Availability Groups.
Work with development teams to deploy code in production when needed.
Participate in on-call rotations.
About Company
Genpact is a global professional services firm that offers a wide range of digital transformation services and solutions. With a presence in over 30 countries, Genpact leverages its deep domain expertise in operations and analytics to help businesses transform their operations, improve efficiency, and enhance customer experience. The company combines digital technology, data science, and operational excellence to deliver business outcomes across various industries, including banking, insurance, manufacturing, and healthcare. Founded in 1997 as a subsidiary of GE, Genpact has grown into an independent, NYSE-listed company with a diverse workforce of over 90,000 employees globally.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).