MS SQL Database Administrator

  • Location: Toronto, Ontario
  • Type: Contract
  • Job #3839

JOB DESCRIPTION

Location: Hybrid (Downtown, Toronto)
Duration: Until October 31, 2024

Our client, a leading financial institution in Downtown Toronto is looking for a MS SQL Database Administrator to support the MS SQL Server on-premises as well as on public cloud and will assist in the team effort to maximize the availability, security, and performance of the databases. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

Typical Day in 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
  • 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
  • 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

Must-Have Skills:

  • 8 to 10+ years of progressive technical working experience as a Database Administrator
  • 5+ years of experience working with MSSQL Server 2022/2019/2017 and prior versions DB Administration
  • Experience with GCP Cloud SQL(MSSQL) and Azure MI/DBaaS/IaaS database administration
  • Experience with AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity
  • Experience in Logical & Physical Backup/Recovery/Compression techniques
  • Experience with 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 Required:

  • Good analytical, problem solving, trouble shooting and automation skills
  • Quick learner, with good interpersonal and communication (verbal/written) skills

Education:

  • Post-secondary education in Computer Science, Math, or related discipline

Finance professional is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. We advocate for you and welcome anyone regardless of race, color, religion, national origin, sex, physical or mental disability, or age.