Job Description

Requisition ID: 87107

Job Category: Information Technology

Location: Vancouver, BC, Canada

Join a company that is passionately committed to the pursuit of a better world through positive change. With more than 65 years of business and technical expertise in , , and , our in tirelessly work toward bettering the industries in which we operate. With practical solutions that are safe, innovative and sustainable, we think globally while acting locally. Are you looking for an opportunity to join a diverse group of professionals who are committed to remaining exceptional? We look forward to hearing from you.

We\'re at the forefront of our clients\' , successfully implementing emerging digital services into our clients\' projects and operations that unlock a step change in their performance. Join the to improve project outcomes, leverage the , deliver systems integration and interoperability, and support decision-making, , 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, Azure Synapse, 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, merge)
• 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
• Understand and support Azure Synapse including ADF with spark environments

You bring to the role:

• A Bachelor\'s degree or Diploma in IT
• 8-10+ years of experience of MS SQL Server 2008-2022 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
• 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?

• Work with

to make a difference * Collaborate on exciting
to develop innovative solutions

What we offer you?

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

Don\'t meet every single requirement? You don\'t need to. At Hatch, we are building a diverse, inclusive workplace that fosters innovation. If you\'re interested in this role, we encourage you to apply even if your past experiences don\'t perfectly align with the skills we\'ve listed.

We\'re committed to fostering a workforce that reflects the of the 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, veteran, 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.

Hatch