Database Administrator
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original 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
Education and Experience
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
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.
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*
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
More about this job
Responsibilities
Lead the design, implementation, administration, and support of FSRA’s database systems, ensuring performance, security, capacity, and business continuity. Coordinate database projects, resolve technical issues, automate operational tasks, and maintain migration, replication, and disaster recovery processes.
Requirements
Requires a degree or diploma in information technology or a related field, relevant Microsoft database certification, and at least five years of database administration experience, including Microsoft SQL Server. Candidates should have substantial experience with database architecture, design, security, performance, and large-scale environments, along with strong troubleshooting, project leadership, collaboration, and communication skills.
Skills
- Microsoft SQL Server Administration
- Database Design and Architecture
- Data Modeling
- Database Security
- Performance Tuning
- High Availability
- Backup and Recovery
- Disaster Recovery
- Database Migration
- PowerShell Scripting
- Microsoft Fabric
- PySpark
- Data Governance
- Cloud Administration
- Project Leadership
- Technical Documentation
Benefits
- Employer-Matched Defined Benefit Pension Plan
- Comprehensive Benefits Plan
- Learning and Development
- Wellbeing Support
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Government & Public Sector
- Management & Leadership
Keywords
- Microsoft SQL Server
- Microsoft Fabric
- Lakehouse
- Warehouse
- OneLake
- Data Factory Pipelines
- PySpark
- PowerShell
- MCSA: SQL Server
- MCSE: Data Platform
- DP-700
- DP-600
- DP-300
- Azure Database Administrator
- Database Administration
- Database Architecture
- Data Modeling
- Relational Databases
- Data Warehousing
- Database Security
- Performance Tuning
- High Availability
- Backup and Recovery
- Disaster Recovery
- Log Shipping
- Always-On
- Database Mirroring
- Hyper-V
- Windows Server
- Enterprise Storage