SQL Database Engineer III

Summary

Responsible for developing and maintaining SQL databases; writing applications to interface with SQL databases; develop queries and procedures, create custom reports, and modify ERP user forms to enhance organizational productivity; designing tables, storing procedures, views and functions; ensuring data integrity through constraints, managing transactions, and implementing security measures like authentication and authorization.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

SQL Development

• Design, develop, and maintain complex SQL queries, stored procedures, functions, and scripts.

• Optimize and troubleshoot SQL queries for performance and efficiency.

• Collaborate with business users to create database schemas and data structures that support application requirements.

Database Administration

• Install, configure, and upgrade SQL Server instances and related software.

• Monitor database performance, implement changes, and apply new patches and versions when required.

• Perform database tuning and optimization, manage backup and recovery processes.

• Ensure data integrity, security, and availability of databases.

API Integration

• Maintain APIs to facilitate communication between different software systems.

• Integrate external and internal APIs to streamline data exchange and business processes.

• Ensure APIs are secure, efficient, and scalable.

Automation

• Identify opportunities for process automation within the database environment.

• Develop scripts and tools to automate routine database tasks, such as backups, indexing, and monitoring.

• Implement and manage ETL (Extract, Transform, Load) processes to automate data flow.

Business Intelligence (BI)

• Utilize BI tools such as Qlik, Microsoft Power BI, Tableau, or similar to provide insights and data-driven decisions.

• Collaborate with stakeholders to understand BI requirements and translate them into technical solutions.

• Ensure the accuracy, completeness, and timeliness of BI reports.

Documentation and Reporting

• Create and maintain detailed documentation of database designs, configurations, processes, and policies.

• Generate regular reports on database performance, usage, and issues.

Collaboration and Support

• Work closely with other IT team members, developers, and stakeholders to ensure database systems meet business needs.

• Provide support and training to users and other IT staff on database-related issues and best practices.

Additional Requirements/Skills

• Proven experience as a SQL Developer and DBA.

• Strong knowledge of SQL Server (or other RDBMS), T-SQL, and performance tuning.

• Experience with API development and integration.

• Proficiency in scripting languages such as PowerShell, Python for automation.

• Familiarity with ETL processes and tools.

• Strong problem-solving skills and attention to detail.

• Excellent communication and teamwork abilities.

• Ability to manage multiple tasks and projects simultaneously.

• Knowledge of database security best practices.

Education and/or Experience

Bachelor's degree in Computer Science, Information Technology or related field. 5+ years related experience and/or training or equivalent combination of education and experience.

Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus. Experience with cloud database services (e.g., Azure SQL Database, Fabric, Datalake). Familiarity with modern development methodologies and tools (e.g., Agile, DevOps, CI/CD).

Knowledge of D365 F&O, ServiceTrade, Qlik.

Company Overview

Century Fire Protection is one of the largest and most successful full-service fire protection companies based in the Southeast and we are still growing! There are a wide range of positions and countless opportunities for career growth. Each employee is empowered to do their job and serve our clients. There is no better place to work in the industry!

We believe our people are our biggest asset and as such, we offer the following:

• Competitive Pay

• Medical (3 plan choices)

• Dental (2 plans choices)

• Vision

• Voluntary Life Insurance, Short-term & Long-term Disability

• Flexible Spending Accounts

• Paid Time Off & Paid Holidays

• 401(K) with Company Match

• Employee Assistance Program

• Employee Relief Fund Financial Grants

• Supplemental Insurance including Critical Illness, Hospitalization & Accident

• Company issued Laptop and/or Tablet

• Company Paid Training and Certifications

• Referral Bonus (Employees receive $1,000 referral bonus for each person they refer to work at Century Fire Protection)

Build a Career that Burns Bright!

We support and hire Veterans and we are an Equal Opportunity Employer