> Markdown version of [/jobs/ext/3020662-programmer](https://www.wearedevelopers.com/jobs/ext/3020662-programmer). 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). --- # Programmer - **Company:** Pro-Search Inc - **Location:** Augusta, ME, United States - **Experience:** Expert - **Salary:** $124,800.0 - **Contract:** Permanent contract - **Skills:** Application Performance Management, Batch Processing, Big Data, Databases, Data Validation, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Mapping, Data Transformation, Data Warehousing, Database Applications, Relational Databases, Oracle Databases, Oracle (Applications), Oracle SQL Developer, Performance Tuning, Systems Development Life Cycle, Software Deployment, Software Engineering, PL-SQL, SQL Databases, Enterprise Data Management, Data Processing, Freeform SQL, Enterprise Software Applications, Sql Optimization, Database Optimization, Data Analytics, Software Version Control - **Published:** September 21, 2026 - **Apply:** https://www.prosearchmaine.com/jobs/20992-programmer-165945/ ## About the Role * 7+ years of application development, database programming, and production support experience. * 5+ years of hands-on experience with Oracle databases, SQL, and PL/SQL. * Experience building and supporting data warehouses, ETL processes, and large-scale data environments. * Advanced proficiency with Oracle relational database technologies. * Experience developing PL/SQL packages, procedures, functions, triggers, and complex stored program units. * Strong experience analyzing and optimizing SQL and PL/SQL performance. * Experience troubleshooting database applications and resolving production issues. * Knowledge of data integration, data transformation, batch processing, and data-loading operations. * Experience with source code management, software deployments, and SDLC best practices. * Strong communication, analytical, and problem-solving skills. Preferred * Experience supporting enterprise reporting and analytics environments. * Experience with dimensional data models and source-to-target data mapping. * Background in large-scale production database environments. * Experience working directly with business stakeholders and end users. * Ability to communicate complex technical concepts to both technical and non-technical audiences. ## Description ProSearch is seeking a Programmer (Specialist) in Augusta, Maine to support enterprise database applications, Oracle development, SQL and PL/SQL programming, ETL processes, data warehouse operations, and production data systems for a large-scale business environment. This opportunity is ideal for a senior database developer with expertise in Oracle databases, SQL, PL/SQL, ETL development, data warehousing, data integration, production support, and performance optimization who enjoys solving complex data challenges and ensuring the reliability, accuracy, and performance of critical business systems. In this role, you'll work across application development, database programming, production support, data quality validation, and warehouse operations. You'll help maintain and enhance complex data-processing solutions, troubleshoot production issues, optimize database performance, and support enterprise reporting and analytics initiatives. Top Skills * Oracle Database Development * SQL & PL/SQL Programming * Data Warehousing * ETL Development & Data Integration * Database Performance Tuning * Production Support & Incident Resolution * Data Validation & Data Quality * Oracle SQL Developer * Database Application Development * Root Cause Analysis & Troubleshooting What You'll Do * Develop, maintain, troubleshoot, and optimize complex Oracle database applications and data-processing solutions. * Write, analyze, and tune advanced SQL queries, PL/SQL procedures, packages, triggers, and functions. * Monitor scheduled and ad hoc data loads, validate results, and resolve data-quality issues. * Support ETL processes, data transformations, batch processing, and enterprise data integrations. * Investigate production incidents, identify root causes, implement fixes, and validate successful resolution. * Analyze database and application performance, identify bottlenecks, and recommend optimization strategies. * Support data warehouses, reporting environments, and enterprise reporting dependencies. * Perform unit, integration, system, regression, and data-validation testing. * Create and maintain technical, operational, and support documentation. * Collaborate with developers, analysts, database administrators, project teams, and business stakeholders to deliver reliable solutions. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [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) - [In-Memory Computing - The Big Picture](https://www.wearedevelopers.com/videos/626-in-memory-computing-the-big-picture) - [OLAP for AI Applications and why you should care](https://www.wearedevelopers.com/videos/100212-olap-for-ai-applications-and-why-you-should-care) - [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) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [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) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Quick guide: How to write a Software Developer CV](https://www.wearedevelopers.com/magazine/37-quick-guide-how-to-write-a-software-developer-cv) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)