SQL Developer

eBusiness Solutions Inc.; Nashville (TN); On-site; USD 85,000 - 110,000; Full time

Job summary

eBusiness Solutions Inc. is seeking an SQL Developer for a government domain project based in Nashville, TN. The role focuses on application support for CityWorks, testing, troubleshooting, and assisting business analysis activities including work planning and status reporting.

You will create and modify reports in Crystal Reports, write SQL queries, and coordinate with team members and end users. Experience with SSMS and data extracts from SQL databases is essential for successful delivery.

Qualifications

• Experience with CityWorks configuration and support.
• Experience writing SQL queries to fetch or update data.
• Experience with Crystal reporting and SQL queries.
• Experience coordinating with process owners, users, ITS team, and consultants.
• Experience building and modifying reports in Crystal Reports.
• Experience as systems analyst supporting users with issues resolution and training.

Responsibilities

• 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 including work plan input, deliverable definition and tracking, status reporting, and user meetings.
• Coordinating with process owners, users, departments, ITS technical team, and consultants.
• Data extracts from SQL based on user request 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.

Skills

SQL

Crystal Reports

CityWorks

SSMS

Data extraction

Requirements gathering

Tools

CityWorks

SSMS

Job description

One of our clients in the government domain is seeking an SQL Developer. The role will provide primary application support for CityWorks, perform application testing and troubleshooting, and support business analysis activities including work planning, deliverable tracking, status reporting, and user-level meetings.

Responsibilities:

• 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.