Database Administrator

Government of New Brunswick•NB, NB

11d•CA$67,600 - CA$94,406•Remote

About The Position

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.

Requirements

A university degree in Computer Science.
Minimum of five years of progressive IT industry experience, with at least three years of experience working directly in SQL Server database management is required.
Written and spoken competence in English is required.

Nice To Haves

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.

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.