This is a contract position for a Database Administrator for our client who is in the Broader Public Sector. Work location will be in North York.
This is a Hybrid Role with 3 days in the office a week. This is a mandatory requirement of the role and is non negotiable outside of exceptional circumstances.
The Contract runs for one year.
...
Hours per day will be 7.25
Advantages
Good Compensation working on projects that will make a difference to the people of Ontario.
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.
Qualifications
Qualification / Certificates
Oracle 19 C
Cognos
Golden Gate
Active Data Guard
Summary
If interested and qualified for this role, please apply today for immediate consideration!!!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
This is a contract position for a Database Administrator for our client who is in the Broader Public Sector. Work location will be in North York.
This is a Hybrid Role with 3 days in the office a week. This is a mandatory requirement of the role and is non negotiable outside of exceptional circumstances.
The Contract runs for one year.
Hours per day will be 7.25
Advantages
Good Compensation working on projects that will make a difference to the people of Ontario.
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.
Qualifications
Qualification / Certificates
Oracle 19 C
Cognos
Golden Gate
Active Data Guard
Summary
If interested and qualified for this role, please apply today for immediate consideration!!!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more