Supporting the Lead DBA across four production SQL Server environments — with particular focus on data volume management, retention and deletion policy implementation, and CDC pipeline reliability for the Redshift data warehouse.
Data Setting
4 x production SQL Server environments. SQL Server CDC Redshift ingestion via DBT and Confluent/RedPanda. EC2 compute, DynamoDB.
Key Responsibilities
- Administer SQL Server environments — performance monitoring, index management, query tuning
- Support implementation of deletion and retention policies across production environments
- Monitor and maintain SQL Server CDC pipelines feeding Redshift ingestion
- Execute backup, recovery, and high availability operations
- Support CyberArk privileged access management for database credentials
- Perform data masking and obfuscation in non-production environments using TonicAI
- Adhere to PCI DSS database security standards
Required Skills & Experience
- 8+ years (junior) in SQL Server DBA — multi-environment production experience
- SQL Server CDC knowledge — change data capture for downstream ingestion pipelines
- AWS experience: EC2, DynamoDB, RDS
- Data retention and deletion policy implementation experience (senior role)
- CyberArk PAM and TonicAI data masking familiarity (senior role)
- PCI DSS awareness for database environments
Skills
Microsoft SQL Server Administration, Being Proactive and Positive, Communication Skills