Database Administrator

Database Administrator

• Department: Technology & Product

Employment Type: Permanent

Location: Remote, Canada

Description

As a crucial part of the Veriforce Data Function, this role is responsible for management of Veriforce
databases to ensure optimal performance, security, and reliability. You will be responsible for maintaining the company's database systems, performing database backups and recovery, and providing technical support to end-users. 

The DBA will also work closely with other IT & Business Intelligence colleagues to ensure that the database environment is in line with our goals and objectives.

What That Means Day-To-Day:

• Manage and maintain the company's databases, including monitoring their performance and security.
• Design and implement database backup and recovery strategies to ensure data protection and disaster recovery.
• Troubleshoot and resolve database-related issues and work with end-users to resolve application level problems.
• Perform database tuning and optimization to ensure the highest levels of performance.
• Authoring and revising SQL statements (queries, stored procedures, triggers, etc.). Leveraging AI assistance wherever possible.
• Manage database security, including creating and maintaining user accounts, assigning roles and privileges, and monitoring access logs.
• Work closely with other IT staff to ensure that database environments are aligned with organisational goals and objectives.
• Develop and maintain database documentation, including data dictionaries, data flow diagrams, and system diagrams.
• Stay up to date with emerging database technologies and industry trends.

What You’Ll Need To Be Successful:

Essential

• Minimum of 5 years of experience as a DBA or in a similar role.
• Experience with database administration tools such as Oracle, MySQL, and SQL Server.
• Experience with database backup and recovery strategies, including point-in-time recovery and full system backups.
• Experience with cloud-based database technologies such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud , Platform (GCP)
• Experience with database tuning and optimisation, including index creation, query optimisation, and storage allocation.
• Understanding of database security principles, including authentication, authorisation, and encryption.
• Strong problem-solving and analytical skills.
• Ability to work well in a team environment. · 

Desirable

• Knowledge of database automation tools such as Puppet, Chef, or Ansible 
• Familiarity with Big Data technologies such as Hadoop, Apache Spark, or NoSQL databases 
• Understanding of data warehousing schemas designs and concepts · Understanding of Business Intelligence (BI) concepts and tools (PowerBI, Tableau, etc.) 
• Knowledge of scripting languages such as Python, Perl, or PowerShell 
• Experience with data migration and integration tools such as SQL Server Integration Services (SSIS), Oracle Data Integrator (ODI), AWS Glue, AppFlow, etc. 
• Experience using AI assisted SQL coding tools (i.e. Copilot or others)

What You’Ll Get In Return:

We want you to be able to do your best work here. We emphasize providing many ways to support our team to do their best work, and believe that if you look after your people, they look after everything else! 

Personal Health & Wellbeing 

>🧠 Integrated mental health & wellbeing support 

>🌴 Vacation – starting at 3 weeks 

>💟 Wellness Days & Annual Giving Day – an extra to give back to yourself or your community

>🩺 Comprehensive medical and dental coverage 

> 😴 End of the year, company-wide shut down for you to relax and recharge

 Future Planning
>🏫 LinkedIn Learning License for upskilling & development 

Interested but don’t feel you meet all the requirements? 

Our recruitment team assesses and reviews all applications against the role and business needs. We believe in people having transferable and soft skills and want you to know that we consider applications that might not meet all the criteria, but have the aptitude and capability, nonetheless. Our priority is to ensure we set people up for success. We will make a final call based on our determining whether we can offer the necessary support to upskill or provide the developmental support needed for you to get the best out of this opportunity with us!

Bring Your Whole Self to Work.

Veriforce-Alcumus is proudly an equal-opportunity employer. We are committed to ensuring that no candidate is discriminated against because of gender identity and expression, race, disability, ethnicity, sexual orientation, age, colour, region, creed, national origin, or sex. We are dedicated to growing a diverse team while continuing to create an inclusive environment where everyone feels safe and empowered to be themselves. 

What you can expect if you apply:

• A response to your application within 15 working days
• An interview process consisting of:
• An initial discovery call with the recruiter
• A first stage interview via Microsoft Teams 
• Additional interview with the stakeholders you’ll be working with closely in the role

We’re keen to ensure our hiring process allows you to be at your best, so if you need us to make any adjustments, please just let us know.

#LI-JT1