Application Database Analyst at Bonita Springs Utilities Inc

Bonita Springs, Florida, United States -

Full Time

Start Date

Immediate

Expiry Date

18 Jun, 26

Salary

0.0

Posted On

20 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Microsoft Sql Server, T-Sql, Power Bi, Data Modeling, Performance Tuning, Indexing, Query Tuning, Relational Database Concepts, Erp, Cis, Gis, Disaster Recovery, Application Configuration, Data Governance, Sql Queries, Stored Procedures

Industry

Description

Description 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 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 Knowledge, Skills, and Abilities 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. Requirements 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

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