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
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• 710 years of experience in Database Administration including design implementation operations and optimization of enterprisescale 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:

• 710 years of experience in Database Administration including design implementation operations and optimization of enterprisescale 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.
  
• Handson 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 missioncritical 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 semistructured 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 ITILaligned or governed publicsector 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 multitenant 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 rolebased 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 problemsolving and decisionmaking abilities.
  
• Strong verbal written and presentation skills with the ability to explain complex technical concepts clearly to both technical and nontechnical 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 publicsector regulatory obligations.