Oracle Database Developer

2 weeks ago


Albany, United States CareerBuilder 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 week 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...


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


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

  • Oracle DBA

    1 week 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

    13 hours 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...


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

  • Database Administrator

    14 hours 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...


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


  • Albany, United States Castletop Logistics LLC Full time

    Job Overview: We are seeking a skilled Expert Database Administrator HBITS-05-13403. Install, configure, and maintain SQL Server database instances. Troubleshoot problems and provide technical explanations. Host\lead meetings in a group environment. Required to work on site from day 1 **DURATION**:30 Months **LOCATION**: Albany, NY - _Onsite_ Install,...

  • Oracle APEX Developer

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

  • Software Developer

    1 week ago


    Albany, United States MVP Consulting Inc Full time

    HBITS-03-12120 System Maintenance, Integration, enhancement efforts, modernization efforts related to daily production support of Workers' Compensation System (WC) and DBL Policy Services; Such as New/Refined development, production support, and analysis. The duties of the consulting resources would be to plan, streamline, create, modify, test and implement...


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

  • PeopleSoft Developer

    13 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 Four or...

  • Java Developer

    1 week ago


    Albany, United States PamTen Full time

    7 years of experience designing and implementing highly available and scalable multitier applications using Object Oriented or Service Oriented Architecture involving data structures, algorithms, software design and JEE design patterns. 7 years of experience in developing applications that are implemented with JAVA Development Kit (JDK 1.8 or higher). ...


  • Albany, United States Five Cubes, Inc. Full time

    Job Title: PeopleSoft Technical Developer Location: Albany, New York Duration: 12 + months (extendable) Direct Client Required Skills: 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...


  • Albany, United States Five Cubes, Inc. Full time

    Job Title: PeopleSoft Technical Developer Location: Albany, New York Duration: 12 + months (extendable) Direct Client Required Skills: 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...

  • java developer

    4 weeks ago


    Albany, New York, United States Reliant vision group inc Full time

    Experience in developing Java/ Backend/Mobile applications. Proficient in Java/J2EE with a good knowledge of its ecosystems. Experience in RESTful APIs (Spring Boot) to connect applications to back-end services. Strong knowledge in spring and spring boot framework. Strong database knowledge (SQL Oracle /NO SQL- Cassandra) is preferred. Solid understanding of...


  • Albany, United States Absolute Staffing & Consulting Solutions Full time

    Absolute Staffing is searching for a Java Lead/Sr. Developer to work with our client. Location: Albany, NY (Hybrid) Duration: 30 Months AssignmentJob Overview: 84 months experience in developing applications that are implemented with JAVA Development Kit (JDK 1.8 or higher). 84 months experience with web development using JSF/JSP, HTML, CSS, and JavaScript....

  • Java Lead/Sr Developer

    13 hours ago


    Albany, United States Absolute Staffing & Consulting Solutions Full time

    Absolute Staffing is searching for a Java Lead/Sr. Developer to work with our client. Location: Albany, NY (Hybrid) Duration: 30 Months AssignmentJob Overview: 84 months experience in developing applications that are implemented with JAVA Development Kit (JDK 1.8 or higher). 84 months experience with web development using JSF/JSP, HTML, CSS, and JavaScript....

  • .Net Developer

    1 week ago


    Albany, United States Mindlance Full time

    Job Title: .Net Developer Location: lbany, NY (12223) Duration: 30 months Assignment Key Responsibilities: • 84 months experience developing and implementing multi-tier .Net Framework and .Net Core web applications using C# code leveraging ASP.Net patterns: Web Forms and Model-View-Controller (MVC) • 84 months experience in creating test plans, test...