Job Description
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
Job Tags