Senior ODS Developer

Job description

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 fast‑paced, global environments. The ideal candidate brings 8+ years of hands‑on 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, self‑driven, 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 high‑quality 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 hands‑on 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. Hands‑on 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 self‑motivation and demonstrated capacity for self‑learning. 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.