Database Administrator

Financial Services Regulatory Authority (FSRA)

Toronto

On-site

CAD 84,000 - 105,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Equity in employment
Accommodation available under OHRC

Job summary

FSRA in Toronto is seeking a senior Database Administrator to provide expert oversight of FSRA's database systems, including design, performance, security, and disaster recovery.

You will lead implementations, monitor health checks, and develop automation scripts while collaborating with cross-functional teams to support all business operations.

This role requires MS SQL expertise, relevant certifications, and strong communication as FSRA aims to uphold safe, fair regulation.

Qualifications

  • Degree in IT or related field and professional certifications.
  • 5+ years as a SQL Server DBA with design, security and tuning experience.
  • Experience with large relational databases and data warehousing concepts.
  • Knowledge of PowerShell and modern data governance is a plus.
  • Strong communication and leadership abilities.

Responsibilities

  • Provide senior technical leadership for database projects and operations.
  • Plan, configure, monitor, and maintain database systems for performance and security.
  • Develop automation scripts and support DR/BC plans.
  • Lead data migrations and ensure high availability and disaster recovery readiness.
  • Define KPIs and produce reporting for database environments.

Skills

SQL Server DBA
Database design
Performance tuning
Security best practices
Leadership

Education

Degree in Information Technology or related field
MCSA: SQL Server
MCSE: Data Platform / Fabric Data Engineer
DP-700 / DP-600 (asset)
DP-300 (Azure DBA) asset

Tools

Hyper-V
Windows Server
Enterprise Storage
Cloud Administration
Virtualization
Data migrations tools (Log Shipping, Always-On, Mirroring)

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 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

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 of Ontario • Canada

On-site
CAD 84,000 - 105,000
Database Administrator
Database Administrator

Financial Services Regulatory Authority of Ontario • Toronto

On-site
CAD 100,000 - 150,000
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
Data Architect
Data Architect

Fsrao • Toronto

Hybrid
CAD 86,000 - 127,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
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
Inquiry and Correspondence Officer
Inquiry and Correspondence Officer

Financial Services Regulatory Authority (FSRA) • Toronto

On-site
CAD 67,000 - 93,000
Senior Risk Analyst
Senior Risk Analyst

Financial Services Regulatory Authority (FSRA) • Toronto

On-site
CAD 73,000 - 110,000