11 Nov
|
Softline Technology
|
Toronto
11 Nov
Softline Technology
Toronto
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 transparent 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.)
📌 Database AdministratorGovernment Services Integration Cluster (Toronto)
🏢 Softline Technology
📍 Toronto