> Markdown version of [/jobs/ext/3027475-oracle-dw-developer](https://www.wearedevelopers.com/jobs/ext/3027475-oracle-dw-developer). 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 DW Developer

- **Company:** Professional Technology Integration (PTI)
- **Location:** Augusta, ME, United States (Remote available)
- **Experience:** Expert
- **Contract:** Temporary contract
- **Skills:** Databases, Data Validation, Data Integrity, Extract Transform Load (ETL), Data Mapping, Data Systems, Data Warehousing, Database Applications, Relational Databases, Database Development, Oracle Databases, Oracle (Applications), Oracle SQL Developer, Systems Development Life Cycle, Query Optimization, Standard Sql, Software Deployment, Software Engineering, SQL Stored Procedures, PL-SQL, SQL Databases, Diagnostic Tools, Data Processing, Sql Optimization, Database Optimization, Test Scripts, Database Performance, Information Technology, Software Version Control
- **Published:** September 22, 2026
- **Apply:** https://professionaltechintegration.com/PTICloud9/index.php?option=com_mycareer&job=apply&jpid=18728&Itemid=568

## About the Role

* Education: Bachelor's Degree in Computer Science, Information Technology, or a related technical discipline.
 * Core Experience: Minimum of 7 years of progressively responsible software and database development experience, including production support and systems troubleshooting.
 * Oracle & SQL Expertise: Minimum of 5 years of hands-on expertise building enterprise solutions using Oracle Relational Database systems, advanced SQL, and PL/SQL (packages, procedures, functions, triggers).
 * Data Warehousing & ETL: Proven experience working with enterprise data warehouses, dimensional data modeling, source-to-target mapping, and large-scale ETL/batch integration workloads.
 * Diagnostic Tools: Proficiency with Oracle SQL Developer or equivalent database management and query-tuning tools.
 * Soft Skills: Proven ability to work independently with limited supervision, handle competing priorities, and articulate complex technical concepts clearly to both technical and non-technical stakeholders.
 * Clearance/Background: Ability to successfully pass standard comprehensive background checks and identity verification., * Application Development & Database Programming (Required 7 Years)
 * Oracle Database Technologies (RDBMS) (Required 5 Years)
 * PL/SQL Development (Packages, Procedures, Functions, Triggers) (Required 5 Years)
 * Complex SQL Querying & Optimization / Tuning (Required 5 Years)
 * Data Warehousing & Dimensional Data Structures (Required 5 Years)
 * ETL Processing, Data Integration & Batch Loading (Required 5 Years)
 * Production Support, Defect Triage & Incident Resolution (Required 5 Years)
 * Oracle SQL Developer / Database Diagnostic Tools (Highly Desired 5 Years)
 * Data Reconciliation & Source-to-Target Mappings (Highly Desired 3 Years)
 * Unit, Integration, System, Regression & Data Validation Testing (Desired 4 Years)
 * SDLC Best Practices & Controlled Code Deployments / Version Control (Desired 4 Years)
 * Public Sector / State / Local / Federal Government Systems Experience (Nice to Have 2 Years)

## Description

We are seeking an experienced Senior Database Developer / Programmer Specialist (Oracle / PL/SQL / Data Warehouse) to lead database development, production support, and performance optimization for mission-critical enterprise data warehouse and analytics systems., In this role, you will be responsible for developing, maintaining, troubleshooting, and tuning complex database applications, ETL pipelines, and batch data-loading workflows. You will work closely with cross-functional teams to resolve production defects, ensure data integrity, translate complex business requirements into robust technical implementations, and drive data warehouse initiatives., * Data Load Monitoring & Validation: Monitor and validate scheduled and ad hoc ETL/batch data loads, reconcile source-to-target datasets, investigate data discrepancies, and implement resolutions to maintain high data quality.

 * Production Support & Incident Investigation: Investigate high-impact production incidents across database applications, SQL/PL/SQL routines, and ETL workflows; conduct root-cause analysis, correct defects, and ensure fixes introduce no downstream side effects.
 * Database Programming & Architecture: Design, build, and maintain complex Oracle stored procedures, functions, packages, triggers, and custom data processing units.
 * Performance Analysis & Query Tuning: Analyze database performance bottlenecks, inspect SQL execution plans, optimize indexing strategies, and refactor inefficient SQL and PL/SQL code.
 * Requirements & Solution Design: Translate functional business needs and operational problems into clear technical requirements, evaluate trade-offs between architectural approaches, and deliver scalable solutions.
 * Testing & Quality Assurance: Formulate and execute unit, integration, regression, system, and data validation test scripts to confirm technical accuracy, error handling, and business rule adherence.
 * Technical Documentation & Collaboration: Maintain comprehensive operational, system, and architectural documentation; actively participate in code/design reviews and guide technical and business stakeholders on data relationships and reporting capabilities.


## Related Videos

- [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)
- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Are Classical Automation Frameworks Dead? How AI Agents Are Transforming QA](https://www.wearedevelopers.com/videos/100243-are-classical-automation-frameworks-dead-how-ai-agents-are-transforming-qa)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Fighting test flakiness with time machines](https://www.wearedevelopers.com/videos/834-fighting-test-flakiness-with-time-machines)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [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)
- [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know)
- [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)