Database Administrator

Assomption; City of Moncton; Hybrid; CAD 85,000 - 115,000; Full time

Benefits offered by this job

Comprehensive benefits

Bonus

Pension

Volunteer day

Family-pet leave

Job summary

Assomption in Moncton, NB is seeking a Database Administrator to ensure the availability, security, and evolution of our data platforms while supporting critical systems and growth initiatives.

You will work across SQL Server and Oracle, implement high availability, backups, and disaster recovery, and drive automation with PowerShell and CI/CD pipelines, collaborating with cross-functional teams to deliver robust data solutions.

Qualifications

• Bachelor's degree or equivalent experience.
• 5+ years of database administration experience with SQL Server and Oracle.

Responsibilities

• Ensure the administration, performance, and availability of SQL Server and Oracle environments.
• Maintain backup, security, high availability, and disaster recovery processes.
• Automate and optimize operations, focusing on reliability and resilience of data platforms.
• Collaborate with infrastructure, development, security, and data teams on projects and evolution of technology solutions.
• Serve as a technical expert in database management, performance, and architecture.

Skills

SQL Server

Oracle

AlwaysOn / High Availability

Backup & Disaster Recovery

Performance Tuning

Database Architecture

Azure / Hybrid Cloud

Windows Server

Automation (PowerShell)

CI/CD

DevOps / IaC

Monitoring & Observability

Data Security

Cross-functional Collaboration

Education

Bachelor's degree in computer science, information systems, or related field

Job description

Data is at the heart of our operations and decision-making. As a Database Administrator, you will play a key role in ensuring the reliability, security, and evolution of the platforms that support our critical systems and drive our growth ambitions.

Purpose of the Role

Ensure the availability, performance, security, and resilience of the organization's data platforms while serving as a technical expert in their management, optimization, and ongoing evolution.

Qualifications

Education & Experience

• Bachelor's degree in computer science, information systems, or a related field, or equivalent experience.
• 5+ years of experience in database administration, including strong expertise in SQL Server and hands-on experience with Oracle.

Technical Skills

• SQL Server (expert level) and Oracle (operational level).
• Experience with high availability (AlwaysOn, clustering), backup, advanced recovery, and disaster recovery testing.
• Solid understanding of performance tuning, indexing, and database architecture.
• Knowledge of Azure, hybrid cloud, and Windows Server environments.
• Automation (PowerShell, SQL scripting, CI/CD pipelines).
• Familiarity with DevOps and Infrastructure as Code (IaC).
• Monitoring and observability of data environments.
• Management of multi-platform and multi-system environments.
• Data security (encryption, access management, auditing).
• Excellent skills in solving complex problems and troubleshooting.
• Clear communication and the ability to explain technical concepts in layman's terms to a variety of stakeholders.
• Effective collaboration with cross-functional teams (development, infrastructure, security, BI).
• Priority management and the ability to handle pressure and emergency situations in a 24/7 production environment.

Responsibilities

• Ensure the administration, performance, and availability of SQL Server and Oracle database environments.
• Maintain backup, security, high-availability, and disaster recovery mechanisms to protect data and support business continuity.
• Automate and optimize operations to improve the efficiency, reliability, and resilience of data platforms.
• Collaborate with infrastructure, development, security, and data teams on project implementation and the evolution of technology solutions.
• Serve as a technical expert in database management, performance, and architecture.

Additional Information

• The chance to be part of a dynamic, high-performing team that adheres to the following ethical values: leadership, collaboration, trust and commitment;
• Training and development opportunities;
• A comprehensive benefits package including a competitive salary, bonus, pension and benefits;
• A dynamic location in downtown Moncton;
• A paid volunteer day;
• Time off to care for family members and pets.