The Senior Database Administrator will oversee Oracle database administration, including backup/recovery, performance optimization, and troubleshooting issues with complex BI/DW solutions. Responsibilities include creating database designs, maintaining technical documentation, and coordinating with support teams to resolve production challenges while adhering to public sector methodologies.
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.
- "Please ensure that your resume is updated and provided in Word format."
- "To facilitate our evaluation process, please fill out the attached Skills Matrix and provide your references accordingly."
- "We kindly request that you specify your expected hourly rate."
- Kindly Provide your Work Authorization.
- Kindly share with us your LinkedIn Profile ID.
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.
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
- 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.
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
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.
- 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.
Top Skills
Informatica
Oracle
S M Software Solutions Inc Toronto, Ontario, CAN Office
25 Wandering Trail, , Toronto, Ontario, Canada, M1X 1K4
Similar Jobs
Be an Early Applicant
The Lead Database Administrator will optimize and maintain database systems to enhance performance and support data management objectives. Key responsibilities include analyzing and implementing best practices for Postgres environments, collaborating across teams, automating database infrastructure, ensuring data integrity, and providing expertise in database migrations and performance tuning.
Be an Early Applicant
The Sr. Consultant in Solutions Consulting will serve as a subject-matter expert, working with clients and the Sales team to drive business opportunities. Responsibilities include conducting market research, developing business cases, executing strategy, leading proposal development, and providing insights to senior leadership.
Be an Early Applicant
The Analyst Associate position in the New Graduate Rotational Program at TransUnion involves managing projects across various business units including Global Technology and Solutions. Candidates will gain mentorship and training while engaging in high visibility projects, developing analytics and market insights, and contributing to operational functions.
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
