Database Administrator

Description

**NOTE**

**Assignment Type**:This position is currently listed as “Hybrid” and consultants will be required to work onsite at the work location 3 days a week and 2 days from home, or as per schedule agreed to with the Hiring Manager.

**Extension/Amendment Attestation**:Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW. The Statement of Work (SOW) shall expire on March 31, 2026. HSC may exercise its option(s) to extend an SOW beyond March 31, 2026. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.

**==============================================**

**Responsibilities**:

- Provide technical expertise with technologies including Oracle T7 Servers, Oracle 19C multi-tenant database/Oracle Active data guard, Oracle Enterprise cloud control (OEM CC), Oracle Golden Gate, Informatica / Cognos and Shadowbase
- Produce daily monitoring scripts for entire stack of DTE databases and reviewing them for any potential issues and pro-actively fixing them to keep things running smoothly.
- Operate and administer the database management system (DBMS) including database optimization, performance tuning, backup and recovery
- Provide installation, administration, fine-tuning and support for SAP Business objects, Cognos BI, Informatica
- PowerCenter, Oracle Goldengate and Oracle Active data guard
- Assist with any performance/functionality issues arising due to recent releases of code to production and proactively implement changes to avoid recurrence
- Create physical database designs
- Operate and administer the database management system (DBMS) including database optimization, performance tuning, backup and recovery
- Develop and maintain data design models, database schemas and scripts, technical documentation and specifications
- Provide build books/deployment guides for the deployment to higher environments
- Assist in change initiatives in planning for data / database design, database setup, migration, optimization and tuning, capacity planning, data conversion and other development and implementation-related activities
- Produce data and database management project plans. Develop and obtain approval for detailed plans and resource estimates
- Provide specialized technical expertise in database administration, data warehouse design, data modeling, Extraction, Transformation & Load (ETL), information management, BI solution design, development and maintenance
- Provide Database (Oracle technologies & products) expertise for troubleshooting, problem resolution and performance tuning of the production solutions in operation
- Provide professional opinions and recommendations for technical issues, management, briefings, etc., and provide expertise, offer solutions and lead implementation of approved recommendations
- Coordinate with Oracle support in opening tickets and providing information to find solutions and root cause analysis of ongoing issues.
- SKILLS

**EXPERIENCE REQUIREMENTS**

PUBLIC
SECTOR EXPERIENCE

5+ YEARS OF
EXPERIENCE WORKING WITH FEDERAL/PROVINCIAL/BROADER PUBLIC-SECTOR HEALTHCARE
PROVIDERSKNOWLEDGE OF PUBLIC
SECTOR ENTERPRISE ARCHITECTURE ARTIFACTS (OR SIMILAR), PROCESSES AND
PRACTICESABILITY TO PRODUCE
TECHNICAL DOCUMENTATION THAT COMPLY WITH INDUSTRY STANDARD PRACTICESKNOWLEDGE AND
EXPERIENCE WITH PUBLIC SECTOR HEALTH RELATED PROJECTSKNOWLEDGE AND
UNDERSTANDING OF MINISTRY POLICY AND IT PROJECT APPROVAL PROCESSES AND
REQUIREMENTS WOULD BE AN ASSETEXPERIENCE ADOPTING
AND ADHERING TO PUBLIC SECTOR UNIFIED I&IT PROJECT METHODOLOGY, PUBLIC
SECTOR ENTERPRISE ARCHITECTURE AND PUBLIC SECTOR GATING PROCESS, AND PUBLIC
SECTOR STANDARD SYSTEMS DEVELOPMENT METHODOLOGIESEXPERIENCE WITH
LARGE COMPLEX IT HEALTH-RELATED PROJECTS.”5 POINTS
TECHNICAL SKILLS10+ YEARS OF EXPERIENCE IN
THE FOLLOWING:
DATABASE ADMINISTRATION USING ORACLE TECHNOLOGIES AND PRODUCTS,
INCLUDING ORACLE 19C, ORACLE RAC, RMAN BACKUP/RECOVERY, DATA COMPRESSION AND
ENCRYPTION, ORACLE DATA GUARD, ORACLE GOLDENGATE AND ORACLE EMEXPERIENCE IN COMPLEX BI/DW SOLUTION DESIGN, IMPLEMENTATION,
MAINTENANCE, AND SUPPORT, USING ORACLE 19C, ORACLE DIRECTORY SERVER,
INFORMATICA POWERCENTER & DATA QUALITY, IBM COGNOS, BUSINESS OBJECTS IN A
SUN SOLARIS/REDHAT ENVIRONMENTSUPERIOR TECHNICAL EXPERTISE IN: ENTERPRISE DATA WAREHOUSE DATABASE
CONFIGURATION, OPTIMIZATION AND TUNING, SUPPORT AND MAINTENANCE WITH ORACLE
DATABASE IN A SUN SOLARIS ENVIRONMENT FOR COMPLEX BUSINESS INTELLIGENCE/DATA
WAREHOUSE (BI/DW) SOLUTIONS, BI-DIRECTIONAL DATA REPLICATION FOR ACTIVE-ACTIVE
SOLUTION CROSSING DATA CENTERS, AND MULTI-TIER WEB-BASED OFF-THE-SHELF
SOLUTIONS TOOLS, INCLUDING ORACLE TECHNOLOGIES & PRODUCTS (ORACLE
DATABASE, ACTIVE DATA GUARD, GOLDENGATE, ETC.) COGNOS, INFORMATICA
POWERCENTER, PO