SQL Database Developer

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 Database Developer is responsible for ensuring that all database systems are maintained, monitored, optimized, configured and backed up in accordance with Information Technology best practices. This role maintains the operation of these systems in a 24x7 work environment. The SQL Database Developer acts as a point of contact for the services, equipment, and software changes and/or installations under their assigned area of responsibility.

JOB DUTIES

The Database Administrator will be responsible for, but not limited to:

• Identify and assess current and future needs of database software purchases.
• Ensure the company database is compliant, secured and optimized for full performance.
• Ensure the successful backup of database and related log files.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
• Manage database utilities and monitor relationships between users and applications.
• Monitor, analyze and resolve issues related to information flow and data architecture standards.
• Write code for update queries, update data dictionaries as new fields are added to the database, and maintain a data correction log.
• Create and maintain 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.
• Expand and update the data dictionary for the database and any related applications.
• Develop and implement standards, data modeling and space usage requirements.
• Solve complex and unique problems, or direct the daily activities of a business, technical support, or functional support team.
• Ensure database related activities are in accordance with industry standards.
• Define, document, and automate processes.

QUALIFICATIONS

• Minimum of six years of experience in day-to-day database technical support
• 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
• Proficient in writing code for update queries, update data dictionaries as new fields are added to the database, and maintain a data correction log
• 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.