This is a 9-month contract role for a Senior Database Administrator to lead an enterprise Oracle migration project and manage database infrastructure across Windows, Solaris, and Linux environments. The position focuses on database optimization, performance tuning, and migrating legacy Solaris-based Oracle databases to version 19c or higher.
Compensation
CA$60–CA$91 / hr
Location
Toronto, ON, Canada
Work setup
Not specified
Seniority
Senior
Employment
Contract
Experience
10+ years
Category
Devops
Posted
Skills
ai
apex
arcgis
cybersecurity
data-warehousing
erp
fine-tuning
java
linux
oracle
Must have
10+ years of experience as Database Analysis or related IT roles
Experience with Oracle 10g, 11g, 12c, 19c databases
Experience designing and configuring Oracle Database Servers on Windows, Solaris, and Linux
Experience leading enterprise Oracle migration projects to 19c or higher
Experience with database optimization, capacity planning, installation, migration, performance tuning, backup, and recovery
Experience with incident, change, and configuration management procedures
Full description
**RQ11214 - Sr. Database Administrator9-month contract (170 business days) - possible extesnionREMOTE - Anywhere in Ontario Must Have:**
Minimum 10+ years of hands-on experience as Database Analysis (other IT roles to be considered as part of years experience)
Creates and implements physical database designs and operates and administers the database management system (DBMS), including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
Maintain and monitor a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments including database administration, maintenance, optimization, migration, and fine tuning of databases
Design, build and configure Oracle Database Servers on Windows, Solaris, Linux
Lead and design solutions for the enterprise Oracle migration project to migrate to 19c or higher
Carry out complex/specialized systems analysis and design for success of Oracle migration
Description:
The Solaris Evergreening project will:
Transition Solaris impacted application databases off of Solaris infrastructure and onto supported infrastructure.
Where applicable/compatible, upgrade to latest version of Oracle database software.
Eliminate security and financial risks by decommissioning out-of-support Solaris infrastructure following successful migrations.
The applications in scope will remain 'as is,' there will be no new development work completed. The migration off of Solaris operating system servers only impacts the operating system and database.
The project represents a time-sensitive, high-priority stream within FY26/27 operating plan deliverables and serves as a key enabler for broader portfolio modernization.
Responsibilities:
Creates and implements physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
Maintain and monitor a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments including database administration, maintenance, optimization, migration, and fine tuning of databases
Design, build and configure Oracle Database Servers on Windows, Solaris, Linux
Ensure existing databases meet performance requirements including but not limited to SIEBEL, Java, ARCGIS, APEX databases on Oracle
Ensure that all deployed databases are secure and that appropriate security and auditing controls are in place to meet security and privacy requirements
Provide database administration technical expertise during design and architecture phases of new solutions
Lead and design solutions for enterprise Oracle migration project to migrate to 19c or higher
Plan, manage and coordinate implementation of technically advanced complex systems and assist in Data refreshes to lower non production environment
Provide regular support to resolve complex and unique database management issues
Provide expert support and guidance to production database systems and clients by overseeing the deployment and evaluation of complex Oracle databases
Provide support and maintenance of databases in GoCloud and on premise based environments
Carry out complex/specialized systems analysis and design for success of Oracle migration
Provide assistance in the implementing, TDE, Dataguard, RAC, OMS, OEM 13c
Provide assistance with replicated database management and migration
Documentation of your technical work such that knowledge can be transferred to you colleagues
Identifies, analyses, prioritizes and communicates technical risks for decision makers
Provides recommendations and mitigation strategies based on a detailed evaluation of technical risks and issues
Communicates effectively to identify needs and evaluate solutions to complex business and technical issues
Experience Requirements:
Minimum 10+ years experience as Database Analysis (other IT roles to be considered as part of years experience)
Experience with one or more operating systems
Experience with one or more database technologies
Experience in one or more programming languages Experience in the use of information retrieval packages and proficiency with query languages
Experience in monitoring and enforcing database rules
Experience in Incident, Change and Configuration Management procedures
Experience with one or more communications protocols
Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
A team player with a track record for meeting deadlines
Desirable Skills:
Experience with distributed data systems
Experience with middleware and gateways
Experience with researching and implementing cyber security vulnerability remediation's
Awareness of emerging IT trends and directions
Experience with Computer Aided Software Engineering (CASE) tools
Knowledge and understanding of Information Management principles, concepts, policies and practices
Experience in Database Administration, Maintenance Optimization
Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE
Subject matter expert in database design of the data warehouse or data marts.
Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning
Additional Skills for Case Management and ERP Experience in designing/developing an automated data distribution mechanism
Knowledge and understanding of object-oriented analysis and design techniques.
Experience in developing enterprise architecture deliverables (e.g. models)
Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
Knowledge and understanding of Information Management principles, concepts, policies and practices
Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
Experience in technical design, planning and implementation of specific technology or suite
Experience with database administration and vendor support services
AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.INCORPORATED RATE RANGE (7.25 billable hours per day)
$75.60/hr - $90.72/hr Inc.T4 RATE RANGE (7.25 billable hours per day)