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.

J-18808-Ljbffr