We are looking for an experienced Oracle SQL Developer to support application development, database programming, and production enhancements. The candidate will work closely with application developers, business analysts, and support teams to design efficient database solutions and ensure reliable application performance.
Key Responsibilities
- Design, develop, and maintain Oracle SQL and PL/SQL components supporting enterprise applications.
- Develop complex SQL queries, stored procedures, functions, packages, triggers, cursors, and views.
- Translate functional and application requirements into efficient database solutions.
- Perform SQL query optimization and performance tuning using execution plans, indexing, and other optimization techniques.
- Design and modify database objects including tables, views, sequences, indexes, constraints, and synonyms.
- Support application development teams with database integration and troubleshooting.
- Analyze and resolve database, data integrity, and application performance issues.
- Develop scripts for data migration, data validation, reconciliation, and deployment activities.
- Perform unit testing and support SIT/UAT and production implementation activities.
- Participate in code reviews and follow SQL/PLSQL coding and database development standards.
- Work with application, QA, DevOps, and production support teams during releases and issue resolution.
- Maintain technical documentation for database objects, interfaces, and application changes.
Required Technical Skills
- Strong hands-on experience with Oracle Database, SQL, and PL/SQL.
#J-18808-Ljbffr
Oracle DB Administration employer: W3Global
W3Global is an excellent employer that values independence and attention to detail, offering a supportive work environment in the picturesque city of Salisbury. Employees benefit from a flexible hybrid working model, opportunities for professional growth, and a culture that encourages innovation and collaboration. Join us to make a meaningful impact on our clients' financial operations while enjoying a balanced work-life experience.
