RQ11159 - Database Administrator - Senior

Responsibilities:

• Designing and developing data pipelines from source to end user
  
• Optimizing data pipelines
  
• 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
  

Experience and Skill Set Requirements:

Must Haves:

• 7–10+ years of experience in Database Administration, including design, implementation, operations, and optimization of enterprise‑scale database systems.
  
• Proven expertise administering cloud database platforms, with a strong focus on Azure PaaS and IaaS database services.
  
• Experience managing cloud data services for project delivery, including storage, repositories, virtual machines, disks, key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms
  
• Expertise in Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
  
• Advanced performance tuning and troubleshooting, including:
  

• Query optimization and indexing strategies
  
• Azure SQL Query Store analysis
  
• Intelligent Performance & automatic tuning features
  
• Review of wait statistics and IO analysis
  
• TempDB optimization
  
• Understanding and mitigating Azure throttling limits
  

Skill Set Requirements:

Core Skills and Experience:

• 7–10+ years of experience in Database Administration, including design, implementation, operations, and optimization of enterprise‑scale database systems.
  
• Proven expertise administering cloud database platforms, with a strong focus on Azure PaaS and IaaS database services.
  
• Extensive experience creating logical and physical database designs, including schema optimization for OLTP and analytical workloads.
  
• Demonstrated experience in database performance tuning, capacity planning, growth forecasting, and lifecycle management.
  
• Hands‑on experience in database installation, configuration, migration, and upgrades, including modernization from legacy platforms to cloud environments.
  
• Proven ability to design and support high availability (HA) and disaster recovery (DR) strategies for mission‑critical systems.
  
• Experience managing cloud data services for project delivery, including storage, repositories, virtual machines, disks, key vaults, Data Lake, Data Warehouse, and Data Lakehouse platforms.
  
• Experience supporting structured, semi‑structured, and unstructured data ingestion, exchange, and provisioning for enterprise data warehouse and lakehouse solutions.
  
• Demonstrated application of DataOPS principles, including monitoring, alerting, performance optimization, and operational tuning across environments.
  
• Strong background in incident, change, and configuration management within ITIL‑aligned or governed public‑sector environments.
  

Technical & Engineering Skills:

• Expertise in Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
  
• Expertise in Azure Storage, Azure Data Lake, Databricks Lakehouse, Azure Data Factory
  
• Experience with relational and distributed database systems; exposure to NoSQL or distributed data platforms is an asset.
  
• Knowledge of cloud networking concepts, including VNET integration, private endpoints, firewalls, and communication protocols.
  
• Expertise in logical and physical data modeling, including normalization, denormalization, and partitioning strategies.
  
• Experience designing multi‑tenant database architectures.
  
• Advanced performance tuning and troubleshooting, including:
  
• Query optimization and indexing strategies
  
• Azure SQL Query Store analysis
  
• Intelligent Performance & automatic tuning features
  
• Review of wait statistics and IO analysis
  
• TempDB optimization
  
• Understanding and mitigating Azure throttling limits
  
• Expertise designing data tiers that balance performance, scalability, and cost.
  
• Expertise implementing Azure authentication and authorization, including Azure AD integration and role‑based access control (RBAC).
  
• Strong experience with data protection and encryption, including Transparent Data Encryption (TDE) and key management.
  
• Experience reviewing and enforcing network security, firewall rules, and access controls.
  
• Proven experience ensuring compliance with audit standards, data classification standards, and regulatory requirements (e.g., PHIPPA).
  
• Experience researching and implementing cybersecurity vulnerability remediation in database environments.
  
• Exceptional analytical, problem‑solving, and decision‑making abilities.
  
• Strong verbal, written, and presentation skills, with the ability to explain complex technical concepts clearly to both technical and non‑technical stakeholders.
  
• Proven interpersonal and negotiation skills, with experience collaborating across infrastructure, security, application, and data teams.
  
• Strong organizational skills with the ability to manage multiple priorities and meet fixed deadlines.
  
• Demonstrated ability to function as a senior technical resource, providing guidance, mentoring, and operational leadership.
  
• A collaborative team player with a track record of successful project delivery in regulated environments
  

General Skills:

• Exceptional analytical, problem-solving, and decision-making abilities.
  
• Strong verbal and written communication skills, with the ability to present technical concepts clearly.
  
• Proven interpersonal and negotiation skills, with experience building strong stakeholder relationships.
  
• Demonstrated critical thinking and troubleshooting in complex data environments.
  
• Effective consulting and facilitation skills, with a track record of engaging diverse stakeholders.
  
• Excellent customer service orientation, applying tact and diplomacy to manage client needs.
  
• Highly motivated, flexible, detail-oriented, and creative team player with strong organizational and multi-tasking abilities.
  
• Proven ability to meet strict deadlines in fast-paced, data-driven environments.
  
• Experience with digital product development, data analysis, and data security.
  
• Familiarity with Data Lakehouse architectures and emerging cloud-native technologies.
  
• Hands-on experience with mainstream cloud providers (AWS, Azure, GCP) and their data services.
  
• Knowledge of data governance, compliance, and security frameworks in enterprise environments.
  

Public Sector Experience:

• Proven public sector experience, particularly within environments supporting legacy systems, formal governance models, and regulated data.
  
• Experience working under Ontario Public Service (OPS) or similar audit standards, data classification frameworks, and compliance requirements.
  
• Knowledge of and experience complying with PHIPPA and other public‑sector regulatory obligations.