Senior SQL DBA

Contract
Toronto
Posted 2 years ago

Progression3 is in search of a Senior SQL Database Administrator for a 6-month contract with our client in Toronto.

Primary Duties and Responsibilities:

  • Monitor and review daily the database environments to validate, performance, resourcing and system availability, review database logs for system reported problems, taking corrective action where required, confirm database backups.
  • Database build, installation and configuration and patching of SQL 2016/2017 environments.
  • Monitor, action, triage and resolve a variety of complex, often unique incidents with single and multi-node SQL environments. Engage the vendor where required to develop action plans to ensure prompt resolution. Lead the resolution of complex database issues engaging and communicating with the client as required.
  • Assess, create and execute Request for Changes (RFC). Develop implementation plans, lead and coordinate the RFC with the client for DCO Database submitted RFCs.
  • Creation of support configuration documentation as required for knowledge transfer

Required Qualifications:

  • 10-15 years of technical experience with Microsoft SQL 2008-2017 database administration in the installation, configuration and management of Clustered/AlwaysOn/Single-Node environments.
  • Demonstrated SQL experience in Windows and VMWare ESXi environments.
  • Demonstrated experience in the operational administration of the SQL database environment: account and file group management, instance creation, backup execution and management.
  • Demonstrated experience monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.
  • Demonstrated experience triaging and resolving a variety of complex, SQL clustered/single-node database management and configuration issues.
  • Demonstrated experience in developing installation plans and executing version and patch upgrades to a variety of Microsoft SQL environments/configurations.
  • Subject Matter Expert (SME) in the area of database administration, configuration, troubleshooting and optimization.
  • Demonstrated experience in utilizing ITIL tools and processes; assessing, creating and executing Request for Changes (RFC).
  • Demonstrated experience in developing implementation plans, leading and coordinating the RFC with the client.
  • Demonstrated experience with database optimization and encryption; configuration of SqlServer services, PowerBI, R and Python server, DQS, MDSProgression3 is in search of a Senior SQL Database Administrator for a 6-month contract with our client in Toronto.

Primary Duties and Responsibilities:

  • Monitor and review daily the database environments to validate, performance, resourcing and system availability, review database logs for system reported problems, taking corrective action where required, confirm database backups.
  • Database build, installation and configuration and patching of SQL 2016/2017 environments.
  • Monitor, action, triage and resolve a variety of complex, often unique incidents with single and multi-node SQL environments. Engage the vendor where required to develop action plans to ensure prompt resolution. Lead the resolution of complex database issues engaging and communicating with the client as required.
  • Assess, create and execute Request for Changes (RFC). Develop implementation plans, lead and coordinate the RFC with the client for DCO Database submitted RFCs.
  • Creation of support configuration documentation as required for knowledge transfer

Required Qualifications:

  • 10-15 years of technical experience with Microsoft SQL 2008-2017 database administration in the installation, configuration and management of Clustered/AlwaysOn/Single-Node environments.
  • Demonstrated SQL experience in Windows and VMWare ESXi environments.
  • Demonstrated experience in the operational administration of the SQL database environment: account and file group management, instance creation, backup execution and management.
  • Demonstrated experience monitoring, validating and tuning database performance, to meet SLA performance SLA objectives.
  • Demonstrated experience triaging and resolving a variety of complex, SQL clustered/single-node database management and configuration issues.
  • Demonstrated experience in developing installation plans and executing version and patch upgrades to a variety of Microsoft SQL environments/configurations.
  • Subject Matter Expert (SME) in the area of database administration, configuration, troubleshooting and optimization.
  • Demonstrated experience in utilizing ITIL tools and processes; assessing, creating and executing Request for Changes (RFC).
  • Demonstrated experience in developing implementation plans, leading and coordinating the RFC with the client.
  • Demonstrated experience with database optimization and encryption; configuration of SqlServer services, PowerBI, R and Python server, DQS, MDS

Apply Online