Oracle//SQL Database Developer

$95,000 - $150,000/Yr

Simventions - Rappahannock Academy, VA

posted 4 months ago

Full-time - Mid Level
Hybrid - Rappahannock Academy, VA
Professional, Scientific, and Technical Services

About the position

SimVentions is seeking an experienced Oracle Database Developer to join our seasoned DBA team in a hybrid work environment. This role is critical in facilitating data loads and movement, maintaining data integrity, and supporting tool development from development to production. The ideal candidate will possess extensive knowledge of Oracle and SQL, and will be responsible for establishing, monitoring, and troubleshooting inbound and outbound interfaces to the Enterprise Data Warehouse (EDW) from multiple Navy and DOD systems. This position requires direct interaction with government customers on a daily basis, necessitating strong communication skills and the ability to refine requirements effectively. In this role, you will be tasked with writing technical documentation related to processing incoming files and producing outgoing file extracts. You will also design and build underlying database objects to meet customer requirements based on functional specifications provided. This may include creating database triggers, functions, procedures, and packages. Safeguarding Personally Identifiable Information (PII) and working in a secure environment is paramount, as is the ability to rapidly troubleshoot and address issues with incoming data or problems that occur within the load process. The position is based in Dahlgren, Virginia, and requires the candidate to live within commuting distance, as on-base presence is required multiple days a week. This is a mid-level position, and candidates must hold an active Oracle Certification and have a minimum of five years of experience in Oracle scripting, data management, and application development, particularly in managing DOD/US Navy databases.

Responsibilities

  • Establish, monitor, and troubleshoot inbound/outbound interfaces to EDW to/from multiple Navy and DOD systems
  • Interface directly with 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, including DB Trigger, Functions, Procedure, and Packages
  • Safeguard PII and work in a secure environment
  • Rapidly troubleshoot and address issues with incoming data or problems that occur within the load process

Requirements

  • Active Oracle Certification
  • Minimum 5 years of experience with Oracle scripting, data management, and application development
  • Experience managing DOD/US Navy databases
  • Excellent communication skills
  • Experience refining requirements
  • Performance Tuning
  • Proficiency with SQL & PL/SQL
  • Proficiency with Unix or Linux Shell Scripting

Nice-to-haves

  • Writing Oracle load Scripting using SQL, PLSQL and SQL*Loader
  • Monitoring scheduled jobs and reading oracle logs
  • Scheduling jobs for execution and monitoring them for successful completion
  • Writing scripts to manipulate incoming files and prep them for loading
  • Writing scripts to manipulate outgoing files and send them to customers

Benefits

  • 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, including free counseling
  • Supplemental Benefit Program
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service