We are looking for a seasoned Database Administrator to lead our migration strategy from on-premise and legacy database systems (MS SQL, PostgreSQL, MariaDB) to a modern, cloud-native architecture on AWS. In this role, you will act as the bridge between traditional DBA responsibilities and Cloud Engineering. You will ensure high availability, data integrity, and performance optimization across our relational database estate while working closely with our SRE and Data Engineering teams to modernize our infrastructure.
Lead end-to-end migrations of production databases (MS SQL, PostgreSQL, MariaDB) from on-premise/EC2 to AWS managed services (RDS, Aurora) with minimal downtime. Design and implement highly available, disaster-ready database architectures on AWS, including Multi-AZ deployments, read replicas, and cross-region replication. Conduct query tuning, index optimization, and schema analysis to ensure sub-second latency for e-commerce workloads. Define and manage database infrastructure using Terraform, ensuring version control, repeatability, and security compliance. Implement backup/restore strategies, patch management, and encryption (at rest and in transit). Manage IAM roles, Secrets Manager, and security group configurations. Manage hybrid environments during the migration phase, ensuring data synchronization and consistency between legacy and cloud environments. Monitor AWS billing for RDS/Aurora, recommend right-sizing, reserved instance purchases, and storage auto-scaling policies. Work closely with SREs to integrate database monitoring into observability stacks (Prometheus/Grafana) and with Developers to optimize ORM queries and schema design.
6+ years of experience as a Database Administrator (DBA), with at least 2 years focused on AWS Cloud migrations. Deep hands-on experience with MS SQL Server, PostgreSQL, and MariaDB/MySQL (installation, configuration, replication, high availability). Proficiency in AWS RDS / Aurora (PostgreSQL & MySQL compatible), AWS DMS (Database Migration Service), AWS Backup, S3 for native backup storage, EC2, IAM, KMS, Secrets Manager. Proven track record of migrating on-prem databases to AWS using native tools (native backups, DMS, or third-party tools like Striim, Attunity). Proficiency in Python or Bash for scripting maintenance tasks (index rebuilds, health checks). Experience with Terraform for provisioning database instances and related resources. Strong understanding of Linux/Windows Server administration as it relates to database engines.
Experience with containerized databases (Kubernetes/StatefulSets) for non-production workloads. Familiarity with AWS Glue or data warehousing concepts (a plus for interacting with Data Lake teams). Knowledge of Prometheus, Grafana, or CloudWatch for database monitoring. AWS Certifications (Solutions Architect, Database Specialty, or DevOps Engineer).