27 Aug
|
BITS Recruiting
|
Toronto
27 Aug
BITS Recruiting
Toronto
Senior Database Administrator (DBA)
Start Date: September 2, 2026
End Date: September 2, 2027
Location: Jarvis St., Toronto
Work Arrangement: 100% onsite, 5 days/week
Hours: 7.25 hours/day, Monday–Friday, between 8:00 a.m.–5:00 p.m.
Security: CRJMC
Incorp Rate: $75-$82.20/hr
Position Summary
The Senior Database Administrator will provide operational support, administration, maintenance, monitoring, security, troubleshooting, and performance optimization for enterprise database environments supporting critical applications.
The DBA will work across Microsoft SQL Server, IBM DB2, and Oracle environments and collaborate with application, infrastructure, development, architecture, vendor, and project teams to ensure database availability, security, integrity, recoverability, and performance.
Must Have
- Robust hands-on SQL Server administration experience with SQL Server 2019, 2022, and 2025.
- Hands-on experience with at least one of:
- Oracle 19c
- IBM DB2 for Windows
- IBM DB2 for z/OS
- Experience designing and implementing REST API integrations, including integration patterns, authentication, error handling, security, and best practices.
- Experience supporting enterprise/production database environments.
- Ability to work 5 days onsite at either the Toronto or Oshawa location.
Nice to Have
- Strong database performance tuning experience, including queries, indexes, execution plans, and server performance.
- Experience with backup, recovery, HA/DR, clustering, failover, and replication.
- Experience with SQL Server Always On Availability Groups.
- Experience supporting Oracle and/or DB2 in addition to SQL Server.
- Experience in large-scale government or enterprise environments.
Key Responsibilities
Database Administration & Operations
- Provide day-to-day operational support for production, development, test, and DR database environments.
- Install, configure, patch, upgrade, migrate, refresh, and maintain databases.
- Monitor database health, availability, capacity, storage, and performance.
- Troubleshoot and resolve database incidents and service requests.
- Manage database users, roles, permissions, security, and access controls.
Performance & Availability
- Analyze and optimize SQL queries, indexes, execution plans, and database resources.
- Identify and resolve database and application performance bottlenecks.
- Support high-availability and disaster-recovery environments.
- Develop and maintain backup and recovery procedures.
Integration & Modernization
- Support REST API and application/database integrations.
- Collaborate with developers and architects on database and integration solutions.
- Support database migrations, modernization, upgrades, and technology lifecycle initiatives.
- Assist with cloud, virtualization, and hybrid infrastructure initiatives.
Change & Production Support
- Support database changes, deployments, releases, and maintenance activities.
- Participate in incident management, root-cause analysis, and post-incident reviews.
- Follow Ministry/OPS standards, change-management processes, and ITIL practices.
- Maintain technical documentation, procedures, runbooks, and knowledge articles.
Technology Environment
SQL Server: 2019, 2022, 2025, Windows Server, Clustering, Failover, Always On
DB2: DB2 v13/zOS, DB2 Windows, DB2 RHEL/Linux
Oracle: Oracle 11g/19c, Multitenant, Oracle Enterprise Manager, RHEL/Linux
Integration: REST APIs, enterprise application integrations, database migration, HA/DR
📌 Senior Database Administrator - BITS Recruiting (Toronto)
🏢 BITS Recruiting
📍 Toronto