Database Administrator

ITjobs.ca; Saint John; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company is seeking a Database Administrator to install, configure, and maintain database systems while ensuring data security. The role involves troubleshooting, optimizing performance, and collaborating with teams to meet database needs. The company offers a supportive work environment with competitive compensation and benefits.

Benefits

Access to fitness facility

Onsite nurse

Café

Annual bonus plan

Pension plan

Parking allowance

Flexible Benefits Plan

Paid vacation

Wellness support

Paid volunteer day

Qualifications

• 3-5 years of experience in database administration or similar role.
• Relevant database administration certificates are an asset.

Responsibilities

• Design, install, configure and maintain highly available database systems.
• Ensure data security and integrity, including implementation of access controls.
• Support users and developers by resolving data-related technical issues.

Skills

Knowledge of database management systems

Analytical abilities

Excellent communication skills

Ability to prioritize tasks

Education

Degree or diploma in a computer-related program

Tools

Microsoft SQL

Oracle

MySQL

PostgreSQL

Python

Powershell

T-SQL

MS Fabric

PowerBI

Databricks

Job description

As a Database Administrator you will be responsible for installing, configuring and maintaining database systems and ensuring data security in our organization. You will also troubleshoot issues in our database management software and providing quick resolution. You will be required to work individually, as well as collaborate with team members and partners, system admins and end-users to maintain databases.

What We Offer

• Work environment - Work in our beautiful home office building with access to a fitness facility, onsite nurse, and a café
• Competitive compensation - Includes an annual bonus plan, pension plan, and parking allowance
• Flexible Benefits Plan - In effect from day one and offers three levels of coverage to select from to meet your unique, personal needs
• Paid vacation - There is an annual option to purchase additional vacation, too
• Wellness support - With an annual wellness allowance, paid personal care days and a 24/7 Employee & Family Assistance Program
• Opportunity to give back to some amazing causes in our community - Choose when and where to make an impact with a paid volunteer day, company volunteer opportunities, and a donation-matching program
  
  

Your Responsibilities

• Design, install, configure and maintain highly available database systems, including monitoring, tuning and troubleshooting issues
• Provide a seamless flow of information by keeping databases running smoothly
• Ensure data security and integrity, including implementation of access controls, backups and recovery plans
• Execute disaster recovery plans and procedures to ensure database availability during system outages or dysfunction
• Develop and maintain database documentation, including data standards, procedures and definitions for data elements and tables in the company
• Identify and implement database requirements for new or existing applications by working collaboratively with other teams
• Optimize database performance and efficiency by evaluating and recommending new database technologies
• Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices
• Execute regular database maintenance tasks, including database defragmentation, backups, and database replication
  
  

Your Skills

• Knowledge of database management systems such as Microsoft SQL and Oracle, experience with MySQL, PostgreSQL is an asset
• Experience with server clustering, such as SQL AlwaysOn Availability Groups, mirroring, and other high availability strategies
• Ability to use a scripting language (Python or Powershell, T-SQL) to automate database administration tasks
• Proven analytical, evaluative, and problem-solving abilities
• Excellent written and oral communication skills with exceptional customer service
• Ability to present ideas in business-friendly and user-friendly language
• Highly self-motivated and directed
• Ability to effectively prioritize and execute tasks in a high performance environment
• Knowledge of reporting and analytic software such as MS Fabric, PowerBI, Databricks would be considered an asset
• Relevant database administration certificates, such as Oracle Certified Professional (OCP) or Microsoft Certified Database Administrator (MCDBA) are an asset
  
  

Your Experience

• Degree or diploma in a computer-related program or equivalent experience within IT
• 3-5 years of experience in database administration or in a similar role
• Experience in database backup, disaster recovery planning, performance optimization and data security
• Experience in cloud database technologies, like Microsoft Azure SQL, Cosmos DB
  
  

Irving Oil is committed to supporting a diverse and inclusive work environment. We thrive on the good energy that's created when our people from different backgrounds, identities, cultures and experiences share their unique perspectives. Diversity is key to our success and inclusion is everyone's responsibility.

Job Requirements - Work Experience

Information Technology

Job Requirements - Education

Bachelors: Information Technology

SaveRemove

