Back to all jobs

Database Administrator - Senior

Senior Database Administrator for the Government Services Integration Cluster, responsible for database design, administration, optimization, cloud and on-premises database operations, security, migration, backup, recovery, and enterprise integrations.

Organization
Government Services Integration Cluster
Location
Toronto, Ontario
Work arrangement
On-site
Employment type
Contract
Compensation
$623/day
Reference
RQ11860

Overview

Senior Database Administrator assignment with the Government Services Integration Cluster. The role creates physical database designs and operates and administers database management systems (DBMS), including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery. The assignment supports large-scale public applications, cloud-hosted and hybrid databases, legacy on-premises mainframes and enterprise servers, enterprise data architecture, security, integrations, and major database upgrades and migrations.

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
• Subject matter expert in database design of the data warehouse or data marts
• Design/develop an automated data distribution mechanism
• Develop enterprise architecture deliverables (e.g. models)
• Perform impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
• Perform technical design, planning and implementation of specific technology or suite
• Provide database administration and vendor support services
• Implement strict role-based access control (RBAC), data masking, row-level security, and transparent data encryption (TDE) at rest and in transit
• Ensure adherence to provincial data privacy and security mandates
• Design, test, and execute enterprise backup strategies, point-in-time recovery, geo-replication, and business continuity failover drills
• Lead major database version upgrades, cross-platform migrations, and consolidation projects without disrupting agency services
• Prepare documentation, including but not limited to reports, reviews, and assessments
• Present ideas and suggestions clearly and effectively in a user friendly manner; maintain a high level of customer service to both internal and external clients
• Communicate designs and development in a clear and understandable manner

Mandatory Qualifications

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

Preferred Qualifications

• 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

Skills and Experience

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 & Integrations, 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

Additional Skills for Data Warehouse including Oracle OBIEE
• 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
• Knowledge and understanding of object-oriented analysis and design techniques
• Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
• Knowledge and understanding of Information Management principles, concepts, policies and practices

Additional Skills for Cloud Database Administrator
• Expertise and experience in Cloud DB Administration, Data Development (DevOps/DataOps) & Operations, Data Integration, Automation tools and technologies

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

Applications are closed.