Direct message the job poster from Vantage
* 12 month contract, extended up to 3 years
* Hybrid – 2x a week on client site in Dublin
The following non-exhaustive list of Key Deliverables applies to this Role:
* Design, develop, and maintain databases ensuring stability, reliability, and performance.
* Optimize in-application PL/SQL statements as needed and establish best practices.
* Develop new database-centric functionalities for existing software products.
* Create technical and architectural documentation and provide instructions throughout the program development lifecycle.
* Provide expertise in the full development lifecycle, from concept and design to testing.
* Advise on Oracle features and recommend best practices for PL/SQL development.
* Ensure the performance, integrity, and security of databases and contribute to the re-architecture and refactoring of legacy systems.
* Ensure data consistency, clear definition, and accessibility while maintaining security and recovery control measures.
* Design database schemes, tables, and servers, setting appropriate user permissions.
* Create shell scripts and perform timely database backups.
* Generate and manage reports as required.
Minimum Requirements:
* 3-5 years of experience in Oracle Database Design & Development.
* Experience designing and building Oracle database schemas, ensuring their stability, reliability, and performance.
* Proficiency with Oracle Built-in Packages, Bulk Collect/Insert, Array Processing, Ref Cursors.
* Experience with Dynamic SQL – use of literal and bind variables.
* Application Tuning for optimal database performance.
* Scripting to generate views, procedures, functions, triggers, indexes, constraints, and packages.
* SQL tuning and Oracle query optimization using cost-based optimizers and other query tools.
* Logical and physical database design and implementation.
* Building and maintaining large-scale databases in a development environment.
Other Key Technical Skills:
* Excel spreadsheets manipulation using only PL/SQL (read and write).
* Binary file (BLOB) manipulation within PL/SQL.
* Programmatic reading and writing of JSON and XML using custom PL/SQL (without relying on Oracle built-in packages/objects).
* Understanding of Oracle APEX themes, CSS, and UI customization.
* Toolset Experience: Oracle 19c, Oracle ORDS, Oracle APEX, Jira, Confluence.
Apply Now:
If you would like to discuss this opportunity in person or with one of our IT Resourcers please forward your CV to Vantage or contact Cathy on +353 15255047 or cathy.wojnicki@vantage.ie for a confidential discussion. Vantage Resources will not forward your details without prior discussion and approval.
Seniority level
Not Applicable
Employment type
Contract
Job function
Information Technology
Industries
IT Services and IT Consulting
#J-18808-Ljbffr