Oracle Database Developer

4 weeks ago

Albany, United States Oscar Full time

Job Description:

We are seeking an experienced Oracle Systems Developer to join our team and contribute to the development and maintenance of backend processing systems for businesses and organizations. As an Oracle Systems Developer, you will be responsible for developing and implementing applications and programs, with a focus on Oracle technologies.

Responsibilities:

  • Reverse engineer Oracle Warehouse Builder (OWB) ETL processes and develop new replacement Oracle Data Integrator (ODI) processes while ensuring consistent functionality.
  • Utilize expertise in data modeling (dimensional & relational), process improvement, normalization/de-normalization, data extraction, data cleansing, and data manipulation in a child welfare environment.
  • Perform development work using PL/SQL in an Oracle Data Warehouse environment.
  • Implement advanced Extract/Transform/Load (ETL) techniques including bulk select, bulk insert, arrays, dynamic SQL, and develop detailed incremental ETL processes.
  • Develop and test maps, perform source-to-target mappings, and conduct storage capacity planning in Oracle Data Integrator (ODI).
  • Build database schemas, tables, views, indexes, and stored procedures.
  • Work in a UNIX or LINUX environment, developing Unix Shell Scripting and utilizing sftp protocols.
  • Participate in all phases of the Software Development Life Cycle (SDLC) including requirement gathering, development, testing, debugging, deployment, documentation, and production support.
  • Resolve load issues, inquiries, and perform 2nd level testing of issues and code fixes.
  • Contribute to infrastructure upgrades and enhancements, including Oracle upgrades.

Requirements:

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • Minimum 84 months (7 years) of experience in Oracle systems development.
  • Expertise in reverse engineering OWB ETL processes and developing replacement ODI processes.
  • Proficiency in data modeling, PL/SQL development, and advanced ETL techniques.
  • Experience with Oracle Data Integrator (ODI), Unix Shell Scripting, and sftp protocols.
  • Strong understanding of SDLC principles and practices.
  • Excellent problem-solving and troubleshooting skills.
  • Ability to work effectively in a team environment and provide guidance to large teams.
  • Excellent communication and interpersonal skills.

This position offers an exciting opportunity to work with cutting-edge technologies and make significant contributions to the backend processing systems of our organization. If you have a passion for Oracle systems development and meet the qualifications outlined above, we encourage you to apply.

