Senior Database Administrator (DBA)

vTech Solution Canada

Toronto

On-site

CAD 110,000 - 140,000

Full time

3 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

vTech Solution Canada is seeking a Senior Database Administrator to provide operational support, administration, maintenance, monitoring, and optimization of enterprise environments across SQL Server, IBM DB2, and Oracle.

You will ensure availability, performance, security, integrity, and recoverability for mission-critical applications while collaborating with infrastructure, development, and vendor teams.

Qualifications

Must-have hands-on experience with SQL Server 2019, 2022, and 2025.
Must-have experience with SQL Server Failover Clustering.
Deep expertise in Always On Availability Groups.
Strong understanding of Backup, Recovery and HA/DR strategies.
Experience performing SQL Server upgrades and migrations.
Experience designing and implementing REST API integrations.
Strong troubleshooting, problem-solving, and database performance tuning skills.
Experience with change management and release management processes.
Experience with IBM DB2 (Windows) or Oracle 19c administration.
Experience with DB2 for Windows.

Responsibilities

Provide day-to-day operational support for enterprise database environments.
Monitor database health, system availability, storage utilization, and performance.
Troubleshoot and resolve database incidents, service requests, and production issues.
Support production, development, testing, disaster recovery, and high-availability environments.
Participate in on-call support and after-hours maintenance activities as required.
Administer, maintain, patch, upgrade, and configure databases.
Manage backups, recovery, and disaster recovery processes.
Implement and maintain database security, permissions, roles, encryption, and compliance controls.
Conduct capacity planning and storage management activities.
Analyze and optimize database performance, queries, indexes, and execution plans.
Identify and resolve application and database performance bottlenecks.
Support clustering, failover, replication, and high-availability technologies.
Implement proactive monitoring and alerting solutions.
Support deployment, release management, and change management activities following ITIL best practices.
Maintain technical documentation, operational procedures, and knowledge articles.
Participate in technical reviews, root cause analysis, and post-incident investigations.
Support modernization, migration, and infrastructure upgrade projects.
Collaborate on database design and implementation strategies.
Assist with cloud, virtualization, and hybrid infrastructure initiatives.
Support technology lifecycle and upgrade planning activities.

Skills

SQL Server 2019-2025

SQL Server Failover Clustering

Always On Availability Groups

Backup & Recovery/HA-DR

SQL Server upgrades/migrations

REST API integrations

Troubleshooting/performance tuning

Change & release management

Oracle 19c

DB2 for Windows

Tools

Oracle Enterprise Manager (OEM)

Job description

About the Role

We are seeking an experienced Senior Database Administrator (DBA) to provide operational support, administration, maintenance, monitoring, and optimization of enterprise database environments supporting mission-critical applications and services.

The ideal candidate will be responsible for ensuring database availability, performance, security, integrity, and recoverability across multiple database platforms, including Microsoft SQL Server, IBM DB2, and Oracle environments. This role requires close collaboration with infrastructure teams, application support teams, developers, architects, vendors, and project stakeholders to support both legacy and modernized enterprise systems.

In addition to database administration responsibilities, the successful candidate will contribute to data architecture discussions, support data-driven decision-making, and help define key metrics and KPIs aligned with business objectives.

Key Responsibilities

Database Operations & Support

Provide day-to-day operational support for enterprise database environments.
Monitor database health, system availability, storage utilization, and performance.
Troubleshoot and resolve database incidents, service requests, and production issues.
Support production, development, testing, disaster recovery, and high-availability environments.
Participate in on-call support and after-hours maintenance activities as required.

Database Administration

Administer, maintain, patch, upgrade, and configure:

Microsoft SQL Server

Perform database installations, migrations, refreshes, cloning, and environment setup.
Manage backup, recovery, and disaster recovery processes.
Implement and maintain database security, permissions, roles, encryption, and compliance controls.
Conduct capacity planning and storage management activities.

Performance Optimization

Analyze and optimize database performance, queries, indexes, and execution plans.
Identify and resolve application and database performance bottlenecks.
Support clustering, failover, replication, and high-availability technologies.
Implement proactive monitoring and alerting solutions.

Change & Release Management

Support deployment, release management, and change management activities following ITIL best practices.
Maintain technical documentation, operational procedures, and knowledge articles.
Participate in technical reviews, root cause analysis, and post-incident investigations.

Project & Modernization Initiatives