Database Administrator - Jobs in Toronto, ON

Job Description

PURPOSE OF POSITIONAccountable 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.
• 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.

QUALIFICATIONSEducation and Experience

• Degree/diploma in Information Technology, or related field.
• Certifications: MCSA SQL Server, or SQL Database Administrator, Microsoft Certified Solutions Expert (MCSE): Data Platform, or Azure Database Administrator
• 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
• 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.

FSRA is guided by our vision of financial safety, fairness and choice for Ontarians. And we achieve this by public service through dynamic, principles-based and outcomes-focused regulation. FSRA is committed to attracting and retaining exceptional people who bring energy, expertise, and experience. This includes providing a comprehensive total rewards package that looks beyond compensation and takes into consideration those things that are important to employees:

• High employee engagement scores with opportunity for growth, learning and development
• Flexibility with a hybrid work model in an office designed for collaboration Competitive benefits plan, including a Defined Benefit pension plan
• Promoting wellness and fostering an inclusive environment where all employees feel valued and respected
• Culture of giving back to our communities through charitable activities

Job Posting End Date:09/15/2022Job postings close at 11:59pm on the date noted.Compensation Grade:Grade 272-OPSEU ADMCompensation Range:$1,687.30

$2,107.87Bargaining Unit:OPSEUJob Code:Job Code: 17162Employment Type:RegularScheduled Weekly Hours:36.25FSRA 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.FSRA is committed to the health and safety of our employees. To demonstrate our commitment to this critical priority and further protect against the spread and risks of COVID-19, and its variants, full vaccination against COVID-19 is required as a condition of employment for individuals hired by FSRA, subject to any duty to accommodate in accordance with the Ontario Human Rights Code. Fully vaccinated is defined as having received all of the required doses of a Health Canada approved vaccine and having received the final dose at least 14 days before commencing employment with FSRA.NOTE: ONLY QUALIFIED CANDIDATES WILL BE CONSIDEREDQuick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job
• SimplyHired OnDemand

Stay Connected