This recruiter is online.

This is your chance to shine!

Apply Now

Senior SQL Database Administrator - project migration to Cloud- 74228

Toronto, ON
  • Number of positions available : 1

  • To be discussed
  • Contract job

  • Starting date : 1 position to fill as soon as possible




Job Description:

• Proactive Performance and Capacity review

• Serve as SME (subject matter expert) for Microsoft SQL Server and Azure

• Perform database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always-On.

• Accountable for day-to-day activities regarding the upkeep and availability of all Prod-Non Prod database servers

• SQL code-review for the application teams to enforce SQL coding standards and tune

• Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.

• Assist in the technical analysis and design for current and future projects.

• Migrate the database from On-Prem to Azure

Must Have Requirement:

  • 5+ Years' of SQL experience including T-SQL
  • 3+ years' of Azure database experience *Azure is priority although willing to consider other cloud experience
  • Experience with large database and heavy transactions
  • Knowledge of API

Nice to Have:

  • Banking experience is a strong nice to have
  • KeyVault experience would be great
  • CDC experience also nice to have



Apply

Requirements

Level of education

undetermined

Work experience (years)

undetermined

Written languages

undetermined

Spoken languages

undetermined