What are the responsibilities and job description for the Enterprise Systems & Application Development Manager position at City of Rockville?
This position is responsible for performing complex professional and difficult administrative work providing enterprise application management and support and supervising the members of the IT Application Team. Systems consist of financial, procurement, human resources, GIS, asset management and other various enterprise software systems. The incumbent provides enterprise systems management and support, including planning, installation, configuration, operations, project management and maintenance of systems as well as application migration from on-premise to cloud.
The incumbent provides business process implementation for enterprise systems, systems programming and database administration, system-to-system interface design and development, and oversees technical support for new and existing applications. The incumbent also ensures that requirements analysis, specifications, programming, documentation, and testing are completed correctly, on time, and according to established standards.
The work requires a proactive approach to ensure the applications meet the needs of a wide range of users across a wide range of service areas and expertise, in a rapidly expanding municipal government environment. Communication, teamwork and customer service skills are required. Assignments, tasks and projects are performed under direction of the Chief Information Officer and Deputy Chief Information Officer. The work has serious impact on the objectives of multiple departments and the work of the City as a whole. The incumbent is required to be on call and to perform other duties as required.
Team Supervisor Functions
Manages the daily operations of a 4 person team of systems analysts, data analysts and application developers. Distributes workload as appropriate to each team member.
Develops Application Team strategy and goals in line with the overall IT strategy, goals and direction of the CIO & DCIO.
Works with each team member to develop individual goals and performance reviews.
Provides opportunities for team member growth and skill development in line with the needs of the information Technology department and the City.
Systems Implementation Job Functions
Design, develop and manage the City's enterprise system roadmap to best support the City's departments and staff members.
Develop a strategic plan for systems including staging of add-on technologies, data cleansing and data governance activities. Lead business analysis for new functionality to drive business process improvement, achieve value, and enable efficiencies in operations.
Serve as the subject matter expert on development and integration tool sets and practices for enterprise solutions; provide expert guidance to the team on best practices, standardization and documentation; provide guidelines to ensure consistent user experiences; review and contribute to application documentation.
Partner with IT Enterprise Project Manager to control and manage ERP efforts with an end result orientation, including all project phases/tasks as applicable to the project size; coordinate with vendor project managers responsible for implementation as well as other product managers involved.
Manage integration testing and system testing of new development work as assigned.
Work with system vendors from product evaluation and procurement, through implementation, testing, production and maintenance.
Systems Analyst Job Functions
Coordinate enterprise application-related project initiatives across multiple City departments. Drive digital transformation initiatives and integrate system processes with business processes citywide to enhance efficiency and improve services to customers.
Serve as the liaison between business process owners and the IT Department. Act as a trusted advisor to the City of Rockville business process owners and business operations.
Understand customer requirements and the impact of system issues; meet with internal customers regularly and establish priorities by working with internal customers and end-users; work closely with the team to deliver high-quality customer support.
Incorporate business process workflows into application functionality. Provide assistance in system report design and generation. Provide scripting assistance to support system automation.
Assist end-users with problems encountered in the use of applications software.
Schedule and lead project meetings, facilitate meetings for other departments, provide status updates following established processes, gather and document requirements from business owners, update project lists and timelines.
Provide regular written and verbal project communication, including updates to City leadership as required. Effectively lead diverse groups of stakeholders through a decision-making process to reach consensus on process changes.
Systems Administration Job Functions
Serve as technical project lead, systems manager, and vendor liaison for systems involving implementation, upgrades, and maintenance of applications, databases, middleware, mobile devices, interfaces, and servers.
Perform administration of servers hosting and supporting enterprise systems, databases, and applications.
Report regularly on the status of identified risks and issues.
Oversee business continuity and disaster recovery design, planning and implementation for enterprise systems. Develop procedures, programs and documentation for backup and restoration of enterprise applications.
Define, implement and maintain interfaces to provide integration among application modules and with other systems.
Control, troubleshoot and manage production and software system issues in a timely manner with internal and vendor personnel. Review system-related logs and history files for abnormalities, triage issues; conduct detailed impact analysis, root cause analysis, and downstream effects of modifications; Determine most effective way to operationalize fixes.
Ensure that records of system downtime and equipment inventory are properly maintained. Maintain and documents system configuration, accounts and user profiles.
Monitor system performance.
Conduct installation of new software releases and system upgrades, evaluate and install patches, conducting database migrations, refreshes, and restores.
Perform database administration, maintenance and tuning.
Administer systems security measures to protect data, software, and hardware.
Set user profiles, reset passwords, disable and enable user accounts; grant users access to authorized information.
Draft Requests for Proposals, Requests for Information and other appropriate specifications for application and system software and utilities or related equipment.
Participate in the preparation of the IT department annual budget.
- Participate in Mayor and Council meetings as necessary.
Bachelor's degree with major coursework in computer science or closely related field from an accredited university or college; and five (5) to seven (7) years of progressively responsible work in software system administration and analysis with ERP applications, databases and servers; or an equivalent combination of education, training and experience that provides the required knowledge, skills and abilities. At least one (1) year of formal IT supervisory experience or at least (3) years of experience in an IT team leadership role.
Knowledge of artificial intelligence and machine learning (AI & ML).
Knowledge of data warehouses, data lakes and data repositories.
Knowledge of business practices and operations in order to anticipate user technology needs.
Knowledge of principles and methods used to identify business requirements and to analyze and design technology solutions that meet those requirements.
Knowledge of enterprise application functionality, system requirements, and alternatives to configure or customize applications to meet business needs and translate business requirements into functional requirements.
Skill in comparing business processes to ERP best practices.
Skill in facilitating requirement meetings and in accurately compiling and managing requirements, issues and associated team action items.
Skill in clearly communicating complex technical information to non-technical audiences.
Knowledge of ERP database management systems, applications, and database components (tables, rows, etc.).
Knowledge of Structured Query Language (SQL) in order to query data for problem solving, to create ad hoc reports, and to repair data in the database.
Knowledge of the principles and methods of web technologies, tools and delivery systems for web-based and mobile applications of ERP.
Skill in troubleshooting production issues and in the use of troubleshooting and trace tools.
Knowledge of Project Management tools, such as Microsoft Project, PowerPoint, Visio, Word and Excel.
Knowledge of Windows Server administration.
Knowledge of database administration with MS SQL Server, and technical administration of web resources.
Knowledge of Windows Server security and SQL Server security.
Familiarity with data warehouse and report writing environments.
Ability to select tools which best satisfy the needs of the City.
Ability to resolve differing user priorities, needs and schedules among a variety of internal customers with different technology skill sets.
Ability to understand hardware and software concepts, computer security, data management, systems analysis and design, and programming techniques.
Knowledge of enterprise asset management systems.
Knowledge of customer relationship management, or “311” systems used in a municipal government environment.
- Knowledge of permitting and land management systems used in a municipal government environment.
Salary : $107,629 - $177,587