Senior Database and Software Developer Associate – ACDMS

Under the overall supervision of the Senior Programme Coordinator (DTM) and the direct supervision of the National Information Management and Database Officer – ACDMS, and the technical supervision of the Database and Information Management Officer, the Senior Database and Software Developer Associate – ACDMS will be responsible and accountable for being the technical focal point for the database and application layers of the Afghanistan Centralised Database Management System (ACDMS). The role will support in the development, maintenance, integration, performance and operational reliability of the system. The incumbent will work closely with the ACDMS team, programme information management focal points, Information and Communications Technology (ICT) and other relevant units, and will work within agreed priorities and escalates only policy, strategic or exceptional matters.

ACDMS is a Country Office (CO)-wide institutional data management initiative intended to provide a centrally governed, secure, scalable and interoperable platform supporting beneficiary and service records, programme and project management, document management, referrals and case management, needs and assessments, monitoring and evaluation, audit functions, reporting and analysis. The platform is intended to reduce fragmented systems and duplication while strengthening data quality, accountability, information security and evidence-informed decision-making.

The position will translate approved functional specifications into reliable database structures, application components, Application Programming Interfaces (APIs), integrations, automated reports and technical documentation. Programme ownership, business-rule validation and prioritisation remain with the relevant programme management structures, while technical architecture, database standards and information management compliance will be guided by the Database and Information Management Officer.

• 1.Develop, configure, maintain and support in the design of relational database structures, schemas, tables, views, functions, procedures and data models required for ACDMS modules. Apply approved naming conventions, data dictionaries, metadata and reference-data standards, and maintain technical consistency across development, testing and production environments.
  2.Lead the configuration, maintainance and enhancement of secure web-based ACDMS applications and modules in accordance with approved functional and technical specifications to produce clean, documented and maintainable code, resolve defects, implement approved changes and steer controlled application upgrades and releases.
  3.Develop and maintain approved application programming interfaces, data exchange services and integration routines connecting ACDMS modules with authorised internal or external systems. Conduct secure data migration, import, export, synchronisation and transformation processes with validation and reconciliation of migrated data.
  4.Administer application source code, database scripts and related technical assets in approved version-control repositories applying agreed branching, peer-review, change-control, build and deployment practices, and maintain traceability between releases, approved requirements, test results and technical documentation.timise database queries, application components and reporting processes to improve performance, reliability and scalability. Undertake routine technical maintenance, identify emerging capacity or performance issues, and recommend technical improvements or implement approved corrective actions in coordination with the Database and Information Management Officer and ICT.
  6.Implement and verify approved authentication, authorisation, role-based access, encryption, logging and audit-control requirements, apply secure coding and database practices, promptly document and escalate identified vulnerabilities or privacy risks, to uphold technical compliance with IOM information security and data protection requirements.
  7.Prepare and conduct unit, integration, regression, performance and technical tests, document results and defects, support user acceptance testing led by the National Information Management and Database Officer – ACDMS, and verify approved acceptance criteria and release-readiness requirements before deployment.
  8.Build and maintain approved automated reports, extracts, data services, dashboards and interfaces with business-intelligence or visualisation tools, document calculations, filters, data refresh routines and technical definitions, and align them with validated programme and information management requirements
  9.Implement and test approved backup, restoration, disaster-recovery and business-continuity arrangements for ACDMS databases and applications, and maintain configuration records and technical recovery documentation in coordination with ICT and the Database and Information Management Officer.
  10.Provide second-line technical support for ACDMS, diagnose and resolve application, database, integration and performance incidents, maintain clear incident and change records, and escalate issues requiring infrastructure, security, vendor or management action through the established channels.
  11.Maintain and develop system architecture records, database diagrams, data models, API documentation, deployment instructions, configuration registers, release notes, code documentation and troubleshooting guides to facilitate structured knowledge transfer to other technical personnel and contribute to relevant technical training and user guidance.12.
  Coordinate day-to-day technical work with the direct supervisor, the Database and Information Management Officer, ICT and assigned developers or assistants, provide technical guidance, code and database review, assign technical tasks, review outputs and support knowledge transfer and technical development of assigned personnel to foster aligned, quality-assured technical delivery and developed team capability.
  13.Perform such other relevant duties as may be assigned.

EDUCATION

• 
  •Bachelor’s degree in Computer Science, Software Engineering, Information Technology, Information Systems, Database Administration or a related field from an accredited academic institution with five years of relevant professional experience; or,
  •High School diploma with seven years of relevant professional experience.

EXPERIENCE

1. Progressively responsible experience in database design, software or web application development, systems integration and technical support;
2. Experience developing and maintaining web-based applications using one or more established server-side and client-side programming languages or frameworks;
3. Experience developing or consuming RESTful APIs, web services or other data-integration mechanisms;
4. Experience using version-control platforms and structured software development, testing, release and change-management practices;
5. Experience implementing authentication, authorisation, role-based access, logging and other application or database security controls;
6. Experience with data migration, data validation, performance tuning, troubleshooting and production support; and,
7. Experience developing automated reports, dashboards or data services for business-intelligence and visualisation platforms is an advantage.