SQL Engineer

Job Type: Full- Time

Workplace Type: Onsite

Clearance: TS/SCI Clearance

Must be a U.S. Citizen

Benefits: Medical, dental, and vision coverage, 401k matching, generous PTO, paid holidays, professional training opportunities, and even pet insurance to ensure your furry friends are cared for too.

Job Summary

Castalia Systems is seeking an Onsite SQL Engineer to maintain multiple MSSQL, PostgreSQL and MySQL instances. An ideal candidate should have experience in many of the required technical skills below. This position requires working independently under limited oversight while supporting and maintaining the environment.

Roles and Responsibilities

A qualified candidate will perform the following duties and responsibilities, but are not limited to:

• Configure, manage and maintain Microsoft SQL, PostgreSQL and MySQL database servers in accordance with established best practices as applied for performance and security. May require off-hour support
• Implement and maintain SQL server DISA STIGs
• Install, configure and integrate SQL servers and support dependent applications
• Management and validation of SQL Backups as well as restoral
• Build highly available server clusters
• Document, test and implement SQL server services
• Assess and evaluate current deployments providing recommendations for enhancements
• Develop and maintain standard operating procedures
• Create and defend system change requests
• Manage user requests for assistance, application installation and upgrades.
• Configuring and supporting security support infrastructure including backups, anti-virus software, patch management and vulnerability scanning.
• Install and upgrade SQL server components, when possible supporting integration of automation processes
• Troubleshoot hardware and software errors, documenting problems and resolutions, prioritizing problems, and assessing impact of issues.
• Create documentation of all work performed to capture configuration and installation procedures
• Support security staff in compliance and vulnerability audits of SQL Servers and supporting client systems, implementing security remediation, and during accreditation events
• Work with fellow engineers to identify database design changes required to support changing processes or requirements
• Support security staff in compliance and vulnerability audits of SQL Servers and supporting client systems, implementing security remediation, and during accreditation events
• Work with fellow engineers to identify database design changes required to support changing processes or requirements

Required Qualifications

• A strong understanding and knowledge of computer, network, and security systems.
• Good interpersonal and communication skills.
• Strong analytical, critical thinking, and problem-solving skills.
• Ability to work well independently under limited oversight, be self-directed and able to prioritize work.
• Must be able to attain and maintain a DoD 8570 IAT Level II certification (Security+ CE or CISSP preferred).
• Bachelor's degree and 2 Years of relevant professional work experience (excluding internships)
• In absence of a degree, 6 years of relevant experience is required

Preferred Qualifications

• Experience with Microsoft SQL, Microsoft Windows Server environment
• Postgres and MySQL
• Experience with Linux
• Understanding of basic network engineering fundamentals, including: OSI layers, IP addressing, sub-netting, TCP/IP stack, VLANs, DHCP, etc.
• Willingness to learn new technologies and applications as required.
• Demonstrated experience implementing computer security.
• Ability to adapt both an offensive and defensive mindset to support securing information systems.
• Ability to quickly switch tasks based on changing priorities.
• Ability to work with limited supervision. Must be a self-starter with initiative.
• Ability to work with an extremely risk adverse customer and their policies.

Physical Requirements/Work Environment

• Normal office environment

Travel

• As needed

Company Description

Castalia Systems is a proven business partner providing mission critical solutions to the Federal Government. We provide cutting edge solutions from Securing and Managing Data to Systems Engineering and Development. Castalia Systems is a pioneer in Artificial Intelligence Design and Application.

With our vast knowledge of our customers' needs and relevant technology, our team is able to bring successful solutions to every mission. We are one-upping our competitors by providing premium IT solutions and platforms with cutting-edge technology so it's so evident when you compare us with anyone.

Disclaimer

Castalia Systems is an equal employment opportunity and affirmative action employer and strives to comply with all applicable laws prohibiting discrimination based on race, color, creed, sex, sexual orientation, age, national origin, or ancestry, physical or mental disability, veteran status, marital status, HIV-positive status, as well as any other category protected by federal, state, or local laws. All such discrimination is unlawful, and all persons involved in the operations of the company are prohibited from engaging in this type of conduct.