Position Summary:Under supervision and direction of the Infrastructure & Development Officer, the Programmer & Database Analyst I-IV designs, develops, troubleshoots & supports activities across the entire Systems Development Life Cycle (SDLC) for a variety of AHFC applications.
This is a non-exempt, technical position with no supervisory or management responsibilities.
Telework options are available for this position.
Reports to: IS INFRASTRUCTURE & DEVELOPMENT OFFICER
Examples of Duties- Develop applications that follow modern design principles and are implemented using secure, flexible & scalable methodologies, promote a streamlined, collaborative environment & use efficient work flows while keeping focus on a positive user experience.
- Develop databases that follow modern design principles & are implemented using secure, flexible & scalable methodologies. Support, optimize, secure & analyze problems with databases that may be part of a vendor supplied or in-house application stack.
- Develop secure & scalable applications to replace legacy applications as needed.
- Develop secure data exchange interfaces between applications inside & outside the AHFC environment using modern application design principles.
- Develop & maintain a consistent, high quality, customer focused approach when interacting with AHFC's business partners, clients, customers and other AHFC departments.
- Develop working knowledge of AHFC business practices & processes as well as understanding its goals as a corporation.
- Performs workflow analysis, process mapping, documentation, and workflow implementation.
- Other duties as required.
Knowledge, Skills and Abilities (KSAs)Knowledge:
- Modern application design technologies & trends, with focus on secure application development & efficient code re-use.
- Modern design patterns that focus on rapid development, but still ensure separation between application & database context, in relation to data access.
- Modern database integration patterns that allow disparate applications (vendor supplied & in-house) to exchange data in a secure & efficient manner.
- Modern design patterns that facilitate version control, “Continuous Delivery” development pipelines and high availability;
- Different SDLC’s, such as AGILE, as well as using UML to describe overall design of a system or process.
- N-tier designs using object oriented models.
- Analysis using unit, regression & fuzzing methods.
- Mainstream trends in technology such as virtualization of servers, networking and storage.
- ITIL & ITSM principles and best practices.
Skills:
- Understand and use object oriented software design with primary focus on web applications using Visual Studio and Visual Studio Code tooling.
- Design application solutions using .Net, C#, Angular, TypeScript, JavaScript, AJAX, SOAP, JSON, etc.
- Understand & use Microsoft SSMS, SSRS, SSIS as well as Tableau Server and Desktop.
- Design database solutions using T-SQL, ODBC, etc.
Abilities:
- Understand, identify, and plan for the business process impact of planned or existing system changes while ensuring that new technical requirements are properly integrated with business processes.
- Thrive in an environment where peer review is used to determine viability of a solution or process.
- Perform algorithm analysis against a business process or auditing requirement in search of rational efficiencies.
- Maintain documentation for a solution or process that is in sync with the needs of management, team members & end users.
- Effectively and consistently use an issue tracking system while organizing and prioritizing a constantly changing workload. Must be able to work with minimal supervision and continual interruption. Must be able to function with a high degree of independence within levels of delegated authority.
- Use independent judgment in the research and recommendation of application design decisions before making appropriate recommendations to management, team members and end users.
- Establish and maintain a good working relationship with AHFC personnel, contractors, customers, consultants, suppliers and vendors. Interpersonal skills will be utilized on a daily basis through interaction with a diverse cross-section of people and organizations.
- Read & understand written material, interpret & apply rules. Must be able to write clearly and prepare documents as required by management, team members & end users.
- Continually learn, adapt, and apply new technology skills to stay current with emerging or existing IT archetypes.
- Work as needed.
Maintains the integrity, availability, security, and efficiency of databases. Resolves complex and often conflicting agency requirements.
