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 Provide experienced programming for large, complex information systems projects addressing the needs of multipledepartments or functions. Assist lower-level programmer/analysts in assigned projects. Job Description Overview The Programmer Analyst II 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 large multi-department to enterprise scale 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. 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 coordinate 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 Monitor, influence and respond 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 Collaborate 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 1 Thorough knowledge of multiple programming languages, database methodologies/platforms that support application layer processing, service/support and enhancement 2 Knowledge of current Client, Server, Web, Database, Security/Compliance and IT Service Management technologies, systems, software, and integration standards/techniques. 3 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. 4 Demonstrated familiarity with waterfall, agile and other project methodologies. 5 Demonstrated ability to communicating effectively verbally, in writing and in collaborative presentation settings. 6 Demonstrated ability to establish and maintain effective working relationships with customer departments, other IT Service Delivery Manager groups and supporting vendors. 7 Knowledge of multiple programming languages- .NET, Object-Oriented Programming, SQL, etc. 8 Ability to write advanced SQL Queries, Stored Procedures. 9 Knowledge and understand of Scripting Languages such as VBScript. 10 Working knowledge of ITSM/ITIL methodologies for knowledge base build, Application Runbook framing, CMDB, change, release, problem, incident, asset and event management processes. 11 Working knowledge of automated network, server, database, security, CMDB tools and system monitoring tools (NetScout, APP-D, Extra Hop, etc.). 12 Strong analytical skills 13 Ability to write and evaluate new software programs. 14 Ability to solve problems with developing/deploying software technology solutions. 15 Ability to communicate effectively and diplomatically orally and in writing. 16 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 17 Ability to participate in 24x7 support coverage as needed Minimum Qualifications: EDUCATION: Bachelor's degree or higher in engineering, math, computer science, business or information technology related field. EXPERIENCE: Three (3) year experience in Object-Oriented Programming and/or relational database (MS SQL, Oracle PC SQL, Python, UML Framework solutions and/or C or C within Applications), and familiarity with project management utilizing either Waterfall or Agile Methodologies. EQUIVALENCIES: High school diploma or GED plus seven (7) years of the required experience will meet the education and experience requirements. An associate degree in any field plus five (5) years of the required experience will meet the education and experience requirements. A bachelor's degree or higher in a non-specified field plus five (5) years of the required experience will meet the education and experience requirements. A master's degree or higher in a stated field plus one (1) years of the required 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. Must be able to participate in the 24x7 support coverage as needed. PREFERENCES: Experience with .Net and SQL Server Reporting Services is a plus. Close Date: April 10, 2024 Salary Range $70,080.75 - $87,600.94 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. 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. Questions? Contact our recruiting departments: Civil Service - civilserviceinfo@dallascityhall.com Talent - Acquisition hrtalent@dallas.gov