We are seeking a skilled Oracle PL/SQL Developer with a minimum of 6 years of relevant experience to join our dynamic team. The ideal candidate will have extensive experience with Oracle PL/SQL 19c or higher, RAC, and Exadata environments, along with a strong background in various development and performance tuning tools.
Responsibilities
- Design, develop, and maintain complex PL/SQL applications in Oracle 19c or higher environments.
- Utilize Oracle RAC and Exadata for high availability and scalability of database solutions.
- Develop and optimize Dynamic SQL, Bulk Collects, and complex SQL queries.
- Generate and analyze AWR reports, and create SQL Profiles for performance tuning.
- Implement database partitioning and manage materialized views for performance improvement.
- Use TOAD, SQLT, and OEM for database development and performance monitoring.
- Develop web applications using Oracle APEX, HTML, CSS, and JavaScript.
- Integrate and automate database tasks using Python with libraries such as SQLAlchemy, cx_Oracle, PyODBC, Pandas, NumPy, Matplotlib, and Flask.
- Utilize APScheduler for scheduling and automating routine tasks.
- Develop and manage RESTful APIs, and use Postman for testing and debugging.
- Collaborate with cross-functional teams using VS Code and GIT for version control.
- Use Eclipse IDE for development and debugging.
Qualifications
- Oracle PL/SQL Developer Certified Associate
- Oracle Database SQL Certified Associate
- Oracle PL/SQL: Advanced skills in writing and optimizing PL/SQL code.
- Oracle Database: Extensive experience with Oracle 19c or higher, RAC, and Exadata environments.
- Development Tools: Proficient with TOAD, Oracle APEX, SQLT, OEM, and Eclipse IDE.
- Performance Tuning: Strong ability to generate and interpret AWR reports, create SQL Profiles, and implement partitioning and materialized views.
- Web Technologies: Knowledge of HTML, CSS, and JavaScript for web application development.
- Python Development: Experience with Python libraries such as SQLAlchemy, cx_Oracle, PyODBC, Pandas, NumPy, Matplotlib, Flask, and Django.
- APScheduler: Proficient in scheduling and automating tasks using APScheduler.
- API Development: Expertise in developing and managing REST APIs and using Postman for API testing.
- Version Control: Strong experience with VS Code and GIT for code management.