Senior Programmer

Duration: 8 months to start

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; 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.
• Work with limited supervision and exercise sound technical judgment; independently analyze complex systems and data issues, determine appropriate course of action, and carry work through development, testing, implementation, and production validation.
• 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 non‑technical audiences.

Requirements

• 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.
• Senior‑level experience developing, maintaining, troubleshooting, and optimizing complex database applications and data‑processing solutions.
• Experience with data warehouses, ETL processes, production data loads, performance analysis, defect correction, and data‑quality validation.

Skills

• Advanced proficiency in Oracle relational database technologies.
• PL/SQL development, including packages, procedures, functions, triggers, and complex stored program units.
• Writing, analyzing, and optimizing complex SQL queries.
• Proficiency with 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 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‑warehouse concepts, including dimensional data structures, source‑to‑target mappings, data reconciliation, and reporting dependencies.
• 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.