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
* 4 years of sql server database development / programming
* 6 years experience in transact sql, ssrs ssis package development
* 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.
“ 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”