share-facebook"> " class="cls-1" d="M15,0A15,15,0,1,0,30,15,15,15,0,0,0,15,0Zm3.25,15H16v8H13V15H11V12h2V10.71c0-1.27.29-3.26,2.94-3.26H18V10H16.76a0.83,0.83,0,0,0-.76.87V12h2.54Z"> share-twitter"> " class="cls-1" d="M15,0A15,15,0,1,0,30,15,15,15,0,0,0,15,0Zm5.79,12.39c0,0.12,0,.25,0,0.37A8.31,8.31,0,0,1,8,19.77c0.23,0,.46,0,0.7,0a5.94,5.94,0,0,0,3.65-1.25,2.91,2.91,0,0,1-2.71-2,4.07,4.07,0,0,0,.61,0,4.22,4.22,0,0,0,.87-0.1A2.76,2.76,0,0,1,9,13.61v0a1.33,1.33,0,0,0,1.12.37A3.11,3.11,0,0,1,8.6,11.51,2.91,2.91,0,0,1,9,10a8.29,8.29,0,0,0,6,3,2.93,2.93,0,0,1,5-2.67,5.69,5.69,0,0,0,1.85-.71,2.88,2.88,0,0,1-1.28,1.62,6,6,0,0,0,1.68-.46A6,6,0,0,1,20.79,12.39Z"> share-linkedin"> " class="cls-1" d="M16.19,13.74a0,0,0,0,0,0,0v0h0Z"> "> " class="cls-1" d="M15,0A15,15,0,1,0,30,15,15,15,0,0,0,15,0ZM11.83,21H9V12.52h2.82V21Zm-1.41-9.64h0a1.47,1.47,0,1,1,0-2.94A1.47,1.47,0,1,1,10.42,11.36ZM22,21H19.18V16.46c0-1.14-.41-1.92-1.43-1.92a1.56,1.56,0,0,0-1.45,1,2.1,2.1,0,0,0-.09.69V21H13.39s0-7.69,0-8.48h2.82v1.2a2.81,2.81,0,0,1,2.54-1.4c1.86,0,3.25,1.21,3.25,3.82V21Z"> share-email"> " class="cls-1" d="M15,0A15,15,0,1,0,30,15,15,15,0,0,0,15,0Zm9,21H6V10H24V21Zm-1-1.71v-7l-4,3ZM15,17l8-6H7Zm0.6,1H14.4l-2.57-2L7.71,20H22.29l-4.12-4ZM7,12.25v7l4-4Z"> share-print"> " class="cls-1" d="M10,8v3H20V8H10ZM8,12v6H9V17h1v5H20V17h1v1h1V12H8Zm2,2H9V13h1v1Zm9,7H11V20h8v1Zm0-2H11V18h8v1ZM8,12v6H9V17h1v5H20V17h1v1h1V12H8Zm2,2H9V13h1v1Zm9,7H11V20h8v1Zm0-2H11V18h8v1ZM10,8v3H20V8H10Zm0,0v3H20V8H10ZM8,12v6H9V17h1v5H20V17h1v1h1V12H8Zm2,2H9V13h1v1Zm9,7H11V20h8v1Zm0-2H11V18h8v1ZM8,12v6H9V17h1v5H20V17h1v1h1V12H8Zm2,2H9V13h1v1Zm9,7H11V20h8v1Zm0-2H11V18h8v1ZM20,8H10v3H20V8ZM15,0A15,15,0,1,0,30,15,15,15,0,0,0,15,0Zm8,19H21v4H9V19H7V11H9V7H21v4h2v8ZM8,18H9V17h1v5H20V17h1v1h1V12H8v6Zm3,0h8v1H11V18Zm0,2h8v1H11V20ZM9,13h1v1H9V13ZM20,8H10v3H20V8ZM10,8v3H20V8H10ZM8,12v6H9V17h1v5H20V17h1v1h1V12H8Zm2,2H9V13h1v1Zm9,7H11V20h8v1Zm0-2H11V18h8v1ZM8,12v6H9V17h1v5H20V17h1v1h1V12H8Zm2,2H9V13h1v1Zm9,7H11V20h8v1Zm0-2H11V18h8v1ZM10,8v3H20V8H10Z"> SaveRemove