Oscar Associates Limited (US) is acting as an Employment Agency in relation to this vacancy.

  • Database Developer

    1 day ago

    Albany, United States Avenues International, Inc. Full time

    Position Name: Database DeveloperJob ID: HBITS-05- 13417Duration: 5+ MonthsLocation: Albany, NY, (Day 1 Onsite)Primary Skills:60 Months Experience with relational database management systems.48 Months Experience with Oracle 10g or higher.48 Months Experience writing complex stored procedures with the use of triggers.48 Months Experience with designing and...

  • Database developer

    1 day ago

    Albany, United States Mindlance Full time

    Job Title: Database developer Job Type: lbany, New York (Hybrid) Duration: 30 Months Required Skills: • 84 month's experience developing and supporting Microsoft Access databases / applications. • 84 Month's experience developing and supporting Oracle Databases. • 84 month's experience developing and supporting Microsoft SQL Databases. • 84 month's...

  • MS Access/Oracle developer

    7 days ago

    Albany, United States Mindlance Full time

    Job Title: MS Access/Oracle developer Job Type: Albany, NY (Hybrid) Duration: 24 Months Required Skills: • 72 months of experience gathering, documenting and tracking changes of functional and technical requirements for development and maintenance of advanced Access/Oracle Databases. • 84 months of experience gathering requirements and developing and...

  • Software Developer

    4 weeks ago

    Albany, United States Castletop Logistics LLC Full time

    Overview: We are seeking a Software Developer (Oracle APEX) Consultant to act as a Software Developer for the APEX Team in the OSC Division of the Chief Information Officer (CIO). **Responsibilities**: - Work under the guidance of the APEX Team Manager and Supervisor. - Help OSC management develop APEX Roadmap and Strategy. - Contribute to the development...

  • Oracle DBA

    7 days ago

    Albany, United States Mindlance Full time

    Job Title: Oracle DBA Location: Menands, NY Duration: 12 Months Required Skills: • 84 months of experience troubleshooting Oracle 10g or higher database performance and other related issues; specifically by working with other teams to identify if the issue is at the storage, network, database, or application tier. • 84 months of experience working with...

  • Oracle DBA

    1 day ago

    Albany, United States Mindlance Full time

    Job Title: Oracle DBA Location: Menands, NY Duration: 12 Months Required Skills: • 84 months of experience troubleshooting Oracle 10g or higher database performance and other related issues; specifically by working with other teams to identify if the issue is at the storage, network, database, or application tier. • 84 months of experience working with...

  • Sr. .NET Developer with Oracle DB

    4 days ago

    Albany, United States Sligo Software Solutions Full time

    Job DescriptionJob DescriptionDescription Systems Developer responsible for building .NET applications using c#, MVC, bootstrap, .net core and Oracle.DutiesWork in coordination with a team of developers to expand the current system.Work with Business Analyst on analysis and logical design.Perform unit testing and correct all identified bugs.Perform complex...

  • Database Administrator

    7 days ago

    Albany, United States Symplr Software LLC Full time

    Overview The Database Administrator implements, maintains and continuously improves RDBMS systems to ensure availability, scalability, and advancement of our enterprise applications, showcasing solid technical and interpersonal skills to assist in debugging protocols/process for stack callbacks, implementing corrective action within SQL scope, and analyzing...

  • Need for Oracle SQL Developer with healthcare Exp + ALBANY, NY

    1 day ago

    Albany, United States 3A Soft Inc Full time

    84 months experience in the area of: Public Health information Systems such as Medicaid or the Childs Health Insurance Program 84 months experience using Oracle products including: SQL Developer, SQL plus and executing SQL scripts using DBeaver to query Vertica and Oracle Databases 84 months experience Working with Stakeholders and vendor in the entire...

  • .NET Developer With Oracle 11G

    1 day ago

    Albany, United States Avtech solution Full time

    Job Title: ON-SITE - .NET Developer With Oracle 11G Location: Albany, NY Duration: Long-term Project: Behavioral Health Authentication and Authorization Solution (BHAAS) and other OMH projects as needed. Detailed Job Description: Lead developer for several applications, including but not limited to, Security Application Rewrite using Microsoft .Net Core,...

  • Database Architect/Developer

    4 days ago

    Albany, United States Empire State Full time

    *Applicants MUST submit a cover letter with resume to be considered.*Position expected to work onsite and hybrid consistent with New York State.BASIC FUNCTION: For the Database of Economic Incentive’s: Develop, test, and maintain new and existing Microsoft SQL Server Databases in support of ESD’s business requirements. Applicant must possess a...

  • Database Architect/Developer

    4 weeks ago

    Albany, United States Empire State Full time

    Job DescriptionJob Description*Applicants MUST submit a cover letter with resume to be considered.*Position expected to work onsite and hybrid consistent with New York State.BASIC FUNCTION: For the Database of Economic Incentive’s: Develop, test, and maintain new and existing Microsoft SQL Server Databases in support of ESD’s business requirements....

  • Systems Developer Expert( Sr .Net developer

    6 days ago

    Albany, United States Princeton IT Services Full time

    Job DescriptionJob DescriptionJob Title: Systems Developer Expert( Sr .Net developer)Location: Albany, NYJob Type: ContractJob Summary:Develops and implements applications and programs for the backend processing systems used in businesses and organizations.Requirements:84 months experience developing n-tiered applications utilizing .Net using MVC pattern. 84...

  • Systems Developer Expert( Sr .Net developer

    6 days ago

    Albany, United States Princeton IT Services Full time

    Job DescriptionJob DescriptionJob Title: Systems Developer Expert( Sr .Net developer)Location: Albany, NYJob Type: ContractJob Summary:Develops and implements applications and programs for the backend processing systems used in businesses and organizations.Requirements:84 months experience developing n-tiered applications utilizing .Net using MVC pattern. 84...

  • Oracle APEX Developer

    3 weeks ago

    Albany, New York, United States System Edge (USA) L.L.C. Full time

    Hello, We are urgently hiring for the below contractual role with our Direct clientNYS:Job Title: Oracle APEX DeveloperClient: State of New YorkAgency: Office of the New York State Comptroller (OSC)Task ID: HBITS Location: 110 State Street Albany, NY 12236Duration: 12 monthsRate: $60/hr on C2C (all incl.) This is a long term opportunity on the Hourly-Based...

  • Expert System Developer 5/24

    1 day ago

    Albany, United States Dogwood Management Partners, LLc Full time

    Requirements:84 months experience developing .net web applications.72 months experience writing and developing Web Services or WCF.36 months experience developing applications utilizing CSLA.84 months experience with PL/SQL writing packages, stored procedures and triggers.48 months experience utilizing Model View Controller (MVC).36 months experience with...

  • PeopleSoft Developer

    22 hours ago

    Albany, United States Five Cubes Inc Full time

    Job Title: PeopleSoft Developer Location: Albany, New York Duration: 12+ months Direct Client Requirements: Four or more years of application development experience with PeopleSoft using at least three of the following toolsets: XML,PeopleSoft SQR, PeopleTools, PeopleCode, PSQuery, Data Mover, Application Engine, and Component Interface ...

  • PeopleSoft Developer

    7 days ago

    Albany, United States Five Cubes, Inc. Full time

    Job Title: PeopleSoft Developer Location: Albany, New York Duration: 12+ months Direct Client Requirements: Four or more years of application development experience with PeopleSoft using at least three of the following toolsets: XML,PeopleSoft SQR, PeopleTools, PeopleCode, PSQuery, Data Mover, Application Engine, and Component Interface Four or...

  • .Net Developer

    16 hours ago

    Albany, United States Avenues International Full time

    Job DescriptionJob DescriptionPosition Name: Systems Developer- ExpertJob ID:- HBITS-05-13415Location Albany, NY (day 1 onsite) Duration: 24 Months84 months experience developing n-tiered applications utilizing .Net using MVC pattern.84 months experience writing and developing Web Services or Windows Communication Foundation (WCF)84 months experience with...

  • Tableau Developer

    2 days ago

    Albany, United States CMA Full time

    CMA Consulting Services has an immediate need for experienced and certified Tableau Developers in support of CMA’s Medicaid Data Warehouse Project in Albany, NY. Tableau Developers will be responsible for designing and maintaining dashboards using various databases. Mandatory experience includes:4+ years of experience in Tableau dashboard development.4+...