Remote Senior Oracle DBA & PL/SQL Performance Specialist

Capgemini; Bogotá; A distancia; COP 120.000.000 - 200.000.000; Jornada completa

Descripción de la vacante

Capgemini seeks an experienced Oracle DBA/PL-SQL professional to ensure availability and performance of critical databases in enterprise systems. You will install, patch, upgrade, and monitor Oracle environments, tune SQL, manage backups and DR, and automate routine tasks on Linux/Unix platforms. Strong English communication and 4–6 years of hands-on experience are required, with opportunities to work in a global team.

Formación

• 4-6 years of hands-on experience as an Oracle Database Administrator.
• Strong English communication (B2+, C1).
• Experience with Oracle 12c, 19c, or newer versions.

Responsabilidades

• Install, configure, maintain, patch, upgrade, and support Oracle Database environments.
• Monitor database health, performance, availability, storage, and capacity planning.
• Develop, optimize PL/SQL packages, procedures, functions, triggers, and views.
• Perform database performance tuning using Oracle tools and explain plans.
• Troubleshoot issues related to locking, blocking, deadlocks, memory, and queries.
• Manage backup, recovery, DR, cloning, and migration activities.
• Administer database security including users, roles, privileges, and access controls.
• Automate routine DBA activities using PL/SQL and Shell Scripting.
• Maintain runbooks and recovery procedures; participate in on-call support.

Conocimientos

Oracle Database Administration

PL/SQL development

Performance tuning

Production support

Linux/Unix

English communication

Educación

Bachelor's degree in Computer Science/Engineering/IT

Herramientas

RMAN

Oracle Enterprise Manager

SQL Developer

Data Guard

Oracle RAC

Shell Scripting

Python

Descripción del empleo

Capgemini seeks an experienced Oracle DBA/PL-SQL professional to ensure availability and performance of critical databases in enterprise systems. You will install, patch, upgrade, and monitor Oracle environments, tune SQL, manage backups and DR, and automate routine tasks on Linux/Unix platforms. Strong English communication and 4–6 years of hands-on experience are required, with opportunities to work in a global team.