Oracle Database Administrator (Oracle DBA)

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

At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world’s most innovative companies unleash their potential. From autonomous cars to life-saving robots, our digital and software technology experts think outside the box as they provide unique R&D and engineering services across all industries. Join us for a career full of opportunities. Where you can make a difference. Where no two days are the same.Job DescriptionYour Role:We are seeking a highly skilled Oracle Database Administrator (Oracle DBA) with 4–6 years of hands-on experience in Oracle Database Administration, PL/SQL development, database performance tuning, and database maintenance activities. The ideal candidate will be responsible for ensuring database availability, performance, security, and reliability across enterprise environments. The role requires strong expertise in Oracle Database Administration, PL/SQL programming, query optimization, backup and recovery, database monitoring, performance troubleshooting, patching, and production support. The candidate will work closely with application, infrastructure, and support teams to maintain stable and high-performing Oracle database environments.Support Install, configure, upgrade, and maintain Oracle Database environments.Monitor database health, performance, storage usage, and availability across Production, UAT, QA, and Development environments.Develop, maintain, and optimize complex PL/SQL packages, procedures, functions, triggers, and views.Perform database performance tuning using AWR Reports, ASH Reports, Explain Plans, SQL Trace, and Oracle performance tools.Troubleshoot and resolve database issues related to locking, blocking, deadlocks, memory utilization, and query performance.Implement and manage backup, recovery, and disaster recovery solutions.Support database patching, upgrades, migrations, and database refresh activities.Manage Oracle user accounts, roles, privileges, and database security controls.Monitor and maintain tablespaces, storage utilization, and database growth.Perform index analysis, SQL tuning, partitioning, and execution plan optimization.Support production incidents, problem management, Root Cause Analysis (RCA), and Corrective Action Plans (CAP).Automate routine DBA activities using Shell Scripts and PL/SQL.Collaborate with development and application teams to troubleshoot and resolve database-related issues.Create and maintain database administration documentation, SOPs, runbooks, and recovery procedures.Participate in on-call support and critical incident management activities.Your Profile:4–6 years of hands-on experience in Oracle Database Administration.Strong experience in PL/SQL Development and Optimization.Experience with Oracle Database 12c, 19c, or higher.Strong understanding of SQL and PL/SQL performance tuning techniques.Experience with Oracle Backup and Recovery.Hands-on experience with database patching, cloning, refreshes, and upgrades.Expertise in database monitoring, troubleshooting, and proactive maintenance.Experience managing Oracle users, roles, permissions, and security policies.Good understanding of Oracle architecture, memory structures, and database internals.Knowledge of partitioning, indexing strategies, and query optimization.Experience supporting production databases in enterprise environments.#LI-DC10#LI-RemoteCapgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.