Database analyst Jobs in Canada

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.