Oracle DBA

General Overview

Functional Area : Information Technology (ITM)

Career Stream : IT Infrastructure (INFR)

Role : Specialist (SPE)

Job Title : Specialist, IT Infrastructure

Job Code : SPE-ITM-INFR

Job Level : Level 08

Direct / Indirect Indicator : Indirect

Summary

We are seeking an experienced and motivated Oracle Database Administrator to manage, maintain, and optimize our critical Oracle database systems. The ideal candidate will ensure the performance, integrity, security, and availability of our databases, working closely with development and infrastructure teams.

Detailed Description

Performs tasks such as, but not limited to, the following :

• Installation & Configuration : Install, configure, and upgrade Oracle database software and related products (e.g., Oracle RAC, Data Guard).
• Performance Tuning : Proactively monitor database performance, perform SQL and PL / SQL tuning, and implement optimization strategies.
• Backup & Recovery : Develop, implement, and manage robust database backup, recovery, and disaster recovery strategies using tools like RMAN.
• Security Management : Implement and enforce database security policies, manage user accounts, roles, and privileges, and apply necessary patches and updates.
• Maintenance & Troubleshooting : Perform routine database maintenance, including patching, cloning, and managing tablespaces. Troubleshoot and resolve database-related issues promptly.
• High Availability (HA) & Disaster Recovery (DR) : Configure and maintain HA solutions such as Oracle RAC and Data Guard to ensure minimal downtime.
• Capacity Planning : Monitor database usage, predict future storage and performance needs, and plan for capacity expansion.
• Collaboration : Work with application development teams to optimize database designs, queries, and stored procedures (PL / SQL).
• Documentation : Maintain comprehensive documentation for database environments, configurations, procedures, and standards.

Knowledge / Skills / Competencies

Certifications : Oracle Certified Professional (OCP) or Oracle Certified Master (OCM) certification.

Physical Demands

Duties of this position are performed in a normal office environment.

Duties may require extended periods of sitting and sustained visual concentration on a computer monitor or on numbers and other detailed data. Repetitive manual movements (e.g., data entry, using a computer mouse, using a calculator, etc.) are frequently required.

Typical Experience

Typical Education

Educational Requirements may vary by Geography

Notes

This job description is not intended to be an exhaustive list of all duties and responsibilities of the position. Employees are held accountable for all duties of the job. Job duties and the % of time identified for any function are subject to change at any time.

Skills Required

Perl, Sql, Rman, PDB, Oracle Enterprise Manager, Unix, Pl Sql, Oracle Database, Oracle Rac, Goldengate, Linux, Data Pump, Aws, Awr, Oracle Cloud Infrastructure, Data Guard, Python, Bash, Azure, Servicenow, Ash