Database Administrator

Upstaff


Job Location:

Toronto - Canada

Monthly Salary: CAD 70 - 70
Experience Required: 10years
Posted on: 4 hours ago
Vacancies: 1 Vacancy

Job Summary

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.





Required Skills:

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

Job Title: Database AdministratorWork EnvironmentLocation: Onsite (Ontario Public Service Office)Schedule: Monday to Friday 7.25 hours per dayAssignment Type: Full-time Onsite (5 days per week)Position OverviewThe Government of Ontario is seeking an experienced Database Administrator (DBA) to suppor...