Database Administrator

David Aplin Job Details

Database Administrator

Calgary, AB

Contract

Posted Date: 05/05/2022

Job ID: HS82955155

Information Technology

Join a top employer and advance your career. Our client, a leader in the mining industry, has partnered with David Aplin Group to hire a Database Administrator to advise and support database applications such as system-to-system integrations or as an advisor to data migration/data cleansing efforts.
 
This is a 6-month contract role. This opportunity is available to candidates in Vancouver or Calgary.
 
Responsibilities:
  • Develop plans for providing reliable, recoverable, and scalable database/computing environments to store and integrate company data
  • Plan and deploy upgrades or modifications to improve the performance and availability of SQL servers and production databases
  • Build and maintain overall systems architecture concerning databases back-end servers and computing environment
  • Install, supervise, maintain, and performance tune production SQL Servers and databases while ensuring high levels of data availability
  • Lead all aspects of 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 supervise the status of database systems ensuring their integrity and availability
  • Supervise and optimize the performance of database queries including preparation of periodical metrics
  • Implement and maintain compliance of SQL/database environments with internal database security standards
  • Ability to coordinate and prioritize multiple work activities
  • Be available to work extended hours, including weekends and holidays when required, and participate in on-call rotation
Qualifications:
  • 7+ years’ experience in a Database Administrator role
  • Microsoft SQL Server (2019) certification
  • 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
  • Experience 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, monitoring, troubleshooting, performance tuning 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
  • 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 the software development process, including CI/CD pipelines setup and management, automated database deployment techniques
  • Strong written and verbal communication skills in both technical and non-technical scenarios (including presentation skills to senior-level management
 Job ID: HS82955155
 
If you are interested in this position and meet the qualifications, apply today! We thank all applicants; however, only those who are authorized to work in Canada or are selected for an interview will be contacted.
 
David Aplin Group, one of Canada’s Best Managed Companies, is an employment agency specializing in finding top talent for exceptional organizations across North America. There are no fees to apply to our jobs or engage with our recruiters to find a new career. Companies hire us to help them grow their teams. Visit our website to learn more: www.aplin.com #LI-DNP#IND-DNP

  • Max. file size: 128 MB.
  • This field is for validation purposes and should be left unchanged.

Get notified for
similar jobs.

Sign up for Job Alerts