Database Administrator

Softline Technology
Toronto, ON

Apply Now

Job details

Contract
7 hours ago

Qualifications

Authentication
Statistics
Performance tuning
Data modeling
Azure
Operating systems
Oracle
Node.js
Financial auditing
Customer service
DevOps
ERP systems
Encryption
Data analysis skills
UNIX
Microsoft SQL Server
NoSQL
PaaS
Solaris
Oracle EBS
Google Cloud Platform
Enterprise architecture
Weblogic
Databases
SQL
Database administration
Firewall
AWS
Presentation skills
Product development
Computer networking
Organizational skills
Linux
Cybersecurity
Communication skills
Data warehouse
Information management
OBIEE
Shell Scripting
IaaS
Negotiation
High availability
Network security

Full job description

Description

NOTE:

Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

Extension/Amendment Attestation:

Extensions are permitted only to the extent of unused contract days and/or remaining contract funds. No additional funds will be added beyond the maximum contract value, including any extension options set out in the original SOW.

HSC may exercise its option to extend the SOW beyond October 5, 2027, provided that the Master Service Agreement is extended. Any such extension shall be on the same terms, conditions, and covenants as those contained in the SOW.

Responsibilities:

Designing and developing data pipelines from source to end user
Optimizing data pipelines

Creates 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

General Skills:

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 remediations

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.

Skills:

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) based

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

Additional Skills for Cloud Database Administrator:

Expertise and experience in Cloud DB Administration, Data Development (DevOps/DataOps) & Operations, Data Integration, Automation tools and technologies. Further research suggested on a potential need for a role of a Senior DevOps/Cloud DBA at a rate similar to a Senior DevOps/Could Engineer

Additional Skills for Oracle Database Administrator:

Experience in e-Business Suite Applications R12.2 and Oracle Data Guard application (installation, configuration, maintenance, patching, upgrade, and cloning)

Knowledge and experience in configuring the latest version of WebLogic, OEM Grid Control

Expert level knowledge of migrating Oracle technologies from Unix (Solaris) to Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x

Expert level knowledge of Advanced Compression, Data partitioning processes

High level knowledge of data masking using Oracle patches and database scripts

Performance tuning of e-Business Suite R12.2/19c in multi-node RAC

Developing database backup and restore strategy utilizing Flash Recovery Area (FRA) for RMAN and ASM.

Expert level knowledge of Oracle 12c/19c database administration, maintenance, security implementation, upgrade and patching, database performance tuning, sizing and capacity planning, database backup and recovery using RMAN

Knowledge of Configuring Oracle E-Business Suite Release 12.2 using Logical Host

Knowledge of Online patching

Knowledge of UNIX OS (Operating System) and Linux OS, utilities, shell scripting

Experience Requirements

Core
Skills and Experience

7–10+ years of experience in Database

Administration, including design, implementation, operations, and
optimization of enterprise?scale database systems.

Proven expertise administering cloud database

platforms, with a strong focus on Azure PaaS and IaaS database services.

Extensive experience creating logical and

physical database designs, including schema optimization for OLTP and
analytical workloads.

Demonstrated experience in database performance

tuning, capacity planning, growth forecasting, and lifecycle management.

Hands?on experience in database installation,

configuration, migration, and upgrades, including modernization from legacy
platforms to cloud environments.

Proven ability to design and support high

availability (HA) and disaster recovery (DR) strategies for mission?critical
systems.

Experience managing cloud data services for

project delivery, including storage, repositories, virtual machines, disks,
key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms.

Experience supporting structured, semi?structured,

and unstructured data ingestion, exchange, and provisioning for enterprise
data warehouse and lakehouse solutions.

Demonstrated application of DataOPS principles,

including monitoring, alerting, performance optimization, and operational
tuning across environments.

Strong background in incident, change, and

configuration management within ITIL?aligned or governed public?sector
environments.

40%

Technical
& Engineering Skills

Expertise in Azure SQL Database, Azure SQL
Managed Instance, and SQL Server on Azure Virtual Machines.

