Skip to content

Open nowFirst seen 32 hours ago

RQ00620 - Sr. Database Administrator

SourceCode857 open roles

Where
Toronto, ON, Canada
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowRQ00620 - Sr. Database AdministratorSourceCode · Toronto, ON, Canada
  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on SourceCode's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

11.5% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.0%1 day
  2. 4.3%3 days
  3. 11.5%7 days
  4. 18.1%14 days
  5. 35.6%30 days
  6. 44.6%60 days
This job: first seen 32 hours ago

The posting

RQ00620 - Sr. Database Administrator

6-month contract (125 business days)- possible extension

Up to 5 days onsite ( subject to HM's discretion) - 525 University Avenue Toronto

Background:

The Database Administrator will support the next phase of the modernization strategy, OH is committed to migrate appropriate products to Azure Cloud platform and identifying opportunities to improve and mature existing processes both on cloud as IAAS and PAAS from database administration and cloud engineering perspective. As the Agency makes progress towards a more efficient and stream-lined health system, an investment in MS Azure/Synapse platforms and requires maintenance and operation support to sustain growth.

Qaulifications:

  • At least 7- 9 years of proven working experience as a SQL Server(Azure and on-prem)
  • At least 5 year proven experience working experience Azure Synapse Analytics
  • Must have extensive experience with SQL server 2012/14/16/19 on Windows and Linux operating system.
  • At least 5 years of experience managing Azure Sql dedicated pool, Data Lake and Server less.
  • Must has experience on Azure Managed Instance and Azure Sql database
  • Demonstrated understanding of performance tuning and analysis in an Microsoft SQL Server environments
  • Must have MS Azure Fundamentals (AZ-900T00), Microsoft Azure Data Fundamentals(DP-900) and Administering Microsoft Azure SQL Solutions(DP-300) certification

Desired Skills:

  • Experience with distributed data systems
  • Exerience with middleware and gateways
  • Experience with researching and implementing cyber security vulnerability remediations
  • Awareness of emerging IT trends and directions
  • Experience with Computer Aided Software Engineering (CASE) tools
  • Knowledge and understanding of Information Management principles, concepts, policies and practices Experience in Database Administration, Maintenance Optimization
  • Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE
  • Subject matter expert in database design of the data warehouse or data marts
  • Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning

Required Skills:

  • Additional Skills for Case Management and ERP
  • Experience in designing/developing an automated data distribution mechanism Knowledge and understanding of object-oriented analysis and design techniques.
  • Experience in developing enterprise architecture deliverables (e.g. models) based
  • Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
  • Knowledge and understanding of Information Management principles, concepts, policies and practices
  • Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
  • Experience in technical design, planning and implementation of specific technology or suite Experience with database administration and vendor support services
  • Experience and Skill Set Requirements.

Deliverables:

  • Responsible to support the installation, configuration, security, operation, and maintenance of SQL Servers for new servers builds with special focus on Sql Managed Instance.
  • Responsible for the development, execution and analysis of database expansions, re-organization and purging of Sql 2019
  • Participates in the long-term technical strategy and architecture for the Data Warehouse and Analytics Data Hub
  • Develops systems and processes to monitor data quality or integrity, diagnose problems and implement solutions.
  • Provides expertise in the support of complex cross-platform database migrations and data governance activities.
  • Responsible of SQL high availability options (Log Shipping, DB Mirroring, DB Clustering)
  • Resolves and debugs complex reporting and analytic application problems
  • Participates in the creation and maintenance of the Enterprise Data Strategy Plan
  • Responsible for managing the SQL databases on Azure Cloud, SQL Always-On and Clustering.
  • Provides knowledge and direction assistance to support a hybrid environment of on premise and cloud-based database environments.
  • Configure, manage, monitor and maintain database server performance, health, availability and security.
  • Provide feedback and recommendations to management for best course of action where needed
  • Participates in problem analysis and resolution, for example tuning of sql query, deadlocks, data problems, access times, application recoveries, etc
  • Performs software review, evaluation, recommendations, design and implementation for database management tools.
  • Leads database disaster recovery design, implementation and monitoring.
  • Patching, and database backup including testing and execution of SQL and Oracle database backup and recovery processes
  • Provide guidance and reference to Tier 1 and Tier 2 Service Desk resources, as well as Tier 3 team members

Must Haves:

  • At least 7- 9 years of proven working experience as a SQL Server(Azure and on-prem)
  • At least 5 years of proven experience working with Azure Synapse Analytics
  • Must have extensive experience with SQL server 2012/14/16/19 on Windows and Linux operating system.
  • At least 5 years of experience managing Azure SQL dedicated pool, Data Lake and Serverless.

Nice-to-Have:

  • Public Sector experience
From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against SourceCode's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.
  3. We apply on SourceCode's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.
  4. Every reply, sorted

    SourceCode's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.
  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.