SQL Database Administrator

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.

The Cognizant community:
We are a high caliber team who appreciate and support one another. Our people uphold an energetic, collaborative and inclusive workplace where everyone can thrive.

Cognizant is a global community with more than 300,000 associates around the world.
We don’t just dream of a better way – we make it happen.
We take care of our people, clients, company, communities and climate by doing what’s right.
We foster an innovative environment where you can build the career path that’s right for you.
About us:
Cognizant is one of the world’s leading professional services companies, transforming clients’ business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World’s Best Employers 2024) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com

Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, state or local laws.

Disclaimer:
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Apply nowSave