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 provide quick resolution. You will be required to work individually, as well as collaborate with team members, 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é
Hybrid work model – Allows for a blend of in-office and work-from-home days
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