Expertise in Azure

Storage, Azure Data Lake, Databricks Lakehouse, Azure Data Factory

Experience with relational and distributed
database systems; exposure to NoSQL or distributed data platforms is an
asset.
Knowledge of cloud networking concepts,
including VNET integration, private endpoints, firewalls, and
communication protocols.
Expertise
in logical and physical data modeling, including normalization,
denormalization, and partitioning strategies.
Experience
designing multi?tenant database architectures.
Advanced
performance tuning and troubleshooting, including:
Query
optimization and indexing strategies
Azure
SQL Query Store analysis
Intelligent
Performance & automatic tuning features
Review
of wait statistics and IO analysis
TempDB
optimization
Understanding
and mitigating Azure throttling limits
Expertise
designing data tiers that balance performance, scalability, and cost.
Expertise
implementing Azure authentication and authorization, including Azure AD
integration and role?based access control (RBAC).
Strong
experience with data protection and encryption, including Transparent
Data Encryption (TDE) and key management.
Experience
reviewing and enforcing network security, firewall rules, and access
controls.
Proven
experience ensuring compliance with audit standards, data classification
standards, and regulatory requirements (e.g., PHIPPA).
Experience
researching and implementing cybersecurity vulnerability remediation in
database environments.

Exceptional
analytical, problem?solving, and decision?making abilities.

Strong verbal,
written, and presentation skills, with the ability to explain complex
technical concepts clearly to both technical and non?technical stakeholders.

Proven interpersonal
and negotiation skills, with experience collaborating across infrastructure,
security, application, and data teams.

Strong organizational
skills with the ability to manage multiple priorities and meet fixed
deadlines.

Demonstrated ability
to function as a senior technical resource, providing guidance, mentoring,
and operational leadership.

A collaborative team
player with a track record of successful project delivery in regulated
environments

30%

General
Skills

Exceptional analytical,
problem-solving, and decision-making abilities.
Strong verbal and written
communication skills, with the ability to present technical concepts
clearly.
Proven interpersonal and
negotiation skills, with experience building strong stakeholder
relationships.
Demonstrated critical thinking
and troubleshooting in complex data environments.
Effective consulting and
facilitation skills, with a track record of engaging diverse
stakeholders.
Excellent customer service
orientation, applying tact and diplomacy to manage client needs.
Highly motivated, flexible,
detail-oriented, and creative team player with strong organizational
and multi-tasking abilities.
Proven ability to meet strict
deadlines in fast-paced, data-driven environments.

Experience with digital
product development, data analysis, and data security.
Familiarity with Data
Lakehouse architectures and emerging cloud-native technologies.
Hands-on experience with
mainstream cloud providers (AWS, Azure, GCP) and their data services.
Knowledge of data governance,
compliance, and security frameworks in enterprise environments.

25%

Public
Sector Experience

Proven public sector experience, particularly

within environments supporting legacy systems, formal governance models, and
regulated data.

Experience working under Ontario Public Service

(OPS) or similar audit standards, data classification frameworks, and
compliance requirements.

Knowledge of and experience complying with PHIPPA

and other public?sector regulatory obligations.

Supplier Comments

Closing date/time: 2026-06-22, 12:00 p.m.

Max no. of submission: 1 (one)

Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

Must have:

7–10+ years of experience in Database Administration, including design, implementation, operations, and optimization of enterprise?scale database systems.

?· Proven expertise administering cloud database platforms, with a strong focus on Azure PaaS and IaaS database services.

?· Experience managing cloud data services for project delivery, including storage, repositories, virtual machines, disks, key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms

?· Expertise in Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.

?· Advanced performance tuning and troubleshooting, including:

Query optimization and indexing strategies
Azure SQL Query Store analysis
Intelligent Performance & automatic tuning features
Review of wait statistics and IO analysis
TempDB optimization
Understanding and mitigating Azure throttling limits

Apply Now

Job seeker tools

Employer Tools

Browse

Stay Connected