Industry - sector:
financial services – banking
what you’ll do?
* monitor and maintain database maintenance plans for backups, index rebuild/defragmentation, and database statistics.
* perform database shrink operations and execute dbcc commands.
* troubleshoot and resolve database integrity, performance, blocking, and deadlocking issues.
* implement features like query store, table partitioning, and always encrypted.
* perform performance tuning and optimization.
* resolve sql server performance bottlenecks such as high cpu, memory, and disk i/o.
* handle sql server installations, upgrades, migrations, and configurations.
* install database software service packs and cumulative updates as needed.
* maintain comprehensive database documentation.
* administer database security and access controls.
* develop high availability strategies including always on, clustering, log shipping, mirroring, and replication.
* perform ad-hoc database backups and restores.
* troubleshoot and resolve database connectivity issues.
* follow change management processes for database configuration changes.
* implement problem management to troubleshoot recurring issues.
* proactively monitor and respond to mssql database alerts.
* participate in on-call rotations for 24x7 database support.
what you’ll bring:
* 6+ years of experience as a sql server database administrator.
* 6+ years of experience with transact-sql, ssrs, and ssis package development.
* at least 4 years of sql server database development and programming.
* experience managing sql server versions 2008 through 2019.
* proficiency with monitoring and diagnostic tools.
* experience working with windows server environments, including active directory and disk configurations.
* bachelor's or master's degree or equivalent experience.
* ability to work under pressure, focus on quality, and be results-oriented.
what can you expect in a career with capgemini?
* collaborate in a team environment focused on analyzing, designing, and developing technology solutions.
* work alongside industry specialists on innovative system solutions.
* contribute to client satisfaction with timely, value-added services.
* benefit from a competitive compensation and benefits package.
* join a multicultural organization with a global delivery model.
you will love this job because
* capgemini offers a personalized onboarding and career development environment.
* values such as honesty, boldness, trust, and teamwork are core to our culture.
* we support your professional growth both horizontally and vertically.
at capgemini mexico, we are committed to diversity and inclusion, welcoming applications regardless of race, sex, sexual orientation, gender identity, or other characteristics. Applications are considered based on merit.
joining capgemini means becoming part of something bigger. Learn about our recruitment process, application steps, and interview tips to prepare for your journey with us.
#j-18808-ljbffr