*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.