Job Description

We have received a new requirement with one of the ministries in Ontario, kindly find the details below:

Note:

This position is currently listed as "Hybrid" however, the consultant will be remote due to COVID-19 related Work from Home (WFH) direction. Once the I&IT cluster staff are required to return to the office, the resource under this request will be required to work onsite as well.

• Candidate is required to come in office -3 days a week

Mandatory documents: * Kindly provide updated Resume in word format.

• Kindly provide attached Skills Matrix and References after filling.
• Kindly provide your expected hourly rate.

Job Title: RQ05859 - Database Administrator \xe2\x80\x93 Senior

Client: Ministry of Northern Development, Mines, Natural Resources and Forestry

Work Location: 40 St. Clair Ave. W, Toronto, Ontario, Hybrid

Estimated Start Date: 2023-09-11

Estimated End Date: 2024-03-31

#Business Days: 145.00

Extension: Probable after the initial mandate

Hours per day or Week: 7.25 hours per day

Security Level: No Clearance Required

Mandatory Requirements:

• Support data migration activities from external data sources into source Oracle/Siebel database
• Maintain and monitor a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments including database administration, maintenance, optimization, migration, and fine tuning of databases

Kindly share the following documents to by Tuesday, August 22 at 01:00 PM EST

Description

• Creates and implements physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
• Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
• Implement Transparent Data Encryption (TDE) at selective schema/tablespace level on various versions Oracle database
• Build new databases with TDE enabled at selective schema/tablespace level on various versions of Oracle database
• Support data migration activities from external data sources into source Oracle/Siebel database
• Maintain and monitor a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments including database administration, maintenance, optimization, migration, and fine tuning of databases
• Design, build and configure Oracle Database Servers on Windows, Solaris, Linux
• Ensure existing databases meet performance requirements including but not limited to SIEBEL, ARCGIS, APEX databases on Oracle
• Ensure that all deployed databases are secure and that appropriate security and auditing controls are in place to meet security and privacy requirements
• Provide database administration technical expertise during design and architecture phases of new solutions
• Lead and design solutions for enterprise Oracle migration project to migrate to 19c
• Plan, manage and coordinate implementation of technically advanced complex systems and assist in Data refreshes to lower non production environment
• Provide regular support to resolve complex and unique database management issues
• Provide expert support and guidance to production database systems and clients by overseeing the deployment and evaluation of complex Oracle databases
• Provide support and maintenance of databases in GoCloud and on premise based environments
• Carry out complex/specialized systems analysis and design for success of Oracle migration
• Provide assistance in the implementing, TDE, Dataguard, RAC, OMS, OEM 13c
• Install Oracle RDBMS software on virtual servers for Pre-Production and Production environments
• Setup all required automation on database server as per cluster\xe2\x80\x99s operation team\xe2\x80\x99s standard procedures
• Build various databases, schema etc. for individual client data holding in Persistent Storage
• Implement Transparent Data Encryption (TDE) at selective schema/tablespace level on various versions Oracle database
• Integrate with Informatica server and transactional database servers to ensure DCP transactional data is available at regular frequency in PSA databases
• Provide assistance with replicated database management and migration
• Documentation of your technical work such that knowledge can be transferred to you colleagues
• Identifies, analyses, prioritizes and communicates technical risks for decision makers
• Provides recommendations and mitigation strategies based on a detailed evaluation of technical risks and issues
• Communicates effectively to identify needs and evaluate solutions to complex business and technical issues

Skills

• Minimum 10+ years experience as Database Analysis (other IT roles to be considered as part of years experience)
• Experience with one or more operating systems
• Experience with one or more database technologies
• Experience in one or more programming languages Experience in the use of information retrieval packages and proficiency with query languages
• Experience in monitoring and enforcing database rules
• Experience in Incident, Change and Configuration Management procedures
• Experience with one or more communications protocols
• Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
• A team player with a track record for meeting deadlines

Desirable Skills

• Experience with distributed data systems
• Experience with middleware and gateways
• Experience with researching and implementing cyber security vulnerability remediation\'s
• Awareness of emerging IT trends and directions
• Experience with Computer Aided Software Engineering (CASE) tools
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Experience in Database Administration, Maintenance Optimization
• Additional Responsibilities/Skills for Data Warehouse including Oracle OBIEE
• Subject matter expert in database design of the data warehouse or data marts.
• Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning
• Additional Skills for Case Management and ERP Experience in designing/developing an automated data distribution mechanism
• Knowledge and understanding of object-oriented analysis and design techniques.
• Experience in developing enterprise architecture deliverables (e.g. models)
• Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
• Experience in technical design, planning and implementation of specific technology or suite
• Experience with database administration and vendor support services

Experience and Skill Set Requirements

Evaluation Criteria

Database Analysis, Design and Implementation Skills/Experience - 50%

• 10+ years hands on experience
• Experience with database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
• Experience maintaining and monitoring a number of Oracle 10g,11g,12c,19c databases in large multi-tenant environments
• Experience with deployed databases security i.e. ensuring appropriate security and auditing controls are in place to meet security and privacy requirements

Technical Planning, Coordination and Monitoring Skills/Experience - 30%

• Experience coordinating implementation of technically advanced complex systems resources to lower non production environment
• Experience in providing complex/specialized systems analysis and design for success
• Communicates effectively to drive technical outcomes with technical staff/teammates
• Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
• Experience with distributed data systems
• Experience with middleware and gateways
• Awareness of emerging IT trends and directions

Communications and Teamwork Skills - 20%

• Experience documenting technical work that facilitates knowledge transfer
• Communicates technical issues in plain language effectively
• Excellent verbal and written communication skills
• Demonstrated strength building strong relationships and being a strong team player

Powered by JazzHR

S M Software Solutions Inc