We are seeking an experienced SQL Database Administrator to join our dynamic team with an Insurance client. The role involves managing and optimizing our database infrastructure across Canada locations.
In this role, you will:
- Lead and optimize Azure SQL Managed Instance and SQL Server databases to ensure high performance and availability.
- Lead database migration projects and upgrades to minimize downtime and disruption.
- Experience in trouble shooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Ability to detect and trouble shoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
- Provide technical support and trouble shooting for database-related issues.
- Implement and maintain database monitoring tools to proactively determine and resolve performance issues.
- Collaborate with development teams to design and implement database solutions that meet business requirements.
- Conduct regular database maintenance tasks, including indexing, statistics updates, and performance tuning.
- Develop and maintain documentation for database configurations, processes, and procedures to ensure compliance with industry standards for database management.
What you’ll need to succeed (required skills):
- Experience in Database Administration in SQL Server. (2008R2, 2014, 2016, 2017, 2019 and 2022)
- Proficiency in maintaining database scalability by planning and forecasting.
- Solid understanding of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, Always ON.
- Expertise in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and trouble shooting tools on Azure SQL VM.
What will help you stand out (preferred skills):
- Hands on experience on PostgreSQL, Oracle and DB2 LUW Databases would be added as advantage.
- Hands on Monitoring tool such as Foglight, Sentry, Idea Litespeed.
- Hands on Backup tool such as EMC Networker, Litespeed and Commvault.
At Cognizant, we're eager to meet people who believe in our mission and can make an impact in various ways! We strongly encourage you to apply even if you only meet the required skills listed. Consider what transferrable experience and skills make you an outstanding applicant and help us see how you'd be helpful to this role.
Cognizant will only consider applicants for this position who are legally authorized to work in Canada without requiring employer sponsorship, now or at any time in the future.
At Cognizant, we strive to provide flexibility wherever possible, and we are here to support a healthy work-life balance though our various wellbeing programs. Based on this role’s business requirements, this is an onsite position requiring 3 days a week in a client office based in Ontario or Nova Scotia.
Regardless of your working arrangement, we are here to support a healthy work-life balance through our various well-being programs.
Note: The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.
La Comunidad Cognizant:
Somos un equipo que se aprecia y apoya mutuamente. Nuestros asociados trabajan en un entorno colaborativo e integrador en el que todos pueden prosperar.
- Cognizant es una comunidad global con más de 300.000+ asociados en todo el mundo.
- No solo soñamos con un mundo mejor, sino que trabajamos para hacerlo realidad.
- Cuidamos de nuestros asociados, clientes, socios, comunidades y entorno haciendo lo correcto.
- Fomentamos un entorno innovador en el que puedes desarrollar tu carrera profesional.
Acerca de nosotros
Cognizant es una de las principales empresas de servicios profesionales del mundo, transformando los modelos de negocio, operativos y tecnológicos de los clientes para la era digital. Nuestro enfoque consultivo único, basado en la industria, ayuda a los clientes a visualizar, construir y gestionar negocios más innovadores y eficientes. Con sede en los EE. UU., Cognizant (miembro del NASDAQ-100 y uno de los mejores empleadores del mundo según Forbes en 2024) está constantemente listado entre las empresas más admiradas del mundo. Descubra cómo Cognizant ayuda a los clientes a liderar con lo digital en www.cognizant.com.
Cognizant es un empleador que ofrece igualdad de oportunidades. Tu solicitud y candidatura no serán consideradas en base a raza, color, sexo, religión, credo, orientación sexual, identidad de género, origen nacional, discapacidad, información genética, embarazo, condición de veterano o cualquier otra característica protegida por las leyes federales, estatales o locales.
Si tienes alguna discapacidad que requiera ciertas adaptaciones para buscar un puesto de trabajo o presentar una solicitud, envía un correo electrónico a [email protected] con tu solicitud e información de contacto.
Advertencia:
La información sobre remuneración es exacta a la fecha de esta publicación. Cognizant se reserva el derecho a modificar esta información en cualquier momento, sujeto a la legislación aplicable.Es posible que los candidatos deban asistir a entrevistas en persona o por videoconferencia e, incluso, que tengan presentar su documento de identidad vigente, durante cada entrevista.