Job ID: TN-66391
Hybrid/Local SQL Developer with SSMS, Crystal Reports, CityWorks/Land Management Data, QA/BA/PM and training experience
Location: Nashville, TN (TN Metro-ITS)
Duration: 12 Months
Skills:
Skills Languages SQL Writing SQL scripts using SSMS Proficient (4-6 Years) Yes
Skills Others Communication skills both verbal and written Proficient (4-6 Years) Yes
Skills Others Learning ability Proficient (4-6 Years) Yes
Skills Others Software Troubleshooting Novice (1-3 Years) Yes
Skills Others Team work Proficient (4-6 Years) Yes
Skills Tools Crystal Reports Proficient (4-6 Years) Yes
Skills Tools Microsoft Office Proficient (4-6 Years) Yes
Job Description:
Providing primary application support for CityWorks which is being used by a select group of general government departments.
Performing application testing (test plans/cases and execution) and troubleshooting for all CityWorks and related systems and applications.
Performing business analysis activities for enterprise-wide application such as: work plan input, deliverable definition and tracking, status reporting, conducting user level meetings.
Report or form creation/modification in Crystal Reports and SQL queries using Cityworks and Land Management data.
Performing project analysis activities for enterprise-wide application projects such as: work plan input, deliverable definition and tracking, status reporting, conducting user level meetings, and preparing application requirements/specifications.
Coordinating and communicating with other team members including process owners, users, departments, ITS technical team, and consultants.
Data extracts from SQL based on user request and/or public request
Experience with CityWorks configuration and support, Crystal reporting, and SQL queries
Experience with SQL Server Management Studio (SSMS)
Experience writing SQL queries to update or extract data from a SQL database
Experience as systems analyst, supporting users with issues resolution, system enhancement, upgrades and conversion.
Experience coordinating and conducting end-user training including preparing and updating training materials. As part of an implementation training rollout a plus.
Experience with Microsoft Office Suite.