Application Database Analyst

Bonita Springs Utilities Inc•Bonita Springs, FL

About The Position

This position is responsible for the administration, performance, integrity, and security of SQL databases and associated enterprise applications. This role supports Customer Service, Finance, and Operations systems, develops data analytics and reporting solutions using Power BI, and serves as a liaison between business users and software vendors.

Requirements

Microsoft SQL Server and T-SQL development.
Power BI report development and data modeling.
Troubleshoot and optimize database performance using indexing strategies, execution plan analysis, and query tuning.
Relational database concepts and data integrity principles.
Supporting enterprise applications such as ERP (Microsoft Dynamics GP preferred), CIS, and GIS systems.
Database backup, restore, and disaster recovery procedures to ensure data integrity and availability.
Application configuration and implementation.
Design, develop, and optimize complex SQL queries and database objects to support operational and financial reporting.
Analyze large data sets to identify trends, discrepancies, and data integrity issues.
Develop and present clear, actionable dashboards and reports for technical and non-technical users.
Troubleshoot and optimize database performance using indexing strategies, execution plan analysis, and query tuning.
Maintain data governance standards, including security, role-based access controls, and documentation.
Support and troubleshoot integrations between enterprise systems.
Communicate technical concepts clearly to users, leadership, and vendors.
Prioritize and manage multiple projects in a fast-paced operational environment.
Exercise sound judgment and independent decision-making when evaluating technical solutions.
Advanced proficiency in Microsoft SQL Server and T-SQL, including writing complex queries, stored procedures, and scripts.
Proven ability in performance tuning and query optimization to maximize database efficiency.
High School Diploma or equivalency
Bachelor’s degree in Computer Science preferred, or two years of college with major coursework in Computer Science.
2–3 years of SQL/database administration experience, including relational database management (preferred)
Valid Florida Driver’s License

Responsibilities

Analyze business functions and work processes to determine technical and reporting needs.
Administer, monitor, and optimize Microsoft SQL Server databases including backups, restores, performance tuning, indexing, and security configuration.
Develop queries, reports, database extracts, and data models utilizing SQL, Power BI, and other reporting tools.
Test and debug database-related processes and identify system improvements.
Provide analysis and limited development support for enterprise application packages.
Maintain consistency and reliability of applications by enforcing standards and procedures.
Identify system capability and capacity issues and recommend solutions.
Define requirements, develop specifications, and document processes for new and existing applications.
Provide training and assistance to users on reporting tools and data interpretation.
Support integrations between enterprise systems (ERP, CIS, GIS, SCADA, financial systems).
Participate in system upgrades, disaster recovery planning, and testing.
Other duties as assigned