RCOH SQL Developer / Database Administrator

KMS Solutions, LLC; Virginia Beach, Northern (VA, KY); On-site; USD 70,000 - 80,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401k / Retirement Savings Plan

Paid Time Off

Job summary

KMS Solutions, LLC is seeking an experienced RCOH SQL Developer to support the SUPSHIP Newport News Planning Team. The role involves providing SQL development and Access/SQL Server integration across legacy and modern data platforms.

The candidate will administer SQL Server databases, convert Access SQL, design GUI forms, and ensure cybersecurity/compliance. A DoD Secret clearance is required, with extensive shipyard and fleet asset knowledge preferred.

Qualifications

• Active DoD Secret clearance required.
• 10+ years in aircraft carrier maintenance/ship repair business analysis.
• Strong MS SQL Server (12.0+) and Access (accdb) knowledge.
• Experience with software version control systems.
• Proficient in MS Excel, PowerPoint, Outlook; able to design GUI forms and debug VBA.

Responsibilities

• Maintain and troubleshoot existing Access databases.
• Administer SQL Server databases: backups, tuning, security, user accounts.
• Design and optimize SQL-driven applications with data integrity and cybersecurity.
• Collaborate with contracting officers and users to ensure functionality and develop features.
• Convert Access SQL to SQL Server syntax; design GUI forms; debug VBA.
• Improve security of Access apps and assist with ATO process.
• Use version control for existing apps.

Skills

SQL

VBA

MS Excel

Microsoft Access

Data security

Education

Security+ certification

SQL Server certification

Bachelor’s degree

Tools

SQL Server

Access (accdb)

Version control

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full-Time Regular Virginia Beach, VA, US

3 days ago Requisition ID: 1690

Salary Range: $70,000.00 To $80,000.00 Annually

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 three-time winner of the USA Today Top Workplaces recognizing quality workplace cultures across the United States who put their employees first. Additionally, we have received multiple Regional Top Workplace awards and Culture Excellence Awards for Compensation & Benefits, Innovation, Leadership, Purpose & Values and Work-Life Flexibility.

Position Summary

The primary objective of this role is to provide RCOH SQL developer support for the SUPSHIP Newport News Planning Team. As the RCOH SQL developer, you will be responsible for providing Structured Query Language (SQL) support services to SUPSHIPNN RCOH project teams and ensuring interoperability across legacy and modern data platforms.

Essential Functions

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

• Maintain, enhance, develop, and troubleshoot issues/bugs in existing Access applications and vintage Microsoft Access “accdb” databases.
• Responsible for maintaining and administering SQL Server databases, including backups, tuning, modifying existing tables/queries, security, and managing user accounts.
• Design, develop, repair, and optimize SQL database-driven applications while ensuring strict compliance with data integrity and Cybersecurity requirements.
• Work closely with Contracting Officers, Planning Manager(s), and application users to ensure required functionality of existing code, evaluate/recommend software solutions, and develop new features.
• Convert Access SQL statements into SQL server syntax, design GUI forms in Access, and debug code using VBA.
• Improve the security features of Access applications and assist SUPSHIP with the Authority to Operate (ATO) process when necessary.
• Incorporate software versioning and utilize software version control systems for existing applications.

Required Education and Experience

• Possess an active or current Secret clearance.
• Minimum of 10 years of relevant experience with aircraft carrier maintenance and operations, shipbuilding/ship repair business analysis. Equivalent experience with other fleet assets will be considered.
• Working knowledge of MS SQL Server (12.0 and above) and vintage Microsoft Access “accdb” databases. Fundamental understanding of SUPSHIP workflow and the use of Government acronyms to facilitate communication. Working knowledge of software version control system(s).
• Must possess Security+ or equivalent certification. SQL server certification.
• Strong knowledge of MS Excel, Access, PowerPoint, and Outlook. Ability to design forms (GUI) and debug code (VBA) in Access.

Preferred Education and Experience

• Former US Navy Chief Petty Officer, Chief Warrant Officer, or Limited Duty Officer.
• Bachelor’s Degree from an accredited university.
• Experience working with or at a shipyard, Naval Surface/Undersea Warfare Center (NSWC/NUWC), Supervisor of Shipbuilding Command (SUPSHIP), Regional Maintenance Center (RMC), and/or Type Commander (TYCOM).
• Working knowledge of AWS is preferred.
• Strong communication skills with the ability to communicate, both orally and in writing, to all levels of customer and company leadership including the ability to brief technical and non-technical stakeholders.
• Capable of effectively working and problem solving in both independent and team environments.
• Proficient with Microsoft Office applications, specifically Word, Excel, PowerPoint, and Project.
• Thoroughness and attention to detail.

Additional Eligibility Requirements

Work Authorization/Security Clearance Requirement

• This position requires the ability to obtain and/or maintain a DoD Secret Security Clearance. Security clearances may only be granted to U.S. citizens.
• Legally authorized to work in the United States at the time of hire and throughout employment.

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

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 and hear. The employee is frequently required to stand, walk, use hands to finger, handle or feel, and reach with hands and arms. Must be able to remain in a stationary position 50% of the time. Must be able to lift up to 20 lbs.

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 mandatory meetings is required. Must be available during the core work hours as determined by the contract/location and must account for the required number of hours in a pay period to maintain Full-time status.

Telework:

• No Telework Allowed.

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 is an Equal Employment Opportunity Employer and maintains an AffID. We recruit, employ, train, compensate, and promote qualified individuals without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, age, genetic information, or any other protected status under applicable federal, state, or local laws. Applicants or employees needing a reasonable accommodation during the application or interview process should contact Human Resources.