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.
or continue with email
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.
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more
