ThreatLocker is looking to improve the security of servers and endpoints by building and optimizing high-performance SQL queries that power critical application features.
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
Other
- Job will generally be performed in an office environment but may require travel to visit company offices and/or property locations
- 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
- Must be able 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
- Bachelor's degree not mentioned but 3 years of experience is required
