Senior Oracle PL/SQL Developer (Remote)
Role details
Job location
Tech stack
Job description
IDS is seeking Senior Oracle PL/SQL Developers with expert-level command of the Oracle RDBMS, SQL, and PL/SQL. You will be responsible for the architecture, development, and performance optimization of Oracle databases, including complex PL/SQL packages, triggers, types, and data pipelines. We're looking for somebody who is a confident problem solver, proactively challenges traditional solutions, and brings strong opinions on code quality and maintainability. You will also have opportunities to contribute to Java Spring Boot microservices, and modern front-end applications built with Angular and TypeScript., * Oracle database full life-cycle development including data modeling, database architecture, SQL and PL/SQL development, performance tuning, unit testing, and production support.
- Design and implement efficient, maintainable database solutions for high-volume, web-based applications serving DoD customers.
- Contribute to architecture decisions and drive implementation of changes across our product base.
- Develop detailed technical analysis and design specifications from functional and compliance requirements.
- Collaborate closely with developers, DevSecOps engineers, designers, and analysts to solve complex problems.
- Create, refactor, and improve reusable database objects with an emphasis on modularity and testability.
- Profile, optimize, and tune SQL queries and execution plans for performance at scale.
- Establish and enforce coding standards, peer review practices, and documentation norms.
- Support CI/CD pipeline integration for database change management (Liquibase, Flyway, or equivalent).
Requirements
- 7+ years of hands-on experience developing Oracle SQL and PL/SQL in production environments.
- Strong understanding of Oracle performance tuning tools and techniques (AWR, ASH, execution plan analysis, indexing strategies).
- Experience with CI/CD tooling (Jenkins, GitLab CI, or GitHub Actions) and Git-based source control workflows.
- Familiarity with database migration and version control frameworks (Liquibase, Flyway).
- Disciplined approach to testing and quality assurance, including experience writing unit tests for PL/SQL (utPLSQL or similar).
- Experience with containerized deployment environments (Docker, Kubernetes) is a plus.
- Experience developing Java Spring Boot applications is a plus.
- Experience with modern front-end frameworks (Angular, React, or Vue) and TypeScript is a plus.
- Exposure to cloud-hosted Oracle environments (AWS RDS, OCI) is a plus.
Education and Work Experience:
- Bachelor's degree from an accredited college or university in Engineering, Information Technology, Computer Science, or a related field is preferred. A Bachelor's degree may be waived with commensurate years of relevant professional experience.
Physical & Mental Qualifications:
- Must be able to sit, type, hear, see, and speak for extended periods of time.
- Must consistently work and type on a computer for prolonged periods of time.
- Must be able to communicate accurate information and ideas so others will understand.
- Must be able to lift/carry at least 15 lbs.
- May be required to move about inside an office to access file cabinets, office supplies, etc.
Benefits & conditions
Referral program, AD&D insurance, 401(k), Health insurance, Paid time off, Vision insurance, Dental insurance, Flexible spending account, Hours:
- Normal work schedule hours may vary, Monday through Friday. May be required to work additional hours and/or weekends, as needed, to meet deadlines or to fulfill travel obligations.
Salary Range:
- $125,000 - $145,000 per year
- The estimated salary range listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of this job posting and may be modified in the future. The disclosed salary range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. When determining an applicant's compensation, various factors are taken into consideration including, but not limited to: geographic location, relevant prior work experience, relevant training, special skills/competencies, education, clearance, licenses/certifications, labor categories/contract rates and other business needs.
IDS offers a robust benefits package including employer paid health, dental, vision, disability, AD&D and life insurance plans for eligible employees. IDS also offers a variety of elective plans to eligible employees including flexible spending accounts, voluntary life insurance and supplemental insurance plans. Benefits become effective the first of the month following the start date of employment unless starting on the 1st of the month, in which case benefits are effective immediately upon the eligible employee's start date. IDS offers eligible employees eleven (11) paid holidays, generous PTO accruals starting at three (3) weeks per year, as well as a 401(k) safe harbor contribution upon eligibility. IDS also offers generous employee referral bonuses.