Database Administrator (DBA) - Mid-Level (AWS Cloud)
About the Role
You will support and operate MySQL (Aurora & self-hosted), Redis, and MongoDB in production environments. You will monitor database health, apply patches, and perform backups and restores while maintaining replication, high availability, and disaster recovery procedures. You will troubleshoot slow queries, add indexes, and tune databases for low-latency high-traffic applications, including financial transaction workloads. You will contribute to automation and infrastructure as code by developing Terraform and Helm templates and scripting routine DBA tasks. You will integrate database metrics into monitoring dashboards and follow database security best practices such as IAM roles, encryption, and user management. You will participate in compliance activities for sensitive data and collaborate with backend engineers on schema changes, migrations, and managed versus self-hosted trade-offs.
Requirements
- 2–4 years of DBA or database engineering experience
- Experience with MySQL and InnoDB operations including replication and backups
- Practical knowledge of Redis Cluster or Sentinel
- Practical knowledge of MongoDB replica sets
- Familiarity with AWS services such as RDS Aurora ElastiCache and MongoDB Atlas
- Experience with Terraform and Helm for provisioning
- Scripting experience with Python and Bash for automation
- Exposure to Kubernetes and database operators
- Experience tuning queries and optimizing databases for transactional workloads
- Experience with monitoring and observability tools such as Grafana Prometheus and Loki
- Exposure to analytics or columnar databases such as ClickHouse Spark BigQuery or Cassandra
- Experience with capacity planning and scaling production workloads
Responsibilities
- Support day-to-day operations of MySQL Aurora and self-hosted MySQL
- Operate and maintain Redis and MongoDB instances
- Monitor database health and apply patches
- Perform backups and restores
- Maintain replication, high availability, and disaster recovery procedures
- Troubleshoot slow queries and implement indexing
- Tune databases for high-traffic and low-latency workloads
- Assist in capacity planning and scaling activities
- Contribute Terraform and Helm templates for database provisioning
- Automate routine DBA tasks and failover testing
- Integrate database metrics into monitoring dashboards
- Follow database security best practices including IAM and encryption
- Participate in compliance initiatives for sensitive financial data
- Review schema changes and migrations with backend teams
Skills
Capacity PlanningQuery OptimizationAuroraSchema MigrationDatabase SchemaRestoreCassandraLokiElasticacheOlapSchema EvolutionDb OperatorMongodb AtlasIndexingBigqueryBashRdsSreMongodbAutomationTerraformSecurityMonitoringPerformance TuningAwsBackupClickhouseGrafanaPrometheusSparkIamHelmHigh AvailabilityInnodbReplicationApache Spark