Irving Oil

SQL Systems Administrator

Saint John, NB

full_time

About This Job

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

Similar Jobs

SQL Systems Administrator

About This Job

Your Responsibilities

Your Skills

Your Experience

Similar Jobs

SQL Systems Administrator

SQL Server Database Administrator

Database Administrator

Database Administrator

Database Administrator

System Administrator

System Administrator

System Administrator

System Administrator

Systems Administrator

Senior Database Administrator

Systems Administrator

Systems Administrator

Systems Administrator

SharePoint Administrator

Administrator

Administrator

Business Systems Administrator

Operations Administrator

Operations Administrator

Trending Jobs

Electrical Engineer

Division Order Analyst

Professional Landman

Accounts Payable Clerk

Division Order Landman

contract landman

Oil and Gas Land and Title Analyst - SAM Associate II

Attorney

Title Landman

Senior Landman

Oil and Gas Title Attorney

Electrical Designer

Title Reviewer

Civil/Structural Designer

Landman

contract Landman

contract Landman

E &amp; I - Office/Field Administration

Mechanical/Piping Engineer

Senior Division Order Analyst

E & I - Office/Field Administration