Oracle DBA / PL-SQL Expert — Performance & Availability

Capgemini Engineering; Bogotá ciudad; Presencial; COP 90.000.000 - 140.000.000; Jornada completa

Descripción de la vacante

Capgemini Engineering seeks an experienced Oracle Database Administrator to ensure the availability, performance, security, and reliability of Oracle databases within enterprise environments. You will collaborate with development, infrastructure, and support teams to maintain high-performing database environments.

The role requires strong PL/SQL development, tuning, RMAN backup/recovery, and experience in Linux/Unix systems.

Formación

• 4-6 years of hands-on experience as an Oracle Database Administrator.
• Strong experience with Oracle Database 12c, 19c, or newer versions.
• Advanced PL/SQL development and optimization skills.
• Strong knowledge of SQL and database performance tuning.
• Experience with RMAN backup and recovery processes.
• Experience performing database monitoring, patching, upgrades, cloning, and refresh activities.

Responsabilidades

• Install, configure, maintain, patch, upgrade, and support Oracle Database environments.
• Monitor database health, performance, availability, storage utilization, and capacity planning across Development, QA, UAT, and Production environments.
• Develop, maintain, and optimize PL/SQL packages, procedures, functions, triggers, and views.
• Perform database performance tuning using AWR Reports, ASH Reports, SQL Trace, Explain Plans, and Oracle performance tools.
• Troubleshoot database issues related to locking, blocking, deadlocks, memory utilization, and query performance.
• Manage backup, recovery, disaster recovery, database cloning, refreshes, and migration activities.
• Administer database security, including users, roles, privileges, and access controls.
• Implement indexing, partitioning, SQL tuning, and execution plan optimization strategies.
• Support production incidents, conduct Root Cause Analysis (RCA), and drive corrective actions.
• Automate routine DBA activities using PL/SQL and Shell Scripting.
• Maintain operational documentation, runbooks, and recovery procedures.
• Participate in on-call support and collaborate with cross-functional teams to resolve database-related issues.

Conocimientos

Oracle DBA

PL/SQL

RMAN

Linux/Unix

Performance Tuning

Data Guard

Oracle RAC

Cloud (OCI/AWS)

Educación

Bachelor's degree in CS/Engineering/IT

Herramientas

OEM

SQL Developer

OCI

Azure

AWS

Descripción del empleo

Capgemini Engineering seeks an experienced Oracle Database Administrator to ensure the availability, performance, security, and reliability of Oracle databases within enterprise environments. You will collaborate with development, infrastructure, and support teams to maintain high-performing database environments.

The role requires strong PL/SQL development, tuning, RMAN backup/recovery, and experience in Linux/Unix systems.