Senior Database Administrator

Teck Resources Limited; Vancouver; On-site; CAD 105,000 - 130,000; Full time

Job summary

Join a leading mining company as a Senior Database Administrator in Vancouver. You will ensure operational database functionality, oversee database policies, and lead continuous improvement efforts. This role offers a competitive salary and a comprehensive benefits package, promoting a fulfilling career in a collaborative environment.

Benefits

Annual Performance Bonus

Profit Share Plan

Health Spending Account

Personal Spending Account

Extended Health Care

Dental and Vision Care

Life Insurance and Disability Coverage

Paid Sick Leave, Vacation and Holidays

Virtual Telemedicine

Employee and Family Assistance Program

Qualifications

• 8+ years of experience with Database Administration for MSSQL Server.
• Hands-on experience with Microsoft SQL Server Reporting, Analysis, and Integration Services.

Responsibilities

• Install, monitor, maintain and performance tune production SQL Servers and databases.
• Develop plans for reliable and scalable database environments.

Skills

Database Administration

Problem Solving

Communication Skills

Time Management

Tools

Microsoft SQL Server

PowerBI

SSRS

SSIS

Azure DevOps

Job description

Press Tab to Move to Skip to Content Link

Search by city, province/state, or country

Search by city, province/state, or country

Choose how often (in days) you want to to be notified of jobs matching the above search criteria.

Choose how often (in days) you want to to be notified of jobs matching the above search criteria.

Teck is a leading Canadian resource company focused on responsibly providing the metals essential for global development and the energy transition while caring for the people, communities and land that we love.

Teck's two regional business units, North America and Latin America, oversee Teck's assets through all phases of safe, sustainable development, operation and closure. The business units are supported by enterprise-wide functions that set strategic direction, establish standards and provide governance, as well as supporting the business through shared services, centers of excellence and business partnering.

Reporting to Manager, Database Services, the Senior Database Administrator is part of a distributed team responsible for ensuring all enterprise operational database functionality. The related infrastructure supports core functions inclusive of: information acquisition, analysis, storage, and retention for financial, mining, materials, sales, logistics, exploration, environmental, risk purposes.

This role will act as a Senior Production Database Administrator supporting the services associated with database implementation and database maintenance. The DBA team will work with other distributed teams to ensure storage, server hardware, server software and related configurations necessary to support databases agnostically in the enterprise. Services supported by the distributed DBA team include but are not limited to the hardware and software configurations necessary to support databases for: Communications and Collaboration, Financial Applications (Hyperion, SAP, Dynamics 365and JDE), Materials Management and Logistics (Dynamics AX, JDE), Exploration (GIS Data, Gemcom, aQuireand Flexicadastre), environmental (SiteLine) etc.

The DBA is part of a team of intermediate and senior database administrators. This team is comprised of members from operational sites included but not limited to Trail, HVC, Chile and Red Dog.

Don't miss out on this outstanding opportunity to be part of one of Canada's leading mining companies and join our team!

Responsibilities

• Be a courageous safety leader, adhere to and sponsor safety and environmental rules and procedures
• Develop plans for providing reliable, recoverable, and scalable database/computing environments to store and integrate company data
• Build and maintain overall systems architecture concerning databases back-end servers and computing environment
• Install, monitor, maintain and performance tune production SQL Servers and databases while ensuring high levels of data availability
• Oversee database policies and procedures to ensure the integrity and availability of databases and their accompanying software
• Lead continuous improvement efforts to improve performance and provide increased functionality of SQL Servers and database environment
• Develop and improve tools and procedures used for automated checks and monitoring the status of database systems ensuring their integrity
• Monitor and optimize the performance of database queries including preparation of periodical metrics
• Enforce and maintain compliance of SQL/database environments with internal database security standards
• Provide project estimates and ensure projects and tasks are completed within acceptable timeframe and to business/customer specifications/requirements
• Ability to coordinate and prioritize multiple work activities
• Available to work extended hours, including weekends and holidays when required and participate in on-call rotation

Qualifications

• 8+ years of experience with Database Administration for MSSQL Server
• Database design, data modeling and scripting
• On-premises, Cloud and Hybrid database environments design, development, and support
• High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server (log shipping, DB mirroring, replication and Always-On), DR strategies design, implementation, and testing
• Database monitoring, troubleshooting and performance tuning
• Hands on experience with Microsoft SQL Server Reporting (SSRS), Analysis (SSAS) and Integration Services (SSIS) projects development and deployment
• Solid understanding of Database security and implementation of best practices in database access across enterprise, including Azure specific authentication and access methods
• Experience with PowerBI development and support, including on-premises SSRS and Cloud based PowerBI dashboards
• In-depth performance tuning and troubleshooting of SQL queries, stored procedures and SSIS packages
• Indexing for performance (index maintenance and statistics, index usage analysis etc.)
• Source Code repository experience (TFS, GitHub, Azure DevOps) to support software development life cycle, including CI/CD pipelines setup and management, automated database deployment techniques
• Problem Solving: Advanced troubleshooting and diagnostic skills are needed to solve a broad range of complex problems related to infrastructure applications, configurations, workstation operation, server operation, application quirks and network operation
• Communication Skills: Incumbent must effectively and efficiently work with employees in all departments and at all levels of the organization
• Time and Priority Management: Essential to manage time demands and prioritize work when supporting numerous staff at many locations and managing time with different projects

Nice to Haves

• Microsoft SQLServer 2022 (or earlier) certification
• Experience with GCP and Azure Cloud services
• Experience working with Windows server 2016 and higher
• Experience with Active Directory in context of database security
• Storage and Virtualization

Why Join Us?

At Teck, we offer more than just a job – we provide a pathway to personal and professional enrichment. With captivating projects set against stunning backdrops, a culture of inclusivity and collaboration, and boundless opportunities to learn and grow, joining us means embracing a fulfilling and dynamic career adventure.

Teck employees receive access to our total rewards program and comprehensive benefits package that promote physical, mental, financial, and emotional well-being. This includes but is not limited to:

• Annual Performance Bonus
• Profit Share Plan
• Health Spending Account
• Personal Spending Account
• Extended Health Care
• Dental and Vision Care
• Life Insurance and Disability Coverage
• Paid Sick Leave, Vacation and Holidays
• Virtual Telemedicine and additional support for overall well-being
• Employee and Family Assistance Program (EFAP)

Salary Range: $105,000 - $130,000

The actual base salary offered is determined based on the successful candidate’s relevant experience, skills, and competencies and considers internal equity.

About Teck

At Teck, we value diversity. Our teams work collaboratively and respect each person’s unique perspective and contribution.

Teck is one of Canada's leading mining companies, focused on providing products that are essential to building a better quality of life for people around the globe.Our commitment to our people is why Teck has been named one ofCanada’s Top 100 Employers for seven consecutive years, listed as one ofCanada's Top Employers for Young People and named to the 2024 Bloomberg Gender-Equality Index.The pursuit of sustainability guides Teck's approach to business and we are proud to be recognized as one of the 2024 Global 100 Most Sustainable Corporations by Corporate Knights.Headquartered in Vancouver, Canada, its shares are listed on the Toronto Stock Exchange under the symbols TECK.A and TECK.B and the New York Stock Exchange under the symbol TECK.

We wish to thank all applicants for their interest and effort in applying for the position; however, only candidates selected for interviews will be contacted.