Senior Manager - Database Administration

Akasa Air; Mumbai; On-site; INR 4,200,000 - 6,800,000; Full time

Job summary

Akasa Air in Mumbai seeks a senior data engineer to own the database platforms and cloud data architecture on AWS. You will design purpose-built data solutions, migrate workloads to managed cloud services, and run resilient operations across Mumbai and Hyderabad regions.

You will lead data integration, architect reference patterns, and mentor junior DBAs while ensuring security, cost efficiency, and compliance with ISO 27001 and DPDP Act 2023.

Qualifications

• B.E./B.Tech or MCA in Computer Science or IT required.
• AWS Data Engineer Associate or AWS Solutions Architect Associate required or equivalent experience.
• Preferred: AWS SA Professional, AWS Security Specialty, PostgreSQL certs.
• Deep hands-on expertise with Aurora/RDS PostgreSQL/MySQL and AWS data services.

Responsibilities

• Design data architectures on AWS using Aurora/RDS, DynamoDB, Redshift, S3-based lake with Glue, Athena, Lake Formation.
• Publish reference architectures and database standards; select engines per workload.
• Migrate SQL Server/Oracle to Aurora/RDS using DMS and SCT.
• Design data integration with SaaS/LOB systems: CDC, event streams (Kinesis, MSK) and APIs.
• Own availability, performance and capacity of production databases; lead incident response.
• Plan high availability and DR: Multi-AZ, cross-region replicas, point-in-time recovery.
• Tune performance with Performance Insights, monitoring, and indexing; plan upgrades with minimal downtime.
• Provision DBs as code (Terraform/CloudFormation); enforce encryption and audit logging.

Skills

Aurora & RDS PostgreSQL/MySQL

AWS data services

Migration to AWS

Infrastructure-as-Code

Python/Bash scripting

SQL & data modeling

Performance tuning

Leadership & mentoring

Education

B.E. / B.Tech or MCA in Computer Science or IT

AWS Certified Data Engineer – Associate

AWS Certified Solutions Architect – Associate

AWS Certified Solutions Architect – Professional

PostgreSQL professional certification

Tools

DMS

SCT

Terraform

CloudFormation

KMS

Secrets Manager

Athena

Glue

Redshift

S3

Job description

Owns the airline's database platforms and cloud data architecture on AWS. Designs purpose-built data solutions, runs resilient and cost-efficient database operations, and leads the move from traditional engines to managed cloud services.

Key Responsibilities:

• Design data architectures on AWS using purpose-built services: Aurora and RDS (PostgreSQL, MySQL), DynamoDB, ElastiCache, Redshift and an S3-based data lake with Glue, Athena and Lake Formation.
• Select the right engine per workload on performance, resilience and cost; publish reference architectures and database standards.
• Plan and execute migrations from SQL Server, Oracle and self-managed MySQL to Aurora and RDS using AWS DMS and SCT.
• Design data integration with SaaS and line-of-business systems: CDC, event streams (Kinesis, MSK) and APIs.

Database operations and resilience

• Own availability, performance and capacity of production databases; lead P1 database incident response.
• Run high availability and DR: Multi-AZ, Aurora Global Database, cross-region replicas, AWS Backup and point-in-time recovery across the Mumbai and Hyderabad regions.
• Tune performance using Performance Insights, Enhanced Monitoring, execution plans and indexing.
• Plan patching and major version upgrades with minimal downtime, using blue/green deployments where supported.

Automation, security and cost

• Provision and change databases as code (Terraform or CloudFormation) with versioned schema pipelines
• Enforce encryption (KMS), secret rotation (Secrets Manager), IAM database authentication, least privilege and audit logging.
• Apply data protection controls for ISO 27001 and the DPDP Act 2023, including masking of non-production data.
• Drive database FinOps: rightsizing, Graviton instances, Savings Plans or reserved capacity and storage tiering.

Leadership and collaboration

• Mentor and develop the Junior DBA as trained backup for routine operations.
• Partner with application, development and analytics teams on data models and query design.
• Manage AWS support cases and database vendor relationships.

Skills and Experience:

• Deep hands-on expertise with Aurora and RDS for PostgreSQL and MySQL, including replication, failover and parameter tuning.
• AWS data services: DynamoDB, Redshift, S3, Glue, Athena and DMS.
• Migration of SQL Server or Oracle workloads to open-source engines on AWS.
• Infrastructure-as-Code and scripting in Python or Bash.
• Strong SQL, data modelling and performance diagnostics.

Advantageous

• Streaming and CDC (Kinesis, MSK).
• Data warehouse and lakehouse design for reporting and analytics.
• Airline, travel or other high-volume transactional systems

Qualifications and Certifications

• B.E. / B.Tech or MCA in Computer Science or IT.
• Required: AWS Certified Data Engineer – Associate, or AWS Certified Solutions Architect – Associate with equivalent data platform experience.
• Preferred: AWS Certified Solutions Architect – Professional, AWS Certified Security – Specialty, PostgreSQL professional certification.