Senior Database Administrator to support the MS SQL Server on-premises as well as on public cloud for one of our major banking clients - 34318

Senior Database Administrator to support the MS SQL Server on-premises as well as on public cloud for one of our major banking clients -

Hiring Manager : Manager Database Administration

Location Address : Hybrid (as required for meetings, within 2 day notice) 44 King Street W

Contract Duration : 12 months (possibility of extension and FTE)

Scheduled Hours : Monday to Friday, 9am-5pm

Story Behind the Need :

Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data platform products across the globe where the bank is present.

Physical & logical database services, from deployment, project support and after go live steady state support is the essence of what we do.

Reporting to the DBA Manager / Lead, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud.

As a member of the database administration group, you will assist in the team effort to maximize the availability, security, and performance of the databases.

Candidate Value Proposition :

The successful candidate will have the opportunity to work within the bank. We are technology partners who help the business transform how our employees around the world work.

You will get to work with and learn from diverse industry leaders, who have hailed from top technology.

Typical Day in Role :

• Configuration planning & deploying MSSQL servers on public cloud and on-premise servers.
• Performance tunning, capacity planning and monitoring.
• Database maintenance / housekeeping including database rebuilds / re-indexing / expansion and
• archiving.
• Trouble-shoot 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, doing installations, database loading, migrations, testing, and go live support etc.
• Follow Database best practices, security and change control process of the bank.

Candidate Requirements / Must-Have 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 / / , 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.

Nice-To-Have Skills :

• Microsoft and / or Google Data Platform certification.
• Windows Servers / 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.
• Logical & Physical Backup / Recovery / Compression techniques.

Best vs. Average Candidate : Previous experience working in FI with regulatory / compliance environment.

Education : Post-secondary education in Computer Science, Math, or related discipline.

Candidate Review & Selection :

• One round interview Hiring manager & team member (1 hour)
• 90% of the interview will be assessing technical skills listed in the must-have requirements such as Public Cloud, Database Security, etc.

and 10% will be assessing soft skills / team fit.