RQ11210 - Sr. Database Administrator
9-month contract (170 business days) - possible extension
Remote - Anywhere in Ontario
Must Have:
- 10+ years of hands-on experience as a DBA
- Experience with database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
- Experience maintaining and monitoring a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments
- Experience migrating from end of life Oracle database to latest supported version in on-premise and cloud data centers.
Nice-to-have:
Description - 'APEX/ORDS Evergreening' - The goal of the APEX/ORDS evergreening initiative is to upgrade the full technical stack for 5 Ministry of Environment, Conservation and Parks business critical applications. The current suite is built with Oracle database, APEX/ORDS, and Red Hat Linux OS software which are all at end-of-life support with the manufacturer. To stay secure and compliant with Ontario's Digital and Data Strategy, the systems software and hardware technical components must be upgraded - A process known as Evergreening . Cloud hosting is targeted as part of this evergreening.
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.
- Experience in cloud and on-premise environments.
- 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, 23 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)