Programmer Analyst II (Dallas Water Utilities - Civil Service)

City of Dallas

13h•Onsite

About The Position

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.

Requirements

Thorough knowledge of multiple programming languages, database methodologies/platforms that support application layer processing, service/support and enhancement
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
Bachelor's degree or higher in engineering, math, computer science, Business or Information Technology related field.
Three (3) year 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), and familiarity with project management utilizing either Waterfall or Agile Methodologies to maintain and improve application performance.
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.
Availability to work varying shifts including nights, weekends and/or holidays.
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

Responsibilities

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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Performs any and all other work as needed or assigned.