RQ09857 - Sr. Database Administrator

Job Description

<p><strong>RQ09857 - Sr. Database Administrator </strong></p> <p><strong>Toronto (Jarvis St) - Hybrid/on-site</strong></p> <p><strong>- From October 20, 2025, the candidate is required to work onsite 4 days a week and 1 day from home</strong></p> <p><strong>- From January 5, 2026, the candidate is required to work onsite 5 days a week fully</strong></p> <p><strong>Security Level: CRJMC</strong></p> <p><strong>Contract 5 months, possible extension</strong></p> <p><strong>Responsibilities:</strong></p> <p>1. Perform day-to-day operations, maintenance, and support, including:</p> <p>· Database error/alert monitoring & troubleshooting</p> <p>· Database logs review and troubleshooting</p> <p>· Database backup/recovery jobs/tasks review</p> <p>· Performance monitoring and tuning</p> <p>· Storage and capacity planning and management</p> <p>· Database objects management</p> <p>· Database change management</p> <p>· Security/auditing</p> <p>· Identify security gaps and vulnerabilities, identify and implement mitigations (e.g. patches)</p> <p>· Installing, configuring, patching work related to projects</p> <p>· User and profile management</p> <p>2. Create a Standard Operation Procedure (SOP) document to assist operational staff (non-DBAs) in their duties regarding Oracle database environments.</p> <p>3. Perform regular assessment of the existing Oracle databases/environments, and make recommendations regarding:</p> <p>· Maintenance and leading practices.</p> <p>· Changes required to address production issues (e.g. instability, poor performance) and risks.</p> <p>· 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.</p> <p>· Recommendations for disaster recovery and non-production environments.</p> <p>· Database upgrade options and approaches, informed by overall solution refresh plans and industry best practices.</p> <p>4. Implement approved recommendations as described above.</p> <p>5. Provide guidance and outline best practices for incorporating future database requirements into the environment.</p> <p>6. Contribute to a team culture of collaboration, excellence and innovation.</p> <p>7. Develop or inform the development of role descriptions for the development and sustainment of OPS/BPS Secure.</p> <p>8. 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.</p> <p><strong>Must-Have's:</strong></p> <ul><li><strong>10+ years of experience</strong> in deploying and administering <strong>Oracle </strong>databases within an operations environment.</li><li><strong>5+ years of DBA experience</strong> supporting <strong>Oracle </strong>databases for large mission-critical enterprise solutions.</li><li><strong>10+ years of experience</strong> designing, making recommendations for, and implementing high availability database environments.</li><li>Working knowledge of migration strategies for <strong>Oracle </strong>databases versions <strong>8, 9, 10g, 11g,</strong> and <strong>12c</strong>.</li><li>Experience with <strong>OIAM </strong>and <strong>OEM</strong>.</li></ul>