Direct message the job poster from Vantage
Principal Recruitment Consultant at Vantage
Don’t miss out on this great opportunity. Apply today to work for a large public sector body!!!
What’s involved:
1. Design, develop, and maintain databases ensuring stability, reliability, and performance.
2. Optimize in-application PL/SQL statements as needed and establish best practices.
3. Develop new database-centric functionalities for existing software products.
4. Create technical and architectural documentation and provide instructions throughout the program development lifecycle.
5. Provide expertise in the full development lifecycle, from concept and design to testing.
6. Advise on Oracle features and recommend best practices for PL/SQL development.
7. Ensure the performance, integrity, and security of databases and contribute to the re-architecture and refactoring of legacy systems.
8. Ensure data consistency, clear definition, and accessibility while maintaining security and recovery control measures.
9. Design database schemes, tables, and servers, setting appropriate user permissions.
10. Create shell scripts and perform timely database backups.
11. Generate and manage reports as required.
What you need:
1. 7+ years of experience
2. Oracle Database Design & Development
3. Designing and building Oracle database schemas, ensuring their stability, reliability, and performance.
4. Oracle Built-in Packages, Bulk Collect/Insert, Array Processing, Ref Cursors.
5. Dynamic SQL – use of literal and bind variables.
6. Application Tuning for optimal database performance.
7. Scripting to generate views, procedures, functions, triggers, indexes, constraints, and packages.
8. SQL tuning and Oracle query optimization using cost-based optimizers and other query tools.
9. Logical and physical database design and implementation.
10. Building and maintaining large-scale databases in a development environment.
11. Must hold valid working visa – stamp 4/ Irish Citizenship / EU
What’s on offer:
1. Hybrid model
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 Tinley on +353 012952850 or tinley.tubbert@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