Lead Consultant - Sql Dba (Zapopan)

Lead Consultant – GenpactLocation: Mexico‐ZapopanSchedule: Full‐timeResponsibilitiesDiagnose and resolve database performance, capacity, replication, and T‐SQL issues.Proactively monitor databases for errors and troubleshoot ongoing issues in all CAI environments DEV/QA/PROD.Maintain and monitor systems on‐prem or in AWS/Azure.Coordinate and schedule database downtimes to perform patching, upgrades, and other maintenance procedures.Define backup and recovery strategies using Netapp Snapshots, SnapCenter/SnapManager, Idera SQLSafe, or native SQL Server backup/recovery tools.Perform advanced database administration activities, including performance tuning, T‐SQL tuning, backup/recovery, and disaster recovery solutions.Create and update CAI database documentation about standard procedures, database technology features, or production issue troubleshooting.Stay current with changes in the technical area of expertise.Support highly available production systems using Database Mirroring, Lo...