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
Analyse and apply patches, hot fixes, upgrades, and product enhancements
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
Excellent knowledge of ERP cloning, Apps/database refresh, backup recovery of ERP applications
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.
“At Capgemini Mexico, we aim to attract the best talent and are committed to creating a diverse and inclusive work environment, so there is no discrimination based on race, sex, sexual orientation, gender identity or expression, or any other characteristic of a person. All applications welcome and will be considered based on merit against the job and/or experience for the position”
