Rh:
raul garcía
position:
sql server dba
location:
any state of mexico
industry - sector:
financial services – banking
what you’ll do?
1. monitor and maintain database maintenance plans for backups, index rebuild/defragmentation, and database statistics.
2. perform database shrink operations and execute dbcc commands.
3. troubleshoot and resolve database integrity, performance, blocking, and deadlocking issues.
4. implement query store, table partitioning, and encryption.
5. perform performance tuning and optimization.
6. resolve sql server performance bottlenecks related to cpu, memory, and disk i/o.
7. handle sql server installation, upgrades, migrations, and configuration.
8. apply database software service packs and cumulative updates as needed.
9. maintain documentation related to databases.
10. manage and administer database security access.
11. develop high availability strategies for ms sql environments (e.g., always on, clustering, log shipping, mirroring, replication).
12. perform ad-hoc database backups and restores.
13. troubleshoot and resolve database connectivity issues.
14. follow change management processes for configuration changes.
15. follow problem management processes to troubleshoot recurring issues.
16. monitor and respond proactively to mssql database alerts.
17. participate in on-call support to ensure 24/7 database operations.
what you’ll bring
1. at least 6 years of experience as a database administrator in sql server environments.
2. at least 4 years of sql server database development and programming.
3. experience with transact-sql, ssrs, and ssis package development.
4. experience administering sql server versions 2008, 2008 r2, 2012, 2014, 2016, 2017, and 2019.
5. experience with monitoring and diagnostic tools.
6. knowledge of windows server, including active directory and disk configurations.
7. bachelor's or master’s degree, or equivalent education and experience.
soft skills
ability to work under pressure, focus on quality, and be results-oriented.
what can you expect in a career with capgemini?
* work in a team environment, focusing on analyzing, designing, and developing technology solutions for clients.
* collaborate with technical, functional, and industry specialists to implement innovative solutions.
* contribute to client satisfaction through timely, responsive, and value-added services.
* enjoy a competitive compensation and benefits package.
* join a multicultural organization with over 340,000 professionals across mexico, headquartered in paris, france.
* experience our unique working approach, the collaborative business experience™ and the rightshore delivery model.
you will love this job because
* capgemini offers a personalized onboarding and career development experience.
* we foster a collaborative environment rooted in our core values: honesty, boldness, trust, freedom, team spirit, modesty, and fun.
* we support your growth both horizontally and vertically, encouraging hands-on involvement.
at capgemini mexico, we are committed to diversity and inclusion, welcoming applications regardless of race, sex, sexual orientation, gender identity, or other characteristics. All applications will be considered based on merit.
#j-18808-ljbffr