AWS - SQL DBA

Role & responsibilities :

Lead Database Administrator SQL Server

Experience: 12+ years

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

• 12+ 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
• Strong people management and mentoring skills

Preferred candidate profile :

Looking for immediate joiners