Oracle Database Administrator / PL-SQL Developer

Capgemini Engineering; Bogotá; Presencial; COP 100.440.000 - 267.840.000; Jornada completa

Descripción de la vacante

Capgemini Engineering is hiring an experienced Oracle Database Administrator to ensure high availability, performance, and security of enterprise Oracle databases. You will work with development, infrastructure, and support teams to deliver scalable database environments and support mission-critical applications.

The role requires strong PL/SQL development, performance tuning, RMAN backups, and Linux/Unix experience. Collaboration across global teams and on-call support are expected.

Formación

• 4-6 years hands-on Oracle DBA experience.
• Experience with Oracle 12c/19c or newer.

Responsabilidades

• Install, configure, maintain, patch, upgrade, and support Oracle Database environments.
• Monitor database health, performance, availability, and capacity planning.
• Develop and optimize PL/SQL packages, procedures, and views.
• Perform performance tuning using AWR/ASH, SQL Trace, and Explain Plans.
• Manage backup, recovery, and DR activities (RMAN).
• Administer security, users, roles, and access controls.
• Automate routine DBA tasks using PL/SQL and Shell scripting.

Conocimientos

Oracle DBA

PL/SQL

SQL tuning

Linux/Unix

Shell scripting

Python scripting

On-call support

Stakeholder management

Educación

Bachelor's degree in CS/Engineering

Herramientas

RMAN

OEM

SQL Developer

Oracle RAC

Descripción del empleo

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired bya collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizationsunlock the value of technology and build a more sustainable, more inclusive world.

Job Description

About the Role

We are seeking an experienced Oracle Database Administrator (Oracle DBA / PL/SQL Developer) with strong expertise in Oracle Database Administration, PL/SQL development, performance tuning, and production support within enterprise environments.

In this role, you will be responsible for ensuring the availability, performance, security, and reliability of Oracle databases while supporting business-critical applications. You will collaborate closely with development, infrastructure, and support teams to maintain stable, scalable, and high-performing database environments.

Key Responsibilities

• 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.

Required Qualifications

• 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.
• Strong understanding of Oracle Architecture, Database Internals, Memory Structures, Query Optimization, Indexing Strategies, and Partitioning.
• Experience supporting mission-critical production environments.
• Experience working in Linux/Unix environments.
• Bachelor's degree in Computer Science, Engineering, Information Technology, or a related field.

Preferred Qualifications

• Oracle RAC and Oracle Data Guard administration.
• Experience with Oracle Cloud Infrastructure (OCI), Azure, or AWS.
• DevOps and database deployment automation experience.
• Python scripting for automation and reporting.
• Experience supporting Manufacturing, MES, LIMS, ERP, or other enterprise applications.
• Oracle certifications such as OCP, OCA, OCI Foundations, or ITIL Foundation.

Technologies

Oracle Database 12c / 19c / 21c, PL/SQL, RMAN, Oracle Enterprise Manager (OEM), SQL Developer, Oracle RAC, Oracle Data Guard, Linux/Unix, Shell Scripting, Python (Preferred).

Soft Skills

• Strong analytical and problem-solving abilities.
• Excellent troubleshooting skills.
• Effective communication and stakeholder management.
• Ability to work in global, cross-functional teams.
• Strong ownership, accountability, and attention to detail.
• Ability to manage multiple priorities in a fast-paced environment.

Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.

Make it real | www.capgemini.com