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.