DATABASE DEVELOPER

Posted Date

6/2/2025

Post End Date

6/12/2025

Job Description

Position involves the design, development, maintenance, and documentation of data programming objects, reports, and ETL processes.

Examples of Work

Design and create all forms of database objects and schemas

Design and architect small scale to complex databases

Create standard to complex, multi-sourced reports using a reporting engine (e.g., Reporting Services)

Create complex DTS/SSIS packages

Define and create simple to complex ETL processes

Assist other database developers with object creation, optimization

Assist the DBA with defining database standards and processes

Responsible for Database Team owned server jobs. Assist with creation, scheduling and maintenance of said jobs.

Assist application developers with performance and stored procedure optimization

Define, scope and deliver development projects

Assist users in determining appropriate data models

Perform unit testing, integration testing, user training testing, final acceptance testing, and modifications based on user feedback

Participate in vendor product reviews and provide feedback.

Work with vendors in evaluating and implementing new technologies

Maintain existing and new databases, make modifications, deploy updates as required

Prepare reports, statuses, system documentation, technical papers, and presentations periodically. Maintain business correspondence and keep documentation current

Knowledge, Skills and Abilities

Required Candidate Skills, Knowledge, and Proficiencies:

Thorough understanding of a TSQL database language (e.g. SQL)

Understanding of client-server computing

Data Analysis/Report building experience (e.g., SSRS)

Experience with data management

Database design experience

Proficient and demonstrated use of reporting and query tools

Understanding of software development lifecycle

Understanding of development in a multi-system environment

Thorough understanding of SQL Server configuration and server environment

Experience building/creating tables, views, stored procedures, functions and indexes

Experience working with creating and maintaining ETL processes

Preferred Knowledge, Skills, Abilities, and Requirements:

Transaction application database knowledge

Data Warehouse experience

Experience with geocoded data

Experience importing and exporting XML and JSON data using SQL Server

Ability to integrate and manipulate data via APIs, including building and consuming API calls within database environments

Experience handling JSON and XML data within SQL Server environments

Experience with SQL Server CLR objects for advanced processing

Open Requirements/Supplemental Information

Previous Experience Required:

Bachelor’s Degree in Computer Science, MIS, or equivalent work experience

1 - 12+ years professional IT data related experience with a demonstrated understanding of database structures, theories, principles, and practices

1 - 10+ years Microsoft SQL Server experience or comparable enterprise DB experience

Additional Requirements:

Must be able to conduct research and effectively collaborate with outside entities and agencies regarding current best practices

Must maintain existing knowledge and skills through continuing education;

Must have a personal standard of high attention to detail in all work tasks;

Must work well as part of a team and/or as an individual depending on the task at hand;

Must be flexible with changing, and often unexpected, work demands to meet the operational needs of the agency;

Must be able to adhere to the Core Values of the agency: Worthy of Trust, Respect for Each Other, Community Focused, and Always Improving;

Must exhibit a commitment to continuous improvement to eliminate waste, improve the work experience for all employees, and perfect our ability to add value to our services for our customers.

Must adhere to all written directives of the Jacksonville Sheriff’s Office.

The City of Jacksonville is an Equal Opportunity/Equal Access Employer and will provide equal opportunity to all employees and applicants in compliance with all applicable federal and state employment laws and the current interpretation of employment discrimination by the United States Equal Employment Opportunity Commission, as set forth in Directive 0528. There shall be no discrimination or harassment against any person with regard to race, color, sex (including pregnancy), sexual orientation, gender identity or expression, religion, political affiliation, national origin, disability, age, marital status, veteran status, or any other impermissible factor in recruitment, hiring, compensation, training, placement, promotion, discipline, demotion, transfers, layoff, recall, termination, working conditions and related terms and conditions of employment.

Min

USD $88,428.00/Yr.

Max

USD $99,364.00/Yr.