Description

You will manage and maintain large-scale production, UAT, QA, SIT, and DEV database environments, administering Oracle 19c RAC clusters on Exadata while applying PostgreSQL DBA expertise.

Responsibilities

• Manage Oracle version upgrades, migrations, and RMAN backup, recovery, and cloning procedures.
• Configure Oracle Goldengate for multi-master, uni-directional, and bi-directional replication.
• Execute database change implementations using DevOps automation and manage data transfers via Export/Import, SQL Loader, and Data Pump.
• Perform proactive monitoring and implement performance tuning using ADDM, AWR, ASH, and SQL advisors.

Required Skills

• 3-6 years of PostgreSQL DBA experience with expertise in Postgres system metrics and optimization strategies.
• Extensive experience administering Oracle 19c RAC clusters on Exadata.
• Proficiency in SQL development and performance tuning.
• Proficiency in Python, Perl, or Bash scripting.
• Familiarity with Linux system-level metrics and common utilities.
• Understanding of virtualization and clustered environments.
• Experience with Logical and Physical Data Modeling using ERStudio Data Architect.

Key Skills

Education

Any Graduate