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”