Oracle PL/SQL & Database Developer

Novalink Solutions LLC; Augusta (ME); On-site; USD 110,000 - 140,000; Full time

Job summary

Novalink Solutions LLC seeks an experienced data/ETL specialist to support and enhance Oracle-based data loads and warehouse processes. You will diagnose incidents, translate business needs into robust technical requirements, and ensure dependable data quality across systems.

The role emphasizes collaboration with cross-functional teams, rigorous testing, and clear documentation of procedures and fixes to maintain operational excellence.

Qualifications

• 7+ years in application development and production support.
• 5+ years hands-on experience with Oracle databases, SQL, and PL/SQL.
• Experience with data warehouses and ETL processes.

Responsibilities

• Monitor and validate scheduled and ad hoc data loads, reconcile results, investigate discrepancies.
• Investigate production incidents, identify root causes and verify solutions.
• Translate business needs into technical requirements and workable solutions.
• Review tasks and accept criteria before development work and seek clarification when needed.
• Analyze designs, assess risks, and provide feedback on alternatives and performance.
• Develop and execute unit/integration/system/regression tests for data functionality.

Skills

Data analysis

Problem solving

Communication

Tools

Oracle databases

PL/SQL

SQL

SQL Developer

ETL processes

Data warehousing

Source code management

Job description

Required Technical Skills

• Oracle relational database technologies.
• PL/SQL development, including packages, procedures, functions, triggers, and complex stored program units.
• Writing, analyzing, and optimizing complex SQL queries.
• Oracle SQL Developer or comparable Oracle development and diagnostic tools.
• Troubleshooting existing application code and identifying the underlying cause of defects.
• SQL and PL/SQL performance analysis, including the ability to identify inefficient queries, execution-plan issues, indexing opportunities, and database-related performance bottlenecks.
• ETL processing, data integration, data transformation, and batch data-loading operations.
• Production support and incident investigation involving SQL, PL/SQL, ETL processes, and data-warehouse workloads.
• Unit, integration, system, regression, and data-validation testing.
• Source-code management, controlled deployments, and standard software-development lifecycle practices.

Required Responsibilities and Competencies

• 1. Monitor and validate scheduled and ad hoc data loads, reconcile source and target results, investigate discrepancies, and resolve data-quality issues.
• 2. Investigate production incidents, analyze application and database behavior, identify root causes, correct defects, and verify that solutions do not introduce unintended impacts.
• 3. Translate business needs, operational concerns, and user-reported issues into clear technical requirements and workable solutions.
• 4. Review and fully understand assigned tasks, applicable requirements, dependencies, expected outcomes, and acceptance criteria before beginning development work. The resource must seek clarification when requirements are incomplete, inconsistent, or ambiguous.
• 5. Analyze design specifications and proposed solutions, identify technical risks or limitations, and provide constructive feedback regarding alternative designs, implementation methods, and performance considerations.
• 6. Develop and execute appropriate unit, integration, system, regression, and data-validation tests. Testing must confirm technical functionality, data accuracy, error handling, and compliance with defined requirements.
• 7. Create and maintain accurate system, program, operational, support, and user documentation.
• 8. Participate effectively in reviews of system designs, database designs, source code, test plans, implementation procedures, and deployment activities.
• 9. Assist technical and business users in understanding application functionality, warehouse data, data relationships, and reporting capabilities.
• 10. Manage assigned work independently, organize priorities, meet established deadlines, and coordinate effectively with other team members.
• 11. Identify and communicate risks, dependencies, technical concerns, and blockers promptly, including their potential effects on scope, schedule, system performance, and data quality.
• 12. Communicate incident status, technical findings, recommended solutions, implementation progress, and resolution details clearly to customers, stakeholders, and technical team members.

The resource must also demonstrate the ability to:

• Anticipate downstream effects on applications, ETL processes, warehouse data, interfaces, and reports.
• Evaluate more than one potential solution and explain the benefits, risks, effort, and maintainability of each approach.
• Produce reliable, maintainable, secure, and well-documented code.
• Provide technically sound recommendations and respectfully challenge a proposed design when a more effective approach is available.
• Collaborate effectively with developers, analysts, database administrators, business users, project managers, and support personnel.
• Take ownership of assigned work and production issues through completion.
• Explain complex technical matters in language appropriate for both technical and nontechnical audiences.

Requirements

Top Skills:

• Minimum of 7 years application development, database programming, and production-support experience.
• Minimum of 5 years of hands-on experience with Oracle databases, SQL, and PL/SQL.
• Experience must include work with data warehouses and ETL processes.