Database Administrator

Financial Services Regulatory Authority of Ontario

Toronto

On-site

CAD 100,000 - 150,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Financial Services Regulatory Authority of Ontario (FSRA) is seeking a Senior Database Administrator to lead, design, implement and maintain FSRA's database environments. You will ensure performance, security, disaster recovery and data integrity across enterprise systems, leveraging SQL Server and modern data tools.

You will collaborate with cross-functional teams, develop automation scripts, and establish ongoing monitoring, reporting, and governance to support regulatory operations and data

Qualifications

  • Degree/diploma in Information Technology or related field.
  • Certifications: MCSA SQL Server or 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 and data management including data warehouse; PowerShell.
  • Microsoft Fabric DP-700/DP-600 certifications preferred; DP-300 asset.
  • Experience leading design, building, installation, configuration and support of SQL Server production environments.
  • Knowledge of Hyper-V, Windows Server, enterprise storage, cloud administration and virtualization.

Responsibilities

  • Provide senior technical leadership in database technologies for design, plan, implement and maintain projects.
  • Oversee FSRA's database environment and align with long-term goals.
  • Define setup, configuration and maintenance strategies for security and safeguards.
  • Plan resources, coordinate projects, monitor progress and report to management with recommendations.
  • Monitor and maintain database operations and integration with servers, network and security.
  • Develop scripts to automate tasks.
  • Serve as technical expert for second-level support and resolve access/performance issues.
  • Define KPIs and create reporting for database environments.
  • Develop and maintain processes for continuous operation and disaster recovery testing.
  • Install updates and patches for database systems and applications; maintain security with proper access controls.
  • Document changes and maintain knowledge base materials.

Skills

Database Administrator (MS SQL)
Database design/architecture
Data modeling
PowerShell

Education

Degree/diploma in IT or related field
MCSA: SQL Server
MCSE: Data Platform
DP-700 Fabric Data Engineer Associate
DP-600 Fabric Analytics Engineer Associate
DP-300 Azure Database Administrator Associate

Tools

Hyper-V
Microsoft Windows Server
Enterprise Storage (RAID, SAN)
Cloud Administration
Virtualization

Job description

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 ad
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Administrator
Database Administrator

Financial Services Regulatory Authority (FSRA) • Toronto

On-site
CAD 84,000 - 105,000
Equity in employment
Accommodation available under OHRC
Database Administrator
Database Administrator

Financial Services Regulatory Authority of Ontario • Canada

On-site
CAD 84,000 - 105,000
Senior SQL Database Architect & HA/DR Expert
Senior SQL Database Architect & HA/DR Expert

Financial Services Regulatory Authority (FSRA) • Toronto

On-site
CAD 84,000 - 105,000
Equity in employment
Accommodation available under OHRC
Database Administrator
Database Administrator

Fsrao • Toronto

On-site
CAD 90,000 - 120,000
Lead Infrastructure Architect
Lead Infrastructure Architect

Financial Services Regulatory Authority (FSRA) • Toronto

Hybrid
CAD 130,000 - 150,000
Employer-matched pension
Comprehensive benefits
Learning & development
+1
Lead Infrastructure Architect
Lead Infrastructure Architect

Financial Services Regulatory Authority of Ontario • Canada

On-site
CAD 130,000 - 150,000
Defined benefit pension
Comprehensive benefits
Learning & development opportunities
Lead Infrastructure Architect
Lead Infrastructure Architect

Fsrao • Toronto

On-site
CAD 130,000 - 150,000
Employer-matched pension
Comprehensive benefits
Learning & development
+1
Senior Database Administrator
Senior Database Administrator

BuzzClan • Toronto

On-site
CAD 83,000 - 165,000
Data Architect
Data Architect

Fsrao • Toronto

Hybrid
CAD 86,000 - 127,000
Database Administrator – Oracle, SQL Server, AWS RDS
Database Administrator – Oracle, SQL Server, AWS RDS

Astra-North Infoteck Inc. • Toronto

Hybrid
CAD 95,000 - 130,000