Programmer Analyst III (IT Services-Development Services Support)

Welcome to the City of Dallas The City of Dallas is one of the largest employers in the DFW Metroplex. We offer growth opportunities and a chance to make a difference in our community. What do we offer? A competitive salary, five-year vested pension plan, great benefits package that includes health, vision and dental insurance, pet insurance, tuition reimbursement, qualifying childcare assistance, paid time off and more. Join our diverse workforce and help us in providing excellent service to the residents of Dallas while building a rewarding career. Job Summary Lead a team of programmer/analysts working on large projects/applications for client departments. Responsible for theplanning, administration, operation, programming and evaluation of new systems, existing systems and modificationsto existing systems. Job Description Overview The Programmer Analyst III provides application layer and related integrations readiness through active monitoring of assigned systems, support to related incident and request management processes, and in delivery of experienced programming or technical support in enterprise scale and lesser complex information systems and projects within the City. Works closely with other IT Service Delivery Managers, teams, and vendors (Server, Active Directory, Security, Database, Service Desk, Network, etc.) in optimizing overall and specific performance, compliance, response to issues that emerge and overall readiness in supporting business processes. Works closely with above teams in the successful planning, execution and completion of various projects and initiatives. The Programmer Analyst III leads and oversees a team of programmer analysts working on large projects, applications, or software development for client departments. Plans, administers, operates, programs, and evaluates new systems, existing systems, and modifications to existing systems for the benefit of the City and its departments. Preferences will be unique to each Programmer Analyst III position based upon the team they are a part of and the application alignments assigned. The preferences below apply to a member of the ITS DEV Technology Support Team. Essential Functions 1 Provides application-layer technical subject matter expertise in support of assigned/aligned applications through close monitoring of system (application, web, and database) processing and other dependencies to ensure that current operational business processes and application information processing requirements are met, supported, triaged, restored, and enhanced. 2 Proactively coordinates with supporting IT Service Delivery Teams (Server, Network, Security, Service Desk, etc.) and functions to ensure responsive incident, service request/task, problem, change and release management functions in support of assigned/aligned applications; coordinate assembly and orientation of these teams as required to combine and resolve problems. 3 Monitors, influences and responds to IT Service Management queues (incident, support, or service request, change request, etc.) related to assigned/aligned applications to ensure appropriate support, triage, assignment routing and customer service. 4 Writes, modifies, and administers assigned/aligned software applications, programs, and documentation in Admin-Runbooks; tests, debugs, and assists in teaching users/Project Teams in how to use newly developed or refined software; tailors but avoids 'custom coding' in supporting reporting/dash-boarding initiatives to make application systems more user friendly. 5 Collaborates closely with supported operational business department subject matter experts to ensure that operational business processes, data processing, data conversion, data dictionary, data mapping and conversion, integrations, reporting, standards, and dashboard requests are clearly documented and mapped so that any as-is application requests or enhancement requests are clearly understood and actionable by teams. 6 Evaluates and enhances systems and programs to ensure support of documented department business practices, standards, and expectations to maximize processing efficiency of aligned applications; provides troubleshooting support, resolves incidents and supports/addresses service and incident requests within benchmark standards. 7 Performs application-oriented performance, smoke, regression, end-to-end and other testing on assigned aligned applications in as-is to will-be enhancements; creates and runs accompanying testing scripts and scenarios as required; captures this content sufficiently to support Application Change Control/Release Control preparations and processes. Runs and tests software of client departments to detect program problems and improve efficiency; schedules and monitors periodic processing and provides documentation and reporting on functionality, programming, and issues addressed. 8 Assists in evaluations and planning of software and hardware purchases to maintain and enhance the system; prepares cost analysis of maintenance or enhancement of existing programs; develops, creates, and implements workflow solutions to improve end user's daily workflow activity. 9 Reviews the coding and development of vendor provided, peer and lower-level programmer analysts and others as-required for accuracy, efficiency, and skill development; assists in training lower-level programmer analysts in coding, testing, and debugging according to City standards; participates in training webinars and seminars to remain abreast of technology enhancements and changes. 10 Compiles complex ad-hoc reports for client departments, participates in various special projects, and provides analysis and programing support for various business needs within the City. 11 Performs any and all other work as needed or assigned. Knowledge and Skills Thorough and broad knowledge of multiple programming languages, database methodologies/platforms that support application layer processing, service/support and enhancements. Thorough and broad knowledge of current Client, Server, Web, Database, Security/Compliance and IT Service Management technologies, systems, software, and integration standards/techniques. Demonstrated familiarity with physical platforms, virtual platforms, Software as a Service hosted platforms, and common industrial platform services such as Amazon Cloud, Microsoft Azure, etc. Demonstrated familiarity with waterfall, agile and other project methodologies. Demonstrated ability to communicating effectively verbally, in writing and in collaborative presentation settings. Demonstrated ability to establish and maintain effective working relationships with customer departments, other IT Service Delivery Manager groups and supporting vendors. Knowledge of multiple programming languages- .NET, Object-Oriented Programming, SQL, etc. Ability to write advanced SQL Queries, Stored Procedures. Knowledge and understand of Scripting Languages such as VBScript. Working knowledge of ITSM/ITIL methodologies for knowledge base build, Application Runbook framing, CMDB, change, release, problem, incident, asset and event management processes. Working knowledge of automated network, server, database, security, CMDB tools and system monitoring tools (NetScout, APP-D, Extra Hop, etc.). Strong analytical skills Ability to write and evaluate new software programs. Ability to solve problems with developing/deploying software technology solutions. Ability to communicate effectively and diplomatically orally and in writing. Ability to establish and maintain an effective working relationship with all levels of management, city officials, vendors, other government agencies, other employees and the public Ability to participate in 24x7 support coverage as needed Minimum Qualifications Education: Bachelor's degree or higher in engineering, math, computer science, Business Technology, or Information Technology related fields. Experience: Four (4) years' experience in Object-Oriented Programming and/or relational database (JAVA, MS SQL, SQL Server, Oracle PC SQL, Python, UML Framework solutions and C or C++ within Applications), to maintain and improve application performance. Equivalencies: High school diploma or GED plus eight (8) years of the required experience at commercial or enterprise scale levels will meet the education and experience requirements. Associate degree in any field plus six (6) years of the required experience will meet the education and experience requirements. Bachelor's degree or higher in a non-specified field plus six (6) years of the required experience will meet the education and experience requirements. Master's degree or higher in a stated field plus two (2) years of the hands-on technical support experience will meet the education and experience requirements. Other Requirements: No felony or class A misdemeanor convictions No class B misdemeanor convictions within the last ten (10) years No family violence convictions Cannot currently be on any active deferred adjudication for any felony, class A misdemeanor or class B misdemeanor charge. Preferences: Experience with online analytical processing and data mining as a lead programmer, project leader or supervisor is highly desirable. Salary Range $81,127.23 - $101,409.04 The salary listed on this job posting is the starting salary range; amount offered will depend upon qualifications. City of Dallas is an Equal Opportunity Employer and values diversity at all levels of its workforce.