Database Administrator - Senior

Contract - 8 Months (Extension Possible)

Remote - Anywhere in Ontario

Public Sector

Experience:

Required - OPS / Public Sector

Contract End Date:  *

Rate: $86/hour

The Ministry of Public and Business Service Delivery and Procurement is seeking a Senior Database Administrator to support the Solaris Evergreening Project within the Land & Resources Cluster. This time-sensitive, high-priority initiative focuses on migrating Oracle databases off end-of-life Solaris infrastructure onto supported platforms, with upgrades to the latest Oracle versions where applicable. The successful consultant will bring deep Oracle DBA expertise to ensure a secure, performant, and seamless transition with zero new application development.

• Create and implement physical database designs; administer and operate the database management system (DBMS) including optimization, capacity planning, installation, migration, performance tuning, and backup and recovery
• Maintain and monitor Oracle 10g, 11g, 12c, and 19c databases across large multi-tenant environments, including administration, maintenance, optimization, and fine-tuning
• Design, build, and configure Oracle Database Servers on Windows, Solaris, and Linux platforms
• Ensure existing databases (including SIEBEL, Java, ArcGIS, and APEX) meet performance requirements on Oracle infrastructure
• Ensure all deployed databases are secure and that appropriate security and auditing controls are in place to satisfy security and privacy requirements
• Lead and design solutions for the enterprise Oracle migration project, targeting Oracle 19c or higher
• Plan, manage, and coordinate implementation of technically advanced, complex systems and assist with data refreshes to lower non-production environments
• Provide database administration technical expertise during design and architecture phases
• Provide expert support and guidance for production database systems, overseeing deployment and evaluation of complex Oracle databases in GoCloud and on-premise environments
• Assist with implementing TDE, Dataguard, RAC, OMS, and OEM 13c technologies
• Identify, analyze, prioritize, and communicate technical risks; provide recommendations and mitigation strategies to decision makers
• Document technical work thoroughly to enable knowledge transfer to colleagues and ministry staff

• Minimum 10+ years of experience as a Database Administrator or in related IT roles
• Hands-on experience with Oracle database optimization, capacity planning, installation, migration, performance tuning, and backup and recovery
• Experience maintaining and monitoring Oracle 10g, 11g, 12c, and 19c databases in large multi-tenant environments
• Experience migrating from end-of-life Oracle databases to the latest supported versions in both on-premise and cloud data centres
• Experience with Oracle Database Server configuration on Windows, Solaris, and Linux operating systems
• Experience ensuring database security and implementing appropriate auditing controls to meet security and privacy requirements
• Experience with Incident, Change, and Configuration Management procedures
• Experience monitoring and enforcing database rules and standards
• Experience with one or more programming languages and proficiency with query languages and information retrieval packages
• Excellent analytical, problem-solving, and decision-making skills with strong verbal and written communication abilities
• Proven track record as a team player with ability to meet deadlines in complex, high-priority environments

• Experience with distributed data systems and middleware/gateway technologies
• Experience researching and implementing cybersecurity vulnerability remediations
• Awareness of emerging IT trends and directions
• Experience…