Department: Cyber Security & Digital Solutions
Location: HALIFAX
Type of Employment: Permanent
Union Status: NSGEU - NSPG
Closing Date: 12-Jun-25 (Applications are accepted until 11:59 PM Atlantic Time)

ABOUT US

At the Department of Cyber Security and Digital Solutions (CSDS), we prioritize people and are dedicated to driving digital transformation that meets modern expectations. Our mission is to support government departments and partners in their digital transformation journeys, ensuring that digital services are user-centered, efficient, and impactful for all Nova Scotians.
We don’t just implement digital solutions; we navigate the complexities of digital transformation by modernizing outdated systems and ways of working. Our role is to make a real difference by ensuring that our digital services are accessible and user-friendly.
At CSDS, we celebrate diversity, inclusion, and belonging. We recognize that the people who use government programs and services come from all walks of life, and it’s essential that we reflect the communities we serve. We are committed to creating an environment where diverse perspectives and experiences are valued, and where all talent can thrive. By embracing these values, we deliver better, more accessible, and inclusive public services.

PRIMARY ACCOUNTABILITIES

Under the direction of the senior technical architect (database), your responsibilities will include:

• Provide Tier 1 and some Tier 2 support by troubleshooting, deploying, maintaining, and monitoring MSSQL, Oracle, and MySQL database infrastructure.
• Provide support to mission critical database environments.
• Resolve database incidents and problems in a timely manner.
• Perform database backup and recovery operations and implement robust backup and recovery procedures.
• Manage users, security, tables, indexes, and views within the database systems.
• Monitor server and database health, taking preventive or corrective action as required.

• Support the core ITIL standard and processes to ensure consistent levels of service to users.Collaborate with other operational teams (server, virtualization, storage, etc.) to ensure seamless integration and operation of database systems.

QUALIFICATIONS AND EXPERIENCE

• Graduation from a recognized Information Technology program
• Excellent communication (both verbal and written) and interpersonal skills.
• Demonstrated ability to interact effectively with clients, staff, peers, and management.
• Well-organized and capable of prioritizing and undertaking high-level work under tight deadlines.
• Flexible and adaptable to ever-changing priorities while demonstrating initiative.

Assets:

• Experience supporting enterprise environments with Microsoft SQL (MSSQL) Server, Oracle, or MySQL database implementations
• Familiarity with PostgreSQL, MariaDB, and any relational database management system would be considered as an asset.
• Experience with Oracle Cloud Infrastructure (OCI), or other cloud platforms.

• Knowledge or experience in scripting languages (Shell, Python, PowerShell) and infrastructure automation tools.Experience in the public sectors or other complex, regulated environments.

• Provide Tier 1 and some Tier 2 support by troubleshooting, deploying, maintaining, and monitoring MSSQL, Oracle, and MySQL database infrastructure.
• Provide support to mission critical database environments.
• Resolve database incidents and problems in a timely manner.
• Perform database backup and recovery operations and implement robust backup and recovery procedures.
• Manage users, security, tables, indexes, and views within the database systems.
• Monitor server and database health, taking preventive or corrective action as required.
• Support the core ITIL standard and processes to ensure consistent levels of service to users.Collaborate with other operational teams (server, virtualization, storage, etc.) to ensure seamless integration and operation of database systems