Senior Database Administrator

SENIOR DATABASE ADMINISTRATOR (DB Replication - MS SQL or Oracle)

Requisition #: R24-3105 (RQ# 07594)

Location: Hybrid (Toronto, ON - 3 days onsite/2 days remote per week)

Engagement Type: Contract

Number of Resources required: 1

Term: ASAP to 2025-03-31 with up to 300 days of extension available

Rate (Per Day): Up to $601.75 per diem (equivalent to $83/hour) / Commensurate with related experience and market competitiveness

Hours per day: 7.25

Security Screening: OPP Level 4 (Criminal Record Check)

Closing Date: June 18, 2024 (3:00 PM Eastern Time)

------------------------------------------------------------------------

Tri-global Solutions Group Inc. is seeking one (1) Senior Database Administrator (DB Replication - MS SQL or Oracle) to join our talented Service Delivery team at Ministry of Solicitor General (Ontario Public Service).

Hybrid Work Model: The successful candidate is required to work 3 days per week onsite in Toronto, ON and 2 days per week remotely (from home).

Please review the project overview, description of services, and requirements below. If you meet the requirements and are interested in submitting for this role, please reply to this job posting.

If you know other consultants who may be interested in this opportunity kindly share this job posting.

Thank you.

Tri-global Solutions Group Inc.

Website: https://tri-global.com

------------------------------------------------------------------------

PROJECT OVERVIEW

Requisition Title:

CCS_ Justice Sector Report_ Database Administrator_ Senior

Description:

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.

DESCRIPTION OF SERVICES

• 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.

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

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

MANDATORY REQUIREMENTS (Candidates must meet all requirements below)

• 10+ years' experience as a Database Administrator (DBA)

• 5 +years' experience in database replication / Real-Time data delivery with either MSSQL or Oracle products

DESIRABLE REQUIREMENTS (Nice to have)

• Previous experience in OPS will be an asset

EXPERIENCE / SKILL SET AND EVALUATION CRITERIA

Criteria 1: Technical Skills (55%)

• 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%)

• 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%)

• Demonstrated writing and negotiation

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

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

NOT FOR YOU?

Check out our other opportunities at https://tri-global.com or follow us on LinkedIn. We thank all candidates in advance. Only candidates selected for an interview will be contacted.

WHY WORK WITH TRI-GLOBAL?

- Empower positive change by enabling our clients to revolutionize innovation and technology, elevating them to a higher level of excellence and efficiency.

- Join an exceptional and committed team that redefines the landscape, forging a distinctive path towards success.

- Engage in stimulating and captivating projects that push boundaries and keep you constantly motivated.

Job Type: Full-time

Pay: Up to $601.75 per day

Benefits:

• Work from home

Flexible Language Requirement:

• French not required

Schedule:

• Monday to Friday

Application question(s):

• Have you previously worked with Ontario Public Service (OPS) or Ontario's Broader Public Service (BPS)? BPS organizations included but are not limited to hospitals, universities, colleges, and school boards. Please specify "Yes" or "No". If Yes, please indicate names of OPS/BPS organizations you have worked with previously.


• Hybrid Work Model: The successful candidate is required to work 3 days per week onsite in Toronto, ON and 2 days per week remotely (from home).

Please Acknowledge the Hybrid Work Model requirement by providing a "YES or NO" response. Candidate who cannot commit to the hybrid work requirement will not be considered further. Thank you for your understanding.

• Please confirm the following Mandatory Requirements.

Candidates must possess the following skills/experience to be considered:

• 10+ years' experience as a Database Administrator (DBA)


• 5 +years' experience in database replication / Real-Time data delivery with either MSSQL or Oracle products

Respond with "YES" or "NO".

Experience:

• prior public sector: 1 year (preferred)


• Database Administrator (DBA): 10 years (required)


• database replication with either MSSQL or Oracle products: 5 years (required)


• Real-Time data delivery with either MSSQL or Oracle products: 5 years (required)


• Previous experience in Ontario Public Service: 1 year (preferred)

Work Location: Hybrid remote in Toronto, ON

Application deadline: 2024-06-19
Expected start date: 2024-07-02