Remote Oracle DBA | PL/SQL, Tuning & DR

Capgemini; Bogotá; A distancia; COP 90.000.000 - 130.000.000; Jornada completa

Descripción de la vacante

Capgemini Engineering seeks a skilled Oracle Database Administrator with 4–6 years of hands-on experience to join our global team. You will ensure availability, performance, security, and reliability of Oracle DBs across production, UAT, QA, and development environments.

You will install, configure, upgrade, patch, and maintain Oracle databases; develop PL/SQL, perform tuning with AWR/ASH, and collaborate with developers and operations to prevent incidents and optimize queries.

Formación

• 4–6 years of hands-on Oracle DB Admin experience.

Responsabilidades

• Support Install, configure, upgrade, and maintain Oracle Database environments.
• Monitor database health, performance, storage usage, and availability across Prod/UAT/QA/Dev.
• Develop, maintain, and optimize PL/SQL packages, procedures, functions, triggers, and views.
• Perform database performance tuning using AWR/ASH and Explain Plans.
• Troubleshoot and resolve database issues related to locking, memory, and query performance.
• Automate routine DBA activities with Shell/PL/SQL.
• Create and maintain DBA documentation, SOPs, runbooks, and recovery procedures.

Conocimientos

Oracle DBA

PL/SQL optimization

Performance tuning

Backup & Recovery

Patching & Upgrades

Monitoring & Troubleshooting

Herramientas

AWR Reports

ASH Reports

Explain Plans

SQL Trace

Descripción del empleo

Capgemini Engineering seeks a skilled Oracle Database Administrator with 4–6 years of hands-on experience to join our global team. You will ensure availability, performance, security, and reliability of Oracle DBs across production, UAT, QA, and development environments.

You will install, configure, upgrade, patch, and maintain Oracle databases; develop PL/SQL, perform tuning with AWR/ASH, and collaborate with developers and operations to prevent incidents and optimize queries.