RQ07594 - Database Administrator - Senior

• NOTE: This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be “Hybrid”, working 7.25 hours per calendar day, sometime between 8:00-5:00 PM (excluding lunch breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment you will be under the discretion of the Hiring Manager’s requirements for the Project you are assigned to

Job Title: RQ07594 - Database Administrator - Senior

Location : Onsite / 21 College Street, Toronto

Client: Justice Technology Services /
Ministry of Solicitor General

Estimated Start Date: 2024-12-02

Estimated End Date: 2025-03-31

#Business Days: 82.00

Hours per day or Week:7.25 hours per day
Security Level: CRJMC
Closing Date/Time 2024-06-19, 12:00 p.m.

Without mandatory documents, we cannot submit a candidate.

Updated Resume in word format (Mandatory)

Expected hourly rate (Mandatory)

If you are interested, kindly send the following documents to [email protected] by , Wednesday , June 19 at 09:00 am EST. if that interests you and matches your profile.

Must haves:

• At least 10 years of experience


• Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years)


• Previous experience in OPS will be an asset

Description

NOTE: This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be “Hybrid”, working 7.25 hours per calendar day, sometime between 8:00-5:00 PM (excluding lunch breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment you will be under the discretion of the Hiring Manager’s requirements for the Project you are assigned to.

• Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support.

• Work with the project team in completing all relevant and required documentation in alignment with OPS standards.

Experience and Skill Set Requirements

Deliverables:

• Creation of technical specifications for Azure, SQL and Oracle database systems development

• Design, implement and work with the project team in completing all relevant and required documentation in alignment with OPS standards

• Undertake special assignments/sub-projects as assigned

• Conduct, assess, evaluate and document stakeholder interests and business needs

• Create and validate business scenarios and use cases

• Produce visual depiction of use cases and process flows; ensure alignment with the program area and associated business architecture, as well as traceability to solution logical and physical architectures

• Create, review, provide input and support of Enterprise Architecture artifacts for all checkpoints as required

• Create system and user interface design and modifications (data & screen) as required

• Review all test scenarios to ensure the requirements are met; establish traceability matrix to monitor output

• Ensure alignment and adherence to Ministry of Government Services’ processes and standards

• Support the testing team during system and UAT testing

• Participate in Knowledge transfer

Skills and Knowledge:

• Experience administering database management systems (i.e. ORACLE, Exadata, Microsoft SQL Server, Azure etc.) for business intelligence and analytics applications

• Create, test and implement safeguards to maintain data integrity and protect against unauthorized access

• Assist with SQL optimization and code reviews to ensure queries are efficient

Mandatory Requirements:

• At least 10 years of experience

• Experience in database replication / Real-Time data delivery with either MSSQL or Oracle products (5+ years)

Criteria Ratings MUST TOTAL 100

Criteria 1: Technical Skills 55 Points

• Oracle Exadata, Golden Gate, MSSQL, Azure SQL technical knowledge and experience.

• Demonstrated experience in modifying database structures using information provided by application developers

• Demonstrated experience with monitoring, optimizing and performance tuning using either manual or automated tools

• Able to develop and interpret highly complex SQL to support queries and provide feedback for developers.

Criteria 2: Analysis and Problem Solving 30 Points

• Research, and evaluation of complex design options.

• Superior ability to identify root cause of complex environmental or underlying database specific issues.

• Determining areas of risk and recommending innovative alternatives and options for resolution to meet program needs.

• Demonstrated experience working within a team environment to troubleshoot and resolve technical problems.

Criteria 3: Communication and Interpersonal Skills 15 Points

• Demonstrated writing and negotiation

• Oral and written communication skills, Interpersonal and consultative skills,

• Experience preparing operational documentation (build guides, procedures, etc)

Knowledge Transfer

Knowledge to be Transferred: • All documentation relating to functional and technical specifications for systems development. Codes Scripts.

Knowledge to be Transferred to: • Project Manager, team members

Details of Transfer:

• Knowledge Transfer to occur throughout the project life cycle.

• 1:1 meetings / team meetings / documentation on SharePoint site

If you are interested to learn more about this opportunity or If not please feel free to send over any names or forward this email to anyone who may be interested.

Job Type: Fixed term contract
Contract length: 82 days

Application question(s):

• At least 5 years of QA experience


• Working knowledge of SharePoint, .NET Web, Web Services, HTML, Jira, MS Dev Ops, JavaScript, VBScript and related scripting technologies for automation


• Knowledge and experience in the use of automated test tools and version control systems on one or more platforms such as DevOPS as well as experience in all phases of the Systems Development Life Cycle


• Public sector experience ( 5 points)

•Experience on testing enterprise level systems and exposure to OPS/ministry QA processes and standards- minimum of 5 years

• Business and Interpersonal skills (35 points)

•Demonstrated experience working with clients and technical teams to ensure effective resolution of defects and management of change requests are complete with excellent analytical, problem-solving and decision-making skills; organizational, creativity and perseverance skills; strong verbal and written communication skills

• Technology and Tools skills (30 points)

•Demonstrated knowledge and experience in the use of automated test tools and version control systems on one or more platforms such as DevOPS as well as experience in all phases of the Systems Development Life Cycle

• QA Skills (30 points)

•Hands on experience in developing and executing test scripts, test data, record software defects, documenting software defects and track resolution.

•Extensive knowledge in developing test plans, test cases and test scripts to validate the functionality of various modules and changes made to the modules.

Work Location: In person

Application deadline: 2024-06-19