Senior Database Administrator

at  TekisHub Consulting Services

Job title: Senior Database Administrator
Job location: Toronto-hybrid
Job type: Contract
Senior Database Administrator
Reporting to Manager, Database Services, the Senior Database Administrator is part of a distributed team responsible for ensuring all enterprise operational database functionality. They will oversee the related infrastructure supporting core functions inclusive of: information acquisition, analysis, storage, and retention for financial, mining, materials, sales, logistics, exploration, environmental, risk purposes.
This diverse team encompasses intermediate and senior DBAs from operating mine sites including but not limited to Trail, Highland Valley Copper, Chile and Red Dog mines.

Responsibilities

• Be a courageous safety leader, adhere to and sponsor safety and environmental rules and procedures
• Act as a Senior Production DBA and support the services associated with database implementation and maintenance
• Collaborate with other distributed teams to ensure storage, server hardware, server software and related configurations necessary to support databases agnostically in the enterprise
• Handles services related to hardware and software configurations necessary to support databases for: Communications and Collaboration, Financial Applications (Hyperion, SAP, Dynamics 365 and JDE), Materials Management and Logistics (Dynamics AX, JDE), Exploration (GIS Data, Gemcom, aQuire and Flexicadastre), environmental (SiteLine) etc.
• 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 MS SQL Server
• Skilled at database design, monitoring, data modeling, scripting and performance tuning
• Exposure to on-premises, Cloud and Hybrid database environments design, development, and support
• Familiarity with Azure cloud services: Azure SQL, Azure SQL managed instance, Azure Data Lake, Azure Data Warehouse, Azure Data Factory – resources provisioning, cost optimization, licensing/pricing models, database restore scenarios
• Exposure to High Availability and Disaster Recovery options for MS SQL Server (log shipping, DB mirroring, replication and Always-On), DR strategies design, implementation, and testing
• 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 standard processes 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 problem solving of SQL queries, stored procedures and SSIS packages
• Exposure to indexing for performance (index maintenance and statistics, index usage analysis etc.)
• Knowledge of Implementing operational automation using scripts (PowerShell, Python, T-SQL, VB Scripts etc.)
• Source Code repository experience (TFS, GitHub, Azure DevOps) to support software development process, including CI/CD pipelines setup and management, automated database deployment techniques
• A self starter with the capacity to work with minimum or no direct supervision or direction and able to work in team environment
• A motivated, interpersonal individual who can resolve conflict when necessary

Job Type: Fixed term contract
Contract length: 12 months
Pay: $60.00-$65.00 per hour

Benefits:

• Dental care
• Extended health care
• Flexible schedule
• Paid time off
• Vision care
• Work from home

Schedule:

• 8 hour shift

Work Location: In perso

• Be a courageous safety leader, adhere to and sponsor safety and environmental rules and procedures
• Act as a Senior Production DBA and support the services associated with database implementation and maintenance
• Collaborate with other distributed teams to ensure storage, server hardware, server software and related configurations necessary to support databases agnostically in the enterprise
• Handles services related to hardware and software configurations necessary to support databases for: Communications and Collaboration, Financial Applications (Hyperion, SAP, Dynamics 365 and JDE), Materials Management and Logistics (Dynamics AX, JDE), Exploration (GIS Data, Gemcom, aQuire and Flexicadastre), environmental (SiteLine) etc.
• 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 rotatio