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”