Description

You will manage, optimize, and migrate complex Oracle database environments.

Responsibilities

• Install Oracle software, configure instances, and set up Oracle Net Services for client connectivity.
• Design schemas, tables, and indexing strategies while implementing partitioning and clustering for performance.
• Develop and execute backup and recovery strategies using RMAN, including regular testing of recovery procedures.
• Monitor performance using AWR and ASH to tune SQL queries and indexes.
• Manage database migrations from Oracle to PostgreSQL, including complexity analysis and validation.
• Handle Oracle licensing, including transitions between Enterprise and Standard editions and audit preparation.
• Implement disaster recovery using Oracle Data Guard and manage GoldenGate replications.
• Execute database upgrades, patching, and routine maintenance like rebuilding indexes and gathering statistics.

Required Skills

• Extensive experience with Oracle Database administration and Oracle Enterprise Manager.
• Proven ability to migrate databases from Oracle to PostgreSQL.
• Deep understanding of Oracle licensing models, including Named User Plus and Processor licenses.
• Hands-on experience with RMAN, Oracle Data Guard, and GoldenGate.
• Proficiency with PostgreSQL and MS SQL Server.
• Experience managing AWS Cloud services including EC2, RDS, CloudWatch, CloudTrail, CloudFormation, IAM, and S3.
• Knowledge of AWS Config, Autoscaling, and CloudFront.
• Any Graduate degree.

Key Skills

Education

Any Graduate