Principal Database Solutions Consultant

Principal Consultant – SQL DBA

Location : Bangalore / Hyderabad / Delhi NCR

Experience : 8-15 years

Immediate joiners preferred.

Second round will be a F2F.

Key Skills : SQL DBA, AWS, SQL Server Always On

Kindly share resume to sreenivas.karanam@genpact.com with sub of "SQL DBA" along with notice period.

Genpact is hiring a senior SQL DBA who will be responsible for recommending, implementing and supporting current and new SQL Server DB technologies, as required, to support the technical capabilities. To be successful in this role one must be able to work effectively in a fluid, fast-paced environment. This role requires good communication skills, both with team members and business contacts. In addition, the successful SR Database Administrator must be able to work with minimal supervision on multiple concurrent projects.

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 / Snap Manager 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 CAI’s 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.

Qualifications we seek in you!

Preferred Qualifications / Skills