Lc - DBA Oracle - Gdc

**RH**:Raul García**

**Position**:Oracle DBA

**Location**:any state of Mexico

**Industry - Sector**:Financial Services - Banking

**What you’ll do?**
- Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
- Databases shrink operations, DBCC commands
- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues
- Implementation of Query store, table partitioning, always encryption
- Performance tuning and optimization
- Resolving SQL server Performance bottle necks (100% CPU, Memory, Disk I/O)
- SQL Server Installation, Upgrades, Migrations and Configuration
- Install database software service packs and cumulative updates as necessary
- Maintain database documentation as required
- Maintain and administer database security access
- High Availability strategies for MS SQL environments (always on, clustering, log shipping, mirroring, replication)
- Perform database Ad-hoc backups and restores
- Troubleshoot and resolve database connectivity issues
- Follow Change Management processes to implement database configuration changes
- Follow Problem Management processes to troubleshoot and resolve recurring issues
- Proactively monitor and respond to MSSQL database Alerts.
- On-call requirements to ensure 24 x 7 support of database operations

**What you’ll bring**:

- 5+ years’ experience with on-premises administration of Oracle EBS
- Must understand logical and physical data modelling design concepts
- Good performance tuning skills
- Monitor various coding and job design implementations as per documented standards
- Strong knowledge of Multi-Tier (Web, Apps, Database and DMZ Tiers) Application support.
- Strong technical knowledge of concurrent processing, concurrent managers
- Provide security administration support with respect to users and privileges
- Manage backup, restore, and disaster recovery processes and procedures
- Manage deployments of code through non-production and production environments
- Participate in On-call rotation
- Experience with Precise I3
- Proficiency with Linux/Unix and ability to write complex shell scripts
- Hands on experience with EBS and database upgrades and migrations.

**Soft skills**:
Work Underpressure, Quality at work, Results Oriented

**What can YOU expect in a career with Capgemini?**
- Working in a team environment, Consultants will focus on the analysis, design and development of technology-based solutions for Capgemini’s clients.
- You will work alongside technical, functional and industry specialists to assist with the development, implementation and integration of innovative system solutions including methods, techniques and tools.
- You will contribute to client satisfaction by providing timely and responsive value-added services and work products.
- Capgemini offers a competitive compensation and benefits package.
- Headquartered in Paris, France, Capgemini has a presence of more than 340 thousand professionals in Mexico distributed among 3 sites located in Mexico City, Monterrey and Aguascalientes. A deeply multicultural organization.
- Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore, its worldwide delivery model.

**You will love this job because**
- Capgemini focuses on giving each new hire a YOU-nique experience through our recruitment process and on-boarding program, as well as by helping you to build your own career and professional skills foundation.
- Capgemini provides a collaborative environment that embodies and holds the following stated values close to heart: Honesty, Boldness, Trust, Freedom, Team Spirit, Modesty, and Fun.
- Capgemini cultivates an atmosphere for development that enables YOU to be hands-on, planning for your growth, both horizontally and vertically.