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.
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
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
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
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.