Sr. Oracle PL/SQL Developer Job at Maddisoft, Houston, TX

N3pLQTVqbFBiZHB6TkdaUDRQcEd4cUpYOXc9PQ==
  • Maddisoft
  • Houston, TX

Job Description

Maddisoft has the following immediate opportunity, let us know if you or someone you know would be interested. Send in your resume ASAP. - U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. Looking for W2 CONTRACT, Send in resume along with LinkedIn profile without which applications will not be considered. Call us NOW! ***Visa sponsorship is available for this position.***


Role: Sr. Oracle PL/SQL Developer
Location: Houston,Texas Hybrid 3 days/week


Job Description:

Design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization.

Essential Duties/Responsibilities:
• Develop Oracle PL/SQL applications.
o Create Oracle PL/SQL packages, stored procedures, and functions. Create database objects like tables, views, triggers, types, synonyms based on requirements. Create new applications or enhance existing applications to produce commissions reports.
o Work with Manager/IT Lead to understand requirements, create technical design, analyze source tables and relationships, adhere to consistent coding/SVN standards, and provide daily status updates.
o Work with the Commissions analyst to understand the existing calculations process for each workstream and build, test, and UAT according to their expectations.
o Use Oracle Analytical functions, MERGE statements, WITH clause, Partitioning, Job logging, File handling, External tables, and Exception handling in the Oracle PL/SQL code.
o Optimize code by following performance tuning techniques and coding standards established within the team.
o Create and test Unix scripts to transfer reports from Unix server to Windows share using sFTP server
o Perform Unit testing and end to end System testing of the Oracle PL/SQL application. Prior to UAT submission test and compare the reports to Production calc. reports and identify and fix discrepancies.
o Use analytics skills to troubleshoot and resolve problems quickly
o Use SVN to maintain all database object scripts/source code. Follow versioning standards established by the team.
o Have code reviewed with IT lead prior to moving the code to QA environment
o Create ControlM/Redwood job documents, create Change requests, and work with ControlM/Redwood to get them created and scheduled.
o Use ServiceNow ticketing system for opening, handling, and closing tickets and change requests.
o Follow SOX procedures for code deployment.
• Perform production support.
o Monitor batch processes daily/weekly/monthly and resolve job failures as soon as possible to meet established SLAs.
o Work with ControlM/Redwood group on re-run/re-start instructions.
o Be willing to perform this off hours during weekdays and weekends.
o Fulfill ad-hoc requests for data pull, table updates or minor enhancements.
• Work effectively in a team environment.
o Develop strong working relationship with team members, Manager, Commissions team analysts, DBA team, Project Manager, and other IT groups.
o Independently work on tasks without the need for step by step Supervision
o Communicate progress or issues clearly either verbally or through email.
o Escalate issues or delays that would impact deadline as early in the process as possible.
• Must be local to Houston or TX and be willing to come into the downtown office Monday, Tuesday, and Thursday of every week

Education:
Bachelor's degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university.

Experience:
- 15+ years of experience in Software development
- 12+ years of strong development experience using Oracle PL/SQL including experience using features like Analytical functions, merge statements, WITH clause, oracle partitioning, job logging, exception handling, performance tuning
- 12+ years of experience in Oracle 12c or 19c
- 5+ years of experience in a Data Warehouse environment
- Strong Analytical skills
- Troubleshooting skills
- Strong Team Player

Job Tags

Contract work, Local area, Immediate start, Visa sponsorship, Weekend work, 3 days per week, Weekday work,

Similar Jobs

Hyundai Autoever America

10783 - Gen AI Engineer Job at Hyundai Autoever America

10783 Gen AI Engineer Purpose: Hyundai AutoEver America is seeking a highly motivated Generative AI Engineer with a passion for continuous innovation in AI and Machine Learning. As a Generative AI Engineer in the Emerging Technology department, the candidate will... 

The Cool Hardware Company, Inc.

Delivery Driver Job at The Cool Hardware Company, Inc.

 ...individuals to join our team to make customer deliveries and conduct inter-store transfers. Our...  ...think about applying for our Delivery Driver position! Key Responsibilities...  ...Ability to assemble outdoor grills, furniture, power equipment, etc. Positive attitude... 

Lite Flight Helicopters

R44 Helicopter Pilot Job at Lite Flight Helicopters

 ...Great time building and experience for building up enough hours to move on to turbine jobs. Job Requirements Minimum Commercial pilot preferably CFI and CFII. We require a minimum of 500 rotorcraft hours to start. Preferable 100 hours in the R44. It is important to... 

Aramark

Administrative Support Worker - Ecolab Global Headquarters Job at Aramark

Job Description The Administrative Support Worker is responsible for assisting management with administrative tasks including, but not limited to, ordering, data entry, filing, etc. The Administrative Support Worker will be required to work well with customers, visitors...

Cedars-Sinai

Admin/Ops Intern - Health Equity - Paid - Per Diem Job at Cedars-Sinai

 ...wide-ranging programs that improve the health of its most vulnerable residents.This intern...  ...Program.**What will you learn in this internship?**The Community Connect Internship role...  ...to many different roles in the field of Public Health, roles within the health system,...