Hybrid Senior ODS Developer

Posted 5 hours ago

Apply now

About the role

  • Senior ODS Developer at Avnet, utilizing Oracle Database technologies and collaborating with global teams. Involves developing and maintaining technical solutions while supporting strategic projects.

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.
  • Participate actively in daily team meetings as part of a global MiddleTier team, ensuring continuous communication and alignment.
  • Support troubleshooting and triage activities across database and UNIX environments.
  • Lead projects or components of projects, ensuring timely and high-quality delivery.

Requirements

  • 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.

Benefits

  • Flexible work arrangements

Job title

Senior ODS Developer

Job type

Experience level

Senior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job