Role Description Experiencia para diseñar, desarrollar y optimizar soluciones de bases de datos que soporten nuestros procesos de negocio. Responsable de crear procesos automáticos, asegurar la integridad de la información y mejorar el rendimiento de los sistemas existentes mediante el uso avanzado de objetos de base de datos y programación procedimental. - Desarrollo de Programas: Diseñar y codificar procedimientos almacenados (Stored Procedures), funciones, paquetes y triggers utilizando PL/SQL. - Optimización de Consultas: Analizar y "tunear" sentencias SQL complejas y bloques PL/SQL para garantizar un alto rendimiento. - Automatización de Tareas: Crear y mantener "jobs" automáticos para el procesamiento de datos utilizando herramientas como el paquete DBMS_SCHEDULER. - Modelado de Datos: Diseñar esquemas de bases de datos relacionales, incluyendo la creación de tablas, vistas materializadas, sinónimos y tipos de datos definidos por el usuario. - Mantenimiento y Depuración: Identificar y corregir errores en el código existente, además de documentar los cambios técnicos realizados. - Integración: Colaborar con desarrolladores de backend y frontend para integrar la lógica de base de datos con aplicaciones externas. Qualifications - Experiencia: Mínimo de 3 a 5 años trabajando directamente con Oracle Database. - Habilidades Técnicas: - Dominio avanzado de SQL y PL/SQL. - Experiencia en el uso de herramientas como Oracle SQL Developer o TOAD. - Conocimiento en colecciones (Nested Tables), funciones analíticas y manejo de excepciones. - Familiaridad con metodologías ágiles (Scrum/Kanban). - Educación: Título en Ingeniería en Sistemas, Computación o carrera afín. - Deseable: Experiencia en industria bancaria. Requirements - Capacidad de pensamiento sistémico y resolución de problemas complejos. - Habilidad para trabajar en equipos multidisciplinarios. - Orientación a resultados y atención al detalle en la integridad de los datos. Company Description Capgemini 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.

• Designing, developing, and implementing automated solutions for managing and optimizing Db2z and IMS databases • Implementing structural changes through environments and access method analysis • Optimizing Db2z resource utilization by tuning queries and recommending indexes • Processing Database Support Requests and Change requests in production and non-production environments • Building and implementing database backup and recovery strategies • Preparing disaster recovery (DR) documentation and participating in DR activities • Maintaining complex zOS Db2 databases with respect to JCL, DDL, Security and Db2 customer support • Providing technical training and consultation to other members of the IT organization • Supporting day-to-day monitoring and maintenance activities for Db2 z/OS • Responding to Audit requests and providing necessary documentation

• Develop & maintain naming standards for database objects such as tablespaces, tables, indexes & views • Install, configure, patch, maintain, and upgrade Oracle and Sql Server software and related products • Troubleshoot and resolve Oracle and Sql Server errors and user requests • Develop, implement, and enforce database standards, security guidelines and operational policies and procedures • Migrate database objects through the lifecycle management process for the development team • Monitor and apply performance tuning techniques to ensure the databases operate at high levels • Evaluate Oracle and Sql Server enhancements and features • Design and develop capacity planning processes of all databases • Review proposed architectural data models to ensure applications are being designed in accordance with database best practices • Other duties as assigned

• Install, configure, and maintain Microsoft SQL Server instances on Windows Server. • Manage databases across development, staging, and production environments. • Perform patching, upgrades, health checks, and routine maintenance tasks. • Monitor database and server performance using SQL Server-native tools and third-party platforms. • Optimize queries, indexes, jobs, and overall database architecture. • Diagnose and resolve performance bottlenecks across storage, compute, and SQL layers. • Design, implement, and maintain robust backup and recovery strategies. • Support HA/DR solutions including Always On Availability Groups, Clustering, Log Shipping, and Replication. • Ensure Affinitiv’s systems meet defined RPO/RTO requirements. • Manage database-level security, accounts, roles, encryption, and auditing. • Work with Security and Compliance teams to meet internal and external standards. • Monitor activity for abnormal or high-risk events and act proactively. • Partner with Infrastructure, Network, and Application teams to support server builds and configurations. • Develop and maintain scripts to automate routine tasks. • Leverage monitoring for proactive oversight. • Improve database management efficiency through automation and tooling enhancements. • Work closely with software engineering, SRE, and product teams to support database needs in application lifecycles. • Provide database expertise for new application features, deployments, and architecture decisions. • Maintain clear, thorough documentation of database structures, configurations, and procedures.