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

• 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

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

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.