- 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.

DATABASE-SPECIFIC DUTIES

- Implement and manage database services in the AWS cloud infrastructure.
- Ensure compliance with security standards and policies for all databases.
- Monitor system performance and identify downtimes along with underlying causes.
- Managed migrations of DB from Onprem to RDS services.
- Manage backup and restores of DB’s on requirement basis.

SKILLS

- Require 7-12 years of technology experience.
- At least 5-7 years of experience in AWS Cloud Database Operations with large enterprise organisations.
- Hands-on experience with AWS database services (RDS, MSSqL, Aurora, DynamoDB,

Redshift).
- Proficient in performance tuning, query optimization, indexing strategies, and troubleshooting replication, storage, and I/O issues.
- Experience with database migrations and replication technologies.
- Proficiency in scripting (Python, Bash) for automation.
- Solid understanding of cloud networking, IAM, and DevOps fundamentals.
- AWS certifications (e.g., AWS Database – Specialty) are highly desirable
- Having a MCSA: SQL Server / Database Development certification is beneficial.

📌 Lead Database Engineer (Chennai)
🏢 Hapag-Lloyd
📍 Chennai