Primary Responsibilities: Database Administration Provide administration, support, and optimization of enterprise relational database platforms (on-premises and cloud), including: Administer, monitor, and maintain relational database environments to ensure high availability, reliability, and performance Perform database performance tuning, optimization, and capacity planning Automate routine database maintenance tasks, including backups, refreshes, patching, and health checks Configure and support replication, disaster recovery, and high availability solutions Troubleshoot issues across the database, operating system, storage, and network layers Administer database monitoring and alerting tools (SolarWinds, custom monitoring, etc.) Automate database provisioning, configuration, and administration using scripting and Infrastructure-as-Code where applicable Develop and maintain database objects including views, stored procedures, functions, and triggers Support SOX compliance, regulatory audits, and database security best practices Data Platform Support Provide operational support for enterprise cloud data platforms, ensuring reliable movement and availability of data, including: Support automated replication processes from relational databases into the Databricks data lake Assist with troubleshooting platform security, networking, connectivity, and access issues Coordinate with vendors and platform providers to resolve infrastructure and platform-related issues Maintain reliable and scalable data platform infrastructure Develop and support backup, recovery, and business continuity strategies for data platforms Identify opportunities to improve platform reliability, automation, scalability, and operational efficiency Collaboration & Stakeholder Support Provide support for data-related technical issues and infrastructure requirements Collaborate with data engineers, data scientists, analysts, infrastructure teams, and business stakeholders to understand operational and data requirements Participate in production support, incident response, and root cause analysis Continuous Improvement & Documentation Monitor platform health and recommend improvements to database and platform performance, reliability, and scalability Identify opportunities to automate manual operational processes Document database environments, platform configurations, operational procedures, data flows, and system architecture to support knowledge sharing and operational continuity Secondary Responsibilities: Data Engineering Support Support the Data Engineering team in building and maintaining data integration solutions as business priorities require, including: Assist with developing and automating ETL workflows to ingest structured and unstructured data from APIs, databases, and third-party systems Support data transformation, cleansing, and loading into cloud-based data lakes and warehouses (Databricks, Azure) Monitor and troubleshoot data pipelines, assisting with performance optimization, scalability, and cost efficiency Contribute to automation initiatives that improve data engineering processes and operational support WHAT YOU WILL BRING TO ARC : A bachelor's degree in computer science or a related field, or equivalent work experience A minimum of 3 years of experience administering Oracle, Postgres, and SQL Server databases in both Windows and Unix/AIX environments Proficiency in SQL, procedural database development (e.g., PL/SQL), Unix scripting A strong understanding of cloud data infrastructure Strong problem-solving skills and the ability to work collaboratively across technical and business teams A commitment to continuous improvement, innovation, and delivering high-quality solutions in a fast-paced and dynamic environment Beneficial, but not required: Proficiency in Python Experience in data engineering and platform development Hands-on experience with Terraform, GitHub Actions, and Azure DevOps for infrastructure management and workflow automation Hands-on experience with Databricks for pipeline development and orchestration REWARDING OPPORTUNITY: An opportunity to be part of delivering responsible energy by developing and growing your career with us Working collaboratively with, and learning from some of the most talented and experienced people in our industry A culture of caring and high performance Focus on health and well-being An environment where all individuals are treated fairly and respectfully, have equal access to opportunities and resources, feel a sense of belonging, and can contribute fully to the organization’s success Meaningful work that makes a difference in the Canadian energy industry We are pleased to share that Shell’s acquisition of ARC Resources Ltd. has now officially closed. This marks an important milestone for both organizations and the beginning of a new chapter together. ARC Resources Ltd. is now a wholly owned subsidiary of Shell and will continue to operate largely as a standalone business for a period of time before fully integrating. We thank you for your interest in ARC, however, only those candidates selected for an interview will be contacted. Accessibility accommodation for applicants is available upon request during the talent acquisition process.
