*rh*:raul garcía*
*position*:sql server 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*:
- 6 years of experience as a database administrator in sql server environment
- 6 years experience in transact sql, ssrs ssis package development
- 4 years of sql server database development / programming
- experience of administering sql server 2008, 2008r2,2012,2014,2016,2017 and 2019 databases
- experience with monitoring & diagnostic tools
- experience working with windows server, including active directory and disk configurations
- bachelor's\master's degree or equivalent combination of education and experience.
*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.