Oracle DBA: Performance Tuning, RAC & Cloud Automation

Capgemini Engineering; Colombia; Presencial; COP 70.000.000 - 140.000.000; Jornada completa

Descripción de la vacante

Capgemini Engineering is seeking an experienced Oracle Database Administrator to ensure availability, performance, security, and reliability of Oracle databases in enterprise environments.

You will collaborate with development, infrastructure, and support teams to maintain stable, scalable, and high-performing database environments, including on-call support and proactive optimization.

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, troubleshooting, 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 environments.
• Develop, maintain, and optimize PL/SQL packages, procedures, functions, triggers, and views.
• Perform database performance tuning using Oracle tools and reports.
• Troubleshoot database issues related to locking, deadlocks, memory utilization, and query performance.
• Manage backup, recovery, disaster recovery, 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 RCA, and drive corrective actions.
• Automate routine DBA activities using PL/SQL and Shell Scripting.
• Maintain operational documentation and runbooks.
• Participate in on-call support and collaborate with cross-functional teams.

Conocimientos

Oracle DBA

PL/SQL development

Performance tuning

Linux/Unix

RMAN backup

SQL tuning

Shell scripting

On-call support

Educación

Bachelor's degree in CS/Engineering/IT

Herramientas

Oracle Enterprise Manager

SQL Developer

Python scripting

Descripción del empleo

Capgemini Engineering is seeking an experienced Oracle Database Administrator to ensure availability, performance, security, and reliability of Oracle databases in enterprise environments.

You will collaborate with development, infrastructure, and support teams to maintain stable, scalable, and high-performing database environments, including on-call support and proactive optimization.