About this Database Administrator role at Financial Services Regulatory Authority of Ontario

Financial Services Regulatory Authority of Ontario · Onsite · Toronto, ON

At FSRA, our vision is to ensure financial safety, fairness, and choice for Ontarians. As a financial services regulator, we’re passionate about protecting consumers. Our principles-based approach means we can quickly and effectively respond to the changing needs of consumers and the industry.
 

Our team combines industry expertise with commitment to public service. We attract individuals who are interested in meaningful work and who measure success through outcomes, not inputs.
 

At FSRA, we invest in the personal and professional growth of our team.  We offer a competitive compensation package that includes an employer-matched defined benefit pension plan, and a comprehensive and competitive benefits plan. We prioritize learning and development, wellbeing, diversity, equity, inclusion and belonging, and community giving.
 

Join FSRA and help us shape the future of regulation for generations to come!

Job Description:

PURPOSE OF POSITION


Accountable for providing highly specialized senior level technical expertise, oversight and support in the project implementation and administration of FSRA database systems to ensure all business operations are fully supported in the areas of design, setup, configuration, performance, capacity, monitoring, backup and recovery, security, maintenance and repair and disaster recovery.


KEY RESPONSIBILITIES


  • Provides highly specialized senior technical leadership and expertise in database technologies to research, scope, design, plan, implement, as per project initiatives, and maintain and support.
  • FSRA’s database environment and technologies and FSRA’s long-term strategic goals.
  • Determines and implements strategies for the setup, configuration and maintenance required for all database systems that will enhance efficiency, effectiveness or provide appropriate security and safeguards.
  • Plans resources, leads, coordinates, evaluates and reports on technical aspects of multiple concurrent or sequential projects including: providing technical guidance, coordination and instruction, monitoring progress and problem-solving and reporting to management with recommendations.
  • Experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Data Factory pipelines, cloud-based data engineering, and working knowledge of PySpark and modern data governance practices would be an asset.
  • Monitors and maintains database system operations and integration of servers, network, security, in support of client business requirements.
  • Assesses the systems environment and executes database system health checks, performance, and capacity reporting.
  • Develops scripts for automating tasks.
  • Serve as a technical expert for second level support groups and provides solutions for the resolution of database access and performance issues.
  • Defines Key Performance Indicators and create reporting for database environments.
  • Develops and maintains processes to ensure continuous operation of all database systems.
  • Installs updates and patches both database systems and applications published by the manufacturer.
  • Maintains database systems’ security, including user access rights.
  • Analyzes service incidents and problems, identifies risks, provides recommendations, and implements solutions.
  • Plans and coordinates data migrations between systems and maintains replicated databases (eg. Log Shipping, Always-On, Mirroring, etc.).
  • Keeps current with trends and issues in technology, reports and provides updates on current IT technologies, pricing, and innovations for consideration.
  • Designs, implements, maintains, and tests Disaster Recovery plans, that meet business platform RTO & RPO. · Develops technical documentation to facilitate the implementation and adoption of system changes; develops and maintains documentation and Knowledge Base materials.

QUALIFICATIONS

Education and Experience

  • Degree/diploma in Information Technology, or related field.
  • Certifications: MCSA: SQL Server or MCSA, Microsoft Certified Solutions Expert (MCSE): Data Platform.
  • 5 years of experience as a Database Administrator (MS SQL a must).
  • 5 years of experience in database design/architecture, data modeling, security, performance, scaling and tuning for large environments
  • 5 years of experience with relational databases, database structures and design, systems design, data management, data warehouse. Including Power shell
  • Preferred Microsoft certifications: DP-700 (Fabric Data Engineer Associate) and/or DP-600 (Fabric Analytics Engineer Associate), with DP-300 (Azure Database Administrator Associate) considered an asset.
  • Technical experience in leading the design, building, installation, configuration and support of
  • database environments, with focus on SQL Server in a production environment.
  • Working knowledge of Hyper-V, Microsoft Windows Server, Enterprise Storage (RAID, SAN, and
  • NAS), Cloud Administration, and Virtualization.
  • Knowledge and Skills
  • Advanced knowledge of database structure and theory, and design.
  • Demonstrated knowledge of database administration methods and techniques to act as FSRA’s
  • technical expert in database administration.
  • Strong knowledge of database tuning and troubleshooting practices, including high performance and
  • high availability implementations, ensuring database integrity and performance standards are met.
  • Familiarity with database technologies, operating systems, platforms, storage, and network.
  • Knowledge of System Security and data backup/recovery.
  • Project skills to lead database initiatives.
  • Proven analytical and methodical skills.
  • Strong collaboration and customer service orientation.
  • Excellent oral and written communication skills.


 *Please note that this position will close at 12AM on the expiry date*

