Database Administrator Senior

<div><b>Assignment: RQ10358 - Database Administrator - Senior</b></div> <div><b>Job Title: Database Administrator Senior</b></div> <div><b>Requisition (SS): RQ10358</b></div> <div><b>Start Date: 2026-04-01</b></div> <div><b>Client: Justice Technology Services</b></div> <div><b>End Date: 2027-03-31</b></div> <div><b>Office Location: 21 College Street, Toronto</b></div> <div><b>Organization: Justice Technology Services</b></div> <div><b>Extension # of Days: 250.00</b></div> <div><b>Ministry: Ministry of Public and Business Service Delivery and Procurement</b></div> <div><b># Business Days: 250.00</b></div> <div><b>Assignment Type - Onsite 5 days</b></div> <p><b>MUST HAVES:</b></p> <ul> <li>Oracle, SQL Managed Instance & Elastic Pools <ul style="list-style-type:circle"> <li>Performance tuning using AWR, ASH, and execution plans</li> <li>Storage optimization, partitioning, and indexing strategies</li> </ul> </li> <li>Oracle GoldenGate <ul style="list-style-type:circle"> <li>Designing, deploying, and monitoring GoldenGate replication topologies</li> <li>Tuning extract/replicat processes, log retention, and checkpointing</li> </ul> </li> <li>Azure Data Replication <ul style="list-style-type:circle"> <li>SQLMI transactional replication</li> <li>Elastic pool implementations and tenant level balancing</li> </ul> </li> <li>Operational Excellence <ul style="list-style-type:circle"> <li>Incident response, performance baselines, and proactive monitoring</li> <li>Root cause analysis and post incident optimization</li> </ul> </li> </ul> <p><b>Description</b></p> <ul> <li>Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support.</li> <li>Work with the project team in completing all relevant and required documentation in alignment with OPS standards.</li> </ul> <p><b>Experience and Skill Set Requirements</b></p> <ul> <li>Creation of technical specifications for Azure, SQL and Oracle database systems development</li> <li>Design, implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards</li> <li>Undertake special assignments/sub-projects as assigned</li> <li>Conduct, assess, evaluate and document stakeholder interests and business needs</li> <li>Create and validate business scenarios and use cases</li> <li>Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business architecture, as well as traceability to solution logical and physical architectures</li> <li>Create, review, provide input and support of Enterprise Architecture artifacts for all checkpoints as required</li> <li>Create system and user interface design and modifications (data & screen) as required</li> <li>Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output</li> <li>Ensure alignment and adherence to Ministry of Government Services' processes and standards</li> <li>Support the testing team during system and UAT testing</li> <li>Participate in Knowledge transfer</li> <li>Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL Server, Azure etc.) for business intelligence and analytics applications</li> <li>Create, test and implement safeguards to maintain data integrity and protect against unauthorized access</li> <li>Assist with SQL optimization and code reviews to ensure queries are efficient</li> <li>At least 10 years of experience</li> <li>Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years)</li> </ul> <p><b>Criteria Ratings MUST TOTAL 100</b></p> <p><b>Technical Skills - 55 Points</b></p> <ul> <li>Oracle Exadata, Golden Gate, MSSQL, Azure SQL technical knowledge and experience.</li> <li>Demonstrated experience in modifying database structures using information provided by application developers</li> <li>Demonstrated experience with monitoring, optimizing and performance tuning using either manual or automated tools</li> <li>Able to develop and interpret highly complex SQL to support queries and provide feedback for developers.</li> </ul> <p><b>Analysis and Problem Solving - 30 Points</b></p> <ul> <li>Research, and evaluation of complex design options.</li> <li>Superior ability to identify root cause of complex environmental or underlying database specific issues.</li> <li>Determining areas of risk and recommending innovative alternatives and options for resolution to meet program needs.</li> <li>Demonstrated experience working within a team environment to troubleshoot and resolve technical problems.</li> </ul> <p><b>Communication and Interpersonal Skills - 15 Points</b></p> <ul> <li>Demonstrated writing and negotiation</li> <li>Oral and written communication skills, Interpersonal and consultative skills,</li> <li>Experience preparing operational documentation (build guides, procedures, etc)</li> </ul>