Database Administrator Bhjob13022 12174

**Database Administrator (SQL) - Contract position in Vancouver (hybrid model).**

On behalf of our client in **Vancouver,** **Ignite Technical Resources** is looking for a **Database Administrator (SQL).**
**Role Description**:
**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.

**Requirements**:

- 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.
- Strong written and verbal communication skills in both technical and non-technical scenarios. This includes presentation skills to senior-level management.
- Strong Business Acumen: a large part of the role will be working directly with business streams to meet the organization’s strategic goals.
- A positive and people-oriented personality that is action-oriented.
- An analytical, creative, and innovative approach to solving problems.
- Require a Computer Science or related degree plus 7 years of related experience in a Database Administrator role for a large corporation.
**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.
- Based in Vancouver and proudly Canadian, Ignite Technical Resources has been providing Top Technical Talent to organizations across Canada since 2005._

**Ignite. Wired for people.**

**About Ignite Technical Resources.**: