Database Administrator (RQ11860) Government Services Integration Cluster

Softline Technology Inc.; Toronto; Vor Ort; CAD 90.000 - 130.000; Vollzeit

Zusammenfassung

Softline Technology Inc. seeks a skilled Database Administrator/Engineer to design and administer enterprise DBMS, optimize performance, and manage backups and migrations. You will work across Oracle, SQL Server, PostgreSQL, MySQL, and IBM DB2, with cloud and on-premise deployments and OBIEE involvement.

The role requires strong data modeling, security, and collaboration with teams to ensure reliability and scalability of critical systems.

Qualifikationen

• Experience with major DBMS and cloud databases to support enterprise applications.
• Knowledge of data modeling, performance tuning, and backup/recovery strategies.
• Familiarity with data warehouse concepts and OBIEE is a plus.

Aufgaben

• Creates physical database designs and administers DBMS including optimization, capacity planning, installation and migration.
• Maintains data integrity and performance through monitoring and tuning.
• Implements incident, change and configuration management processes.
• Supports data warehousing activities such as data marts and OBIEE design.
• Ensures security, access control and compliance for database systems.

Kenntnisse

Operating systems

DBMS experience

Programming languages

Query languages

DB governance

Incident/Change/Config mgmt

Networking protocols

Analytical/problem solving

Team player

Tools

Oracle DBMS

SQL Server

PostgreSQL

MySQL

IBM DB2

Azure/AWS cloud DBs

Jobbeschreibung

Description

Responsibilities:

• 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

Technical Skills (40%)

• Experience with major database management systems (DBMS) such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2
• Experience managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on-premises mainframes and enterprise servers
• Experience with Agile methodologies
• Experience with conceptual, logical, and physical data modeling, schema design, and enterprise data architecture to support large-scale public applications
• Experience with onPrem and Cloud connections using Mulesoft or similar tools
• Experience Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,
• Experience with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)
• Experience with Rest APIs & Integration, Web/Lite Apps

Experience (40%)

• Experience with cloud platforms such as Azure, Dynamics 365, Power Platform
• Experience Implementing strict role-based access control (RBAC), data masking, row-level security, and transparent data encryption (TDE) at rest and in transit
• Ensuring adherence to provincial data privacy and security mandates
• Designing, testing, and executing enterprise backup strategies, point-in-time recovery, geo-replication, and business continuity failover drills
• Experience with Agile methodologies including using kanban/task boards
• Hands‑on experience leading major database version upgrades, cross-platform migrations, and consolidation projects without disrupting agency services
• Experience with SQL, PL/SQL, T‑SQL, and shell scripting (Bash, PowerShell, Python) for automation, stored procedures, and triggers
• Experience with large government applications

Communication Skills (20%)

• Strong communication skills to prepare documentation, including but not limited to; reports, reviews, assessments
• Ability to present ideas and suggestions clearly and effectively and in a user friendly manner; maintain a high level of customer service to both internal and external clients
• Ability to communicate designs and development in clear and understandable manner

Supplier Comments

Closing Date/Time: 2026-11-12, 12:00 p.m.

Max submission: 1 (one)

5 days onsite

Must Have:

• Experience with major database management systems (DBMS) such as Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and IBM DB2
• Experience managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS, Google Cloud SQL) alongside legacy on-premises mainframes and enterprise servers
• Experience Cloud (Azure or AWS), Cyber Security, Enterprise and Solution Architecture, Java, Microsoft .Net,
• Experience with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL MI, Azure Blob, Cosmos DB etc.)