Database Administrator

Job Description

Job Title: Database Administrator

Work Environment

• Location: Onsite (Ontario Public Service Office)
  
• Schedule: Monday to Friday, 7.25 hours per day
  
• Assignment Type: Full-time Onsite (5 days per week)
  

Position Overview

The Government of Ontario is seeking an experienced Database Administrator (DBA) to support the administration, maintenance, optimization, and security of enterprise database environments. The successful candidate will be responsible for database design, installation, configuration, migration, performance tuning, backup and recovery, capacity planning, and cloud-based database solutions across Oracle and SQL Server platforms. This role requires extensive experience supporting mission-critical enterprise systems in both on-premises and cloud environments while following ITIL service management practices.

Key Responsibilities

• Design, implement, administer, and maintain enterprise database environments.
  
• Install, configure, upgrade, migrate, and clone Oracle and SQL Server databases.
  
• Monitor database performance and perform performance tuning, optimization, and capacity planning.
  
• Develop and maintain backup, recovery, and disaster recovery strategies.
  
• Administer Oracle RAC, Oracle GoldenGate, and Oracle Data Guard environments.
  
• Develop and optimize PL/SQL procedures, packages, ETL processes, and SQL queries.
  
• Support database environments hosted on on-premises infrastructure as well as Microsoft Azure and Oracle Cloud Infrastructure (OCI).
  
• Monitor database health, availability, security, and compliance.
  
• Manage database incidents, problems, changes, configurations, and capacity planning using ITIL best practices.
  
• Coordinate database deployments and migrations across development, testing, and production environments.
  
• Maintain database security, user access, and data integrity.
  
• Create technical documentation, operational procedures, and implementation plans.
  
• Collaborate with application, infrastructure, cloud, and security teams to ensure reliable database services.
  

Required Qualifications

• 10+ years of experience in Database Administration.
  
• Extensive experience administering Oracle and Microsoft SQL Server databases.
  
• Hands-on experience with database installation, configuration, migration, upgrades, and maintenance.
  
• Strong expertise in database performance tuning, optimization, and capacity planning.
  
• Experience with Oracle RAC, Oracle GoldenGate, and Oracle Data Guard technologies.
  
• Minimum 5+ years of experience developing PL/SQL procedures, packages, ETL processes, and query optimization.
  
• Experience implementing backup, recovery, and disaster recovery solutions.
  
• Experience with Microsoft Azure and Oracle Cloud Infrastructure (OCI).
  
• Experience working with Linux, Unix, and Windows operating systems.
  
• Proficiency with database administration tools such as TOAD, Oracle Enterprise Manager (OEM), and DB Artisan.
  
• Knowledge of database security, access management, and data integrity.
  
• Experience with Incident, Problem, Change, Configuration, and Capacity Management processes.
  

Technical Skills

• Oracle Database (12c and above)
  
• Microsoft SQL Server
  
• PL/SQL Development
  
• ETL Procedures and Packages
  
• SQL Query Optimization
  
• Oracle RAC
  
• Oracle GoldenGate
  
• Oracle Data Guard
  
• Performance Tuning
  
• Backup and Recovery
  
• Disaster Recovery
  
• Capacity Planning
  
• Microsoft Azure
  
• Oracle Cloud Infrastructure (OCI)
  
• Linux, Unix, Windows
  
• TOAD
  
• Oracle Enterprise Manager (OEM)
  
• DB Artisan
  
• Python or Shell Scripting
  
• Database Security
  
• Cloud Migration
  
• ITIL Service Management
  

Preferred Qualifications

• Experience supporting large enterprise or government environments.
  
• Experience with distributed database systems.
  
• Knowledge of middleware technologies such as Oracle WebLogic and OEM Middleware.
  
• Experience implementing cybersecurity vulnerability remediation.
  
• Knowledge of Enterprise Architecture principles and practices.
  
• Experience with ERP or Case Management systems.
  
• Experience implementing database patches, maintenance packs, and technology stack upgrades.
  
• Knowledge of Object-Oriented Analysis and Design (OOAD).
  
