29 Oct
|
Akasa Air
|
Mumbai
Job Summary: 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
Cloud data architecture
• 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:
Essential
• 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 skilled certification.
📌 Senior Manager (Mumbai)
🏢 Akasa Air
📍 Mumbai