Oracle DBA

Oracle DBA Job Description Template

Our company is looking for a Oracle DBA to join our team.

Responsibilities:

  • Strong ability to work positively with team members, vendors and external/internal customers;
  • Troubleshoot and resolve critical and minor issues detected via monitoring or during system analysis;
  • Respond within define SLA requirements in relation to system issues;
  • Conduct security risk assessments that include, but not limited to, monitoring, investigation and reporting of security and access violations;
  • Practice Capacity Management with regards to evaluating systems usage and performance with a goal of being proactive in identify system problems;
  • Deploy PSU/CPU patches in an effort keep oracle environments up-to-date with the latest releases;
  • Deploys production code in a high availability environment;
  • Ensures server data integrity by evaluating and managing the appropriate software/hardware solutions;
  • Install, configure and fine tune production oracle systems and server settings in an effort to achieve optimum levels of performance;
  • Manage on-call responsibilities in a 24/7 environment and provide first line of defense to system and application issues;
  • OLTP, OLAP, Staging, and Datawarehouse configurations;
  • Replication between different version of Oracle Database and across GoldenGate releases;
  • Perform GoldenGate Upgrade/re-setup replication w/out any data loss;
  • Strong fundamentals in all aspects of DBA responsibilities;
  • Install, Configure, troubleshoot and support GoldenGate.

Requirements:

  • Must be experienced using OEM Grid Control, Emrep and OMS. Experienced with tools such as Toad, Spotlight, or other Monitoring tools;
  • Bachelor’s degree;
  • Exposure to Foglight Monitoring tool;
  • Experience with Oracle 12c, 18c and GoldenGate 13.X;
  • Experience with Oracle Enterprise Manager (OEM);
  • Database server and application sizing and capacity planning;
  • Some DBA experience with SQL Database;
  • Experience with Oracle Security Administration;
  • Strong track record supporting complex GoldenGate. Replication Setup across different release of Oracle Database and different release of GoldenGate;
  • Work experience with OLTP, OLAP, Staging, and Data warehouse configuration;
  • Must be experienced using Oracle 10g and/or Oracle 11g Data Guard;
  • Bachelor’s Degree in Computer Science, Computer Engineering or a closely related field;
  • Good understanding of the Linux/UNIX environments;
  • Deep understanding of relational database design;
  • Experience in SQL server/MySQL Administration is a plus.