What are the responsibilities and job description for the IT Programmer/Oracle Database Programmer/Developer (PL/SQL Programmer) position at INSPYR Solutions?
Job Details
Location: 100% on site (in Las Vegas NV or Carson City NV)
Compensation: $40.00 - $49.00/Hour
Duration: 5 month contract (Possible extensions)
Work Requirement: , Holder, or Authorized to work in the U.S.
Our Government client in Carson City NV/ Las Vegas NV is looking for an IT Programmer/Oracle Database Programmer/Developer (PL/SQL Programmer).
PL/SQL Programmer
Scope of Work:
- Project Overview:
- 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).
- Key Responsibilities:
- Develop new PL/SQL queries, scripts, and stored procedures to support data integration between the legacy data warehouse and the new ERP.
- Modify and optimize existing PL/SQL code to improve performance and functionality.
- Collaborate with the project team to understand requirements and translate them into technical solutions.
- Perform data analysis and validation to ensure accuracy and completeness of data transfers.
- Document all developed code, scripts, and procedures thoroughly.
- Troubleshoot and resolve issues related to data integration and interface functionality.
- Required Skills and Qualifications:
- Proficiency in Oracle s PL/SQL is essential.
- Experience with data warehousing concepts and ETL processes.
- Experience with UNIX Shell scripting and Scheduler jobs (Cosmos or Automate).
- Experience with SQL*Loader and mod_plsql package.
- Strong analytical and problem-solving skills.
- Ability to work independently and in a team environment.
- Excellent communication skills to interact effectively with technical and non-technical stakeholders.
- Prior experience in ERP data integration projects is a plus.
- Ability to pass a background check.
- Work Environment:
- Standard working hours.
- The work may require occasional flexibility in hours to accommodate project needs.
- The position may involve remote work depending on individual capabilities and Project criteria.
- Deliverables:
- Functional and efficient PL/SQL code (or other scripting code as required).
- Documentation of developed code and procedures.
- Timely resolution of issues and bugs related to data interfaces.
- Evaluation and Feedback:
- Regular performance evaluations based on deliverables, teamwork, and adherence to project timelines.
- Continuous feedback to improve performance and enhance project outcomes.
- Additional Information:
- The IT Programmer will report to IT Manager and collaborate closely with the project team members.
- Any additional tools or resources required for the job will be provided by the organization.
- Comprehensive medical benefits
- Competitive pay
- 401(k) retirement plan
- ...and much more!
Technology is our focus and quality is our commitment. As a national expert in delivering flexible technology and talent solutions, we strategically align industry and technical expertise with our clients' business objectives and cultural needs. Our solutions are tailored to each client and include a wide variety of professional services, project, and talent solutions. By always striving for excellence and focusing on the human aspect of our business, we work seamlessly with our talent and clients to match the right solutions to the right opportunities. Learn more about us at inspyrsolutions.com.
INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities
Salary : $40 - $49