Jobs
>
Toronto

    Senior SQL Server DBA to maximize availability, performance and security of the on premise data - Toronto, ON, Canada - S I Systems

    S I Systems
    S I Systems Toronto, ON, Canada

    3 weeks ago

    Default job background
    Description

    Senior SQL Server DBA to maximize availability, performance and security of the on premise database as well as public cloud (GCP/MS SQL/Azure) with one of our major banking clients- BNSJP

    Senior SQL Server DBA to maximize availability, performance and security of the on premise database as well as public cloud (GCP/MS SQL/Azure) with one of our major banking clients- BNSJP

    Location Address: Hybrid (as required for meetings, within 2 day notice) – Toronto

    Contract Duration: 12 months (High Chance of Extension)

    Scheduled Hours: 37.5 Hours Per Week

    Story Behind the Need:

    • Bank's Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data platform products across the globe where Scotiabank is present. Physical & logical database services, from deployment, project support and after go live steady state support is the essence of what we do.
    • Reporting to the DBA Manager/Lead, the Database Administrator would be supporting the MS SQL Server on-premises as well as on public cloud. As a member of the database administration group, you will assist in the team effort to maximize the availability, security, and performance of the databases.

    Must-Have skills:

    • 8-10+ years of progressive technical working experience as a Database Administrator.
    • 5+ years of experience with Public Cloud including GCP Cloud SQL (MSSQL) and Azure MI/DBaaS/IaaS database administration.
    • Hands on experience with MSSQL Services (SSRS/SSAS/SSIS/PolyBase, R Service, Power BI etc.) and MSSQL Instance/Database Installation/Configuration/Hardening.
    • Hands on experience with MSSQL Servers 2022/2019/2017, Database Security, HA/DR, Performance & Tuning, Database Backup, and prior versions DB Administration.
    • Hands on experience with Scripting and Automation with Power Shell, C#, VB Scripts, SSIS, TSQL etc .

    Nice-To-Have Skills:

    • Microsoft and/or Google Data Platform certification.
    • Windows Servers 2019/2016 and prior versions.
    • AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity.
    • Setup MSSQL Always-On, Availability groups & Database Replication.
    • Logical & Physical Backup/Recovery/Compression techniques.

    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

    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.
    • One round interview – Hiring manager & team member (1 hour)
    • 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
  • Red Bull

    On Premise Trade Marketing Manager

    2 weeks ago

    Red Bull Toronto, Canada

    Bachelor's degree in marketing & sales or economical background · - Fluent in English, bilingual in French a strong assetRed Bull Canada is committed to treating all people in a way that allows them to maintain their dignity and independence. We believe in integration and equal o ...

  • CT Corporation

    Intelligent Automation Manager

    1 week ago

    CT Corporation Toronto, Canada

    **What you'll do** · - Deliver solutions and products in collaboration with the Program Manager and other managers. Own your team's products, end-to-end, from ideation to launch. · - Facilitate solution ideation and requirements gathering sessions with diverse stakeholder groups. ...

  • Red Bull

    Intern, On Premise Marketing

    3 weeks ago

    Red Bull Toronto, Canada

    **Company Description**: · Red Bull is looking for top-performing college students to work with our Sales and Marketing teams From day one, you'll have the opportunity to take ownership of tasks, support projects and contribute based on your strengths and passions. The On Premise ...

  • TD Bank

    Business Management Analyst Iii

    3 weeks ago

    TD Bank Toronto, Canada

    400479BR · Technology Solutions · Toronto, ON · March 14, 2023 · Company Overview · Department Overview · The Transformation, Enablement, and Customer Experience (TECE), Central Services team offers · business management support to TECE businesses including communications, premis ...

  • Red Bull

    Category Development Manager

    3 weeks ago

    Red Bull Toronto, Canada

    University - Bachelor's Degree · - Fluent in English · - Permanent, Full-time · Our goal is to be Energy Category experts and the only reasonable choice when deciding on an Energy Category partner. The Category Development Manager (CDM) will be playing an integral role in buildin ...

  • Southern Glazer's Wine and Spirits

    Manager, National Accounts

    2 weeks ago

    Southern Glazer's Wine and Spirits Toronto, Canada

    **What You Need To Know**: · Open your future to incredible career potential. Work for an industry leader who invests in their people. Southern Glazer's Wine & Spirits is North America's preeminent wine and spirits distributor, as well as a family-owned, privately held company wi ...

  • Red Bull

    Category Development Manager

    2 weeks ago

    Red Bull Toronto, Canada

    University - Bachelor's Degree · - Fluent in EnglishRed Bull Canada is committed to treating all people in a way that allows them to maintain their dignity and independence. We believe in integration and equal opportunity. Accommodations are available throughout the recruitment p ...

  • University of Toronto

    Sessional Lecturer, Inf2190h

    2 weeks ago

    University of Toronto Toronto, Canada

    **University of Toronto** · **Faculty of Information** · Sessional Lecturer · **Fall Term 2023 (September - December)** · **INF2190H - Data Analytics: Introduction, Methods and Practical Approaches** · **Course Description**:The influx of data that is created, gathered, stored an ...

  • Mark Anthony Group Inc. - Canada

    On-premise Account Manager

    3 weeks ago

    Mark Anthony Group Inc. - Canada Toronto, Canada

    Mark Anthony Group is the leading family-owned company in the Canadian Beverage Alcohol Industry with three distinct sales organizations in Canada each representing a unique portfolio of wine, spirits, and ready to drink beverages. At Mark Anthony, we are innovators and disruptor ...

  • Mark Anthony Group Inc. - Canada

    On-premise Account Manager

    2 weeks ago

    Mark Anthony Group Inc. - Canada Toronto, Canada

    Mark Anthony Group is the leading family-owned company in the Canadian Beverage Alcohol Industry with three distinct sales organizations in Canada each representing a unique portfolio of wine, spirits, and ready to drink beverages. At Mark Anthony, we are innovators and disruptor ...

  • Atlantis IT group

    Data Security Encryption Lead

    3 weeks ago

    Atlantis IT group Toronto, Canada

    Feel free to call on ASAP if you have any questions regarding this position. I will be more than happy to assist you further. · **Job description** · 6+ years of Hands-on experience in Data Discovery & Classification, Cryptography, Hardware Security Management, PKI, Key Managemen ...

  • City of Toronto

    Corporate Application Technical Leader

    3 weeks ago

    City of Toronto Toronto, Canada

    **Job ID**: 43632 · **Job Category**:Information & Technology · **Division & Section**:Technology Services, Technology Standardization Delivery · **Work Location**:Metro Hall, 55 John Street, Toronto, ON · **Job Type & Duration**:Full-time, Temporary Vacancy, 12 months · **Hourly ...

  • LifeWorks

    Student Survey Analyst

    1 week ago

    LifeWorks Toronto, Canada

    Build a meaningful career · At LifeWorks, we offer more than career opportunities, we provide career opportunities to make meaningful contributions to people's lives. The extraordinary expertise of a more than 7,000-strong workforce is harnessed to support the employees and famil ...

  • LifeWorks

    Finance Administrator, Vendor Forms

    2 weeks ago

    LifeWorks Toronto, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...

  • LifeWorks

    Human Resources Coordinator

    1 week ago

    LifeWorks Toronto, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...

  • LifeWorks

    Rebranding: Finance Administrator, Vendor Forms

    2 weeks ago

    LifeWorks Toronto, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...

  • Chipotle

    Restaurant Design Manager

    2 weeks ago

    Chipotle Toronto, Canada

    Restaurant Design Manager · Description · **CULTIVATING A BETTER WORLD** · Food served fast does not have to be a typical fast-food experience. Chipotle has always done things differently, both in and out of our restaurants. We are changing the face of fast food, starting conver ...

  • LifeWorks

    Jr. Salesforce Administrator

    3 weeks ago

    LifeWorks Toronto, Canada

    Build a meaningful career · At LifeWorks, we offer more than career opportunities, we provide career opportunities to make meaningful contributions to people's lives. The extraordinary expertise of a more than 7,000-strong workforce is harnessed to support the employees and famil ...

  • Scotiabank

    Database Analyst Advisory,

    1 week ago

    Scotiabank Toronto, Canada

    Requisition ID: 196092 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · Scotiabank's Global Technology and Enterprise Platform (GTEP) Database operations (MSSQL) team takes care of end-to-end support for Microsoft data pla ...

  • LifeWorks

    Actuarial Analyst

    2 weeks ago

    LifeWorks Toronto, Canada

    TELUS Health and LifeWorks have recently come together to leverage the power of technology and our caring cultures to further progress our shared goal of building a healthier and friendlier future for all. As a global-leading health and well-being provider - encompassing physical ...