RQ09857 - Database Administrator - Senior at S M Software Solutions Inc

Client: Ministry of Public and Business Service Delivery and Procurement

Work Location: 222 Jarvis Street, Toronto, Ontario, Onsite

Estimated Start Date: 2025-11-20

Estimated End Date: 2026-03-31

#Business Days: 90.00

Extension: Probable after the initial mandate

Hours per day or Week: 7.25 hours per day

Security Level: CRJMC

Must Have

• 10+ years of experience in deploying and administering Oracle databases within an operations environment.
• 5+ years of DBA experience supporting Oracle databases for large mission-critical enterprise solutions.
• 10+ years of experience designing, making recommendations for, and implementing high availability database environments.
• Working knowledge of migration strategies for Oracle databases versions 8, 9, 10g, 11g, and 12c.
• Experience with OIAM and OEM.
  
  

Description

Responsibilities:

• Perform day-to-day operations, maintenance, and support, including:
• Database error/alert monitoring & troubleshooting
• Database logs review and troubleshooting
• Database backup/recovery jobs/tasks review
• Performance monitoring and tuning
• Storage and capacity planning and management
• Database objects management
• Database change management
• Security/auditing
• Identify security gaps and vulnerabilities, identify and implement mitigations (e.g. patches)
• Installing, configuring, patching work related to projects
• User and profile management
• Create a Standard Operation Procedure (SOP) document to assist operational staff (non-DBAs) in their duties regarding Oracle database environments.
• Perform regular assessment of the existing Oracle databases/environments, and make recommendations regarding:
• Maintenance and leading practices.
• Changes required to address production issues (e.g. instability, poor performance) and risks.
• Improvements to operational procedures (e.g. backup/restore) to align to standard methodology and industry best practices, taking into account the amount and criticality of the systems.
• Recommendations for disaster recovery and non-production environments.
• Database upgrade options and approaches, informed by overall solution refresh plans and industry best practices.
• Implement approved recommendations as described above.
• Provide guidance and outline best practices for incorporating future database requirements into the environment.
• Contribute to a team culture of collaboration, excellence and innovation.
• Develop or inform the development of role descriptions for the development and sustainment of OPS/BPS Secure.
• Develop plans for the knowledge and skills transfer to OPS employees, including activities or tests to demonstrate the successful transfer of knowledge and attainment of required skills.
  
  

Experience And Skill Set Requirements

Sustainment of Large Database Systems: 40%

• 10+ years of experience in deploying and administering Oracle databases within an operations environment.
• 5+ years of DBA experience supporting Oracle databases for large mission-critical enterprise solutions.
• 10+ years of experience designing, making recommendations for, and implementing high availability database environments.
• Working knowledge of migration strategies for Oracle databases versions 8, 9, 10g, 11g, and 12c.
• Experience with Oracle in Solaris 8, Solaris 9, and Solaris 10 environments running on Sun Platforms, and RedHat Linux environment.
  
  

Solutions Leadership: 30%

• 10+ years of experience in designing, developing, deploying, and sustaining large implementations based on the Oracle Database product.
• Experience with ITIL processes such as Service Level Management, Problem Management, Change Management, Release Management, and Capacity Management.
  
  

Problem Management and Incident Management: 20%

• 10+ years of experience with triaging, analyzing, diagnosing (troubleshooting), evaluating options, and resolving database problems.
  
  

Quality Assurance: 10%

• 10+ years of experience with quality control and assurance methodologies and practices as applied to the implementation of database with over 10,000 records.
• Experience with Change Management and Release Management as processes supporting the implementation of large applications.
  
  

Note

• "This position is listed as "Onsite"; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location".
• From October 20, 2025, the candidate is required to work onsite 4 days a week and 1 day from home
• From January 5, 2026, the candidate is required to work onsite 5 days a week fully
  
  

Eligibility and Application Steps

If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: [email protected]

Without mandatory documents, we cannot submit a candidate.

• Updated Resume in word format (Mandatory)
• Skills Matrix and References (Mandatory)
• Expected hourly rate (Mandatory)
• Visa Status (Mandatory)
• LinkedIn ID (Mandatory)
  
  

Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role!

If you have any questions or need further clarification, feel free to call or text at (647) 408-1348.