Location: Bengaluru, India | Employment Type: Full-time
About the Role
Client runs four production SQL Server environments carrying a large, complex transactional data estate. This role inherits an environment where deletion policies were not historically enforced, data volumes have accumulated significantly, and the estate is a live source for CDC-based ingestion into Redshift. Stabilising, governing, and evolving this estate is the primary mission.
Client Data Environment
4 x production SQL Server environments. SQL Server CDC Confluent/RedPanda Redshift via DBT. EC2 compute. DynamoDB for specific workloads. CyberArk for privileged access management.
Key Responsibilities
- Own all four production SQL Server environments — performance, availability, security, and compliance
- Define and implement data retention and deletion policies — a critical gap confirmed by Client's Data and AI Lead
- Lead SQL Server CDC configuration and reliability for the Redshift ingestion pipeline
- Manage data volume growth — implement archiving, partitioning, and capacity strategies
- Oversee database security including CyberArk-based privileged access management
- Collaborate with the Data Platform team on the broader platform consolidation programme
- Establish and enforce DBA standards, backup and recovery procedures across all four environments
- Mentor and manage IC DBAs within the team
- Ensure PCI DSS compliance across all SQL Server environments — PAN, PII, CVV controls
Required Skills & Experience
- 5+ years in SQL Server DBA roles — multi-environment production experience required
- Proven experience managing large-scale SQL Server estates with significant data volume challenges
- Deep expertise in data retention, archiving, and deletion policy design and implementation
- Strong SQL Server CDC experience for downstream ingestion pipelines
- AWS experience: EC2, DynamoDB, RDS
- Familiarity with CyberArk or equivalent PAM solutions
- PCI DSS database compliance experience — PAN/PII data handling
- Experience with legacy SQL Server environments and inherited technical debt
- Solid people management and mentoring skills