Jobs
>
Toronto

    SQL Server DBA - Toronto, Canada - Sun Life

    Sun Life
    Default job background
    Temps plein
    Description

    Description

    de poste:

    About the role

    The candidate will be a member of the SQL Server Client team within Data Management Services (DMS). The primary role on the team will be a SQL Server Database Administrator supporting both client and internal DMS initiatives. This role could require training on various emerging technologies, PEGA, Cloud technologies, DevOps tools and processes, and vendor applications.

    This role requires Canadian Enhanced Reliability Security clearance [a minimum of 5 years of consecutive residency in Canada] and Star Compliance.

    What will you do?

  • Support database workload in AWS Cloud and SQL expertise as a shared resource to Agile projects
  • Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of difficult SQL issues
  • Administrative support of SQL Server versions 2012, 2014, 2016, 2019 including: Database Engine, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
  • Provide support of application and database upgrades from existing SQL versions to SQL2016, SQL2019 and future supported releases
  • Migration of database objects from development through production following documented standards, policies and procedures (Change Management Process)
  • Participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
  • Support of PowerShell, T-SQL stored procedures and functions to support internal processes and improve system performance (if applicable)
  • What you need to succeed?:

  • BE/B Tech/MCA/M Tech/Proven administration/analyst skills preferably with a degree in Computer Science or related technology degree/diploma, or equivalent experience
  • 3+ years of SQL Server database administration experience handling medium to large databases
  • Manage medium to large projects and participate in a variety of projects through the entire project lifecycle (if applicable)
  • Experience with AWS Cloud technologies
  • Experience with the Microsoft BI stack
  • Strong T-SQL skills that include a thorough understanding of system tables, stored procedures, functions, triggers, and SQL tuning
  • Hands-on experience with SQL Server installations and patching
  • SQL Server Certification (optional)
  • Maintain up-to-date documentation and procedures for all supported applications and environments
  • Preferred Skills

  • Excellent communication skills and experience in assisting clients with various issues related to connectivity, permissions and access
  • Analytical and problem solving skills with a keen attention to detail and the ability to consistently produce high-quality deliverables
  • Strong organizational skills and monitoring skills with the ability to handle several tasks efficiently and escalate to manager when issues arise
  • Ability to work and lead projects with minimal direction and to successfully juggle multiple tasks and priorities simultaneously
  • Good judgement in knowing when to escalate issues including seeking guidance when managing competing priorities and peak workload situations
  • Work closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services
  • Ability to evaluate functionality and features with newer versions of the SQL Server DBMS as part of a readiness program
  • What's in it for you:

  • Joining an organization that the industry calls 'one of the best places to work
  • Being part of our journey in developing the next greatest digital experience
  • Wellness programs that support the three pillars of your health – mental, physical and financial
  • An extensive support system for continual learning including company-run courses, access to online learning platforms, opportunity for rotations and cross training and more
  • A flexible work schedule within core business working hours
  • L'échelle du salaire de base est pour l'emplacement principal du poste affiché. Elle peut varier selon l'emplacement du candidat sélectionné et d'autres facteurs. En plus du salaire de base, les employés admissibles de la Financière Sun Life participent à différents programmes de rémunération incitative, dont le montant octroyé est discrétionnaire et dépend du rendement de l'employé et de la compagnie. Certains postes de vente participent à des programmes de rémunération incitative basés sur les résultats de vente individuels ou de groupe.

    Depuis toujours, la diversité et l'intégration sont au cœur des valeurs de la Financière Sun Life. Nous croyons qu'un effectif diversifié ayant des points de vue variés et des idées créatives est avantageux pour nos clients, pour les collectivités où nous exerçons nos activités, ainsi que pour nous tous, en tant que collègues. Nous accueillons avec enthousiasme les candidatures de personnes compétentes provenant de tous les horizons.

    Les personnes handicapées ayant besoin de mesures d'adaptation pour présenter leur candidature et celles qui doivent consulter les offres d'emploi sur un support de substitution peuvent envoyer leur demande par courriel à l'adresse ''.

    À la Sun Life, nous voulons créer un environnement de travail flexible où nos employés sont outillés pour donner le meilleur d'eux-mêmes. Nous offrons plusieurs options de travail flexibles selon les exigences du poste et les besoins individuels. N'hésitez pas à en discuter pendant le processus de sélection.

    Nous remercions tous les candidats de l'intérêt manifesté pour ce poste. Nous ne communiquerons qu'avec les personnes qui auront été retenues pour passer une entrevue.

    Échelle salariale:

    61,000/ ,000/101 000

    Catégorie d'emploi :

    Services technologiques - TI

    Fin de l'affichage :

    12/05/2024

  • BMO Financial Group

    SQL Server Dba

    2 weeks ago


    BMO Financial Group Toronto, Canada

    4100 Gordon Baker Road Toronto Ontario,M1W 3E8 · Develops and implements IT infrastructure & platform strategies for BMO. Develops strategic technology based on technical and business needs to support anticipated business strategies and organizational growth. Designs, builds / in ...

  • Dawn InfoTek Inc.

    SQL Server Dba

    3 days ago


    Dawn InfoTek Inc. North York, Canada

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. · We a ...


  • S I Systems Toronto, ON, Canada

    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 premis ...


  • Altis Technology Greater Toronto Area, Canada

    Senior SQL Server Database Administrator & Integration Specialist · We're assisting our legal industry client with the search for a Senior SQL Server Database Administrator and Integration Specialist who will join their team on a permanent full-time basis. · Location: Hybrid work ...


  • Jolera Inc. Toronto, Canada

    **Who We Are**: · Jolera offers MSPs & IT solution providers next-generation managed services, enabling them to create world-class experiences for their clients. Your clients receive award-winning solutions built on over 20 years of experience servicing businesses worldwide. We'v ...

  • Atlantis IT group

    Oracle Dba

    1 week ago


    Atlantis IT group Toronto, Canada

    **Oracle DBA** · **Toronto,ON** · **Long Term** · **Responsibilities**: · DBA with work experience in Oracle 11g ,12c and 18c, 19C · Proficient in managing databases in various platforms. Support activities ranging from initial database architecture design through implementation, ...


  • Compest Solutions Inc Toronto, Canada

    12+ years experience working with SQL Server in production environments (at least 3 of those years must be with SQL Server 2017 and higher) \u2525 · - 5+ years must be with high-transaction OLTP instances running 50k batch requests/sec · - Expert knowledge of SQL Server Availabil ...

  • Atlantis IT group

    Oracle Dba

    1 week ago


    Atlantis IT group Toronto, Canada

    **Skills**: · DBA with work experience in Oracle 11g ,12c and 18c, 19C · Proficient in managing databases in various platforms. Support activities ranging from initial database architecture design through implementation, administration, monitoring, tuning, backup and migration. D ...


  • Compest Solutions Inc Toronto, Canada

    **Job title**: Database Administrator · **Location**:Toronto, ON (On-site) · **Max Rate CAD$39/hr on T4** · **Job summary** · **Required Skills**: · **1.SQL DBA Administration** · **2.PostgreSQL DB Administration** · **3. Mongo DB Administration** · Experience: 10 Years · - Exper ...


  • Luxoft Toronto, Canada

    **Project** Description**: · One of our clients · - Canadian Bank is looking for a strong Sybase DBA · **Responsibilities**: · - Maintain current Sybase infrastructure · - Improve Database security posture · - Optimize Database performance · - Implement best practices for Databas ...

  • Compugen Inc

    SQL Dba

    1 week ago


    Compugen Inc Toronto, Canada

    Compugen is one of Canada's largest privately-owned Information Technology (IT) Solution Providers. We help customers design, acquire, integrate and operate technology. Our mission is to help organizations realize new possibilities. Every day, our dedicated staff across North Ame ...


  • Breakdown Services, Ltd. Toronto, Canada

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. ...


  • Breakdown Services, Ltd. Toronto, Canada

    **Internet Development Services,** a subsidiary of **Breakdown Services Ltd**, is seeking an experienced **SQL Database Administrator **to design, implement and maintain the database infrastructure (servers, clusters etc.) behind several high traffic, high availability web sites. ...


  • 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 ...

  • I20 Technologies

    Oracle Dba-remote

    2 weeks ago


    I20 Technologies Toronto, Canada

    Provide DBA operational support with a high degree of customer service, technical expertise, and timeliness. · - Ensuring assigned Oracle Databases are well tuned and requires in-depth working knowledge of Oracle Performance Tuning tools and strong analytical skills. · - Engage w ...


  • Raise Toronto, Canada

    Our Banking client in **Toronto,** is looking to hire a **Finance - Reporting Analyst - Proficient **for an 8** -months contract** · **Position Summary**: · Act as SME and interface between the tools and resources to provide business intelligence and insight. · **Must-have** · - ...

  • Iron Systems

    Dai

    2 weeks ago


    Iron Systems Toronto, Canada

    **Date Posted**: · - 7/14/2023 · **Job Function**: · - Software Development · **Location**: · - Toronto ON - CAN · **Offered Salary**: · - Competitive · Iron Systems is an innovative, customer-focused provider of custom-built computing infrastructure platforms such as network ser ...


  • NTT DATA Toronto, Canada

    **Req ID**: 279188 · We are currently seeking a **Microstrategy Administrator with AWS (Remote)** to join our team in **Ontario (CA-ON)**, **Canada (CA)**. · **Basic Qualifications**: · - Total Experience of 10+ years in Microstrategy · - At least **4 years** of experience in **B ...


  • iPartner Staffing Toronto, Canada

    Role: Database Administrator - Senior · Location: Toronto, ON · Contract · **Must-haves**: · - More than 10 yrs Oracle DBA experience · - Approved experience of Oracle 12c AND 19c using multi-tenant architecture · - Oracle 12c and 19c RAC - Grid infrastructure/ASM · - RMAN backup ...


  • OMERS Toronto, Canada

    Why join us? · Are you looking to join a dynamic pension plan that embodies the strong values of its 500,000 members and is an industry leading global investor? If so, we would love to tell you our story. · At OMERS we put our people first and are proud to embrace the diversity o ...