Database Administrator

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