Programmer (Specialist)

Randstad Digital Americas; Augusta (ME); On-site; USD 73,000 - 80,000; Full time

Job summary

Randstad Digital in Augusta, Maine seeks an experienced Oracle/SQL developer for a contract role. The position requires seven or more years of application development and database programming, with at least five years in Oracle, SQL, and PL/SQL.

You will design, optimize, and support data-driven solutions across data loads, production incidents, and data validation tasks. The role asks for strong troubleshooting, requirements translation, and documentation skills, along with the ability to work

Qualifications

• Minimum seven years of progressively responsible application development and database programming.
• At least five years hands-on experience with Oracle databases, SQL, and PL/SQL.
• Senior-level experience developing, maintaining, and optimizing complex database applications.

Responsibilities

• Monitor and validate data loads, reconcile results, and resolve data quality issues.
• Investigate production incidents and identify root causes without introducing new issues.
• Translate business needs into technical requirements and workable solutions.
• Review tasks and acceptance criteria before starting development work.
• Analyze designs, identify risks, and provide feedback on alternatives.
• Develop and execute unit, integration, system, and data validation tests.
• Create and maintain system, program, and user documentation.
• Collaborate in reviews of system designs, code, and deployment steps.
• Assist users in understanding application functionality and data relationships.
• Manage work independently, prioritize, and meet deadlines.
• Identify risks, dependencies, and blockers and communicate them clearly.
• Report incident status and technical findings to customers and team.

Skills

Oracle relational database tecnologies

PL/SQL development

Writing complex SQL queries

Troubleshooting existing application

SQL performance analysis

ETL processing

Education

Bachelor's degree

Tools

Oracle SQL Developer

Job description

Job Summary

The proposed resource must possess a minimum of seven (7) years of progressively responsible application development, database programming, and production-support experience, including at least five (5) years of hands‑on experience with Oracle databases, SQL, and PL/SQL. The resource must demonstrate senior‑level experience developing, maintaining, troubleshooting, and optimizing complex database applications and data‑processing solutions.

location: Augusta, Maine

job type: Contract

salary: $53 - 58 per hour

work hours: 8am to 6pm

education: Bachelors

Responsibilities

• Monitor and validate scheduled and ad hoc data loads, reconcile source and target results, investigate discrepancies, and resolve data-quality issues.
• Investigate production incidents, analyze application and database behavior, identify root causes, correct defects, and verify that solutions do not introduce unintended impacts.
• Translate business needs, operational concerns, and user‑reported issues into clear technical requirements and workable solutions.
• 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.
• Analyze design specifications and proposed solutions, identify technical risks or limitations, and provide constructive feedback regarding alternative designs, implementation methods, and performance considerations.
• 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.
• Create and maintain accurate system, program, operational, support, and user documentation.
• Participate effectively in reviews of system designs, database designs, source code, test plans, implementation procedures, and deployment activities.
• Assist technical and business users in understanding application functionality, warehouse data, data relationships, and reporting capabilities.
• Manage assigned work independently, organize priorities, meet established deadlines, and coordinate effectively with other team members.
• Identify and communicate risks, dependencies, technical concerns, and blockers promptly, including their potential effects on scope, schedule, system performance, and data quality.
• Communicate incident status, technical findings, recommended solutions, implementation progress, and resolution details clearly to customers, stakeholders, and technical team members.

Qualifications

• 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.

data integration,data‑processing,data transformation,data warehouses,Data-warehouse,dimensional data,database applications,database designs,database programming,database,diagnostic tools,ETL processes,ETL,complex SQL queries,production data,Oracle,Oracle databases,Oracle SQL Developer,PL/SQL,relational database,SQL,user documentation,application development,Communicate,organize,coordinate,troubleshooting,work independently,acceptance criteria,data reconciliation,business needs,data relationships,data accuracy,data quality,database administrators,design specifications,validation tests,production validation,constructive feedback,incident investigation,performance analysis,Production support,investigate,risks,error handling,warehouse,system designs,test plans,Testing,quality validation

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact [e-mail].

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.