Computer Programmer Analyst II

at  City of Alexandria

JOB

Computer Programmer Analyst IIAbout the Department: The Information Technology Services Department is responsible for enterprise technology operations for the City of Alexandria. ITS provides technology services and solutions to City departments to enhance service delivery. ITS aligns its work with City needs by providing leadership, resources, expertise, and products that enable departments to better serve the City’s residents, businesses, and visitors. ITS resources support initiatives funded through the multi-year Information Technology Capital Improvement Plan (IT/CIP) to improve the overall technology landscape. The City of Alexandria’s ITS Department has been a Top Ten National Finalist in the Digital Cities Award program for over the past 19 years. An OverviewThe Information Technology Services department for the City of Alexandria is seeking a Computer Programmer Analyst II (CPA II) for our Enterprise Business Systems Support Division (EBSS). This technical team supports our portfolio of public works software, which includes applications for Permitting, Land Management, Asset Management, Fleet Management, and Recreation Center Management. It also maintains assorted smaller ancillary systems supporting data interfaces or individual departmental needs. The CPA II will be primarily performing system administration and configuration of asset management software packages including day-to-day production support, report writing, troubleshooting, root cause analysis, integration support, and end-user access & security setup. Regular interaction with our end-user subject matter experts is an important characteristic of this position. The selected individual should bring a mix of analytic ability, technical knowledge, and the ability to communicate and coordinate actions within ITS and with external departments and agencies.The OpportunityAs the Computer Programmer Analyst II and an important member of the financial application team, you will: Maintain “commercial off the shelf” (COTS) asset management and other systems including their configuration and support of custom integrations; Provide support during server installations and/or upgrades of software packages, releases, and fixes; Provide tier 2 assistance to our Helpdesk with client PC issues related to the applications; Generally, assist others in the ITS department with support of the applications environment. Support day-to-day production processes of in-house Windows and Web applications.Develop reports for the end users using SSRS and/or Crystal Reports.Perform system administration of systems; Ensure that setup and configuration are current and correct; Maintain workflow templates, and other application- specific objects which contribute to system performance and data integrity.Confer with users to identify requirements and enhancements and develop specifications using business process documentation tools for new and modified small to medium-scaled applications. Analyzes existing and future software needs and makes recommendations to supervisors on methods to enhance productivity.Write documentation for applications and maintain these documents as required, including developing system documentation for assigned projects and in-house programs.Develop and execute test plans for new and adapted systems and identify and correct problems.Provide technical guidance and training to users, ITS Coordinators, Computer Operators, and other staff members.Perform related work as required.Essential Knowledge, Skills, and AbilitiesAn understanding of role-based security and inheritance is essential. This position requires coding and scripting experience using procedural methodologies using Structured Query Language (SQL) and other tools associated with maintaining an enterprise-class application. Some experience with report generation software and tools is needed. A sound understanding of information technology infrastructure components, such as databases, networks, workstations, servers, and firewalls is necessary to assist in problem determination and troubleshooting. Good written and verbal communications skills, good organizational skills, and good analytical skills are necessary to be effective working with end-users and across ITS.

Four Year College Degree; Considerable experience as a Computer Programmer Analyst I or GIS Specialist, or equivalent level and completion of advanced courses in computer science, GIS, or a related field; or any equivalent combination of experience and training which provides the required knowledge, skills and abilities; two to four years demonstrated experience at the intermediate level in the information management and systems environment. Possess a sound working knowledge of, and significant hands-on experience with a high-level programming language, such as C#, Visual Basic, ASP, PL/SQL, or any of the Microsoft.Net development platforms.