Cloud DBA

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., Database Administration & Operations

• Administer and support Amazon RDS and Aurora environments across Oracle, PostgreSQL, and SQL Server platforms.

• Manage database provisioning, configuration, patching, upgrades, and ongoing maintenance. Provisioning & Configuration

• 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. High Availability & Disaster Recovery

• 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. Backup, Restore & Environment Management

• Manage automated backups, snapshots, retention policies, and cross-region copies.

• Perform regular restore testing and support environment refreshes for Dev, QA, and UAT. Performance Monitoring & Tuning

• Monitor and troubleshoot performance using CloudWatch, Performance Insights, and Enhanced Monitoring.

• Analyze query performance, wait events, and system behavior to implement tuning improvements across all supported engines. Security & Compliance

• 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 CloudWatch Logs. Patching & Upgrades

• Plan and execute database engine upgrades and patching with minimal downtime.

• Coordinate testing and implement blue/green or staged deployment strategies where applicable. Automation & Infrastructure as Code

• Automate database operations using scripting (AWS CLI/SDKs).
• Partner with DevOps to manage infrastructure using Terraform or CloudFormation.

• Integrate database checks into CI/CD pipelines. Migration & Data Movement

• Support migrations using AWS DMS and AWS Schema Conversion Tool.

• Utilize native tools including Oracle Data Pump, pg_dump/pg_restore, and SQL Server backup/restore to S3. Engine-Specific Administration

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

• 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. Documentation & Standards

• 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: o AWS Certified Database - Specialty o Oracle Certified Professional (OCP) o Microsoft SQL Server certifications (or equivalent hands-on experience) Required Skills

• 5+ years of hands-on DBA experience in AWS environments, specifically with Amazon RDS and Aurora

• Mandatory experience with BOTH: o Oracle databases on Amazon RDS o Amazon RDS platform (including administration, configuration, and operations)

• Strong hands-on experience with: o Oracle on RDS (backup/recovery, parameter & option groups, performance tuning) o Aurora PostgreSQL (cluster architecture, failover, scaling, vacuum strategy, extensions) o SQL Server on RDS (index/statistics maintenance, SQL Agent, backup/restore)

• Deep understanding of AWS networking and database security (VPCs, IAM, security groups, KMS, TLS)
• Experience with monitoring and diagnostics tools (CloudWatch, Performance Insights, logs)
• Strong scripting and automation skills (Python, Bash, PowerShell, AWS CLI/SDKs)
• Experience with database migration tools (AWS DMS, SCT, native utilities)
• Proven leadership, mentoring, and cross-team collaboration skills

• Strong communication, documentation, and problem-solving abilities Preferred Skills

• Strong results orientation with consistent delivery against goals and deadlines
• Deep technical expertise across database platforms and cloud environments
• Commitment to continuous learning and professional development
• Excellent written and verbal communication skills across technical and non-technical audiences
• Strong analytical and problem-solving capabilities
• Effective project management and prioritization skills