Design, develop, and implement complex database structures, stored procedures, functions, triggers, and packages using Oracle PL/SQL.
Optimize and tune PL/SQL code for performance.
Maintain and enhance existing PL/SQL codebase.
Perform regular database maintenance tasks such as backups, indexing, and data migrations.
Collaborate with application developers to integrate Oracle databases with front-end JAVA applications via JDBC.
Develop and implement data integration solutions using SQL*Loader, external tables, and other Oracle tools.
Provide technical support for database-related issues, including troubleshooting and performance tuning.
Assist in resolving complex data issues and support end-users.
Create and maintain comprehensive technical documentation for database applications.
Generate reports and queries as needed to support business operations.
Conduct code reviews and ensure adherence to best practices and coding standards.
Participate in system testing and validation processes.

Requirements

Bachelor’s degree in Computer Science, Information Technology, or a related field.
5+ years of professional experience as an Oracle PL/SQL Developer
Experience with Oracle database administration and performance tuning.
Experience with Batch Processing
Experience with Oracle tools and technologies such as SQL*Plus, Oracle SQL Developer, or TOAD.
Familiarity with version control systems (e.g., GitLab).
Excellent problem-solving and analytical skills.
Strong communication and collaboration abilities.
Ability to work independently and as part of a team.
Preferred: experience with Java, Python and Snowflake
Preferred: Oracle Certified Professional

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Oracle PL/SQLdatabase structuresstored proceduresfunctionstriggersperformance tuningSQL*LoaderBatch ProcessingJavaPython

Soft Skills

problem-solvinganalytical skillscommunicationcollaborationindependent workteamwork

Certifications

Oracle Certified Professional