#LI-Onsite

Compensation Grade:

Grade 272-OPSEU ADM

Compensation Range:

$1,852.71

-

$2,314.51

Bargaining Unit:

OPSEU

Job Code:

Job Code: 17162

Employment Type:

Regular

Scheduled Weekly Hours:

36.25

FSRA is committed to ensuring equity in employment. Our goal is to create a diverse, inclusive workforce that reflects the communities we serve and to ensure our services and communications are accessible to all individuals. Accommodation is available under the Ontario Human Rights Code.

NOTE: ONLY QUALIFIED CANDIDATES WILL BE CONSIDERED  

Ready to apply to Financial Services Regulatory Authority of Ontario?
Apply to Financial Services Regulatory Authority of Ontario

About Financial Services Regulatory Authority of Ontario

The Financial Services Regulatory Authority of Ontario (FSRA) is a dynamic, innovative, independent and self-funded regulator of financial services and pensions. The organization promotes strong financial services and pension sectors while protecting the public interest. FSRA has responsibility for regulating property and casualty insurance (including auto insurance rates); life and health insurance; credit unions and caisses populaires; loan and trust companies; mortgage brokers; health service providers (related to auto insurance); and pension plans. We are building an agile, forward-thinking and collaborative culture, and FSRA is committed to encouraging innovation and competition, and pr

See all jobs at Financial Services Regulatory Authority of Ontario →

Similar jobs

Financial Services Regulatory Authority of Ontario
Technical Lead, Business Development (Full Stack Developer)
Financial Services Regulatory Authority of Ontario
⚡ Apply early Toronto, ON Onsite
● New 👁 Seen ✓ Applied 4d ago
Financial Services Regulatory Authority of Ontario
Inquiry and Correspondence Officer
Financial Services Regulatory Authority of Ontario
⚡ Apply early Toronto, ON Onsite $66,943–$92,642
● New 👁 Seen ✓ Applied 1w ago
Financial Services Regulatory Authority of Ontario
Data Architect
Financial Services Regulatory Authority of Ontario
⚡ Apply early Toronto, ON Onsite $86,379–$127,288
● New 👁 Seen ✓ Applied 1mo ago
Financial Services Regulatory Authority of Ontario
Lead Infrastructure Architect
Financial Services Regulatory Authority of Ontario
⚡ Apply early Toronto, ON Hybrid $105,370–$165,060
● New 👁 Seen ✓ Applied 2mos ago
HelloFresh
Senior Associate, Social & Brand Marketing (The Pets Table)
HelloFresh
⚡ Apply early Toronto, Ontario, Canada Onsite CA$72,450–CA$82,450
● New 👁 Seen ✓ Applied 25m ago
CoreWeave
Account Executive - Greenfield - Toronto
CoreWeave
⚡ Apply early Toronto, ON Onsite
● New 👁 Seen ✓ Applied 45m ago
CoreWeave
Account Executive - Greenfield
CoreWeave
⚡ Apply early Chicago, IL / Seattle, WA / Lo... Onsite $165,000–$195,000
● New 👁 Seen ✓ Applied 45m ago
Ramp
Senior Customer Activation Manager | Partnerships
Ramp
⚡ Apply early New York, NY (HQ) Hybrid $138,000–$210,000
● New 👁 Seen ✓ Applied 3h ago
Okta
Staff Site Reliability Engineer
Okta
⚡ Apply early Toronto, ON, Canada Onsite CA$168,000–CA$231,000
● New 👁 Seen ✓ Applied 3h ago

Sign up for suggestions tailored to the jobs you open and the searches you save.

More jobs at Financial Services Regulatory Authority of Ontario

See all jobs at Financial Services Regulatory Authority of Ontario →

Apply now
🤖

Whoa — hold up

JobsRadar was built for real people having a rough time in their job search — not for automated requests. You're clicking way too fast and you're now temporarily blocked.

Come back later. If you're genuinely job hunting, we've got your back — just act like a human.

Catch your next role the second it’s posted.

Create a free account and we’ll watch the boards for you — the instant a job matches your search, it lands in your inbox or Telegram. No digging, no refreshing.

Create free account

Free forever · takes 30 seconds · already have one?

Get an edge on your job hunt.

Join our Telegram channel for the stuff that helps you land the role — salary benchmarks, the weekly market pulse, and new-feature drops. No spam, just signal.

Join the channel — it's free