• Awareness of emerging database and cloud technologies.
  

Soft Skills

• Excellent analytical and problem-solving skills.
  
• Strong troubleshooting and performance optimization abilities.
  
• Excellent verbal and written communication skills.
  
• Strong documentation and technical writing skills.
  
• Ability to collaborate effectively with cross-functional technical teams.
  
• Strong organizational and time management skills.
  
• Ability to manage multiple priorities and meet project deadlines.
  

Requirements
Mandatory Skills & Experience Cloud & Infrastructure Engineering Proven experience designing, deploying, and maintaining hybrid infrastructure environments across: Microsoft Azure Amazon Web Services (AWS) Linux-based environments SaaS solutions COTS solutions On-premises systems Strong experience with Windows and Linux server administration including: CentOS Ubuntu CoreOS Experience supporting modern web technology stacks including: LAMP MEAN Drupal Elasticsearch Experience with virtualization platforms, storage solutions, networking, and enterprise infrastructure services. Strong understanding of cloud architecture frameworks, technology assessments, and cloud solution strategies. Identity & Access Management Experience managing and supporting identity and access controls using: Active Directory Microsoft Entra ID Enterprise IAM solutions Experience implementing authentication, authorization, and access governance controls. DevOps & CI/CD Automation Strong experience designing, building, and administering CI/CD pipelines for continuous integration and deployment. Experience with development and collaboration tools including: Azure DevOps JIRA Confluence Maven Jenkins Experience with Infrastructure as Code (IaC) and version-controlled deployments. Strong knowledge of DevOps methodologies, automation frameworks, and release management best practices. Experience with containerization and orchestration technologies including: Docker Kubernetes AKS / EKS Experience automating operational and compliance-related activities using: PowerShell Bash Python Programming & Scripting Hands-on experience with scripting and programming languages including: Python Bash PHP Java JavaScript Node.js Experience with build and configuration management tools including: Git Ansible Chef Puppet API & Integration Experience Experience building and consuming APIs and integration endpoints. Experience integrating cloud platforms, enterprise systems, and deployment pipelines. Understanding of enterprise integration architectures and service-based deployments. Security, Monitoring & Compliance Strong understanding of infrastructure security, cloud security, and DevOps security best practices including: Least privilege access Secure logging Secrets management Vulnerability remediation Experience with security and monitoring tools including: Radware Dynatrace Splunk Azure Monitor / Log Analytics AWS CloudTrail / CloudWatch ELK Stack / SIEM solutions Experience implementing centralized audit logging and monitoring across enterprise platforms. Ability to support internal and external audits through reporting, evidence gathering, and log analysis. Experience supporting forensic investigations, audit remediation, and incident reviews. Familiarity with Government of Ontario I&IT Directives, Policies, and Information Technology Standards. Release Management & Operational Support Experience coordinating infrastructure and application releases across technical and business teams. Knowledge of change management processes, deployment approvals, rollback planning, and release governance. Experience with release readiness reviews, deployment validation, and post-release monitoring. Ability to maintain release documentation, operational records, and audit artifacts. Project Management & Communication Strong project planning, coordination, and resource management skills. Experience with roadmap planning, modernization initiatives, and infrastructure investment planning. Strong stakeholder communication and cross-functional collaboration skills. Ability to explain complex technical concepts to business users, leadership teams, and non-technical stakeholders. Strong documentation, reporting, presentation, and technical writing skills. Mobile Device Management Experience supporting mobile device management for cellular devices and tablets across multiple platforms and operating systems. Desirable Skills Experience supporting Government of Ontario enterprise environments. Experience with enterprise modernization and cloud transformation initiatives. Familiarity with enterprise governance, compliance frameworks, and audit readiness programs. Experience mentoring and coaching junior DevOps and infrastructure resources. Strong understanding of operational resilience, disaster recovery, and enterprise monitoring strategies. Additional Information Strong hands-on DevOps, cloud infrastructure, automation, CI/CD, security, and enterprise release management experience is mandatory for this role.