Developer-Reporting Specialist

City of Galveston; United States; On-site; USD 80,000 - 100,000; Full time

Job summary

The City of Galveston is seeking an experienced database developer and programmer to support various application initiatives and database administration tasks. Responsibilities include providing SQL Server administration, creating complex reports, leading software integration projects, and developing GIS applications using ESRI technologies.

Qualified candidates should hold a Bachelor’s Degree in Computer Science or a related field, with at least eight years of experience in database development and programming. CJIS certification is also required. This position plays a key role in ensuring efficient information technology support and functionality across city operations.

Qualifications

• 8 years’ experience in database development/administration and programming.
• CJIS certification.

Responsibilities

• Provide SQL Server database administration services.
• Develop complex custom reports and applications.
• Assist with new product rollouts.
• Create GIS applications utilizing ESRI APIs and SDKs.

Skills

Database administration

SQL programming

Technical documentation

GIS applications

Problem-solving

Education

Bachelor’s Degree in Computer Science or related field

Tools

SQL Server

ArcGIS

Job description

Job Overview

Under general supervision, this role provides report writing, database administration, scripting, and programming support within the City and performs other duties as assigned.

Responsibilities

• Provide counsel and guidance to City staff regarding information technology software support, including database analysis, reporting, and programming.
• Provide SQL Server database administration services for SQL Server databases.
• Create custom database stored procedures, triggers, views, and complex queries in SQL.
• Develop complex custom reports using a variety of reporting tools and schedule those for delivery.
• Lead initiatives for integrations and APIs between applications.
• Provide software solutions in the form of reports and applications.
• Assist with new product rollouts by reviewing existing custom and standard reporting and modifying or creating new reports.
• Create custom tools as needed in support of business units, such as web-based applications or integrations with new software.
• Design, test, install, and implement various systems.
• Plan, test, and install application software and database updates.
• Work with end-users and application support staff to define needs and provide enhancements to city workflows and software systems.
• Design, develop, and implement needed application software customizations.
• Interpret written business requirements and technical specification documents to design and develop technical solutions.
• Develop technical design documents and test scripts.
• Extract and import client data during software migration efforts.
• Provide application support focused on research, remediation, and documentation of complex application and technical support issues.
• Research solutions for existing problems and gather information on new technologies.
• Perform various special projects and assignments.
• Design, develop, test, deploy, and maintain custom GIS applications utilizing ESRI APIs and SDKs.
• Develop web-based mapping applications using ArcGIS Maps SDK for JavaScript, ArcGIS REST API, ArcGIS Experience Builder, ArcGIS Web AppBuilder, and ArcGIS Instant Apps.
• Create custom widgets, tools, and extensions for ArcGIS applications.
• Develop mobile GIS applications utilizing ESRI mobile technologies.
• Be available to work in order to provide for the safety and well-being of the general public in the event of an emergency.

Knowledge

• City organization, operations, policies, and procedures.
• Principles and practices of information technology management.
• Principles and practices of database development, including design, stored procedures, and related processes.
• Implementation and administration of critical software applications.
• Oracle and SQL database administration principles and practices.
• Application server installation, configuration, and administration.
• Principles and practices of programming.
• Principles and practices of project management.
• Principles and practices of information technology research.
• State and federal statutes, rules, and regulations.
• Texas local government codes.
• Business and personal computers, and spreadsheet software applications.

Skills

• Managing situations requiring diplomacy, fairness, firmness, and sound judgment.
• Analyzing information technology issues, evaluating alternatives, and developing recommendations and reports.
• Translating verbal and electronic user requests into software modifications, reports, and expanded software functionality.
• Understanding and applying City policies and procedures, and applicable federal and state regulations.
• Explaining City information technology policies and procedures while exercising the highest degree of confidentiality.
• Establishing and maintaining cooperative working relationships with all levels within the City.
• Communicating effectively verbally and in writing.

Minimum Qualifications

Bachelor’s Degree in Computer Science or a related field; AND eight years’ experience in database development/administration and programming; OR an equivalent combination of education and experience.

License and Certification

CJIS certification.

Physical Demands and Working Environment

Work is performed in a standard office environment. May be required to lift and carry items weighing up to 50 pounds.

Equal Employment Opportunity

The City of Galveston is an equal opportunity employer and will consider only the qualifications of the applicants. The City does not tolerate any form of discrimination based on race, color, religion, sex, age, national origin, or physical/mental disability in employment or provision services.