Oracle Database Developer
3 weeks ago
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.
You could be just the right applicant for this job Read all associated information and make sure to apply.
Oscar Associates Limited (US) is acting as an Employment Agency in relation to this vacancy.
Remote working/work at home options are available for this role.-
Database Developer
2 days ago
Albany, United States Avenues International, Inc. Full timePosition 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
2 days ago
Albany, United States Mindlance Full timeJob 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
1 week ago
Albany, United States Mindlance Full timeJob 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
1 month ago
Albany, United States Castletop Logistics LLC Full timeOverview: 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
2 days ago
Albany, United States Mindlance Full timeJob 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 week ago
Albany, United States Mindlance Full timeJob 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
5 days ago
Albany, United States Sligo Software Solutions Full timeJob 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
1 week ago
Albany, United States Symplr Software LLC Full timeOverview 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 3A Soft Inc Full time84 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
2 days ago
Albany, United States Avtech solution Full timeJob 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
5 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 timeJob 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
7 days ago
Albany, United States Princeton IT Services Full timeJob 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
7 days ago
Albany, United States Princeton IT Services Full timeJob 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 timeHello, 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
2 days ago
Albany, United States Dogwood Management Partners, LLc Full timeRequirements: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
1 week ago
Albany, United States Five Cubes, Inc. Full timeJob 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
2 days ago
Albany, United States Five Cubes Inc Full timeJob 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 ...
-
.Net Developer
1 day ago
Albany, United States Avenues International Full timeJob 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
4 days ago
Albany, United States CMA Full timeCMA 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+...