SQL Developer

COMPANY OVERVIEW

ThreatLocker® is a leader in endpoint protection technologies, providing enterprise-level cybersecurity tools to improve the security of servers and endpoints. The ThreatLocker® platform with Application Allowlisting, Ringfencing™, Storage Control, Elevation Control, Endpoint Network Control, Configuration Management, and Operational Alert solutions are leading the cybersecurity market toward a more secure approach of blocking the exploits of application vulnerabilities.

POSITION OVERVIEW

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.

JOB DUTIES

The SQL Developer will be responsible for, but not limited to:

• 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.

QUALIFICATIONS

• 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.

WORKING CONDITIONS

The duties described below are representative of those encountered while performing the essential functions of this position. If necessary, reasonable accommodation may be requested and will be evaluated for its relationship to the essential functions that must be performed.

• Job will generally be performed in an office environment but may require travel to visit company offices and/or property locations.
• While performing duties of this job, would occasionally require to stand, walk, sit, reach with hands and arms, climb or balance, stoop or kneel, talk and hear, and use fingers and hands to feel objects and tools.
• Must occasionally lift and/or move up to 25 pounds.
• Specific vision abilities required include close vision, distance vision, depth perceptions, and the ability to adjust focus.