Database Administrator-(Hybrid)

Responsibilities

• Production Database Administration & High Availability
• Administer and maintain enterprise Microsoft SQL Server 2019 environments, with active participation in the migration and upgrade to SQL Server 2025.
• Design, implement, and manage high-availability solutions including Always On Availability Groups, Failover Clustering (WSFC), log shipping, and database mirroring to ensure cross-region availability and business continuity.
• Monitor, maintain, and optimize database infrastructure including storage, I/O subsystems, and server configurations to meet performance SLAs.
• Manage backup and recovery strategies aligned to defined RTO/RPO requirements; conduct and validate regular restore testing.
• Administer DBMS security including role-based access control (RBAC), user provisioning, auditing, and compliance with security standards.
• Support release, change, and patch management processes including deployment and rollback execution for database-impacting changes.
• Participate in a 24/7 on-call rotation, providing production support and resolving complex, high-priority database incidents within defined SLA windows.
• Performance Tuning & Optimization
• Proactively monitor and tune database performance using tools such as SQL Server Profiler, Query Store, Extended Events, Dynamic Management Views (DMVs), and Azure Monitor.
• Identify and resolve performance bottlenecks through query optimization, index design and maintenance, execution plan analysis, and configuration tuning.
• Establish and maintain performance baselines; conduct capacity planning to support growth and peak load requirements across the database estate.
• Analyze wait statistics, blocking, and deadlock scenarios; implement corrective measures to ensure optimal throughput and concurrency.
• Administer and support Azure SQL database services including Azure SQL Managed Instance and Azure SQL Database, with deep working knowledge of cloud-native tooling and configurations.
• Support and lead database workload migrations from on-premises SQL Server environments to Azure, following established migration methodologies and best practices.
• Leverage Azure tools including Azure Portal, Azure Data Studio, Azure Monitor, and Log Analytics to manage and optimize cloud database environments.
• Implement cloud security controls including Transparent Data Encryption (TDE), Advanced Threat Protection (ATP), and Azure RBAC to protect sensitive data in cloud environments.
• Collaborate with Architecture to evaluate and recommend Azure database service tiers, sizing, and configurations appropriate to workload requirements.
• Architecture Collaboration & Version Management
• Partner with the Architecture team to evaluate SQL Server version upgrade paths, assess feature adoption opportunities, and develop migration roadmaps from SQL Server 2019 to 2025.
• Contribute to the definition and enforcement of database standards, naming conventions, and best practices across the enterprise.
• Assess database architectures for new and existing projects, providing technical guidance on design, performance, scalability, and availability requirements.
• Conduct cost-benefit analysis of infrastructure options and present recommendations to technical and business stakeholders.
• Documentation, Automation & Operational Excellence
• Develop and maintain T-SQL and PowerShell scripts to automate routine DBA tasks including health checks, maintenance jobs, alerting, and reporting.
• Create and maintain accurate, up-to-date documentation

Benefits

Additional Information

Central 1 cooperatively empowers credit unions and other financial institutions to deliver banking choice to Canadians. Central 1 provides critical services at scale to enable a thriving credit union system. We do this by collaborating with our clients, developing strategies, products and services to support the financial well-being of their more than 5 million diverse customers in communities across Canada. For more information, visit www.central1.com . Job Summary: Central 1 is seeking an experienced Database Administrator (Production/Systems DBA) to join our Data Engineering team on a 6‑month term. . This is a production-centric role focused on ensuring the stability, performance, security, and high availability of our enterprise Microsoft SQL Server environments. You will serve as a key technical expert responsible for managing mission-critical databases that underpin Central 1's payment and financial services platforms, supporting a SQL Server 2019 environment with an active migration path to SQL Server 2025 and continued expansion into Microsoft Azure. This role requires deep expertise in enterprise SQL Server administration, multi-region clustering and Always On Availability Groups, query performance tuning, and cloud infrastructure on Microsoft Azure. You will collaborate closely with Architecture, Development, and Operations teams to drive modernization, support version upgrade planning, and ensure robust 24/7 production support across our database estate.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at central1resources? Share your experience