Oracle Database Developer

SUPER SYSTEMS INC
Corona, CA, United States
2 days ago
Apply on www.clearancejobs.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours

Tech stack

Code Review Cyber Security Information Systems Databases Data Integration Extract Transform Load (ETL) Data Mart Data Migration Data Warehousing Relational Databases Database Design Database Development
+17 more
Software Debugging Decision Support Systems Linux Online Transaction Processing Oracle Databases Oracle (Applications) Oracle SQL Developer Performance Tuning Query Optimization Standard Sql SQL Stored Procedures PL-SQL SQL Databases Database Optimization Indexer Toad (Software) Data Pipelines

Job description

The Acquisition Readiness & Performance Assessment (AR/PA) Engineering Program at Naval Surface Warfare Center (NSWC) Corona is a critical initiative supporting the U.S. Navy’s mission to maintain and enhance the readiness of its fleet. The contract provides sustainment decision support system services to support the NSWC Corona Division’s mission to oversee maritime information systems equipment and ensure uninterrupted service. These services are critical for maintaining the operational readiness of the Navy’s information systems.

The AR/PA Engineering Program focuses on assessing and improving the performance, reliability, and readiness of Navy systems, including weapons, combat systems, and hull, mechanical, and electrical systems across surface ships, submarines, and aircraft carriers. This is achieved through comprehensive evaluations and analyses to ensure these systems meet the Navy’s operational requirements and standards., The Database Developer designs and builds SQL code to support application features, reporting, and integration. This role supports data modeling, performance tuning, and cross-system logic within DoD-compliant environments. Database Development: Designing, coding, and debugging stored procedures, functions, packages, and triggers using PL/SQL. Performance Tuning: Analyzing SQL queries and optimizing database performance, indexing, and tuning techniques. Data Modeling & Migration: Translating logical designs into physical database objects and managing data migration. Support & Maintenance: Providing technical support, troubleshooting production issues, and performing code reviews. Responsibilities

  • Design and implement stored procedures, triggers, and functions
  • Support normalized schema design and indexing strategies
  • Develop and maintain ETL jobs and data pipelines
  • Provide query tuning and performance improvement recommendations
  • Ensure compliance with secure coding standards

Requirements

  • 5+ years of experience with Oracle (19c) database development experience.
  • 3+ years of experience with Oracle on Linux Operating Systems
  • 3+ years of experience with OLTP Database Design, ETL/ELT Data Integration, and Datawarehouse and Data Mart Development., * U.S. Citizenship Required
  • Active DoD Secret Clearance or higher (or the ability to obtain one)
  • Strong understanding of database architecture, relational database design, and normalization
  • Current Security+ CE Certification
  • Expert knowledge of Oracle SQL and PL/SQL
  • Familiarity with Oracle Database 19c
  • Strong analytical, problem-solving, and collaboration skills
  • If applicable: If you are or have been recently employed by the U.S. government by the U.S. government, a post-employment ethics letter will be required if employment with VSolvit is offered Preferred Qualifications

  • Experience with Quest Toad
  • Experience with ETL processes and data warehouse concepts
  • Experience with Oracle Database on Linux
  • Understanding of DoD cybersecurity and audit controls

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.clearancejobs.com
Prepare application

Good distractions

Loading talks and stories from around this role…