SQL Server DBA

Job Description

SQL Server DBA:
On behalf of our Banking client, Procom is searching for a SQL Server DBA for a 3-month role. This position is a hybrid position with 2 days onsite at our client’s Toronto office.

SQL Server DBA - Job Description:
The SQL Server DBA will support the MS SQL Server on-premises as well as on public cloud environments. As part of the Global Technology and Enterprise Platform (GTEP) Database operations team, the role focuses on maximizing database availability, security, and performance.

SQL Server DBA - Responsibilities:
• Configuration planning & deploying MSSQL servers on public cloud and on-premise servers.
• Performance tuning, capacity planning, and monitoring.
• Database maintenance/housekeeping including database rebuilds/re-indexing/expansion and archiving.
• Troubleshoot MSSQL server problems and assist in the resolution of application problems.
• MSSQL Server Software currency resolution including Patching/Upgrades/Migrations.
• Assist in database code promotions & data fixes following internal change control process.
• Disaster Recovery/High Availability (DR/HA) support with backup, recovery, and failover/failback of local and remote replicated databases.
• Provide DBA support to development/implementation projects as assigned, including installations, database loading, migrations, testing, and go-live support.

SQL Server DBA - Mandatory Skills:
• 8-10+ years of progressive technical working experience as a Database Administrator.
• 5+ years of experience with Public Cloud including GCP Cloud SQL (MSSQL) and Azure MI/DBaaS/IaaS database administration.
• Hands-on experience with MSSQL Services (SSRS/SSAS/SSIS/PolyBase, R Service, Power BI etc.) and MSSQL Instance/Database Installation/Configuration/Hardening.
• Hands-on experience with MSSQL Servers 2022/2019/2017, Database Security, HA/DR, Performance & Tuning, Database Backup, and prior versions DB Administration.
• Hands-on experience with Scripting and Automation with Power Shell, C#, VB Scripts, SSIS, TSQL etc.

SQL Server DBA – Nice-to-Have Skills:
• Microsoft and/or Google Data Platform certification.
• Windows Servers 2019/2016 and prior versions.
• AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity.
• Application side tuning vs. server-side tuning.
• Setup MSSQL Always-On, Availability groups & Database Replication.

SQL Server DBA – Assignment Length:
This is a contract position until October 31st, with the possibility of extension and conversion to full-time employment.

SQL Server DBA - Start Date:
ASAP.

SQL Server DBA - Assignment Location:
Toronto, Ontario, Canada. Hybrid work arrangement with 2 days in the office per week.

This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.