Senior ODS Developer

Farnell

Farnell an Avnet company is a global high-service distributor of technology products services and solutions for electronic system design maintenance and repair.

Job Summary:

We are seeking a Senior ODS (Operational Data Store) developer with strong expertise in Oracle Database technologies SQL/PLSQL development UNIX-based environments and delivering complex technical solutions in fastpaced global environments.

The ideal candidate brings 8 years of handson experience across Oracle platforms databases scripting version control and modern development and testing practices.

The role of senior ODS developer requires strong communication skills collaboration with stakeholders to validate user requirements assess available technologies and recommend solution options. You will have the opportunity to collaborate within a global team and interact with cross-functional teams to deliver solutions for strategic projects while meeting deadlines. We are looking for a proactive problem solver highly analytical selfdriven and eager to learn new technologies and processes while also sharing with your peers in the Middletier team.

Principal Responsibilities:

• Design develop and maintain solutions within Oracle Database platforms ensuring scalability reliability and adherence to architectural standards.
• Develop high-quality code using SQL and PL/SQL following best practices and performance optimization principles.
• Create and review detailed technical designs ensuring all requirements and use cases are fully addressed and the solution met all the performance criteria and best practices that you will contribute to maintain.
• Develop and maintain UNIX shell scripts scheduled jobs and automation tools using languages such as Perl Python or Jython.
• Write and optimize PL/SQL packages queries AQ queues and jobs within Oracle databases.
• Collaborate with DevOps teams using GitLab or SVN for version control merge requests and deployment pipelines.
• Use Jira for task tracking release management and project coordination.
• Conduct thorough unit testing regression testing and stress testing properly documented so they can be reviewed by the other members of the team using frameworks such as UTPLSQL. This will include yourself being the reviewer of those documents when you are leading the project.
• Participate actively in daily team meetings as part of a global MiddleTier team ensuring continuous communication and alignment. Involvement and participation are key in the team where we can all offer guidance to other members of the team.
• Support troubleshooting and triage activities across database and UNIX environments.
• Lead projects or components of projects ensuring timely and highquality delivery.
• Work proactively with architects and cross-functional teams to ensure architectural consistency and quality.

Required Skills & Experience
Technical Skills:

• 8 years of experience in IT including extensive handson work in Oracle Database environments.
• Expertise in at least three of the following:
  • SQL
  • PL/SQL
  • Shell scripting
  • UNIX
• Working experience 6 years with event rules VPD policies audit events scheduled jobs triggers etc.
• Strong understanding of Oracle system architecture subsystems and internal processes.
• Solid experience working in UNIX environments and writing scripts in shell scripting Perl python jython or similar.
• Handson experience with GitLab and/or SVN including merge requests and CI/CD pipelines.
• Experience documenting designs writing clear technical specifications and validating business requirements.
• Experience of unit testing all software development and knowledge of the relevant tools based on the development platform. Required working experience on UTPLSQL.
• Familiarity with test automation unit testing frameworks regression testing and performance/stress testing tools.
• Experience using Jira for issue tracking and project management.

Soft Skills:

• Strong analytical and conceptual thinking abilities to work hands-on in a fast-paced environment.
• Excellent written and verbal communication skills including the ability to work with global architects and distributed teams.
• Ability to lead tasks or projects and deliver within established deadlines.
• High degree of selfmotivation and demonstrated capacity for selflearning.
• Willingness to learn new processes and apply them consistently.
• Comfortable collaborating across regions as part of a global Middletier team.

The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills.