Source Code Staffing
RQ11214 - Sr. Database Administrator
Remote 9-month contract (Ontario, Canada) for a Senior Database Administrator to maintain Oracle 10g-19c databases and lead an enterprise migration off Solaris to Oracle 19c+. Day-to-day covers DBMS administration, performance tuning, capacity planning, backup/recovery, and migrations on Windows/Solaris/Linux using TDE, Data Guard, RAC, and OEM 13c.
- Compensation
- CA$76–CA$91 / hr
- Location
- Canada
- Work setup
- Remote
- Seniority
- Senior
- Employment
- Contract
- Experience
- 10+ years
- Category
- Devops
- Posted
Skills
Must have
- Minimum 10+ years hands-on experience as Database Analysis
- Creates/implements physical database designs and administers DBMS: optimization, capacity planning, installation/migration, design, performance tuning, backup and recovery
- Maintain and monitor Oracle 10g, 11g, 12c, 19c databases in large multi-tenant environments
- Design, build and configure Oracle Database Servers on Windows, Solaris, Linux
- Lead and design solutions for enterprise Oracle migration to 19c or higher
- Carry out complex/specialized systems analysis and design for Oracle migration success
- Experience with one or more operating systems
- Experience with one or more database technologies
- Experience in one or more programming languages
- Proficiency with query languages and information retrieval packages
- 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, decision-making, verbal/written communication and interpersonal skills
- Team player with a track record for meeting deadlines
Nice to have
- Experience with distributed data systems
- Experience with middleware and gateways
- Experience researching and implementing cyber security vulnerability remediations
- Experience with Computer Aided Software Engineering (CASE) tools
- Knowledge of Information Management principles, concepts, policies and practices
- Experience in Database Administration, Maintenance, Optimization
- Data Warehouse skills including Oracle OBIEE; SME in data warehouse/data marts database design
- Expert knowledge in installation, configuration, maintenance, upgrade and cloning of technology stacks
- Experience designing/developing automated data distribution mechanisms (Case Management and ERP)
- Knowledge of object-oriented analysis and design techniques
- Experience developing enterprise architecture deliverables (e.g. models)
- Knowledge of Ontario Government Enterprise Architecture processes and practice
- Experience in impact analysis and implementation of patches, maintenance packs, releases and patch sets
- Experience in technical design, planning and implementation of specific technology or suite
- Experience with database administration and vendor support services
Full description
RQ11214 - Sr. Database Administrator
9-month contract (170 business days) - possible extesnion
REMOTE - 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