Altimetrik logo

AWS - SQL Database Administrator

Altimetrik

5 - 9 years

Bengaluru

Posted:6 days ago

Job Description

Role & responsibilities

AWS Database Administrator SQL Server

Experience: 5 to 9 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

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

Preferred candidate profile

Looking for immediate joiners

Skills Required

Database administration Server Dynamo Db Dynamo DBMS Cdc Db Administration

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

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
Altimetrik logo