Database Administrator

• As the Platform Database Administrator (DBA) for Aurora, serve as the architectural and operational anchor for high-scale database environments.
• Bridge the gap between technical data layers and production feature engineering.
• Take full ownership of database performance tuning, optimization strategies, and system reliability across core software suites.
• Sustain consistent system performance and reliability across 400+ database schemas, managing comprehensive schema migrations and tracking client-specific data growth metrics.
• Supervise AWS Aurora-specific environments, orchestrating cluster endpoint routing configurations, managing failover behaviors, executing parameter tuning, and troubleshooting data warehouse / read replica lags.
• Apply deep knowledge of InnoDB core internals to manage lock behaviors, resolve complex lock contentions, adjust buffer pool parameters, and systematically reduce purge lags across write-heavy database clusters.
• Diagnose and optimize heavy database pipelines utilizing INSERT...SELECT queries and computed-table patterns.
• Analyze Aurora instance utilization models against pricing factors to right-size compute resources and minimize I/O waste stemming from unoptimized queries.

Platform Database Administrator, Aurora/MySQL

• Design, implement, and manage AWS-managed databases including RDS (Oracle, PostgreSQL etc.), develop strategies for high availability, replication, failover, and disaster recovery.
• Migrate on-premises databases to AWS cloud environments using DMS, or native tools.
• Monitor database performance and tune queries, indexes, and configurations.
• Implement caching strategies (ElastiCachce, Redis, etc.) to optimize workloads.
• Proactively identify and resolve performance bottlenecks.
• Implement database encryption, access controls, and key management using KMS and IAM.
• Ensure compliance with industry standards (HIPAA, FedRAMP, SOC 2 etc.) as applicable.
• Automate provisioning, backups, restores, and monitoring using infrastructure as Code (Terraform, CloudFormation etc.).
• Integrate database operations into CI/CD pipelines for schema and data changes.
• Manage cost optimization for cloud-based database services.
• Set up monitoring and alerting with CloudWatch, Performance Insights, and third-party tools.
• Troubleshoot complex database issues across production and non-production environments.
• Conduct root cause analysis of incidents and implement preventive measures.
• Work closely with developers, architects, and QA to ensure smooth releases.

Database Administrator jobs in District of Columbia

See all jobs on JobTailor

Platform Database Administrator, Aurora/MySQL

AWS Cloud Database Administrator