Jobs.ca
Jobs.ca
Language
Procom logo

SQL Server DBA

Procom26 days ago
Toronto, Ontario
Mid Level
contract

Top Benefits

Hybrid position with 3 days onsite
12-month contract position with the possibility of extension or conversion to full-time employment

About the role

SQL Server DBA: On behalf of our Banking client, Procom is searching for a SQL Server DBA for a 12-month role. This position is a hybrid position with 3 days onsite at our client’s Toronto office.

SQL Server DBA - Job Description: The Senior DBA will coordinate changes to computer databases, leveraging expertise in database management systems to implement and safeguard database applications. This role is critical in ensuring high availability, performance, and compliance of database systems while supporting application software development initiatives.

SQL Server DBA - Responsibilities:

  • Design, engineer, and deploy various RDBMS and NoSQL database technologies and platforms including Db2 LUW, Netezza, Oracle, SQL Server, Postgres, MongoDB, AWS RDS, and Redshift.
  • Develop optimal solutions for migrating or upgrading existing databases to new platforms or DBMS versions.
  • Build and utilize automation and DB DevSecOps pipelines for provisioning, upgrading, and maintaining database systems.
  • Support database change requests and troubleshoot issues in both production and non-production environments.
  • Monitor capacity, high availability, and performance of non-production and production databases to ensure reliability and efficiency.
  • Identify and implement performance tuning measures to enhance database performance.
  • Develop and maintain comprehensive backup and recovery strategies, ensuring proper execution of database backups.
  • Ensure compliance with security, audit, and operational standards through regular maintenance and optimization of databases.

SQL Server DBA - Mandatory Skills:

  • 5+ years of hands-on DBA experience with Db2LUW, Netezza, Oracle, SQL Server, Postgres, and MongoDB, with proficiency in at least two database management systems.
  • Strong knowledge of AWS RDS, Redshift, and DynamoDB, with at least one year of hands-on experience.
  • Sound understanding of the Software Development Life Cycle (SDLC).
  • Experience with database automation and DevSecOps tools such as Ansible, AWS CDK, GitHub Actions, and Liquibase, along with shell scripting and Python.
  • Bachelor’s degree in computer science, engineering, or a related field, or equivalent work experience.

SQL Server DBA – Nice-to-Have Skills:

  • Demonstrates in-depth analytical skills and problem-solving abilities.
  • Exhibits strong collaboration and teamwork skills to work effectively with cross-functional teams.
  • Has experience in managing critical database issues and responding promptly under pressure.
  • Possesses excellent verbal and written communication skills to articulate technical concepts to diverse audiences.

SQL Server DBA – Assignment Length: This is a 12-month contract position with the possibility of extension or conversion to full-time employment.

SQL Server DBA - Start Date: ASAP

SQL Server DBA - Assignment Location: Toronto, Ontario, Canada. This is a hybrid role requiring 3 days onsite per week.

About Procom

IT Services and IT Consulting
5001-10,000

Procom is one of North America’s leading staffing and contract workforce services providers. Successfully meeting the needs of Fortune 500 clients since 1978, we have 18 offices across North America, with over 12,500 skilled professionals currently on assignment.

We are an award winning staffing firm. Discover more about our Best of Staffing award and what real clients and job seekers have to say about working with Procom by checking out our client and talent ratings on ClearlyRated.

Procom has long been recognized as a market-leading source of high-performing services and solutions that transform how our clients acquire and manage the very best talent. Relying on the excellence of individuals to make a difference, we know that people matter.

And we want to work with you.