SQL Developer

ThreatLocker•Orlando, FL

2d•Onsite

About The Position

ThreatLocker’s SQL Developer plays a key role in building and optimizing high-performance SQL queries that power critical application features. This role focuses on designing and implementing scalable data workflows, writing stored procedures, tuning query performance, and integrating data across systems through ETL pipelines. The developer also collaborates closely with engineering and product teams to support reporting, analytics, and data migrations—ensuring fast, reliable access to data while enforcing secure access controls. The role will be based in Orlando, FL and is an in-office position.

Requirements

Minimum of three years of experience with SQL server
Proficient in writing code for update queries, update data dictionaries as new fields are added to the database, and maintain a data correction log
Experience managing database utilities and monitoring relationships between users and applications
Knowledgeable in network hardware and software
Proficient in understanding of relational databases concepts and query languages to design summary and aggregate tables which support analysis
Experienced in creating and maintaining data correction logs that identify the date the correction that was performed, tables and fields effected, submission effected, error code effected, and other pertinent metadata.

Responsibilities

Develop and optimize high-performance T-SQL queries, stored procedures, views, and user-defined functions
Design and implement SQL databases aligned to end-user needs and application requirements
Build scalable ETL workflows using SSIS packages and improve their architecture for speed and reliability
Investigate and resolve performance issues—index tuning, transaction log handling, and query optimization
Migrate data across platforms while ensuring integrity, consistency, and zero downtime
Create solutions that distribute data to the right users at the right time, in the right format
Monitor and fine-tune database configurations to ensure fast and stable query responses
Regularly test systems to maintain data security, privacy, and compliance standards
Provide hands-on data access support and troubleshooting for application and internal users
Collaborate with the dev team to establish development standards and ensure consistent practices
Document schema designs, development workflows, and database policies clearly
Apply patches, updates, and system changes as needed for ongoing reliability
Deliver technical support for various in-house applications and systems