Senior Database and Software Developer Associate- ACDMS

Established in 1951, IOM is a Related Organization of the United Nations, and as the leading UN agency in the field of migration, works closely with governmental, intergovernmental and non-governmental partners. IOM is dedicated to promoting humane and orderly migration for the benefit of all. It does so by providing services and advice to governments and migrants.

Context: 

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 andanalysis. 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.

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

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

SKILLS

Advanced working knowledge of relational database concepts and SQL; experience with PostgreSQL, Microsoft SQL Server, MySQL or comparable platforms; Proficiency in at least one relevant application-development stack, such as .NET, Java, PHP, Python or a comparable server-side framework, together with JavaScript or a comparable client-side technology; Knowledge of API design, systems integration, data transformation and structured interchange formats; Working knowledge of Git or a comparable version-control system and collaborative development workflows; Ability to interpret approved business and functional requirements and translate them into effective technical solutions; Knowledge of secure coding, database security, access control, audit logging, data protection and information-security principles; Ability to diagnose complex technical problems, document findings and implement reliable solutions in a controlled environment; Good technical writing, communication, planning and knowledge-transfer skills; and, Ability to work collaboratively with programme, information management and ICT colleagues while maintaining clear technical accountability.

Languages

For all Applicants, fluency in English is required (oral and written). Working knowledge of Pashto or Dari is required. Fluency in all national language(s) are highly advantages. Note: Qualified female candidates are highly encouraged to apply.

Required Competencies

Values

Inclusion and respect for diversity: respect promotes individual and cultural differences; encourages diversity and inclusion wherever possible.

Integrity and transparency: maintains high ethical standards and acts in a manner consistent with organizational principles/rules and standards of conduct.

Professionalism: demonstrates ability to work in a composed, competent and committed manner and exercises careful judgment in meeting day-to-day challenges.

Core Competencies – behavioural indicators level 1

Teamwork: develops and promotes effective collaboration within and across units to achieve shared goals and optimize results.

Delivering results: produces and delivers quality results in a service-oriented and timely manner; is action oriented and committed to achieving agreed outcomes.

Managing and sharing knowledge: continuously seeks to learn, share knowledge and innovate.

Accountability: takes ownership for achieving the Organization’s priorities and assumes responsibility for own action and delegated work.

Communication: encourages and contributes to clear and open communication; explains complex matters in an informative, inspiring and motivational way.

Other: Any offer made to the candidate in relation to this vacancy notice is subject to funding confirmation.

• 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.
• 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.
• 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.
• 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.
• Analyse and optimise 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.
• 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.
• 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.
• 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
• 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.
• 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.
• 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.
• 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.
• Perform such other relevant duties as may be assigned.

How to apply

Interested candidates are required to apply through the below online Form. Also, please take note that IOM does not accept applications in hard copies.

Before filling up the online Form, the candidate must carefully read the advertisement. Please proceed to fill the online form only if you meet the minimum requirements stipulated in the advertisement.

Applicants are advised to fill in all mandatory fields otherwise they will not be able to submit the application and should fill their correct and active e-mail address in the online application as any correspondence will be made by IOM through e-mail only.

Applicants are advised to submit only one application for a particular post. The indicated requirements, qualifications and experience are the minimum and the mere possession of the same does not entitle candidates to be called for written assessment or oral interview.

Note: Due to the high volume of applications received, only shortlisted candidates will be contacted by HR department to submit resume and Motivation Letter. Please ensure that the e-mail address and phone number that you will indicate in form is accurate.

If you agree with above, please proceed to the online application form by click HERE.

No Fees: IOM does not charge a fee at any stage of its recruitment process (application, interview, processing, training, or other fee). IOM does not request any information related to bank account

Application destination: https://fa-evlj-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1001/job/23616