Share this Job

Database Analyst (Computer Services Officer 1(A-B) - 2(A-C))

Date: Jan 10, 2019

Location: HALIFAX, NS, CA, B3K 2A6

Company: The Government of Nova Scotia



Apply By: 1/24/2019  


Internal Services 


Database Analyst (Computer Services Officer 1(A-B) - 2(A-C)), Permanent, HALIFAX  


Competition # 17732  



About Us


Do you thrive on new and innovative efforts that make a positive difference in people’s lives?  Are you one who moves beyond the status quo and has a track record of helping organizations adopt new, digital ways of doing business?  Do you want to be a part of a team focused on modernizing government through digital services?  If so, then you will want to be a part of the Province of Nova Scotia’s Database Infrastructure Operations Team. We are looking to recruit the brightest minds when it comes to managing SQL, Oracle and MySQL database infrastructure. Here is your chance to tell us exactly why you are a winning candidate, and why we should hire you. Tell us your story. Explain why you are a winning candidate.


The Information, Communication and Technology (ICT) Services branch of the Department of Internal Services is a leader in client-focused service delivery. This branch is responsible for all Government of Nova Scotia departments, agencies, boards and commissions’ technology services and support as well as supporting the Nova Scotia Health Authority (NSHA) and IWK. Think "ICT Services" if you seek meaningful work and want to create change.


About Our Opportunity


As the Database Analyst, you will provide customer focused tier 1 and 2 technical support services in areas related to SQL, Oracle and MySQL database infrastructure. Your responsibilities will include 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. You play a key role in supporting the core ITIL Service Support processes to ensure consistent level of services to the users.


About You


To be successful in this role, you must have graduated from a recognized Information Technology program.


You have excellent communication (both verbal and written) and interpersonal skills, as well as demonstrated ability to interact effectively with clients, staff, peers and management. You are a team player with strong negotiation and facilitation skills, well organized, capable of prioritizing and undertaking high level work under tight deadlines, and able to exercise sound judgment under pressure. You will be flexible and adaptable to ever changing priorities while demonstrating initiative. 


Relating to MSSQL/Oracle/MySQL (currently supported versions), the following experience or skills will help you in this role:  installation, configuration, operational support, troubleshooting, performing and implementing robust database backup and recovery procedures; managing users, security, tables, indexes and views; monitoring server performance and database health, and taking preventive or corrective actions as required.  You will also have working knowledge of MS Windows Server (currently supported versions) with respect to server installation, configuration and troubleshooting performance.  

The following skills, experience and knowledge would be considered an asset:


  • MS Azure – SQL databases, dashboards
  • SQL Server query performance – monitoring, analysis of execution plans
  • SQL Server Analysis Services – installation, configuration and operational support
  • SQL Server Reporting Services - installation, configuration, operational support
  • SQL Server Replication – log shipping, database mirroring
  • Transact-SQL – database creation, modification, operational support jobs, stored procedures, triggers, complex queries
  • Knowledge of the Government of Nova Scotia IT and Security policies and procedures
  • Knowledge of Nova Scotia Health Authority’s IT and Security policies and procedures
  • Experience working in a health care or public sector environment
  • Understanding of ITIL standards and processes and how they can be used to improve processes, guidelines and standards


Other Considerations


May be required to work outside of normal business hours to provide service and be on-call for supported services, including weekends.



Pay Grade:  PR 01 - PR 11  


Salary Range:  $1,423.22 - $2,570.87 Bi-Weekly


This is a bargaining unit position initially restricted to current civil service employees represented by the Nova Scotia Government Employees Union (NSGEU).



If applying from outside a government office, employees must apply correctly via this link:





Failure to apply correctly means that your application will not be given first consideration as a bargaining unit applicant, and will only be included if external applications are pursued.  



External applicants and current casual employees will only be considered if there are no qualified civil service bargaining unit candidates.


Our goal is to be a diverse workforce that is representative, at all job levels, of the citizens we serve.  The Government of Nova Scotia has an Employment Equity Policy and we welcome applications from Aboriginal People, African Nova Scotians and Other Racially Visible Persons, Persons with Disabilities and Women in occupations or positions where they are under-represented.  If you are a member of one of the equity groups, you are encouraged to self-identify on your electronic application.



Offer of employment is conditional upon the completion of all applicable background checks and confirmation of credentials, the results of which must be satisfactory to the employer.



We thank all applicants for their interest, however, only those selected for an interview will be contacted.  For questions or concerns, please contact



                                                                                   NS Gov Logo 2016 English 3Col 1 (002)                        Diversity English 2   Click here to see how we won!