Database Developer | Albany, NY (Onsite) | Only W2

Position: Oracle PL/SQL & Oracle APEX Developer

< data-start=310 data-end=326>Job Summary

We are seeking a highly skilled Oracle Developer with extensive experience in Oracle Database development, PL/SQL programming, Oracle Application Express (APEX), production support, and scripting. The ideal candidate will be responsible for developing, maintaining, and supporting mission-critical database applications and ensuring the smooth operation of production environments.

---

Required Experience & Qualifications

< data-start=757 data-end=789>Oracle Database Development

• Minimum 84 months (7+ years) of experience working directly with Oracle Database 12c or higher.
• Strong expertise in:
  • PL/SQL Programming
  • Functions
  • Stored Procedures
  • Packages
  • Triggers
  • Table Design and Management
  • Query Optimization
  • Performance Tuning
  • Business Rule Implementation

< data-start=1116 data-end=1151>PL/SQL Application Development

• Minimum 84 months (7+ years) of hands-on experience performing application development using PL/SQL.
• Experience developing, testing, debugging, and maintaining database-driven applications.
• Ability to analyze business requirements and translate them into technical solutions.

< data-start=1439 data-end=1477>Oracle Application Express (APEX)

• Minimum 60 months (5+ years) of experience developing web-based database applications using Oracle Application Express (APEX).
• Experience designing, developing, enhancing, and maintaining Oracle APEX applications.
• Strong understanding of APEX architecture, reports, forms, dashboards, and security features.

< data-start=1801 data-end=1837>Production Support & Operations

• Minimum 60 months (5+ years) of experience supporting and monitoring a 24/7 production environment.
• Experience managing approximately 250 production jobs per month.
• Ability to respond to production control communications and troubleshoot operational issues.
• Experience performing root cause analysis and implementing corrective actions.

< data-start=2196 data-end=2232>Scripting & Runbook Development

• Minimum 60 months (5+ years) of experience creating and maintaining production environment runbooks.
• Strong experience with shell scripting.
• Experience with Perl scripting preferred.
• Ability to automate operational processes and support activities.

---

Key Responsibilities

• Design, develop, test, and maintain Oracle database applications.
• Develop and optimize PL/SQL code, procedures, functions, packages, and triggers.
• Build and support Oracle APEX web-based applications.
• Monitor and support production environments to ensure system availability and performance.
• Troubleshoot application and database issues and provide timely resolutions.
• Create and maintain operational documentation and runbooks.
• Develop automation scripts to improve operational efficiency.
• Collaborate with business users, analysts, and technical teams to deliver solutions.
• Participate in code reviews, testing, deployment, and production support activities.
• Ensure adherence to coding standards, security requirements, and best practices.

---

Required Skills

• Oracle Database 12c or higher
• Oracle PL/SQL
• Stored Procedures
• Functions
• Packages
• Triggers
• SQL Query Optimization
• Database Performance Tuning
• Oracle Application Express (APEX)
• Shell Scripting
• Production Support
• Troubleshooting
• Documentation & Runbook Creation

Preferred Skills

• Perl Scripting
• Batch Processing
• Job Scheduling Tools
• Database Administration Knowledge
• Process Automation