Share this job

Database Administrator

Apply now »

Date: Nov 6, 2022

Location: Vancouver, BC, CA

Company: Hatch

Requisition ID: 66781 

Job Category: Information Technology 

Location: Vancouver, BC, Canada 
 

With over six decades of business and technical experience in the mining, energy, and infrastructure sectors, we see challenges evolving in every industry. We respond quickly with solutions that are smarter, more efficient, and innovative. We draw upon our 9,000 staff, with experience in over 150 countries, to challenge the status quo and create positive change for our clients, our employees, and the communities we serve.
 

We're at the forefront of our clients' digital transformation journey, successfully implementing emerging digital services into our clients' projects and operations that unlock a step change in their performance. Join the team to improve project outcomes, leverage the digital twin, deliver systems integration and interoperability, and support decision-making, autonomous execution, and integrated operations and performance centers.

 

Looking to take the next step in your career? Hatch is currently seeking a highly motivated Database Administrator to join the Digital group  in Vancouver.

 

Digital solutions have become a key component of the strategic direction and vision of today’s modern organizations. Join our diverse team and award-winning culture and be part of our clients’ digital transformation journey by working to define the best methods and making sure they are supported by the right technology and an enabled workforce. This journey will lead to improve project outcomes, being able to leverage the digital twin, systems integration and interoperability, support for decision-making, autonomous execution, and integrated operations and performance centers. 

 

As the successful candidate, you will: 

  • Manage a global environment of SQL Server, Azure SQL DB, Oracle and other databases through multiple product lifecycle environments, from development to mission-critical production systems
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security;
  • Refine and automate regular processes, track issues, and document changes
  • Manage and ensure compliance with database backup strategies
  • Troubleshoot problems as they occur, including weekends, on-call rotation as required
  • Complete administration of SQL Server Replication (transactional, peer-to-peer)
  • Complete administration of SQL Server Clustering, including Always On; additional knowledge of other HA/DR options as asset
  • Manage and maintain service pack updates, cumulative updates and security patches
  • Complete general database administration of Oracle 12c/21c Database, including datapump, RMAN backup and recovery

 

You bring to the role: 

  • Bachelor's degree
  • 8-10+ years of experience of MS SQL Server 2008-2019 production support in a mission critical environment, Microsoft Azure SQL DBs and Oracle OCI environment
  • Experience in analysis and tuning of T-SQL queries to improve performance, providing baselines and reporting to higher teams on results
  • Experience with backup, restore and recovery models
  • Familiarity with server troubleshooting in a Microsoft Windows environment
  • Experience in Oracle 12c/21c, including RMAN backup and restore and oracle datapump
  • The ability to plan, organize and work on multiple tasks simultaneously
  • MySQL, MongoDB and PostgreSQL knowledge is a plus
  • Strong communication skills
  • The ability to work occasional after-hours or weekends as required

 

Working knowledge in the following areas is considered an asset:

  • PowerShell Automation 
  • Familiarity with Azure DevOps, Data factory, System Center Operations Manager, Azure Synapse
  • Familiarity with Microsoft Azure SecOps, IaaS, PaaS, DBaaS

 

Why join us?



What we offer you?

 

  • Flexible work environment
  • Long term career development
  • Think globally, work locally

 


We're committed to fostering a workforce that reflects the diversity of the communities in which we operate and serve. Hatch is an Equal Opportunity Employer that considers applicants without regard to age, race, color, national origin, citizenship, religion, creed, gender, sexual orientation, marital status, disability, or any other protected status. If you have any accommodation requirements, please let us know. We'll do our best to meet your needs in accordance with applicable local legislation.


Job Segment: DBA, Database, System Administrator, SQL, PLM, Technology, Management