Database Administrator - Oracle Server Operations
Organizational Context
The UN Secretariat's Office of Information and Communications Technology (OICT) requires reliable, secure, and highly available Oracle database services. This role contributes to optimized performance, effective backup and recovery, and automated DBA tasks, providing essential technical support to application owners and developers within the organization.
Job Purpose
The purpose of this role is to ensure the reliable, secure, and highly available operation of Oracle database services. This includes implementing and managing high availability solutions, robust backup and recovery strategies, and disaster recovery readiness. The role focuses on optimizing database performance, automating routine administrative tasks, and providing expert technical support and tuning recommendations to application owners and developers. The ultimate goal is to maintain the integrity, availability, and efficiency of critical database systems, supporting the overall IT infrastructure and operational needs of the UN Secretariat.
Responsibilities
Key responsibilities include deploying, certifying, and managing Oracle Servers, encompassing high availability configurations, RMAN backups, disaster recovery planning, and failover exercises. The role involves continuous monitoring of availability, alerts, incidents, and performance, along with proactive capacity planning and system upgrades. Database performance tuning using tools like AWR and ASH, and OS-level optimization are critical. Automation of routine DBA tasks through shell scripting is required. Responsibilities also extend to managing database space, accounts, indexes, and statistics, supporting change management processes, and providing technical guidance to developers and application owners.
Work Experience
A minimum of 5+ years of experience in Oracle Server database administration is required. Essential experience includes Oracle high availability, RMAN backup/recovery, disaster recovery, and failover validation. Proficiency in performance tuning, capacity planning, database/OS-level optimization, and automating DBA tasks using shell scripts is also necessary.
Skills
Oracle Server administration, High Availability (HA), RMAN backup and recovery, Disaster Recovery (DR), Failover validation, Performance tuning (AWR, ASH), Capacity planning, Database/OS-level optimization, Shell scripting for automation, Oracle Support (SR management), Problem-solving, Communication, Organizational and time-management skills.