Job Description

Service New Brunswick

Database Administrator

(16665) R85-2026/27-131

Open Competition - Pay Band 5

Flexible location within New Brunswick

Working at Service New Brunswick is more than just a job — it’s an opportunity to build a meaningful career.  Guided by our vision of "Excellence in Service Delivery", our teams provide high-quality, innovative public services for customers with a focus on value for all New Brunswickers.  

Known for our people-oriented workplace culture, we foster an environment where innovation, inclusivity, and teamwork are celebrated. We are proud to be recognized as one of  Atlantic Canada's Top Employers for 2026!  

What We Offer

At SNB, our people are at the heart of everything we do. We are:

• Human-Centered: We prioritize well-being and flexibility for our employees.
• Driven by Growth: We invest in your professional development and career advancement.
• Celebrating Excellence: We recognize and reward outstanding contributions.
• United by Purpose: Every project you work on makes a real difference for New Brunswickers.
• Empowered to Decide: We trust our teams to make decisions and innovate boldly.

With offices and locations in most New Brunswick cities and a wide variety of positions and job roles, SNB offers unmatched opportunities for growth and impact, including an employee recognition program, a mentoring program, training & development opportunities, employee townhalls and ongoing leadership development.  

SNB also offers a comprehensive employee benefits package.

Service New Brunswick is seeking an individual to join the Database Administration team within the Cybersecurity and Infrastructure Operations Branch as a SQL Server Database Administrator.

As part of the Technology Services team, the SQL Server Database Administrator reports to the Manager of Database Administration and is responsible for supporting Service New Brunswick’s enterprise SQL Server environments. The role focuses on day-to-day operational support, ensuring the reliability, performance, and availability of SQL Server systems, and contributing to ongoing maintenance, optimization, and modernization initiatives within the Cybersecurity and Infrastructure Operations Branch.

The ideal candidate will have hands-on experience administering SQL Server in an on-premises VMware environment, a solid foundation in database performance tuning and troubleshooting, and a good understanding of operational processes and standards. Experience with database monitoring tools and exposure to emerging cloud technologies will be considered assets.

KEY RESPONSIBILITIES

• Participating in the design and implementation of database solutions to support enterprise applications.
• Supporting database performance tuning, capacity planning, and optimization activities across SQL Server environments.
• Performing routine database administration tasks including installation, configuration, patching, and upgrades.
• Monitoring database systems to ensure performance, availability, and security requirements are met.
• Implementing and maintaining backup and recovery procedures to ensure data integrity and availability.
• Managing database security, including authentication, authorization, and audit controls.
• Providing technical support and troubleshooting for database-related incidents and service requests.
• Developing and maintaining database documentation, standards, and operational procedures.
• Collaborating with Infrastructure teams, Application Support teams, and vendors to deliver stable and reliable services.
• Applying established internal standards, governance, and change management practices in all database administration activities.

ESSENTIAL QUALIFICATIONS:

Education: A university degree in Computer Science.

Experience: Minimum of five years of progressive IT industry experience, with at least of three years of experience working directly in SQL Server database management is required.

Subject to the response to this competition, an equivalent combination of training and experience may be considered.

Written and spoken competence in English is required. Please state your language capability on your application and ensure that preferred language for assessment is clearly identified.  

ASSET QUALIFICATIONS

• Experience with SQL Server in cloud or hybrid environments.
• Microsoft SQL Server–related certifications.
• Experience working with SQL Server monitoring tools (e.g., Idera SQL Diagnostic Manager or similar).
• Experience with VMware virtualization or virtualized SQL Server environments.
• Experience with SQL Server high availability and disaster recovery technologies (e.g., Always On Availability Groups, Failover Cluster Instances, or Replication).
• Experience with PowerShell or other scripting languages.
• Experience with data warehousing or ETL processes.
• Experience with SQL Server licensing concepts and management.

Applicants must clearly demonstrate the essential qualifications to be given further consideration. Resumes should be in chronological order specifying education and employment in months and years including relevant part-time and full-time employment.

OPERATIONAL REQUIREMENTS: 

Some weekday evening and weekend work hours may be required on occasion and candidates must possess a valid driver’s license.

Participation within an on-call rotation after normal business hours will be required. This position may require some travelling within the province.

Candidates will be required to undergo Criminal History Clearance prior to appointment.

BEHAVIOURAL COMPETENCIES: 

• Analytical Thinking/Judgment
• Client Service Orientation
• Conceptual Thinking
• Effective Interactive Communication
• Information Seeking
• Initiative
• Results Orientation
• Teamwork and Cooperation

TECHNICAL COMPETENCIES: 

• Consulting Skills
• Planning and Organizing Skills
• Specialized Subject Matter Expertise and Knowledge

Salary $67, 600 to 94,406 annually – Pay Band 5 - Management and Non-Union Pay Plan

We encourage applicants to apply online  before July 1, 2026 indicating competition number  (16665) R85-2026/27-131.

In the unlikely event that you experience technical difficulties or are unable to complete your application online, contact PC@snb.ca

We thank all those who apply, however only those selected for further consideration will be contacted.

This competition may be used to fill future vacancies at the same level within the same work location.

Candidates registered with the  Equal Employment Opportunity Program and veterans, who demonstrate they are among the most qualified, shall be given preference at the time of appointment.