Database Administrator Senior

Job Title: Database Administrator - Senior
Location: Toronto or Kingston Ontario
Work Model: Onsite
Security Clearance: CRJMC

Description / Responsibilities / Skills

Must Have

• 7 10 years of experience in Database Administration including design implementation operations and optimization
• Strong expertise administering Azure cloud database platforms (PaaS and IaaS)
• Experience managing cloud data services including storage virtual machines disks key vaults Data Lake Data Warehouse and 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 indexing Query Store analysis and IO analysis
• Strong experience with TempDB optimization and managing Azure performance limits

Description

Responsibilities

• Design implement and manage enterprise database solutions
• Develop and optimize data pipelines from source to end-user systems
• Perform database design performance tuning capacity planning and lifecycle management
• Support database installation migration upgrade and modernization initiatives
• Implement high availability and disaster recovery strategies
• Monitor and enforce database performance reliability and security standards
• Support structured and unstructured data ingestion and integration
• Maintain database documentation standards and procedures
• Collaborate with cross-functional teams to support data-driven applications
• Ensure compliance with security privacy and regulatory standards

General Skills

• Strong experience in database administration across enterprise environments
• Experience working with database technologies and operating systems
• Experience with SQL and query optimization
• Strong analytical problem-solving and troubleshooting skills
• Experience with incident change and configuration management processes
• Strong communication and stakeholder engagement skills
• Ability to manage priorities and meet deadlines
• Strong team collaboration and leadership capabilities

Desirable Skills

• Experience with distributed data systems and NoSQL platforms
• Experience with middleware and integration tools
• Experience implementing cybersecurity vulnerability remediation
• Knowledge of CASE tools and database modeling frameworks
• Knowledge of information management principles and policies
• Experience with Oracle EBS environments and Data Guard
• Experience with WebLogic and OEM Grid Control

Skills

Core Skills and Experience - 40%

• Experience designing logical and physical database architectures
• Experience implementing and managing cloud data platforms
• Experience with performance tuning capacity planning and database scaling
• Experience supporting high availability and disaster recovery
• Experience working with DataOps practices including monitoring and optimization
• Experience with data ingestion and provisioning across systems
• Strong experience in governed and regulated environments

Technical and Engineering Skills - 30%

• Expertise in Azure SQL Database Azure SQL Managed Instance and SQL Server
• Experience with Azure Storage Data Lake Databricks Lakehouse and Data Factory
• Experience with data modeling partitioning and multi-tenant architectures
• Advanced performance troubleshooting including indexing query tuning and IO analysis
• Experience with Azure AD authentication and RBAC
• Experience with encryption security and compliance frameworks
• Experience implementing network security configurations
• Knowledge of compliance standards such as PHIPPA

General Skills - 25%

• Strong analytical problem-solving and decision-making abilities
• Strong communication and documentation skills
• Ability to collaborate with infrastructure security and application teams
• Strong organizational and project delivery skills
• Ability to manage multiple priorities in fast-paced environments
• Customer-focused mindset and stakeholder engagement

Public Sector Experience - 5%

• Experience working in public sector or regulated environments
• Knowledge of OPS governance audit standards and data compliance requirements
• Experience working with PHIPPA and regulated healthcare data