Job DescriptionResponsibilities:
- 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
Requirements
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.
RequirementsExperience 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.
){kind=logo}
