SQL Server Dba

1 month ago

Waterloo, Canada Sun Life Full time

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

**About the role**

**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)
- 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)

**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 mínimal 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
- 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

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work. Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

**Salary Range**:
61,000/61 000 - 101,000/101 000

**Job Category**:
IT - Technology Services

**Posting End Date**:
12/05/2024

  • SQL Database Administrator(Intermediate Experienced)

    5 hours ago

    Waterloo, Canada opentext Full time

    **OPENTEXT - THE INFORMATION COMPANY** As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management. **The Opportunity**: As a Database Administrator, you will: - Assure proactive monitoring,...

  • SQL Data Analyst

    2 weeks ago

    Waterloo, Canada Descartes Full time

    **Descartes Unites the People and Technology that Move the World** The need for efficient, secure, and agile supply chains and logistics operations has become ever more critical and complex. By combining innovative technology, powerful trade intelligence and the reach of our network, Descartes helps get goods, information, transportation assets, and people...

  • Server Administrator

    2 days ago

    Waterloo, Canada KPMG-Canada Full time

    **Overview** At KPMG, you'll join a team of diverse and dedicated problem solvers, connected by a common cause: turning insight into opportunity for clients and communities around the world. **The Opportunity** The Server Administrator is a key technical resource responsible for management of various server infrastructure technologies on all KPMG...

  • Database Administrator

    1 month ago

    Waterloo, Canada Descartes Full time

    **Descartes Unites the People and Technology that Move the World** The need for efficient, secure, and agile supply chains and logistics operations has become ever more critical and complex. By combining innovative technology, powerful trade intelligence and the reach of our network, Descartes helps get goods, information, transportation assets, and people...

  • Network Administrator and Infrastructure Analyst

    1 month ago

    Waterloo, Canada City of Waterloo Full time

    **Position Description**: The Network Administrator and Infrastructure Analyst is responsible for maintenance and support of the City’s Systems, Networks, Telecommunications and Security infrastructures. **Accountabilities**: - Build, configure, deploy and maintain servers in physical and virtual environments (vmware) to ensure connectivity and high...

  • Senior Technology Specialist, Data Developer

    3 weeks ago

    Waterloo, Canada Equitable Life of Canada Full time

    Senior Technology Specialist, Data Developer Waterloo, ON, Canada Req #2203 Thursday, April 4, 2024 At Equitable, we realize that your work life is not just about performing a job; it's about being part of a workplace that helps you grow and reach your full potential. Within our friendly and collaborative work environment, we recognize that the key to...

  • Senior Technology Specialist, Data Developer

    4 days ago

    Waterloo, Canada Equitable Life of Canada Full time

    Senior Technology Specialist, Data Developer Waterloo, ON, Canada Req #2203 Thursday, April 4, 2024 At Equitable, we realize that your work life is not just about performing a job; it's about being part of a workplace that helps you grow and reach your full potential. Within our friendly and collaborative work environment, we recognize that the key to...

  • Manager, Database

    4 hours ago

    Waterloo, Canada Erb Fischer Veterinary Corporation Full time

    Education: Master's degree - Experience: 5 years or more **Work setting**: - Veterinary clinic **Tasks**: - Collect and document user's requirements - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards...

  • Senior Software Developer

    1 month ago

    Waterloo, Canada University of Waterloo Full time

    Overview Term - 2 Years The Senior Software Developer is responsible for providing a range of software development and technical services to support the Office of Advancement, the broader campus advancement community, and the broader global advancement alumni and donor constituency. The primary focus of the role will be to provide software design...

  • Senior Software Developer

    4 days ago

    Waterloo, Canada University of Waterloo Full time

    Overview Term - 2 Years The Senior Software Developer is responsible for providing a range of software development and technical services to support the Office of Advancement, the broader campus advancement community, and the broader global advancement alumni and donor constituency. The primary focus of the role will be to provide software design...

  • Manager, Database

    3 weeks ago

    Waterloo, Canada Erb Fischer Veterinary Corporation Full time

    Work Term: Permanent - Work Language: English - Hours: 35 hours per week - Education: Master's degree - Experience: 5 years or more **Work setting**: - Veterinary clinic **Tasks**: - Collect and document user's requirements - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to...

  • IT Helpdesk Support

    2 months ago

    Waterloo, Canada Accelerated Systems Inc. Full time

    **IT Helpdesk Support - Part Time** We are currently seeking a part time IT Helpdesk support person. You must be available Monday-Friday (days) on site in our Waterloo office and be able to travel between two locations (close in proximity). This position is ideal for a college or university student in a related program seeking permanent part time work, with...

  • IT Helpdesk Support

    3 days ago

    Waterloo, Canada Accelerated Systems Inc. Full time

    **IT Helpdesk Support - Part Time** We are currently seeking a part time IT Helpdesk support person. You must be available Monday-Friday (days) on site in our Waterloo office and be able to travel between two locations (close in proximity). This position is ideal for a college or university student in a related program seeking permanent part time work, with...

  • Full Time Manager, Business Intelligence

    4 weeks ago

    Waterloo, Canada UNAVAILABLE Full time

    Job Description CARE AND BE CARED FOR - THIS IS YOUR HOME Reporting to the Director, Business Intelligence & Analytics, this position provides leadership in the development and implementation of business intelligence strategies and operations.  The Manager, Business Intelligence leads a team of professionals in the development and implementation of...

  • Full Time Manager, Business Intelligence

    4 weeks ago

    Waterloo, Canada UNAVAILABLE Full time

    Job Description CARE AND BE CARED FOR - THIS IS YOUR HOME Reporting to the Director, Business Intelligence & Analytics, this position provides leadership in the development and implementation of business intelligence strategies and operations.  The Manager, Business Intelligence leads a team of professionals in the development and implementation of...

  • Full Time Manager, Business Intelligence

    4 weeks ago

    Waterloo, Canada UNAVAILABLE Full time

    Job Description CARE AND BE CARED FOR - THIS IS YOUR HOME Reporting to the Director, Business Intelligence & Analytics, this position provides leadership in the development and implementation of business intelligence strategies and operations.  The Manager, Business Intelligence leads a team of professionals in the development and implementation of...

  • 790465 - Early-career Environmental Data Technician

    2 months ago

    Waterloo, Canada Geosyntec Consultants Full time

    If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you! We are seeking an **Early-Career Environmental Data Technician** to work with our team of consulting scientists and engineers in...

  • 790465 - Early-career Environmental Data Technician

    2 days ago

    Waterloo, Canada Geosyntec Consultants Full time

    If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you! We are seeking an **Early-Career Environmental Data Technician** to work with our team of consulting scientists and engineers in...

  • 790440 - Early-career Environmental Data Specialist

    2 months ago

    Waterloo, Canada Geosyntec Consultants Full time

    If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you! We are seeking an **Early-Career Environmental Data Specialist** to work with our team of consulting scientists and engineers in...

  • 790440 - Early-career Environmental Data Specialist

    2 days ago

    Waterloo, Canada Geosyntec Consultants Full time

    If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you! We are seeking an **Early-Career Environmental Data Specialist** to work with our team of consulting scientists and engineers in...