The Database Administrator is a member of the Archive/Pipeline Operations Group within the ALMA Department of Computing (ADC). The role is responsible for the administration, availability, performance, security, resilience, and lifecycle management of ALMA's production database platforms, with primary emphasis on the high-availability Oracle environment.
The position installs, configures, patches, tests, tunes, monitors, backs up, recovers, and supports Oracle infrastructure, including Grid Infrastructure, ASM, RAC, GoldenGate, and Oracle Enterprise Manager. The role also supports other relational database technologies used by the Observatory and works closely with system administrators, software engineers, data management teams, ALMA Regional Centers, and technical counterparts in Europe, North America, and East Asia.
KEY RESPONSIBILITIES
- Administer and maintain Oracle database environments across development, test, integration, and production platforms.
- Manage the full lifecycle for both Single-Instance and RAC databases — including installation, configuration, patching,



migration, upgrade, and support for Oracle Grid Infrastructure, ASM, GoldenGate, and Cloud Control.
- Monitor database availability, capacity, performance, replication, and overall health; identify risks and implement corrective actions.
- Perform database performance analysis and tuning, including SQL and PL/SQL optimization, profiling, indexing, and execution-plan review.
- Administer database security, including users, roles, privileges, authentication, auditing, and compliance with ALMA cybersecurity policies.
- Plan and execute database capacity, lifecycle, and growth activities in coordination with infrastructure and service owners.
- Design, implement, test, and maintain backup, recovery, disaster-recovery, and failover capabilities in coordination with the IT Group.
- Administer and troubleshoot Oracle GoldenGate replication between geographically distributed ALMA sites.
- Review, test

📌 Database Administrator (Santiago)
🏢 Observatorio ALMA
📍 Santiago