W2 - Oracle Database Developer (PL/SQL, Data warehouse, ETL, UNIX Shell script, SQL*Loader, mod_plsql package) - Hybrid Job at Tanson Corp, City, NV

eWFzVzVUYTNibXNOdUkrdEpUbmJaTjlFanc9PQ==
  • Tanson Corp
  • City, NV

Job Description

Description:

Looking for local candidate who can work for Hybrid role in Carson City, 10% onsite.



Scope of Work:

1. Project Overview: o The IT Programmer will be responsible for upgrading (or creating new) Oracle database and data warehouse views, stored procedures, Unix Shell scripts, batch jobs, and other items from multiple legacy, on-premises Oracle databases (12c and 19c) to our new, cloud-based ERP database solution (Oracle 19c).



2. Key Responsibilities:

o Develop new PL/SQL queries, scripts, and stored procedures to support data integration between the legacy data warehouse and the new ERP.

o Modify and optimize existing PL/SQL code to improve performance and functionality.

o Collaborate with the project team to understand requirements and translate them into technical solutions.

o Perform data analysis and validation to ensure accuracy and completeness of data transfers.

o Document all developed code, scripts, and procedures thoroughly.

o Troubleshoot and resolve issues related to data integration and interface functionality.

3. Required Skills and Qualifications:

o Proficiency in Oracle's PL/SQL is essential.

o Experience with data warehousing concepts and ETL processes.

o Experience with UNIX Shell scripting and Scheduler jobs (Cosmos or Automate).

o Experience with SQL*Loader and mod_plsql package.

o Strong analytical and problem-solving skills.

o Ability to work independently and in a team environment.

o Excellent communication skills to interact effectively with technical and non-technical stakeholders.

o Prior experience in ERP data integration projects is a plus.

o Ability to pass a background check.

4. Work Environment:

o Full-time position with standard working hours.

o The work may require occasional flexibility in hours to accommodate project needs.

o The position is preferably located in person at the OPM Offices in Carson City, Nevada.

o The position may involve remote work depending on individual capabilities and Project criteria.



5. Deliverables:

o Functional and efficient PL/SQL code (or other scripting code as required).

o Documentation of developed code and procedures.
o Timely resolution of issues and bugs related to data interfaces.

6. Evaluation and Feedback:
o Regular performance evaluations based on deliverables, teamwork, and adherence to project timelines.

o Continuous feedback to improve performance and enhance project outcomes.

Job Tags

Full time, Local area, Remote job,

Similar Jobs

J3 Owens Group

Flexible PT Opportunity for Driven Professionals (Remote) Job at J3 Owens Group

 ...Part-Time | Remote | Daily Pay | No Cold Calling | Commission-Based Are you exploring...  ...quickly. What Youll Do Work remotely from your home office Assist clients who have...  ...provided Set your own schedule evenings/weekends welcome What We Provide... 

Apex Focus Group Inc.

Remote Call Center Representative Agent - Part-Time Focus Group Panelist Job at Apex Focus Group Inc.

 ...Job Benefits: Flexibility to take part in discussions online or in-person No commute needed if you choose to work from home...  ...session studies If you are looking for a flexible part-time remote work from home job, this is a great position to supplement your... 

Sodexo Group

General Manager Premium Airport Lounge Experience (Boston) Job at Sodexo Group

 ...A global food services provider is seeking a dynamic General Manager for their premium lounge at Logan International Airport. The ideal candidate should possess strong leadership skills, financial oversight experience, and a background in high-volume catering or elevated... 

PRINCETON IT SERVICES INC.

Drupal Developer Job at PRINCETON IT SERVICES INC.

 ...Job Title: Drupal Developer Location: New York, NY 10041 Engagement Type: Contract Job Summary We are seeking an experienced Drupal Developer to support the design, development, enhancement, and maintenance of Drupal-based web applications... 

Bombardier

Software Engineer Intern Fall 2026 Job at Bombardier

 ...data architecture and related platform technologies(e.g. Apache, IIS, XML) Basic understanding of web technologies (e.g. HTML, CGI Scripts, MVC & .NET Framework) Basic knowledge of software change management, including versioning systems (e.g., Git) Basic knowledge...