Rh: raul garcía
position: sql server dba
location: any state of mexico
industry/sector: financial services - banking
responsibilities
* monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics
* perform database shrink operations and dbcc commands
* diagnose and resolve database integrity, performance, blocking, and deadlocking issues
* implement query store, table partitioning, and transparent data encryption
* optimize performance and tuning of queries and indexes
* address sql server performance bottlenecks such as 100% cpu, memory, and disk i/o
* install, upgrade, migrate, and configure sql server environments
* apply database software service packs and cumulative updates as needed
* maintain database documentation and security access controls
* manage high‑availability strategies for ms sql environments (always on, clustering, log shipping, mirroring, replication)
* execute ad‑hoc backups and restores
* troubleshoot database connectivity issues
* follow change‑management processes for configuration changes
* follow problem‑management processes to resolve recurring issues
* proactively monitor and respond to mssql database alerts
* provide on‑call support to ensure 24/7 database operations
qualifications
* 6 years of experience as a database administrator in a sql server environment
* 4 years of sql server database development/programming experience
* 6 years of experience in transact‑sql, ssrs, and ssis package development
* experience with monitoring and diagnostic tools
* experience working with windows server, including active directory and disk configurations
* bachelor’s or master’s degree (or equivalent combination of education and experience)
soft skills
* work under pressure
* quality at work
* results oriented
benefits
capgemini offers a competitive compensation and benefits package.
#j-18808-ljbffr