Database Administrator

MUST HAVES:

• Please refer to the Experience and Skillset Requirements

Description

• NOTE
  • Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.
  • Extension/Amendment Attestation:
  • Extensions are permitted only to the extent of unused contract days and/or remaining contract funds. No additional funds will be added beyond the maximum contract value including any extension options set out in the original SOW.
  • HSC may exercise its option to extend the SOW beyond October 5 2027 provided that the Master Service Agreement is extended. Any such extension shall be on the same terms conditions and covenants as those contained in the SOW.
• Provide technical expertise with technologies including Oracle Servers Oracle 19C multi-tenant database/Oracle Oracle on AWS - RDS
• Active data guard Oracle Enterprise cloud control (OEM CC) Oracle Golden Gate Informatica / Cognos
• 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

Experience and Skill Set Requirements

Public Sector Experience - 5 points

• 5 years of experience working with federal/provincial/broader public-sector healthcare providers
• Knowledge of Public Sector Enterprise Architecture artifacts (or similar) processes and practices
• Ability to produce technical documentation that comply with industry standard practices
• Knowledge and experience with Public Sector Health related projects
• Knowledge and understanding of Ministry policy and IT project approval processes and requirements would be an asset
• Experience 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 Methodologies
• Experience with large complex IT Health-related projects.

Technical Skills - 50 points

• 10 years of experience in the following:
• Database administration using Oracle technologies and products including Oracle 19C Oracle on AWS RDS Oracle RAC RMAN backup/recovery Data Compression and encryption Oracle Data Guard Oracle GoldenGate and Oracle EM
• Experience 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 environment
• Superior 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 Power exchange & Data Quality
• Experience with Cognos BO Informatica and LDAP servers

Core Skills and Experience - 35 points

• 10 years experience in the following:
• Administering and supporting and troubleshooting server/system issues related to Cognos BO Informatica LDAP and Oracle DBs
• Experience with physical database designs operation and administration of database management system (DBMS) including database optimization performance tuning backup and recovery partitioning compression and security
• Developing and maintaining data design models database schemas and scripts technical documentation and specifications
• Providing build books/deployment guides for the deployment to higher environments
• Experience with database setup migration tuning capacity planning and data conversion in a large operation with multiple environments
• Maintaining data design models database schemas and scripts technical documentation and specifications
• Providing specialized technical expertise in database administration data warehouse design data modeling Extraction Transformation & Load (ETL) information management BI solution design development and maintenance
• Monitoring and enforcing database rules
• Providing Database (Oracle technologies & products) expertise for troubleshooting problem resolution and performance tuning of the production solutions in operation
• Providing professional opinions and recommendations for technical issues management briefings etc. and provide expertise offer solutions and lead implementation of approved recommendations
• Coordinating with Oracle support Informatica support and Cognos support in opening tickets and providing information to find solutions and root cause analysis of ongoing issues
• Producing project plans for database management activities
• Experience with middleware gateways and reporting systems
• Experience in Incident Change and Configuration Management procedures
• Experience with use of information retrieval packages and proficiency with query languages.

General Skills - 10 points

• Proven technical leadership skills with ability to identify areas for improvement and recommend solutions
• Exceptional analytical problem solving and decision-making skills
• Demonstrated strong interpersonal verbal and written communication and presentation skills
• Proven troubleshooting and critical thinking experience
• Demonstrated ability to apply strong listening skills to facilitate issue resolution
• Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships
• Strong interpersonal facilitation and negotiation skills with ability to build rapport with stakeholders and drive negotiations to a successful outcome
• Excellent customer service skills including tact and diplomacy to ensure client needs are managed effectively
• A motivated flexible detail-oriented and creative team player with perseverance excellent organization and multi-tasking abilities and a proven track record for meeting strict deadlines.