· An MSc/BSc in Computer Science or related scientific discipline
· 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
· 3+ 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+ years’ experience in the last five years of hands-on experience in Power Shell scripting with a focus on data management and integration, including proficiency in manipulating data and calling application endpoints (APIs) for automation tasks
· 1+ year of experience in the last five years with NATO, International or National military CIS operations and support, as a military, civilian, or contractor staff member
· 6+ months’ experience in the last five years in a position that required use of NATO’s Workforce Policy and Procedures, MC 216/4 (AAP-16) or use of similar international organisation/governmental organisation workforce policy and procedures
· 1+ year of experience in the last five years as an Azure Dev Ops User for requirements management, project management, and testing

DUTIES/ROLE:
· Develop and maintain Microsoft Power Shell scripts with external applications and APIs to facilitate data exchange and process automation, and deploy and integrate in the environment (response time is within 1 and 3 days)
· Develop and maintain Microsoft Power Shell scripts working with Microsoft SQL server, Microsoft Share Point 2013/2019 on premise, and Active Directory (response time is within 1 and 3 days)
· 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)
· 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)
· Participate in discussions and briefings, presenting information and results as required and authorised by HRDS managers. However, the contractor’s personnel may not make any formal commitment on behalf of HRD, SHAPE, ACO or NATO (on demand, as requested by the COTR)