Database Administrator - L3 SQL Server

WilsonHCG

  • Canada
  • Permanent
  • Temps-plein
  • Il y a 1 mois
Description and RequirementsWork Type: Hybrid 2 days onsitePosition Type: Contract - 6 MonthsLocation: Scarborough, ONCompensation Range: $56 - $63 (Per Hour)Our client, a multinational technology company specializing in information technology services and consulting, is seeking a " Database Administrator - L3 SQL Server ".The position is responsible forResponsibilities:
  • Design, engineer, and deploy on MS SQL Server. Nice to have experiences on Oracle or AWS RDS, Redshift 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.
Qualifications:
  • 5+ years of hands-on DBA experience and strong skills on MS SQL server
Nice to have sound knowledge of Oracle or AWS RDS, Redshift, preferable with 1+ year hands-on experiencesSolid 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 skillsIn depth team and collaboration skillsIn depth Analytical and problem-solving skillsBachelor degree in computer science, engineering or related field or equivalent work experienceAll interested applicants who meet the qualifications listed above are invited to submit a resume by clicking "Apply Now".The indicated pay range for this position is a good-faith estimate based on the qualifications necessary for the position, including experience, training, and other considerations permitted by law. Additionally, it is emphasized that the pay band mentioned herein is the one established by the client company. Factors that may be used when making an offer may include a candidate's skills, experience and geographic location, the expected quality and quantity of work. Most candidates will start at the bottom half of the pay range, with the upper end reserved for candidates with extensive experience and skills and who live in geographic markets commanding a higher starting pay. An employee's pay history will not be a contributing factor where prohibited by local law.This information is subject to change and serves as a general guideline for compensation discussions. Actual offers may vary based on specific circumstances and company policies.

WilsonHCG