RQ08550 - Database Administrator - Senior

Toronto, Ontario, ON, Canada
Contracted
Experienced
Hello,
I hope this email finds you well. We have received a new requirement from one of the ministries in Ontario. Please refer to the details provided below:
We are unable to submit a candidate without below mandatory documents.
  1. "Please ensure that your resume is updated and provided in Word format."
  1. "To facilitate our evaluation process, please fill out the attached Skills Matrix and provide your references accordingly."
  1. "We kindly request that you specify your expected hourly rate."
  1. Kindly Provide your Work Authorization.
  1. Kindly share with us your LinkedIn Profile ID.
 
Job Title:RQ08550 - Database Administrator - Senior
Client:Ministry of Health
Work Location:5700 Yonge St, Toronto, Ontario, Hybrid
Estimated Start Date:2025-04-01
Estimated End Date:2026-03-31
#Business Days:248
Extension:Probable after the initial mandate
Hours per day or Week: 7.25 hours per day
Security Level:CRJMC

To check the detailed description and matrix visit our website: Click here
Link
We're excited to invite you to join our company's WhatsApp group dedicated to for new job postings. Your insights and contributions would be incredibly valuable. Please use the link below to join: [https://chat.whatsapp.com/DwVITx9uaiELQflTDdCv33] We look forward to your participation!" 
(NOTE: Share required documents to [email protected] by Tuesday, January 28, 9:00 AM EST.
Must Haves
10+ 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 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
Active Data Guard, GoldenGate, etc.) Cognos, Informatica PowerCenter, Power exchange & Data Quality
Administering and supporting and troubleshooting server/system issues related to Cognos, BO, Informatica, LDAP and Oracle DBs
Note:
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.
  • Hybrid: 3 days onsite / 2 days remote
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 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.
Description
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.
"If you are interested in learning more about this opportunity, we kindly request that you share the necessary documents. However, if this opportunity does not align with your current interests or responsibilities, please feel free to forward this email to any individuals who may be interested, or provide us with their contact information. We appreciate your attention to this matter.
 
Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Human Check*