Develop, optimize, and maintain JPQL (Java Persistence Query Language) queries to interact with the Oracle database effectively.
Design and implement complex SQL queries, stored procedures, functions, triggers, and views to support application development and data integration needs.
Ensure high performance and responsiveness of Oracle database operations, optimizing query performance and reducing execution times.
Implement best practices for database management, including indexing strategies, query optimization, and efficient data retrieval techniques.
Perform database tuning and maintenance activities, including partitioning, data archiving, and backup/recovery strategies.
Develop and maintain documentation for database designs, queries, procedures, and other technical specifications.
Troubleshoot database-related issues, providing timely resolution and ensuring minimal disruption to services.
Qualifications:
Bachelor’s degree in Computer Science, Software Engineering, or a related field.
5+ years of experience as an Oracle Developer.
Strong proficiency in Oracle SQL and PL/SQL for writing complex queries, stored procedures, functions, and triggers.
Solid understanding of Oracle database architecture, including performance tuning, indexing, and query optimization techniques.
Familiarity with Oracle tools and utilities such as Oracle SQL Developer, Oracle Enterprise Manager, and Oracle Data Pump.