Job Description

We are seeking a skilled, motivated, and detail-oriented Mid-Level Developer with strong expertise in Oracle Database, Oracle APEX, and PostgreSQL. In this role, you will have hands-on responsibility for developing, enhancing, and maintaining robust enterprise applications using Oracle APEX. You will work extensively within Oracle database environments and play a critical role in supporting key database migration activities from PostgreSQL to Oracle systems. Additionally, exposure to or experience with Oracle APEX AI capabilities (specifically APEX 26 AI features) will be a significant advantage as we continue to integrate intelligent automation into our software suite.

Key Responsibilities

Application Development: Design, develop, secure, and maintain scalable web and enterprise applications using the Oracle APEX framework. Build highly responsive, modern, and user-friendly user interfaces.

Database & PL/SQL Engineering: Work extensively with Oracle Database and PL/SQL. Design, write, and optimize complex database objects, including stored procedures, functions, packages, database triggers, and views.

PostgreSQL Support: Manage, query, and support existing PostgreSQL database environments alongside Oracle systems.

Database Migration: Actively participate in PostgreSQL-to-Oracle database migration initiatives. This includes executing schema conversions, rewriting and optimizing queries for Oracle compatibility, and executing thorough data validation protocols to ensure data integrity.

AI Feature Integration: Explore, implement, and work with Oracle APEX 26 AI features, embedding AI-assisted functionalities and smart workflows into applications where required.

Troubleshooting & Optimization: Diagnose, debug, and resolve complex application and database-related performance bottlenecks or technical bugs.

Cross-Functional Collaboration: Partner closely with business analysts, project managers, and cross-functional engineering teams to perform requirement analysis, scoping, and architectural alignment.

Deployment & CI/CD: Support application deployment, unit testing, and production release management activities while following established version control processes.

Code Quality: Write exceptionally clean, well-documented, secure, maintainable, and highly optimized code according to industry best practices.

Role Requirements & Technical Skills

Required Skills

Technical Domain

Required Proficiency & Experience

Oracle Ecosystem

Strong hands-on experience with Oracle Database, Oracle APEX development, and advanced PL/SQL programming.

PostgreSQL Ecosystem

Solid foundational knowledge and hands-on experience working within PostgreSQL Database environments.

Database Migration

Direct project experience or deep understanding of PostgreSQL-to-Oracle database migration methodologies, tools, and validation.

Performance Tuning

Good understanding of relational database design, execution plans, index optimization, and query performance tuning.

APIs & Integrations

Practical experience building, consuming, and configuring REST APIs, SQL integrations, and web services.

Modern Capabilities

Familiarity or conceptual knowledge of Oracle APEX 26 AI features and AI-enabled application development capabilities.

Software Configuration

Solid understanding of modern version control systems (e.g., Git) and application deployment lifecycles.

Preferred Skills

Web Technologies: Practical development knowledge in frontend/backend technologies, including JavaScript, HTML5, CSS3, or general web standards to customize APEX Universal Theme components.

Integrations: Advanced understanding of complex third-party system integrations and authentication protocols (OAuth2, SSO).

Cloud Infrastructure: Familiarity with cloud database environments (e.g., Oracle Cloud Infrastructure - OCI, AWS, or Azure) and enterprise-level production deployments.

Soft Skills: Strong analytical, problem-solving, and debugging skills paired with clear communication capabilities.

Good to Have

Prior experience developing or supporting enterprise-level business workflow automation tools.

Direct hands-on exposure to implementing AI models, vector searches, or generative AI extensions within Oracle application frameworks.

Experience working inside fast-paced, iterative Agile/Scrum development environments.