JOB TITLE:
Oracle Database Analyst - 100% On-Site (NSA Mid-South)
JOB SUMMARY:
GPSIG, LLC is seeking an experienced Oracle Database Analyst to analyze, design, develop, test, and maintain enterprise Oracle applications and reporting systems supporting mission-essential operations for the U.S. Army Corps of Engineers (USACE).
WORK LOCATION NOTICE: This position requires full-time, on-site reporting at the Naval Support Activity (NSA) Mid-South base in Millington, TN to meet strict contractual operational requirements.
Operating within a modern Oracle Exadata and Private Cloud Appliance (PCA) environment running Red Hat Enterprise Linux (RHEL), you will write complex PL/SQL, maintain BI Publisher reports, refactor legacy report queries, optimize performance, and interface with an Oracle Database Repository.
CORE TECHNICAL COMPETENCIES:
- PL/SQL & Database Engineering: Deep expertise in writing, modifying, and maintaining complex Oracle PL/SQL database packages (.pkb), procedures (.prc), functions, triggers, and table structures.
- Reporting & Business Intelligence: Proficiency in developing, maintaining, and updating enterprise reports using Oracle BI Publisher (BIP) and APEX.
- Query Refactoring & Legacy Integration: Proven ability to extract SQL from legacy reports (e.g., Crystal Reports), re-engineer business logic, and adapt queries to run cleanly against modernized Oracle data repositories.
- Performance Engineering: Capability to diagnose slow-running queries, optimize execution plans, and tune database code specifically for high-throughput Oracle Exadata architectures.
- Linux Scripting & Automation: Command-line proficiency in RHEL to write shell scripts (Bash/KSH) for automating database jobs, batch ETL workflows, and report execution.
KEY RESPONSIBILITIES:
- Database Development & Maintenance: Design, write, test, and update complex PL/SQL packages and database objects to support mission-critical business logic and data structures.
- Reporting & Logic Integration: Maintain enterprise BI Publisher (BIP) reports and extract/refactor SQL embedded in legacy Crystal Reports to execute against target Oracle Database Repositories.
- Data Integration & ETL Support: Build and maintain scripts and procedures to handle data staging and processing.
- Production Support & Issue Resolution: Troubleshoot, debug, and resolve application error reports, performance bottlenecks (e.g., query timeouts), and data discrepancies in production environments.
- Testing & Quality Control: Draft and execute system, integration, and performance test plans for newly developed or converted database objects and reporting modules prior to production release.
- Technical Documentation: Maintain accurate documentation of code modifications, report definitions, system parameters, and database package updates.