PL/SQL Database Developer

Location: Dahlgren, Virginia, USA (On-base)
Telework: Hybrid (On-site 2-3 days/week)
Clearance: Secret (US Citizenship Required) 
Experience: Entry to Mid Level (Journeyman)
Number of Openings: 1
Funding Status: Funded
Salary Range: $70,000 - $95,000 (Please see below for more info on salary) 

PL/SQL Database Developer

SimVentions is a 100% employee-owned business and has consistently been voted one of Virginia's Best Places to Work. We are looking for a PL/SQL Database Developer to join a seasoned DBA team, in a hybrid work environment, who are responsible for facilitating data loads and movement, maintaining data integrity and supporting tool development from development to production. This position will require extensive knowledge of enterprise relational databases, bash scripting, and SOPs. Experience with RESTful APIs is a plus. Must live within commuting distance to Dahlgren, VA and be on-base multiple days a week.

Responsibilities: 

• Work to establish, monitor, and troubleshoot inbound/outbound interfaces to EDW to/from multiple Navy and DOD systems
• Interface directly with the government customers daily
• Work with the customer on creating and refining requirements
• Write technical documentation related to processing incoming files and producing outgoing file extracts
• Design and build underlying DB objects to meet customer requirements based on functional specs provided.  This includes DB Triggers, Functions, Procedures and Packages
• Safeguard PII and work in secure network environments
• Rapidly troubleshoot and address issues with incoming data or problems that occur within the load processes

Requirements:

• United States Citizenship/DoD Clearance Eligibility
• Experience with enterprise level database environments such as Oracle, bash scripting, data migration and management, data safeguards, and web application development
• Excellent communication skills
• Experience refining requirements
• Performance Tuning
• Proficiency with SQL & PL/SQL
• Proficiency with Unix or Linux shell scripting
• Monitoring scheduled jobs and reading logs
• Scheduling jobs for execution and monitoring them for successful completion
• Experience writing scripts to manipulate and prep incoming or outgoing files for loading or sending

Preferred Skills & Experience:  

• Writing Oracle load scripting using SQL, PLSQL and SQL*Loader
• Experience with developing and interfacing with RESTful APIs in enterprise environments
• Active Oracle Certification
• Experience managing DOD/USNavy databases

Education:  A Bachelor of Science (BS) degree from an accredited college or university in Computer Science, Data Science, or other STEM subjects, or equivalent years of directly relevant experience.

Clearance: A Secret Clearance is required for this position. Applicants selected will be subject to a security investigation and may need to meet eligibility requirements for access to classified information. US Citizenship is required to obtain a clearance.

Travel: None

 Benefits & Compensation:  At SimVentions, we’re committed to supporting the total well-being of our employees and their families. Our benefit offerings include comprehensive health and welfare plans to serve a variety of needs. 

We offer:

• Medical, dental, vision, and prescription drug coverage 
• Employee Stock Ownership Plan (ESOP) 
• Competitive 401(k) programs
• Retirement and Financial Counselors
• Health Savings and Health Reimbursement Accounts
• Flexible Spending Accounts 
• Life insurance, short- & long-term disability
• Continuing Education Assistance
• Paid Time Off, Paid Holidays, Paid Leave (e.g., Maternity, Paternity, Jury Duty, Bereavement, Military)
• Third Party Employee Assistance Program that offers emotional and lifestyle well-being services, to include free counseling 
• Supplemental Benefit Program 

Compensation at SimVentions is determined by a number of factors, including, but not limited to, the candidate’s experience, education, training, security clearance, work location, skills, knowledge, and competencies, as well as alignment with our corporate compensation plan and contract specific requirements.  

The projected annual compensation range for th