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.