Role:AWS Cloud RDS/Oracle DBA Position Type: Permanent Total Experience: 6-8 years
Role Description: • We are looking for an experienced Oracle DBA to ensure the reliability, performance, and security of mission-critical • Oracle databases, along with an AWS-focused DBA to manage and optimize Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift clusters, with a strong focus on Infrastructure as Code using AWS CDK.
Required Skill Sets: • Strong hands-on with Oracle 19c, RAC, Data Guard, RMAN, ASM, OEM. • Expert-level performance tuning (SQL & instance), AWR/ASH analysis, wait events. • Provision and manage RDS instances/clusters (instance classes, storage autoscaling, Multi-AZ, parameter/subnet groups). • Govern backup/restore (automated backups, snapshots), encryption (KMS), patching, and minor/major version upgrades. • Implement monitoring/alerting via CloudWatch, Performance Insights, Enhanced Monitoring; tune connections/queries. • Cost management: right-sizing, storage management, Reserved/Compute Savings Plans advisory. • Design and operate Redshift clusters; configure WLM, concurrency scaling, queue management. • Optimize schema (distribution/sort keys), VACUUM/ANALYZE, query tuning; workload isolation. • Build CI/CD pipelines (CodePipeline/GitHub Actions) to deploy CDK apps; manage environments (dev/qa/uat/prod). • Implement high availability (Multi-AZ for RDS, cross-region snapshots as needed). • 4–7+ years as a Oracle DBA with 3+ years on AWS data services. • Hands-on with Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift administration. • Expertise in monitoring (CloudWatch, Performance Insights), performance tuning, and cost optimization. • At least one certification in Oracle (OCP) and one in AWS. • Proficiency with AWS CDK (TypeScript or Python), CloudFormation, and CI/CD pipelines. ASM, OEM. • Expert-level performance tuning (SQL instance), AWRASH analysis, wait events. • Provision and manage RDS instances cluster (instance classes, storage autoscaling, multi-AZ, parameter subnet groups). • Govern backup restore (automated backups, snapshots), encryption (KMS), patching, and minor major version upgrades. • Implement monitoring alerting via CloudWatch, Performance Insights, Enhanced Monitoring tune connections queries. • Cost management right-sizing, storage management, Reserved Compute Savings Plans advisory. • Design and operate Redshift clusters configure WLM, concurrency scaling, queue management. • Optimize schema (distribution sort keys), VACUUMANALYZE, query tuning workload isolation. • Build CICD pipelines (Code Pipeline GitHub Actions) to deploy CDK apps manage environments (devqauat prod). • Implement high availability (Multi-AZ for RDS, cross-region snapshots as needed)."""
|