Sr. Database Engineer

S&P Global, Inc.; Halifax; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Engineer III in Database Engineering to join their dynamic team. This role involves supporting and managing multi-terabyte database systems, ensuring optimal performance and reliability. You will automate tasks, manage software releases, and troubleshoot real-time issues while collaborating with various teams. The company values integrity and discovery, offering a supportive environment that encourages continuous learning and growth. If you are passionate about database technologies and eager to make a significant impact, this opportunity is perfect for you.

Benefits

Health care coverage

Generous time off

Access to learning resources

Retirement planning

Financial wellness programs

Family friendly perks

Retail discounts

Referral incentive awards

Qualifications

• 5+ years of hands-on database administration and performance tuning experience.
• Extensive experience in MS SQL Server and familiarity with AWS.

Responsibilities

• Support and manage multi-terabyte database systems with a focus on performance.
• Automate tasks to improve efficiency and manage database releases.

Skills

Database Administration

Performance Tuning

MS SQL Server

AWS

PowerShell

Communication Skills

Education

Bachelor's degree in Computer Science

Equivalent experience

Tools

NoSQL

SOLR

Vertica

PostgreSQL

Job description

About the Role:

Grade Level (for internal use): 10

The Team:

Data Services Engineering is a team in the CESS (Cloud Engineering & Shared Services) in the Market Intelligence division of S&P Global. The Data Services Engineering Team within CESS is designed to provide engineering, enablement, and operational support across data technologies. The team will drive strong capabilities and operational stability measures to ensure data technology health, performance, security, and cost optimized solutions to run in the cloud without the high overhead typically associated with data technology teams.

Responsibilities and Impact:

As an Engineer III / Database Engineering you will:

1. Support, administer, manage, and tune multi-terabyte database systems.
2. Ensure any data replication latency is investigated and resolved quickly.
3. Automate tasks to improve efficiency and quality of the team and infrastructure.
4. Manage periodic database/software releases for QA, Pre-Production, Production, and DR as part of the overall SDLC.
5. Deploy and maintain database instances including configuration enhancements, patches/hotfixes, database engine upgrades, hardware/storage migrations, etc.
6. Solve non-routine problems and use cost/benefit analysis to determine the best solution.
7. Troubleshoot database engine and query performance issues in real-time.
8. Work with IT Server Management and other groups and ensure that all issues, incidents, and problems are resolved in a timely manner.
9. Participate in and coordinate projects with other teams within Operations as well as other peer groups like Development and QA teams.
10. Leverage existing methods and procedures on new or special assignments.
11. Periodically review current processes and suggest improvements as new tools/methods are discovered.
12. Contribute to best-in-class product support resources including run books, tools, monitoring processes, and knowledge bases.
13. Support database backups/refreshes in non-prod environments.
14. Participate in weekly, Tier-3 Support on-call rotation.
15. Support cloud, virtualized, and on-prem database infrastructure.

What We’re Looking For:

Basic Required Qualifications:

1. Bachelor's degree in Computer Science, Information Systems, or Engineering or equivalent experience.
2. 5+ years of hands-on database administration, support, and performance tuning experience.
3. Must have extensive experience in MS SQL Server.
4. Some familiarity/experience with AWS.
5. Proficient in database support, administration, performance tuning, and database monitoring.
6. Experience with Transactional Replication and Log Shipping.
7. Basic knowledge of PowerShell (or other scripting/program language).
8. Excellent communication skills, with strong verbal and writing proficiencies.

Additional Preferred Qualifications:

1. Experience with additional RDMS like NoSQL, SOLR, Vertica, and PostgreSQL.
2. Understanding of Database Mirroring, Availability Groups, and Windows Clustering.
3. AWS Certified Solutions Architect.
4. Ability to troubleshoot problems involving Client Libraries (like ADO.NET), Operating Systems, Network and Storage.
5. Experience in a start-up, Agile, or Dev Ops environment.
6. ITIL V3 Foundation Certified.

Right to Work Requirements:

This role is limited to persons with indefinite right to work in Canada.

Return to Work:

Have you taken time out for caring responsibilities and are now looking to return to work? As part of our Return to Work initiative, Restart, we are encouraging enthusiastic and talented returners to apply, and will actively support your return to the workplace.

About S&P Global Market Intelligence:

At S&P Global Market Intelligence, a division of S&P Global we understand the importance of accurate, deep and insightful information. Our team of experts delivers unrivaled insights and leading data and technology solutions, partnering with customers to expand their perspective, operate with confidence, and make decisions with conviction.

What’s In It For You?

Our Purpose: Progress is not a self-starter. It requires a catalyst to be set in motion. Information, imagination, people, technology–the right combination can unlock possibility and change the world.

Our world is in transition and getting more complex by the day. We push past expected observations and seek out new levels of understanding so that we can help companies, governments, and individuals make an impact on tomorrow. At S&P Global we transform data into Essential Intelligence, pinpointing risks and opening possibilities. We Accelerate Progress.

Our People: We're more than 35,000 strong worldwide—so we're able to understand nuances while having a broad perspective. Our team is driven by curiosity and a shared belief that Essential Intelligence can help build a more prosperous future for us all.

Our Values: Integrity, Discovery, Partnership.

At S&P Global, we focus on Powering Global Markets. Throughout our history, the world's leading organizations have relied on us for the Essential Intelligence they need to make confident decisions about the road ahead.

Benefits:

We take care of you, so you can take care of business. We care about our people. That’s why we provide everything you—and your career—need to thrive at S&P Global.

Our benefits include:

• Health & Wellness: Health care coverage designed for the mind and body.
• Flexible Downtime: Generous time off helps keep you energized for your time on.
• Continuous Learning: Access a wealth of resources to grow your career and learn valuable new skills.
• Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company-matched student loan contribution, and financial wellness programs.
• Family Friendly Perks: It’s not just about you. S&P Global has perks for your partners and little ones, too, with some best-in-class benefits for families.
• Beyond the Basics: From retail discounts to referral incentive awards—small perks can make a big difference.

Inclusive Hiring and Opportunity at S&P Global:

At S&P Global, we are committed to fostering an inclusive workplace where all individuals have access to opportunities based on their skills, experience, and contributions. Our hiring practices emphasize fairness, transparency, and equal opportunity, ensuring that we attract and retain top talent.

Equal Opportunity Employer: S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law.