Database Engineer

Company Overview:

KMS Solutions, LLC is a technical management / solutions company that specializes in engineering, analysis, and cyber security. Founded in 2005, KMS is a certified small business with nearly two decades of experience supporting the Department of Defense as well as many other departments and programs critical to our Nation’s security and well-being.

KMS is a two-time winner of the USA Today Top Workplaces award recognizing quality employee workplace cultures across the United States. Additionally, we received the Providence Journal Rhode Island Top Workplaces award and Culture Excellence award for Compensation & Benefits, Innovation, Leadership, Purpose & Values and Work-Life Flexibility.

Position Summary / Objective:

KMS Solutions is seeking a highly motivated individual to join a team of engineers and technicians providing engineering and technical support to the Ranges, Engineering, and Analysis Department at the Naval Undersea Warfare Center (NUWC) in Newport RI. This multi-disciplinary team is responsible for providing systems safety, environmental qualification testing, and range sustainment in support of undersea warfare systems, including unmanned and autonomous systems. Candidates with education and experience in computer engineering/science and software development fields are highly desired.

Essential functions:

Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.

• Design, develop, test, and maintain software tools and applications to support the marine species modeling team (MSMT) research, data processing, and acoustic modeling.
• Manage and maintain Microsoft SQL Server databases, set up SQL Server instances, configure database settings, and manage server parameters to support large-scale environmental and biological acoustic datasets.
• Develop and optimize stored procedures, views, and functions for querying and transforming oceanographic and species observation data. Monitor query performance, tuning slow queries, managing indexes, and optimizing database resources.
• Manage user accounts, roles, and permissions to ensure secure access to data and applications adhering to organizational data management policies.
• Perform routine database maintenance, capacity planning, and resolve database issues and incidents.
• Implement backup strategies, schedule automated backups, and manage disaster recovery procedures.

Required education and experience:

• Ability to obtain Secret DoD clearance
• Bachelor’s Degree in Computer Science, Software Engineering, Software Development, or a related field
• Five (5) years proven experience in maintaining and optimizing Microsoft SQL Server environments, including performance tuning, backup/recovery strategies, and security management.
• Demonstrated ability to manage network infrastructure including firewalls, switches, VPNs, and Active Directory in a production environment.
• Proficient in T-SQL scripting and stored procedure development.
• Strong programming skills in C and/or Java and ability to work in Linux.

Preferred education and experience:

• Active Secret DoD clearance
• Master’s Degree in a science, technology, engineering, or math field
• Ten (10) years of providing database and network support including SQL Servers.
• Ten (10) years of software development experience
• Five (5) years of NUWC Division Newport specific experience
• Engineering and analytical experience with undersea sound impacts to undersea technologies

Competencies:

• Capable of working and problem solving in both independent and team environments.
• Strong knowledge of Microsoft SQL Server (2016 and later), including SSIS, SSRS, and SQL Agent jobs.
• Proficient with Microsoft Office applications, specifically Word, Excel, PowerPoint, and Project.

Work authorization/security clearance requirements:

An active DoD Secret security clearance.

Other Duties:

Please note this job posting is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Supervisory Responsibility:

None

Work Environment:

This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, and photocopiers.

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

While performing the duties of this job, the employee is regularly required to talk or hear. Excellent listening skills are essential. The employee frequently is required to stand, walk, use hands to finger, handle or feel, and reach with hands and arms. Must be able to lift up to 30lbs.

Position Type/Expected Hours of Work:

The typical workday is eight hours in length. Some flexibility in hours is allowed, with concurrence from the supervisor. Attendance at prescheduled mandatory meetings is required. Must be available during the core work hours as determined by your contract/location and must account for the required number of hours in a pay period to maintain Full-time status.

Telework:

• No regularly scheduled telework.

Travel:

• Ability to travel CONUS; potential to travel OCONUS
• Travel up to 10% may be required.

Benefits and Additional Compensation:

KMS offers a competitive benefits packaging including medical, dental and vision insurances, flexible spending account, PTO, paid holidays, military leave, bereavement leave, 401k / retirement savings plan, professional development and tuition reimbursement, basic and voluntary life insurance / AD&D, short-term and long-term disability, voluntary AFLAC supplemental insurance products and employee assistance plan (EAP) program. Additionally, KMS offers employee referral bonuses and a discretionary annual bonus.

AAP/EEO Statement:

KMS Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

KMS Solutions is a drug free workplace.

#LI-KMS

#ZR