Technical Analyst (Computer Services Officer 1-2)

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.

About Our Opportunity

The Computer Services Officer 1-2 (Technical Analyst) will provide customer-focused Tier 1 and 2 technical support services related to MSSQL, Oracle, and MySQL database infrastructure. This role involves deploying, maintaining, monitoring, troubleshooting, ensuring availability and security of corporate database assets, and resolving database incidents and problems for the Province of Nova Scotia, the Nova Scotia Health Authority, and the IWK.

As a technical analyst within a team of specialists, this position plays a key role in supporting the core ITIL service support processes to ensure providing consistent level of services to the users.

Together, we’re setting new standards for digital public service, delivering resilient solutions that meet today’s needs and anticipate tomorrow’s challenges.

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.
  
  

Equivalency

Applicants relying on education and experience equivalencies must demonstrate such equivalencies in their application.

Benefits

Based on the employment status and union agreement, the Government of Nova Scotia offers its employees a wide range of benefits such as a Defined Benefit Pension Plan, Health, Dental, Life Insurance, General illness, Short and Long Term Disability, Vacation and Employee and Family Assistance Programs.  For information on all our Benefit program offerings, click here: Benefits for government employees.

Other Considerations

You may be required to work outside of normal business hours, including weekends. 

This competition may be used within 4 months to fill similar positions in other areas of Nova Scotia should they become available. 

We recognize that everyone brings different skills and experiences to the table.

If you don’t “check all the boxes”, we encourage you to apply anyway and tell us why you’re the right fit for the job. We value diversity of thought and believe that the best teams are those that bring together people with a range of experiences and perspectives.

What We Offer

• Career development where you have access to career guidance, tools, resources, and ongoing training for every stage of your career
• Engaging workplace: our employees feel valued, respected, connected, and tuned in, we have forward-thinking policies and strategies
• Countless career paths
• Department specific flexible working schedules