SQL Server Dba
1 week ago
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
-
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,...
-
Oracle Database Administrator(Intermediate
4 weeks 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
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...
-
Software Developer-.Net
3 weeks ago
Waterloo, Canada Descartes Systems Group Full timeDescartes 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...
-
Manager, Database
4 weeks ago
Waterloo, Canada Erb Fischer Veterinary Corporation Full timeEducation: 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 Technology Specialist, Data Developer
1 month ago
Waterloo, Canada Equitable Life of Canada Full timeSenior 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 Software Developer
1 month ago
Waterloo, Canada University of Waterloo Full timeOverview 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 timeWork 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
1 month 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...
-
Waterloo, Canada Geosyntec Consultants Full timeIf 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...
-
Principal Cloud Database Administrator
4 weeks 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**: We are looking for an experienced Cloud Database Administrator with...
-
Waterloo, Canada Geosyntec Consultants Full timeIf 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...
-
Waterloo, Canada Equitable Life of Canada Full timeAt 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 our growth and success is a dedicated, motivated and client-responsive staff. Join Equitable today. ...
-
Waterloo, Canada Equitable Life of Canada Full timeAt 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 our growth and success is a dedicated, motivated and client-responsive staff. Join Equitable today. ...
-
Waterloo, Canada Equitable Life of Canada Full timeSenior Technology Specialist, Enterprise Platforms (PeopleSoft Administrator) Waterloo, ON, Canada Req #2338 Wednesday, July 3, 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...
-
Data Operations Analyst
2 weeks ago
Waterloo, Canada Manulife Full timeWe are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and...
-
Waterloo, Canada Equitable Life of Canada Full timeSenior Technology Specialist, Enterprise Platforms Developer Waterloo, ON, Canada Req #2338 Wednesday, July 3, 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...
-
Manager, Technical Infrastructure
3 weeks ago
Waterloo, Canada University of Waterloo Full timeOverview: Reporting to the Director, IT, the position is responsible for the overall strategic management and leadership of a collection of systems within WUSA (Waterloo Undergraduate Student Association) and its subsidiaries. The manager has diverse computing experience of 50+ full-time user computers and over 150 user accounts for part-time staff and...
-
Waterloo, Canada Equitable Life of Canada Full timeAt 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 our growth and success is a dedicated, motivated and client-responsive staff. Join Equitable today. ...
-
Waterloo, Canada Equitable Life of Canada Full timeAt 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 our growth and success is a dedicated, motivated and client-responsive staff. Join Equitable today. ...
