SQL Systems Administrator

Irving Oil; Saint John; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading company in the oil industry is seeking a SQL Systems Administrator to enhance their database management. This role involves ensuring data security, troubleshooting issues, and collaborating with various teams to optimize database performance. Candidates should have a relevant degree and 3-5 years of experience in similar roles, as well as strong analytical and communication skills.

Benefits

Access to fitness facility

Onsite nurse

Café on site

Competitive compensation

Flexible Benefits Plan

Paid vacation options

Wellness support

Community volunteer opportunities

Qualifications

• 3-5 years of experience in database administration or similar roles.
• Experience with server clustering and disaster recovery planning.
• Proven analytical skills in performance optimization.

Responsibilities

• Install, configure, and maintain database systems.
• Troubleshoot database management software issues.
• Ensure data security and disaster recovery.

Skills

Knowledge of database management systems

Analytical skills

Excellent communication skills

Ability to automate tasks with scripting

Problem-solving abilities

Education

Degree or diploma in a computer-related program

Tools

Microsoft SQL

Oracle

MySQL

PostgreSQL

Microsoft Azure SQL

PowerBI

Job description

As a SQL Systems 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