Cloud Database Administrator

ATCO; Calgary; On-site; CAD 75,000 - 95,000; Full time

Job summary

A diversified global corporation is seeking a Cloud Database Administrator to manage and optimize their database systems. This role requires expertise in Oracle and SQL Server with responsibilities including monitoring, maintenance, and collaboration with support teams to ensure peak performance. The ideal candidate has 3 years of relevant experience and a strong understanding of high availability and disaster recovery practices. Competitive compensation and professional development opportunities are offered.

Benefits

Competitive compensation

Flex benefits

Tuition assistance program

Training and mentorship programs

Qualifications

• 3 years of Database Administrator experience including installation, configuration, and administration.
• Ability to provide rotational on-call support approximately once every five weeks.
• Excellent problem-solving and troubleshooting skills.

Responsibilities

• Monitor database health, oversee maintenance and backups.
• Implement recommendations and new solutions for system reliability and efficiency.
• Collaborate closely with infrastructure and application support teams.

Skills

Oracle Database

SQL Server

Troubleshooting

High Availability

Databases

Database Administration

Disaster Recovery

Database Design

Education

Post-secondary education in a related field

Tools

Oracle Cloud Infrastructure

Linux

Windows

SQL and PL/SQL

Git / Bitbucket

Job description

Description

Why Work Here

Employees at ATCO are offered endless variety. We are entrepreneurial with a large degree of autonomy and freedom experiencing new situations and learning opportunities every day. Internal advancement is commonplace and we are always supported in our career journey. We believe in creating a workplace where you can thrive professionally while contributing to something greater and serving our communities.

About the Role

The Cloud Database Administrator is a key contributor to the management and optimization of our database systems ensuring peak performance data integrity and availability across ATCO's multi-cloud and select on-premises environments. Serving as a subject matter expert this role supports both operations and project teams collaborating closely with the 24x7 infrastructure and application support teams.

In this capacity the Cloud Database Administrator proactively monitors database health, oversees maintenance and backups, and responds to operational events. They drive continuous improvement by implementing recommendations and new solutions that enhance system reliability and efficiency.

Leveraging deep expertise in Oracle and SQL Server cloud database systems the Cloud Database Administrator focuses on delivering high availability, resiliency and performance. Their responsibilities span operations design and solutioning ensuring robust and scalable database environments that meet business needs.

What You Get to Do

• Maintain expertise in relevant database technologies and implement high-quality solutions for business and application teams
• Work independently on projects delivering results on time
• Ensure standards and best practices are documented and incorporated into repeatable processes and automation
• Proactively monitor databases to prevent issues and respond quickly to cloud-related requests and incidents
• Collaborate with team members on technical decisions and escalate operational or project risks as needed
• Manage all databases and cloud platforms; assist in root cause analysis and recommend preventive actions for future incidents

Documentation

• Review and ensure existing ATCO database technical documentation is complete and up to date and provide recommendations to Database Manager
• Review vendor-provided system documentation including database solution architecture and system manuals to ensure alignment to business & technical requirements and review with Database Manager as necessary

Planning and Requirements

• Support ATCO initiatives as new or enhanced database solutions / projects are being considered
• Translate business requirements into ATCO database technical requirements and / or solutions
• Contribute to the formulation and definition of system scope and objectives based on operational or project requirements as they relate to ATCO database infrastructure
• Work closely with application and business teams for successful planning of database requirements
• Participate in ATCO database solution design with the Database Technical Lead to ensure completeness of technical scope and implementation

Research and Technical Evaluation

• Keep abreast of new and emerging database and cloud technologies and / or service offerings
• Maintain knowledge of database technology products in ATCO environment
• Sustain a strong understanding of the overall ATCO database architecture and of the technology products in the ATCO cloud environment to understand the issues and implications of proposed cloud system and hardware solutions

Security

• Maintain an understanding of ATCO Security practices and ensure that the database area is always compliant
• Review databases and cloud security alerts / dashboards to quickly fix any security risks
• Recommend continuous improvement opportunities in all the relevant areas of security

What You Bring

• Post-secondary education in a related field with a preference in IT
• 3 years of Database Administrator experience including installation configuration and administration
• Oracle Database and SQL Server experience
• Ability to provide rotational on-call support approximately once every five weeks
• Excellent problem-solving and troubleshooting skills
• Ability to work effectively in a team and communicate technical concepts to non-technical stakeholders
• Experience in implementing high availability and resiliency for database systems
• Prior use of any of the following are considered assets:

Linux & Windows Operating Systems

• SQL and PL/SQL programming
• Git / Bitbucket
• Database Security Encryption and Audit
• Goldengate
• Oracle Enterprise Manager or similar
• Experience with Oracle Cloud Infrastructure (database access and security) or another cloud provider
• Oracle certification (e.g. Oracle Certified Professional)
• Experience / Certification in Azure Cloud
• A general understanding of MySQL and Postgres

What We Offer

• A culture based on caring integrity agility collaboration and striving for excellence
• Competitive compensation
• Flex benefits
• Tuition assistance program
• Training and mentorship programs
• Charitable donation matching

We would like to thank everyone for their application; however only those being considered for an interview will be contacted.

ATCO delivers inspired solutions for a better world. We are a diversified global corporation with investments in the essential services of Structures & Logistics Utilities Energy Infrastructure Retail Energy Transportation and Commercial Real Estate. Learn more about how we build communities energize industries and deliver customer-focused solutions like no other company in the world at . ATCO is proud to be an equal opportunity employer. Visit our website for more information.

In the spirit of reconciliation we acknowledge the traditional territories and homelands on which many of our ATCO operations and facilities are located. We honour and respect the diverse history languages ceremonies and culture of the Indigenous Peoples who call these areas home.

Required Experience

Unclear

Key Skills

Databases, Disaster Recovery, SQL, High Availability, Microsoft SQL Server, ssrs, Database Design, Performance Tuning, SSIS, Database Administration, Sybase, Oracle

Employment Type

Full-Time

Experience

years

Vacancy

1