What are the responsibilities and job description for the Senior SQL Developer position at ThreatLocker?
COMPANY OVERVIEW
ThreatLocker® is a global cybersecurity leader, providing enterprise-level cybersecurity tools for the Managed Services Provider (MSP) industry to improve the security of servers and endpoints. ThreatLocker’s combined Application Whitelisting, Ringfencing™, Storage Control and Privileged Access Management solutions are leading the cybersecurity market towards a more secure approach of blocking unknown application vulnerabilities.
POSITION OVERVIEW
ThreatLocker’s SQL Developer is responsible for creating quick and performant database queries and keeping the database up and running smoothly 24/7. This role will ensure access is provided only to authorized users and services and is also responsible for data migration, business analysis, ETL processes, and performance tuning.
JOB DUTIES
The SQL Developer will be responsible for, but not limited to:
- Build database systems of high availability and quality depending on each end user’s specialized role
- Store, retrieve, migrate and manipulate data for analysis of system capabilities and requirements in multiple data platforms
- Design and implement database in accordance to end user’s information needs and views
- Resolve SQL issues with Indexes and tuning, transaction log issues, and database growth
- Optimize queries and SSIS packages architecture to improve performance and scalability.
- Write and modify complex T-SQL queries, stored procedures, views and user-defined functions.
- Define users and enable data distribution to the right user, in appropriate format and in a timely manner
- Minimize database downtime and manage parameters to provide fast query responses
- Provide proactive and reactive data management support and training to users
- Determine, enforce and document database policies, procedures and standards
- Perform tests and evaluations regularly to ensure data security, privacy and integrity
- Monitor database performance implement changes and apply new patches and versions when required
- Work with the application development team to establish and adhere to development standards
- Provide technical system support for various in-house systems
QUALIFICATIONS
- Minimum of seven 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
- Working knowledge of enterprise SAN storage
- 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.
