Senior Database Administrator
Senior Database Administrator
Posted on :
20-05-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
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.
Tecks two regional business units North America and Latin America oversee Tecks assets through all phases of safe sustainable development operation and closure. The business units are supported by enterprisewide 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.
Dont miss out on this outstanding opportunity to be part of one of Canadas 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 backend 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 oncall rotation
Qualifications
- 8 years of experience with Database Administration for MSSQL Server
- Database design data modeling and scripting
- Onpremises 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 AlwaysOn) 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 onpremises SSRS and Cloud based PowerBI dashboards
- Indepth 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 TSQL 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
$105000 $130000 a year
The actual base salary offered is determined based on the successful candidates relevant experience skills and competencies and considers internal equity.
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 wellbeing. 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 wellbeing
Employee and Family Assistance Program (EFAP)
About Teck
Required Experience:
Senior IC
Employment Type
Full-Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
