SQL Database Administrator

Cognizant; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

An established industry player is looking for an experienced SQL Database Administrator to join a dynamic team supporting an Insurance client. In this role, you will lead the management and optimization of Azure SQL Managed Instances and SQL Server databases, ensuring high performance and availability. You will also troubleshoot various database issues, implement monitoring tools, and collaborate with development teams to design effective database solutions. This onsite position provides a great opportunity to contribute to essential projects while supporting a healthy work-life balance through various well-being programs.

Benefits

Well-being programs

Flexible working arrangements

Healthy work-life balance support

Qualifications

• 5+ years of experience in SQL Server Database Administration.
• Strong troubleshooting skills for database performance and integrity issues.

Responsibilities

• Manage and optimize Azure SQL databases for high performance.
• Lead database migration projects and ensure minimal downtime.

Skills

SQL Server Administration

Performance Tuning

Query Optimization

Database Migration

Troubleshooting

Backup and Recovery

Tools

Azure SQL Managed Instance

SQL Profiler

Foglight

Sentry

EMC Networker

Commvault

Job description

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 troubleshooting 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 troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Provide technical support and troubleshooting 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 troubleshooting tools on Azure SQL VM.

What will help you stand out (preferred skills):

• Hands-on experience with PostgreSQL, Oracle, and DB2 LUW Databases would be an advantage.
• Hands-on experience with monitoring tools such as Foglight, Sentry, Idea Litespeed.
• Hands-on experience with backup tools 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 transferable 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 through 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.