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.