Seeking a Lead Engineer with extensive SQL Server DBA experience to support multiple production environments. This role focuses on critical areas such as data volume management, policy implementation for data retention and deletion, and ensuring the reliability of Change Data Capture (CDC) pipelines feeding into a Redshift data warehouse. You will work with AWS services like EC2 and DynamoDB, and manage ingestion via DBT and Confluent/RedPanda.

This is an opportunity to play a key role in maintaining and optimizing our data infrastructure, ensuring data integrity and efficient processing for downstream analytics.

Key responsibilities include administering SQL Server environments, focusing on performance, indexing, and query optimization. You will be instrumental in implementing data deletion and retention policies across production systems. Maintaining and monitoring SQL Server CDC pipelines for Redshift ingestion is crucial. You will also execute essential backup, recovery, and high availability operations. This role involves supporting privileged access management with CyberArk and performing data masking in non-production environments using TonicAI, while adhering to PCI DSS database security standards.

A minimum of 8 years of experience as a SQL Server DBA in multi-environment production settings is required. Strong knowledge of SQL Server CDC for downstream ingestion pipelines is essential. Familiarity with AWS services such as EC2, DynamoDB, and RDS is necessary. Demonstrated experience in implementing data retention and deletion policies is key, as is familiarity with CyberArk PAM and TonicAI for data masking. Awareness of PCI DSS standards for database environments is also expected. Excellent proactive and positive attitude, coupled with strong communication skills, are vital for this role.