SQL Systems Administrator

Irving Oil Ltd.; Saint John; On-site; CAD 75,000 - 95,000; Full time

Job summary

A leading energy company is seeking a SQL Systems Administrator in Saint John, Canada. The role involves ensuring database performance, security, and integrity, along with collaborating with various teams to optimize database technologies. Applicants should have a Bachelor's degree in IT and relevant experience in database management systems.

Benefits

Access to fitness facility

Onsite nurse

Café access

Annual bonus plan

Flexible Benefits Plan

Paid vacation

Wellness support

Volunteer opportunities

Qualifications

• 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 cloud database technologies, like Microsoft Azure SQL, Cosmos DB.

Responsibilities

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

Skills

Microsoft SQL

Oracle

MySQL

PostgreSQL

Python

T-SQL

PowerShell

Analytical skills

Communication

Problem-solving

Education

Bachelor's in Information Technology

Tools

MS Fabric

PowerBI

Databricks

Job description

SQL Systems Administrator page is loaded

SQL Systems Administrator

Apply locations Saint John time type Full time posted on Posted 30+ Days Ago job requisition id R125911

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’screated 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

Join our Talent Community

We are always looking for amazing candidates to join our talent community.

If you do not see a position that interests you, please fill in your contact information and upload your resume.

Who we are

As a family-owned company deeply rooted in our communities, we work hard to make a difference in the places we serve. For more than 100 years, our commitment to doing good business has been grounded in our commitment to people – to our employees, to our customers, and to our communities.

Our mission is focused on our continued evolution to meet the changing needs of our customers. We are devoted to being part of the solution, in providing the safe and reliable energy that our customers need, while taking concrete steps to evolve our business for the future.