Are you an IT Database Administrator looking for a new opportunity?
Are you looking for a new contract opportunity?
We are pleased to offer you a new contract opportunity for you to consider: IT Database Administrator.
Start: ASAP.
Estimated length: 6 months.
Location: Toronto.
Fully remote work.
...
Actively seeking for candidates with below requirements.
Advantages
You will have an opportunity to work with a leading employer in the local market.
Potential for contract extension and conversion to full time opportunity as well
Responsibilities
Review project docs to ensure design specifications meet application needs
Advise on client DB standards as required on projects (eg. Audit processes, database access, job configuration)
Create new databases (OCAC PDBs - CDBs)
Oracle Upgrade / migrate from 12C to 19C
AWR reporting, tuning and optimization of Database
Updates to database schema (create, alter, or drop objects) details
Apply database permissions (add, modify, or delete logins, grant/revoke permissions to DB objects)
Deploy code (stored procedures, SQL scripts)
Setup DB traces for Performance Testing to capture various performance metrics
Support testing cycles (eg. Running scripts, database backup/restores)
Documentation updates, as required
Defines the content and structure of the database and advises users on efficient techniques for extracting data
Contribute to automation of installs
Establish and maintain database support tools. Monitors overall standards and procedures and ensures integration of systems through database design.
Maintains accurate and up‐to‐date database system documentation. Has awareness of available physical storage and initiates requests for new devices.
Proposes data standards for both software and physical protection.
Assists in database reorganization/restructuring.
Creates new schema for the development of new software products. This work involves working with Application Development, the business line customer, and the project management team.
Informs systems and applications programming staff of any future database changes that might require program modification.
Assists in the change control process to implement changes.
Assure timely and accurate processing of assigned tasks.
Recommends an effective operational procedure in accordance with department goals and application guidelines, in order to effectively utilize the database system and remain within the security and integrity control limits
Qualifications
Strong experience and knowledge installing and building OCAC (DBs, , ODI, Oracle19c upgrades/in place upgrades and Clustered RAC installs
Strong experience with AWR, ADDM reporting, SQL Tuning Advisor, SQL Trace & TKProf and optimization of Database/VLDBs.
Strong experience and knowledge with SQL Developer, Clustered RAC, Active/Normal Data Guard, RMAN, Data Pump, SQL*loader and export/import
Knowledge of related tasks like DR switchover, converting to read/write mode without interrupting primary production database
Experience supporting PostgreSQL project work and maintenance.
OCAC ( Create new databases (OCAC PDBs - CDBs)
AWR reporting, tuning and optimization of Database
SQL tuning
Hands on project and maintenance experience with PostgreSQL Version 11 and above.
Summary
Do you have this experience? If you answer YES, then please apply IMMEDIATELY to so we can then discuss your experience and interest in this opportunity!
Randstad Technologies Group
Canada's largest provider of IT Staffing Solutions, offering hundreds of permanent and contract opportunities across all roles, levels and platforms. Our Web based tools help you see and apply for jobs matched automatically to your skills and preferences. When you're ready to interview we meet with you in person to help you build the technology career path you've always wanted. Visit www.randstad.ca to get started!
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
Are you an IT Database Administrator looking for a new opportunity?
Are you looking for a new contract opportunity?
We are pleased to offer you a new contract opportunity for you to consider: IT Database Administrator.
Start: ASAP.
Estimated length: 6 months.
Location: Toronto.
Fully remote work.
Actively seeking for candidates with below requirements.
Advantages
You will have an opportunity to work with a leading employer in the local market.
Potential for contract extension and conversion to full time opportunity as well
Responsibilities
Review project docs to ensure design specifications meet application needs
Advise on client DB standards as required on projects (eg. Audit processes, database access, job configuration)
Create new databases (OCAC PDBs - CDBs)
Oracle Upgrade / migrate from 12C to 19C
AWR reporting, tuning and optimization of Database
Updates to database schema (create, alter, or drop objects) details
Apply database permissions (add, modify, or delete logins, grant/revoke permissions to DB objects)
Deploy code (stored procedures, SQL scripts)
...
Setup DB traces for Performance Testing to capture various performance metrics
Support testing cycles (eg. Running scripts, database backup/restores)
Documentation updates, as required
Defines the content and structure of the database and advises users on efficient techniques for extracting data
Contribute to automation of installs
Establish and maintain database support tools. Monitors overall standards and procedures and ensures integration of systems through database design.
Maintains accurate and up‐to‐date database system documentation. Has awareness of available physical storage and initiates requests for new devices.
Proposes data standards for both software and physical protection.
Assists in database reorganization/restructuring.
Creates new schema for the development of new software products. This work involves working with Application Development, the business line customer, and the project management team.
Informs systems and applications programming staff of any future database changes that might require program modification.
Assists in the change control process to implement changes.
Assure timely and accurate processing of assigned tasks.
Recommends an effective operational procedure in accordance with department goals and application guidelines, in order to effectively utilize the database system and remain within the security and integrity control limits
Qualifications
Strong experience and knowledge installing and building OCAC (DBs, , ODI, Oracle19c upgrades/in place upgrades and Clustered RAC installs
Strong experience with AWR, ADDM reporting, SQL Tuning Advisor, SQL Trace & TKProf and optimization of Database/VLDBs.
Strong experience and knowledge with SQL Developer, Clustered RAC, Active/Normal Data Guard, RMAN, Data Pump, SQL*loader and export/import
Knowledge of related tasks like DR switchover, converting to read/write mode without interrupting primary production database
Experience supporting PostgreSQL project work and maintenance.
OCAC ( Create new databases (OCAC PDBs - CDBs)
AWR reporting, tuning and optimization of Database
SQL tuning
Hands on project and maintenance experience with PostgreSQL Version 11 and above.
Summary
Do you have this experience? If you answer YES, then please apply IMMEDIATELY to so we can then discuss your experience and interest in this opportunity!
Randstad Technologies Group
Canada's largest provider of IT Staffing Solutions, offering hundreds of permanent and contract opportunities across all roles, levels and platforms. Our Web based tools help you see and apply for jobs matched automatically to your skills and preferences. When you're ready to interview we meet with you in person to help you build the technology career path you've always wanted. Visit www.randstad.ca to get started!
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
