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
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:
NICE TO HAVE:
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
