Altimetrik logo

Lead Engineer - DBA SQL

Altimetrik

8 years

Bengaluru

Posted:5 days ago

Job Description

  • Job ID: 922653
  • 7 - 11 Years
  • 1 Opening
  • Bangalore

Role description

About the Role

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 Environment

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

Skills Required

SQL SQL Server Data Warehouse Performance Monitoring High Availability Access Management PCI DSS Database Security SQL Server DBA AWS ETL and data warehousing Security compliance (GRC)

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Altimetrik logo
Altimetrik

RecommendedJobs for You

Altimetrik logo

Bengaluru

Altimetrik logo

Bengaluru