Senior Database Administrator

Closing Date: June 2, 2025Teck 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
• 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 

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