Lead Database Engineer

Hapag-Lloyd; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

A leading logistics company located in Chennai is hiring a database management professional to oversee AWS database operations. Your responsibilities will include optimizing database performance, leading migration projects to cloud-native architectures, and implementing Infrastructure as Code strategies. To succeed in this role, experience with AWS databases and automation tools is essential. Join us to work on challenging projects in a fast-paced environment.

Qualifications

• Experience designing and deploying databases on AWS.
• Strong understanding of high availability and disaster recovery strategies.
• Knowledge of encryption methods for database security.

Responsibilities

• Manage and optimize AWS databases, ensuring performance and availability.
• Lead migration projects from on-premises to cloud-native architectures.
• Collaborate with teams for CI/CD integration in database deployments.

Skills

AWS knowledge

Database performance optimization

Automation scripting (Python/Bash)

Infrastructure as Code

Database migration projects

Tools

Terraform

CloudFormation

AWS DMS

Job description

JOB DESCRIPTION

• Design, deploy, and manage databases on AWS including DB on EC2, RDS (MySQL, PostgreSQL, SQL Server, Oracle), Aurora, DynamoDB, Redshift, and ElastiCache.
• Implement and maintain high availability, backup, and disaster recovery strategies.
• Monitor and optimize database performance, slow queries, indexing, replication, and storage utilization.
• Manage database upgrades, patching, parameter tuning, and lifecycle operations.
• Lead database migration projects using AWS DMS, SCT, native tools, and custom scripting.
• Convert on-premises databases to cloud-native architectures (Aurora, DynamoDB, Redshift, etc.).
• Optimize schemas, queries, and data flows for cloud-based performance improvements.
• Automate provisioning, patching, and monitoring using Lambda, SSM Automation, or scripting (Python/Bash).
• Implement Infrastructure as Code (Terraform, CloudFormation, or CDK) for database resources.
• Build automated health checks, failover tests, and data validation tools.
• Implement encryption at rest and in transit using KMS and database-native encryption.
• Manage IAM roles, database authentication, parameter groups, and secrets using AWS Secrets Manager or Parameter Store.
• Enforce least privilege, auditing, logging, and compliance controls such as CIS, PCI, HIPAA, or SOC2.
• Set up database monitoring using CloudWatch, Performance Insights, Enhanced Monitoring, or third-party tools.
• Troubleshoot performance bottlenecks, connection issues, replication delays, and scaling challenges.
• Conduct root cause analysis (RCA) and implement preventive measures.
• Work with application teams to design optimal schemas and query patterns.
• Collaborate with DevOps for CI/CD integration and automated database deployments.