Role
AWS Cloud RDS/Oracle DBA. Position Type: Permanent. Total Experience: 6-8 years.
Responsibilities
- Ensure the reliability, performance, and security of mission-critical Oracle databases.
- Manage and optimize Amazon RDS (Oracle, PostgreSQL, MSSQL) and Amazon Redshift clusters with a focus on Infrastructure as Code using AWS CDK.
Required Skill Sets
- Strong hands‑on experience 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 of experience as an 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.
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more
More from Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!