Database Administrator

Financial Services Regulatory Authority of Ontario

Canada

On-site

CAD 84,000 - 105,000

Full time

5 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

FSRA is seeking a senior database administrator to provide expert oversight and support for FSRA database systems, including design, setup, configuration, performance, security, and disaster recovery. The role requires leading technical initiatives, coordinating resources, and implementing automation to improve reliability and efficiency.

Experience with Microsoft Fabric, Lakehouse, Data Factory, and PySpark is valued.

Qualifications

  • Degree/diploma in Information Technology, or related field.
  • 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 and/or DP-600, with DP-300 considered an asset.

Responsibilities

  • Lead design, building, installation, configuration and support of database environments, with focus on SQL Server in a production environment.
  • Plan resources, lead, coordinate, evaluate and report on technical aspects of multiple concurrent or sequential projects.
  • Develop scripts for automating tasks and monitor health/performance.
  • Maintain database systems’ security and user access rights.
  • Coordinate data migrations and disaster recovery planning.

Skills

MS SQL
PowerShell
Hyper-V
Windows Server
Data governance
Security
Backup/Recovery
Disaster Recovery
Performance tuning

Education

Degree/ diploma in IT

Tools

Microsoft Fabric
Lakehouse
Data Factory
OneLake
PySpark

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

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*

Compensation

Grade: Grade 272-OPSEU ADM

Compensation Range: $1,852.71 - $2,314.51

Bargaining Unit: OPSEU

Job Code: 17162

Employment Type: Regular

Scheduled Weekly Hours: 36.25

Employment commitment

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

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 promoting market integrity and stability. Joining FSRA is an exciting opportunity to help shape the regulator of the future.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Administrator
Database Administrator

Fsrao • Toronto

On-site
CAD 90,000 - 120,000
Database Administrator
Database Administrator

Financial Services Regulatory Authority (FSRA) • Toronto

On-site
CAD 84,000 - 105,000
Equity in employment
Accommodation available under OHRC
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
Database Administrator
Database Administrator

Financial Services Regulatory Authority of Ontario • Toronto

On-site
CAD 100,000 - 150,000
Inquiry and Correspondence Officer
Inquiry and Correspondence Officer

Financial Services Regulatory Authority of Ontario • Canada

On-site
CAD 67,000 - 93,000
Employer-matched pension plan
Comprehensive benefits
Senior Risk Analyst
Senior Risk Analyst

Financial Services Regulatory Authority of Ontario • Canada

On-site
CAD 86,000 - 127,000
Employer-matched defined benefit plan
Competitive benefits package
On-site work environment
Inquiry and Correspondence Officer
Inquiry and Correspondence Officer

Financial Services Regulatory Authority (FSRA) • Toronto

On-site
CAD 67,000 - 93,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
Inquiry and Correspondence Officer
Inquiry and Correspondence Officer

Financial Services Regulatory Authority of Ontario (FSRA) • Toronto

On-site
CAD 67,000 - 93,000
Pension plan
Benefits package
Learning & development
Senior Risk Analyst
Senior Risk Analyst

Financial Services Regulatory Authority of Ontario (FSRA) • Toronto

On-site
CAD 73,000 - 110,000
Employer-matched pension plan
Comprehensive benefits plan