Closing Date: June 2, 2025
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!
\n
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
Azure cloud services: Azure SQL, Azure SQL managed instance, Azure Data Lake, Azure Data Warehouse, Azure Data Factory, Synapse Analytics – resources provisioning, cost optimization, licensing/pricing models, database restore scenarios
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.)
Implementing operational automation using scripts (PowerShell, Python, T-SQL, VB Scripts 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
Azure Database Administrator Associate or equivalent
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
\n
$105,000 - $130,000 a year
The actual base salary offered is determined based on the successful candidate’s relevant experience, skills, and competencies and considers internal equity.
\n
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
• Employer Paid Pension Plan
• 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)
About Teck