RQ11438 - Database Administrator - Senior

Flexstaf IT | Career PageToronto, ON, Canada
Active

Job description

Must Have: Experience in designing and implementing REST API integrations and best practices SQL Server Administration — strong hands-on experience with SQL Server 2019, 2022 and 2025 Multi-DBMS Experience — must have hands-on experience with at least one of: Oracle 19c, DB2/Windows, or DB2/zOS Nice to Have: Performance Tuning — ability to diagnose and optimize queries, indexes, and server performance Backup & Recovery — strong understanding of HA/DR strategies and implementation Experience and Skill Set Requirements Evaluation Criteria Technical Knowledge and Experience - 50% SQL Server Administration — strong hands on experience with SQL Server 2019 , 2022 and 2025Failover Clustering — experience in configuring and maintaining SQL Server 2019, 2022 and 2025 cluster instancesAlways On Availability Groups — deep knowledge of setup, monitoring, failover, and troubleshootingPerformance Tuning — ability to diagnose and optimize queries, indexes, and server performanceBackup & Recovery — strong understanding of HA/DR strategies and implementationSQL Server Upgrades — hands on experience upgrading: SQL Server 2019 2022; SQL Server 2022 2025Multi DBMS Experience — must have hands on experience with at least one of: Oracle 19c, DB2/Windows, or DB2/zOSExperience with development and mainframe technologiesExperience with middleware and gatewaysExperience in application monitoring and supportExperience in middleware software installation, configuration, tuning and administration, as well as experience with application developmentExperience with change management and release management as processes supporting the implementation of large applicationsExperience in structured methodologies for the design, development, implementation and maintenance of applicationsAbility to analyze and solve data integrity, security, configuration and recovery issuesAssess and test Change Requests (CRQ) with technical content and update as necessaryAbility to participate in release promotions/implementations and patchingA team player with a track record of meeting deadlinesProvide end-to-end solution design, development, and unit testing, along with recommendations to achieve business outcomes aligned with business requirements, the Cluster reference architecture, and Ministry-specific objectives.Collaborate with stakeholders to understand business goals and support delivery outcomes. Experience in designing and implementing REST API integrations and best practices Incorporate security requirements into the design, understand and comply with OPS security standards and policies. Communication and troubleshooting - 30% Excellent analytical, problem-solving and decision making skills; verbal and written communication skills; interpersonal and negotiation skills Experience working in an agile development environment Ability to provide user and system documentation as required Contribute to the effective management of risks and issues associated with Solution designs Collaborate with cross-functional and distributed teams, including designers, developers, architects, project managers, and QA Promotes industry standards and best practices with the product teams. Perform thorough code reviews, including unit tests and ensure high quality of the software. Fix defects and support developers, testers and end users Planning and documentation - 20% Write technical documentation that supports and thoroughly explains the architecture Deliver knowledge transfer sessions to the team on the work completed Produce reports and updates as required

Must Have:

Must Have:

Experience in designing and implementing REST API integrations and best practices

SQL Server Administration — strong hands-on experience with SQL Server 2019, 2022 and 2025

Multi-DBMS Experience — must have hands-on experience with at least one of: Oracle 19c, DB2/Windows, or DB2/zOS

Nice to Have:

Performance Tuning — ability to diagnose and optimize queries, indexes, and server performance

Backup & Recovery — strong understanding of HA/DR strategies and implementation

Experience and Skill Set Requirements

Evaluation Criteria

Evaluation Criteria

Technical Knowledge and Experience - 50%

Technical Knowledge and Experience - 50%
  • SQL Server Administration — strong hands on experience with SQL Server 2019 , 2022 and 2025
  • Failover Clustering — experience in configuring and maintaining SQL Server 2019, 2022 and 2025 cluster instances
  • Always On Availability Groups — deep knowledge of setup, monitoring, failover, and troubleshooting
  • Performance Tuning — ability to diagnose and optimize queries, indexes, and server performance
  • Backup & Recovery — strong understanding of HA/DR strategies and implementation
  • SQL Server Upgrades — hands on experience upgrading: SQL Server 2019 2022; SQL Server 2022 2025
  • Multi DBMS Experience — must have hands on experience with at least one of: Oracle 19c, DB2/Windows, or DB2/zOS
  • Experience with development and mainframe technologies
  • Experience with middleware and gateways
  • Experience in application monitoring and support
  • Experience in middleware software installation, configuration, tuning and administration, as well as experience with application development
  • Experience with change management and release management as processes supporting the implementation of large applications
  • Experience in structured methodologies for the design, development, implementation and maintenance of applications
  • Ability to analyze and solve data integrity, security, configuration and recovery issues
  • Assess and test Change Requests (CRQ) with technical content and update as necessary
  • Ability to participate in release promotions/implementations and patching
  • A team player with a track record of meeting deadlines
  • Provide end-to-end solution design, development, and unit testing, along with recommendations to achieve business outcomes aligned with business requirements, the Cluster reference architecture, and Ministry-specific objectives.
  • Collaborate with stakeholders to understand business goals and support delivery outcomes.

Experience in designing and implementing REST API integrations and best practices

Incorporate security requirements into the design, understand and comply with OPS security standards and policies.

Communication and troubleshooting - 30%

Communication and troubleshooting - 30%

Excellent analytical, problem-solving and decision making skills; verbal and written communication skills; interpersonal and negotiation skills

Experience working in an agile development environment

Ability to provide user and system documentation as required

Contribute to the effective management of risks and issues associated with Solution designs

Collaborate with cross-functional and distributed teams, including designers, developers, architects, project managers, and QA

Promotes industry standards and best practices with the product teams.

Perform thorough code reviews, including unit tests and ensure high quality of the software.

Fix defects and support developers, testers and end users

Planning and documentation - 20%

Planning and documentation - 20%

Write technical documentation that supports and thoroughly explains the architecture

Deliver knowledge transfer sessions to the team on the work completed

Produce reports and updates as required