Job Description
Job DescriptionTitle: SQL Developer
Location: Nashville, TN(Hybrid)
Duration: 6+ Months
Interview type: Webcam & In Person
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.
Skills:
- SQL
- Communication skills both verbal and written
- Learning ability
- Software Troubleshooting
- Team work
- Crystal Reports
- MicrosoftOffice