> Markdown version of [/jobs/ext/1614285-oracle-database-analyst](https://www.wearedevelopers.com/jobs/ext/1614285-oracle-database-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Oracle Database Analyst - **Company:** Gps Information Guidance, LLC - **Location:** Millington, TN, United States - **Experience:** Experienced - **Salary:** $75,000.0 - $100,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Business Logic, Bash Shell, Command-Line Interface, Databases, Crystal Reports (Reporting Software), Data Integration, Extract Transform Load (ETL), Data Structures, Database Development, Software Debugging, Oracle Exadata, Oracle Application Express, Korn Shell, Oracle Business Intelligence Enterprise Edition, Oracle Databases, Oracle (Applications), Oracle Warehouse Builder, Query Optimization, Red Hat Enterprise Linux, Shell Script, Software Engineering, PL-SQL, SQL Databases, Private Cloud Environment, Apex Code, Bi Publisher, Large Language Models, Generative AI, Oracle Service Cloud, Information Technology, 3-tier Architectures, Code Restructuring, GPT - **Published:** July 31, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=6acd0b2578ab2456 ## About the Role * Work Location (Mandatory): Must be able to work 100% on-site at NSA Mid-South in Millington, TN. (Remote/hybrid arrangements are not available per contract guidelines). * Education (Mandatory): Bachelor's degree in Computer Science, Management Information Systems (MIS), Software Engineering, Information Technology, or a related technical field from an accredited institution. * DoD 8140 Compliance Requirements: Must meet DoD 8140 foundational qualification standards via continuous, uninterrupted professional experience in database/software development since degree completion OR by holding an active qualifying certification (e.g., CSSLP or equivalent approved credential). * Technical Skills: 3+ years of hands-on experience in Oracle PL/SQL development and Oracle BI Publisher (BIP) report maintenance. Practical experience working in Linux/Unix environments (specifically RHEL), shell scripting, and command-line interfaces. * Clearance, Background & Security Requirements: * Must be a U.S. Citizen (contractual requirement). * Must pass a company-administered background check prior to hire. * Must be able to obtain and maintain a favorable Tier 3 (T3) Non-Critical Sensitive / Public Trust investigation (requires SF-86 completion). * Must have continuously resided and worked in the United States for at least the past five (5) consecutive years. DESIRED / PREFERRED SKILLS: * Experience extracting and refactoring legacy SQL (e.g., Crystal Reports logic) for modern Oracle schema structures. * Development or query tuning experience on Oracle Exadata and/or Oracle Private Cloud Appliance (PCA). * Experience with Oracle Application Express (APEX) or Oracle Analytics Server (OAS) / OBIEE. * AI & Generative AI Skills (Plus): Familiarity with commercial/enterprise Large Language Models (LLMs) such as Gemini, Claude, ChatGPT, or local tools to assist in code refactoring, query optimization, or documentation. An AI-focused credential or certification is a plus., * Are you a U.S. Citizen? * Do you hold a 4-year Bachelor's degree in Computer Science, MIS, Software Engineering, or a related technical field from an accredited institution? * Are you able to commute and work 100% on-site at the Naval Support Activity (NSA) Mid-South base in Millington, TN? * Are you able to pass a company background check and successfully complete an SF-86 for a Tier 3 (T3) background investigation? * Have you maintained continuous, uninterrupted professional experience in database/software development since obtaining your degree, OR do you hold an active qualifying DoD 8140 credential (e.g., CSSLP)? Education: * Bachelor's (Required) Experience: * Database development: 5 years (Required) Work Location: Hybrid remote in Millington, TN 38054 ## Description 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., * 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., * 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. ## Related Videos - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) - [ Evaluating AI models for code comprehension](https://www.wearedevelopers.com/videos/1462-evaluating-ai-models-for-code-comprehension) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Speak, Code, Deploy: Transforming Developer Experience with Voice Commands](https://www.wearedevelopers.com/videos/1159-speak-code-deploy-transforming-developer-experience-with-voice-commands) - [Hiring AI Native Talents](https://www.wearedevelopers.com/videos/100268-hiring-ai-native-talents) - [Streaming AI Responses in Real-Time with SSE in Next.js & NestJS](https://www.wearedevelopers.com/videos/1630-streaming-ai-responses-in-real-time-with-sse-in-next-js-nestjs) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Dev Digest 134 - Where pixels sing?](https://www.wearedevelopers.com/magazine/477-dev-digest-134-where-pixels-sing) - [Should senior developers refuse interview coding challenges?](https://www.wearedevelopers.com/magazine/29-should-senior-developers-refuse-interview-coding-challenges) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)