SQL Database Administrator

Location Address: Toronto (hybrid 2-3 days a week in office)

Contract Duration: currently until end of fiscal

Number of Positions: 1

Schedule Hours: 9am-5pm

Reason: Additional support required on the team



Typical Day in the Role:

• Collaborate with stakeholders across the Bank - technology, application security product, security advisory, fraud, compliance and business channel teams - to drive the product features and roadmap in application security domains like SAST, MAST, SCA, DAST etc across the Bank.

• Policies for SCA – Security Policies, Licensing Policies and Operational Policies

• Mobile App Publishing – coordinate with stakeholders to define the minimum-security requirements for publishing a Mobile app to the App Store (Google Play store, Apple etc)

• Continuously evolve app sec product features based on industry best practices and emerging security threats

• Govern and define DevOps pipeline and developer tooling use cases to integrate with enterprise app sec products

• Will work closely with multiple cross enterprise teams to gather requirements and the adoption of new security products.

• Implementation and operations governance based on the defined enterprise standard solution architecture and design patterns

• Co-ordinate efforts from business and technology teams.

• Communicate regularly with various business channels on the progress made for various projects in the pipeline





Must Have Skills/Requirements:

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:

1. 8-10+ years of progressive technical working experience as a Database Administrator.

2. 5+ years of experience working with MSSQL Server 2022/2019/2017 and prior versions DB Administration

3. GCP Cloud SQL(MSSQL) and Azure MI/DBaaS/IaaS database administration

4. AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity

5. - Logical & Physical Backup/Recovery/Compression techniques

6. MSSQL Services (SSRS/SSAS/SSIS/PolyBase, R Service, Power BI etc.)



Nice-To-Have Skills:

• Microsoft and/or Google Data Platform certification.

• Windows Servers 2019/2016 and prior versions.

• Application side tuning vs. server-side tuning.

• Setup MSSQL Always-On, Availability groups & Database Replication.



Soft Skills:

• You have good analytical, problem solving, trouble shooting and automation skills.

• You are a quick learner, with good interpersonal and communication (verbal/written) skills.



Best vs. Average Candidate:

• Must meet the must-have requirements.

• 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)

o 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.