Job Title: SQL Server DBA
Location: Toronto, ON M1W 3E8 (Hybrid • 2 days/week onsite)
Duration: 12 months
Contract Type: T4 only
Pay Rate: CA$68.96/Hour

SUMMARY:

• Responsible for coordinating changes to computer databases, test and implement the database applying knowledge of database management systems.
• Responsible for planning, coordinating and implementing security measures to safeguard the computer database.

Responsibilities:

• Design, engineer, and deploy on a breadth of RDBMS and NoSQL database technologies and platforms such as Db2 LUW, Netezza, Oracle, SQL Server, Postgres, MongoDB, AWS RDS, Redshift, other DBMS technologies.
• Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions
• Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems
• Support DB change request and problem investigation and resolution of both production and non-production environments.
• Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality.
• Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate.
• Develops and maintains database backup and recovery strategy and procedures. Ensures that databases are properly backed up and recovered when necessary
• Ensures databases are properly maintained, meeting security, audit and compliance requirements. Databases are reorganized/groomed when necessary and other DBA utilities run when appropriate.
• Tests upgrades/new releases of database software and related products. Assesses impacts to application and the database environment.
• Responds immediately to critical issues. On call and/or shift duty may be required.

Requirements:

• 5+ years of hands-on DBA experience with Db2LUW, Netezza, Oracle, SQL server. Postgres, MongoDB. Proficient DBA skills for at least 2 DBMS.
• Sound knowledge of AWS RDS, Redshift, DynamoDB, preferable with 1+ year hands-on experiences
• Solid understanding of the Software Development Life Cycle (SDLC)
• Sound knowledge and 1+year experience with Database automation and DB DevSecOps (e.g. Ansible, AWS CDK, Github Action, Liquibase, shell scripting, python, SQL)
• Excellent oral and written communication skills
• In depth team and collaboration skills
• In depth Analytical and problem-solving skills
• Bachelor degree in computer science, engineering or related field or equivalent work experience

• Design, engineer, and deploy on a breadth of RDBMS and NoSQL database technologies and platforms such as Db2 LUW, Netezza, Oracle, SQL Server, Postgres, MongoDB, AWS RDS, Redshift, other DBMS technologies.
• Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions
• Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems
• Support DB change request and problem investigation and resolution of both production and non-production environments.
• Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality.
• Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate.
• Develops and maintains database backup and recovery strategy and procedures. Ensures that databases are properly backed up and recovered when necessary
• Ensures databases are properly maintained, meeting security, audit and compliance requirements. Databases are reorganized/groomed when necessary and other DBA utilities run when appropriate.
• Tests upgrades/new releases of database software and related products. Assesses impacts to application and the database environment.
• Responds immediately to critical issues. On call and/or shift duty may be required