Senior Database Administrator responsible for physical database design, administration, optimization, capacity planning, migrations, performance tuning, backup and recovery. The role manages Oracle, SQL Server, cloud, hybrid, and legacy databases; implements security controls, disaster recovery, version upgrades, data integration, automation, and enterprise architecture. Requires expertise in SQL, cloud platforms, scripting, data modeling, database security, high availability, and large-scale government applications.
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
Requirements
Experience and Skill Set Requirements:
Must Haves:
- 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.)
Skill Set Requirements:
Technical Skills:
- 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:
- 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:
- 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
Similar Jobs
Gaming
Designs and supports AWS back-end services for Wizard of Oz Slots, develops PHP gameplay functionality, and maintains CI/CD pipelines and infrastructure-as-code tooling. Responsibilities include load testing, infrastructure optimization, monitoring, escalation support, code quality, process improvement, and mentoring engineers. The role requires experience operating high-traffic, low-latency systems, working with SQL and NoSQL databases, and collaborating in a distributed team.
Top Skills:
AWSChefCi/CdInfrastructure As CodeJenkinsMicroservicesNoSQLPHPSQLTerraformVue
Cloud • Mobile • Software
Own and scale BuildOps’ customer-facing data platform, including CDC ingestion into Snowflake, dbt modeling, near-real-time pipelines, secure data sharing, platform observability, Terraform infrastructure, and warehouse optimization. Participate in on-call incident response, support internal teams, manage governance and access, and contribute through architecture decisions, documentation, code reviews, and mentorship.
Top Skills:
AirbyteAirflowApache IcebergAWSCdcDbtDebeziumFivetranGitKafkaMwaaMySQLPostgresPythonSecodaSigmaSnowflakeSQLStreamkapTerraform
Artificial Intelligence • HR Tech • Information Technology • Machine Learning • Software • App development • Industrial
Build and improve backend systems, internal tools, and user-facing features in collaboration with leadership and cross-functional teams. Lead initiatives from design through delivery, create scalable and maintainable solutions, contribute to technical direction, and mentor teammates. The role emphasizes autonomy, strong communication, user-centric outcomes, and participation in a mission-driven engineering culture.
Top Skills:
Python
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
