Job Description

Location Address: Toronto, ON (hybrid 2-3 days a week in office)
Contract Duration: currently until end of fiscal
Schedule Hours: 9am-5pmTypical 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.

#MON

LanceSoft