- Migrate existing Oracle APEX portal to Flask or FastAPI, preserving functionality while modernizing architecture.
- Build server-rendered web pages using Jinja2 for dashboards, forms, reports, CRUD workflows, and self-service portals.
- Write and optimize Oracle SQL and PL/SQL; design data access layers using python-oracledb or SQLAlchemy.
- Design RESTful APIs for frontend and integration with internal systems.
- Implement role-based access control with SSO and OpenAuth.
- Create self-service workflows for provisioning and operational tasks.
- Write tests and maintain CI/CD pipelines for automated deployment.
Required Qualifications
- 3–6 years of software engineering experience.
- Strong proficiency in Python (Flask or FastAPI).
- Working knowledge of HTML, CSS, JavaScript, and Jinja2 templating.
- Solid experience with Oracle SQL and PL/SQL (indexes, execution plans, joins, transactions).
- Experience with python-oracledb (cx_Oracle) for DB connectivity.
- Experience designing RESTful APIs.
- Proficient with Git and comfortable in Linux/Unix environment.
Preferred Qualifications
- Experience migrating from Oracle APEX / Oracle Forms or similar platforms.
- Familiarity with modern frontend frameworks (React, Vue).
- Experience with SQLAlchemy, containerization, or CI/CD tools.
- Exposure to Grafana, infrastructure automation, or DBA operations.
- Understanding of web application security best practices.
Tech Stack
- Backend: Python 3.x, Flask/FastAPI, SQLAlchemy, python-oracledb
- Frontend: HTML, CSS, JavaScript, Jinja2 templates
- Database: Oracle 19c / 21c / 23ai
- Infrastructure: Linux, Git, CI/CD pipelines
- Integration: REST APIs, internal automation frameworks