Lead Consultant - SQL Dba (Zapopan)

Lead Consultant – Genpact

Location: Mexico‑Zapopan

Schedule: Full‑time

Responsibilities

• Diagnose 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 c...