Login | Register

Senior Database Administrator to support Information acquisition, analysis, storage, and retention for financial, materials, sales, logistics, exploration, environmental, and risk purposes

Job Type: Contract
Positions to fill: 1
Start Date: Jun 13, 2022
Job End Date: Dec 30, 2022
Pay Rate: Hourly: Negotiable
Job ID: 118926
Location: Calgary, Vancouver
Apply
S.i. System's mining client is looking for a Senior Database Administrator to support Information acquisition, analysis, storage, and retention for financial, materials, sales, logistics, exploration, environmental, and risk purposes.

MUST HAVES:
  • DevOps automation for databases. Implementing operational automation using scripts (PowerShell, T-SQL, VB Scripts, etc.)
  • 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.)
  • Azure cloud services: Azure SQL, Azure SQL led, Azure Data Lake, Azure Data Warehouse, Azure Data Factory – resources provisioning, cost optimization, licensing/pricing models, database restore scenarios
  • On-premises, Cloud, and Hybrid database environments design, development, and support.
  • Experience with PowerBI development and support, including on-premises SSRS and Cloud, based PowerBI dashboards
  • Database design, data modeling, and scripting
  • 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 grasp of Database security and implementation of standard methodologies in database access across the enterprise, including Azure specific authentication and access methods
  • Source Code repository experience (TFS, GitHub, Azure DevOps) to support software development process, including CI/CD pipelines setup and management, automated database deployment techniques

NICE TO HAVE:
  • Microsoft SQL Server 2019 (or earlier) certification
  • Azure Database Administrator Associate or equivalent
  • Experience with ORACLE 12c and higher
  • Experience with GCP and Azure Cloud services
  • Experience working with Windows Server 2016 and higher
  • Experience with Active Directory in the context of database security
  • Storage and Virtualization