Oracle & AWS Database Administrator RDS, Redshift, CDK

Oracle & AWS Database Administrator - RDS Redshift CDK

Top 3 Required Skills:

1. Oracle 19c RAC Data Guard RMAN ASM OEM
   
2. Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift administration
   
3. AWS CDK (TypeScript or Python) CloudFormation and CI/CD pipelines
   

Top 3 Preferred Skills: Ansible Dynatrace Azure

Job Summary:

We are seeking an experienced Oracle DBA to ensure the reliability performance and security of mission-critical Oracle databases. The role also requires expertise as an AWS-focused DBA to manage and optimize Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift clusters with a strong emphasis on Infrastructure as Code using AWS CDK.

Key Responsibilities:

1. Hands-on administration of Oracle 19c RAC Data Guard RMAN ASM and OEM
   
2. Expert-level SQL and instance performance tuning; AWR/ASH analysis; wait events diagnosis
   
3. Provision configure and manage Amazon RDS instances/clusters (instance classes storage autoscaling multi-AZ parameter/subnet groups)
   
4. Govern backup/restore strategies including automated backups snapshots encryption (KMS) patching and version upgrades
   
5. Implement monitoring and alerting using CloudWatch Performance Insights and Enhanced Monitoring; tune connections and queries
   
6. Cost management: right-sizing resources storage optimization and advisory on Reserved/Compute Savings Plans
   
7. Design deploy and operate Amazon Redshift clusters; configure WLM concurrency scaling and queue management
   
8. Optimize schema design (distribution/sort keys) run VACUUM/ANALYZE tune queries and isolate workloads
   
9. Build and maintain CI/CD pipelines (CodePipeline/GitHub Actions) for deploying CDK apps; manage multiple environments (dev/qa/uat/prod)
   
10. Ensure high availability: Multi-AZ deployments for RDS cross-region snapshots as needed
    

Qualifications (Required):

1. 47 years of experience as an Oracle DBA including 3 years managing AWS data services
   
2. Hands-on experience with Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift administration
   
3. Expertise in monitoring (CloudWatch Performance Insights) performance tuning and cost optimization
   
4. At least one Oracle certification (OCP) and one AWS certification
   
5. Proficiency with AWS CDK (TypeScript or Python) CloudFormation and CI/CD pipelines