Oracle pl/Sql Developer

About Matalan

From humble beginnings to disruptive innovations in the retail industry, find out about how Matalan is ever-evolving here.

We know as a team, we are stronger together - we champion equality for all and make lasting connections that go beyond work. We thrive off our inclusive culture, encouraging our colleagues to bring their true selves to work and contributing to collective creativity, open-mindedness, and growth.

We want to give every candidate the opportunity to perform at their best throughout the application and interview process and then ultimately in their role. If you require any adjustments during our recruitment process, please don't hesitate to let us know.

In the event that a high volume of suitable applications are received, the post may close prior to the specified closing date. Please apply as soon as possible if interested.

About the role

We are seeking an Oracle PL/SQL Developer to join our team. As an Oracle PL/SQL Developer, you will be responsible for developing, testing, and maintaining Oracle PL/SQL code to support our organization's database systems and applications. You will collaborate closely with cross-functional teams, including software developers, database administrators, and business analysts, to design and implement efficient and scalable database solutions.

Key Responsibilities

1. Develop and maintain Oracle PL/SQL code to meet business requirements and functional specifications.
2. Design, implement, and optimize database structures, queries, and stored procedures to ensure high performance and data integrity.
3. Collaborate with software developers, business analysts, and database administrators to understand requirements and translate them into technical designs.
4. Troubleshoot and resolve database-related issues, such as performance bottlenecks, data integrity problems, and application defects.
5. Conduct thorough unit testing and participate in code reviews to ensure code quality and adherence to coding standards.
6. Create and maintain technical documentation, including database schemas, data dictionaries, and design documents.
7. Stay up-to-date with industry best practices and emerging trends in Oracle PL/SQL development and database technologies.
8. Participate in the analysis and optimization of existing database code and query performance.

About You

1. Experience in Computer Science, Information Technology, or a related field.
2. Proven work experience as an Oracle PL/SQL Developer, with an understanding of Oracle database architecture and data modeling principles.
3. Proficiency in writing complex SQL queries, stored procedures, triggers, and functions using PL/SQL.
4. Experience in performance tuning and query optimization techniques to improve database performance.
5. Familiarity with Oracle database tools, such as SQL Developer, Toad, or PL/SQL Developer.
6. Knowledge of database design principles, relational database concepts, and normalization.
7. Problem-solving and analytical skills, with the ability to debug and resolve database-related issues.
8. Excellent communication and teamwork skills to collaborate effectively with cross-functional teams.
9. Self-motivated and able to work independently, as well as in a team-oriented, collaborative environment.
10. Strong attention to detail and ability to deliver high-quality work within specified deadlines.

Desirable

1. Experience with Oracle database version 11g or higher.
2. Familiarity with Oracle APEX (Application Express) for building web applications.
3. Knowledge of Oracle Database Performance Monitoring and Tuning tools.
4. Understanding of software development life cycle (SDLC) methodologies, such as Agile or Waterfall.

Benefits

In addition to competitive salaries, we also offer the below core benefits:

1. 20% staff discount, which increases with length of service
2. Thrive Recognition Scheme
3. Wellbeing support provided by the Retail Trust
4. Life Assurance
5. Retail Rewards platform offering discounts for other retailers
6. Pension Scheme
7. Access to a wide range of career development
8. Additional benefits may apply depending on your role and area of the business