Cloud DBA

About the Role

We are seeking a highly skilled Database Administrator (DBA) to manage and optimize relational databases in AWS. This role focuses on Amazon RDS for Oracle, Amazon Aurora PostgreSQL, and Amazon RDS for SQL Server
.

You will own the full lifecycle of database operations including provisioning, configuration, upgrades, performance tuning, backup and recovery, security, and daily support. In addition, you will provide technical leadership, define cloud database standards, build runbooks, and drive automation to ensure high performance, availability, and reliability across environments.

• Administer and support Amazon RDS and Aurora environments across Oracle, PostgreSQL, and SQL Server platforms
  .
• Manage database provisioning, configuration, patching, upgrades, and ongoing maintenance.

• Design, deploy, and configure RDS instances and Aurora clusters.
• Define instance sizing, storage allocation, parameter groups, option groups, subnet groups, maintenance windows, Multi-AZ deployments, and read replicas.

• Implement and validate HA/DR strategies including Multi-AZ deployments, failover configurations, and cross-region replication.
• Develop and maintain disaster recovery runbooks with defined RTO and RPO targets.

• Manage automated backups, snapshots, retention policies, and cross-region copies.
• Perform regular restore testing and support environment refreshes for Dev, QA, and UAT.

• Monitor and troubleshoot performance using Cloud Watch, Performance Insights, and Enhanced Monitoring.
• Analyze query performance, wait events, and system behavior to implement tuning improvements across all supported engines.

• Enforce least-privilege access using IAM and database roles.
• Implement VPC-based network isolation, security groups, encryption at rest (KMS), and encryption in transit (TLS).
• Configure auditing and logging through Cloud Watch Logs.

• Plan and execute database engine upgrades and patching with minimal downtime.
• Coordinate testing and implement blue/green or staged deployment strategies where applicable.

• Automate database operations using scripting (AWS CLI/SDKs).
• Partner with Dev Ops to manage infrastructure using Terraform or Cloud Formation.
• Integrate database checks into CI/CD pipelines.

• Support migrations using AWS DMS and AWS Schema Conversion Tool.
• Utilize native tools including Oracle Data Pump, /, and SQL Server backup/restore to S3.

• Perform engine-specific maintenance:
  • Oracle: statistics management and maintenance operations
  • Aurora PostgreSQL: vacuum tuning and extension management
  • SQL Server: index/statistics maintenance and SQL Agent scheduling

• Act as a liaison between database teams and cross-functional stakeholders.
• Mentor junior DBAs and provide technical guidance.
• Collaborate with developers and platform teams to optimize database design and performance.

• Maintain detailed documentation including runbooks, standards, automation scripts, and health check reporting.
• Establish and enforce database best practices.

• Bachelor’s degree in Computer Science, Information Technology, or related field
• Relevant certifications such as:
  • AWS Certified Database – Specialty
  • Oracle Certified Professional (OCP)
  • Microsoft SQL Server certifications (or equivalent hands-on experience)

• 5+ years of hands-on DBA experience in AWS environments, specifically with Amazon RDS and Aurora
• Mandatory experience with BOTH:
  • Oracle databases on Amazon RDS
  • Amazon RDS platform (including administration, configuration, and operations)
• Strong hands-on experience with:
  • Oracle on RDS (backup/recovery, parameter & option groups, performance tuning)
  • Aurora PostgreSQL (cluster architecture, failover, scaling, vacuum strategy, extensions)
  • SQL Server on RDS (index/statistics maintenance, SQL Agent, backup/restore)
• Deep understanding of AWS networking and database security…