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”