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.
BIOS/Firmware Developer overseeing embedded software design and leading cross - functional teams on innovative solutions. Providing mentorship to junior engineers and managing firmware development projects.
Senior Director of Engineering leading design and execution of Leah’s technology platform. Overseeing product initiatives and collaborating with cross - functional teams in a high - growth AI - driven environment.
Experienced IBM iSeries Developer working on AS/400 platform with focus on batch processing and data management. Requires expertise in RPGLE and COBOL/400.
Senior SPS - Programmierer working on diverse automation projects from concept to commissioning in a small expert team. Emphasizing community with team activities after work.
Scientific Applications Programmer supporting the Environmental Modeling Center for weather prediction. Developing workflows and tools for mission - critical weather prediction systems with a collaborative team environment.
Lead software development teams at Dun & Bradstreet, managing diverse projects across global regions. Focus on innovation and collaboration in a fast - paced environment.
Cobol Developer at Fiserv developing and supporting mainframe applications in a fast - paced environment. Ensure system reliability and performance for core financial services platforms.
Cobol Developer joining technology team supporting enterprise mainframe applications at Fiserv. Modifying and optimizing mainframe applications in a fast - paced environment.
Oracle Developer responsible for designing and maintaining ETL processes in financial markets applications. Collaborating in an Agile environment to optimize data workflows and systems.
Integration, Google Apigee developer, Senior Associate driving API gateway platforms at PwC Canada. Responsible for hands - on design and operation of secure, scalable API functionalities.