· University Degree; or Higher Secondary education and completed higher vocational training leading to a formal technical or professional certification with 2 years’ post related experience; or a Secondary education and completed advanced vocational training leading to a professional qualification or professional accreditation in database administration with 4 years’ business area related experience
· The above education requirements may be waived if a prospective incumbent can demonstrate a minimum of 3 years’ experience in the last five years in the administration of the current HRDS software suite, including APMS, ERT, NPMS, and NSTEP
· 1+ year of experience in the last five years as an application administrator of ACO’s current HRDS software application suite including APMS, another similar Allocate Defence Suite implementation, or similar enterprise-level human resources database application; AMIS, another similar manage ID implementation, or another enterprise-level card management application; NSTEP or another enterprise-level entitlements management application; and ERT or another enterprise-level job description management tool
· 2+ years’ experience in the last five years as an MS SQL developer or programmer working with MS SQL 2016 or later to develop SQL objects including tables, views, and all forms of programmability objects. Experience must include using SQL Server Management Studio (SSMS) and Power Shell scripts, and should also include SQL Job development. Note: this is not necessarily database administrator experience
· 2+ years’ experience in the last five years as a Report Developer using Microsoft SQL Report Services (SSRS) or Power BI Report Server (PBRS) to design static and/or dynamic reports to extract information from multiple databases on different servers/clusters
· 2+ year’s total experience in the last five years performing Quality Assurance functions, e.g., defining, collecting, and refining user requirements related to database operations and testing solutions developed for these requirements. Note: These experiences may be additive from multiple jobs
· 1+ year of experience in the last five years as an Azure Dev Ops User for requirements management, project management, and testing

DUTIES/ROLE:
· Support administration of the HRDS applications, e.g., make functional changes based on customer needs and functionality granted (response time is within 1 hour and 3 days)
· Provide expert database advice in support of the centralised Helpdesk and on-site assistance to HRDS users (response time is within 1 and 3 days)
· Perform database management for the HRDS systems, including back-up procedures and integrity checking (monthly highlight report)
· Develop and generate Microsoft SQL database queries, scripts, functions, stored procedures, and jobs in support of data management efforts on behalf of the NATO-wide HRDS user community (response time is within 1 and 3 days)
· Develop and generate database queries and reports in support of NATO-wide HRDS user community (response time is within 1 and 3 days)
· Support the data administration of the HRDS applications and interfaces (response time is within 1 and 3 days)
· Support the HRD branch in the collection of user requirements and the formulation of requirements and specifications in relation to workflows, database operations, and related functionality (response time is within 1 and 3 days)
· Develop and administer SQL Reporting Services reports and Power BI report server (not the Power BI service) static and dynamic reports (response time is within 1 and 3 days)
· Operate and monitor deployed SQL objects, Power Shell scripts, and other automation objects to ensure that ad hoc and routine data management tasks run successfully (response time is within 0.5 days)
· Support testing of the HRDS applications’ changes in the development, testing, and validation environments (response time is within 1 and 3 days)
· Advise and support the HRDS Accounts managers related applications permissions (on demand, response time is within 1 and 3 days)
· Conduct regular audits of HRDS applications data and accounts to ensure data quality and usage (monthly audit reports)
· Assist the IT service provider with any independent validation and verification testing requirements for the HRDS applications including, but not limited to, installation, configuration, and functional testing (response time is within 1 and 3 days)
· Assist the branch’s data protection team by conducting forensic analysis on the HRDS applications’ datasets and transaction logs, and producing reports to support protection of Personal Data held in the applications and interface databases (monthly reports, as required).es and as directed by the COTR.)