Title : Oracle PL/SQL Developer
Hire Type : Contract
Location : Houston, TX (Hybrid)
Essential Duties/Responsibilities:
Develop Oracle PL/SQL applications.
Code packages, stored procedures, functions, objects, tables, views, synonyms based on requirements. Understand functionality of existing applications and either incorporate new functionality to automate the calculations process or build new applications for the calculations process.
Work with IT Technical Lead to understand requirements/technical design, understand the source tables and relationships, adhere to consistent coding/SVN standards, do code reviews, and provide daily status updates.
Work with the Commissions analyst to understand the existing calculations process for each workstream and build, test, and UAT according to their
expectations.
Use Oracle Analytical functions, merge statements, WITH clause, oracle partitioning, job logging, exception handling, performance tuning and so on in the Oracle PL/SQL code.
Optimize code by following performance tuning techniques considering limitations
of current environment.
Unit test, System test, Integration test, and Parallel test of the Oracle PL/SQL code. Use analytics skills to troubleshoot and resolve problems quicklyo Use SVN to maintain all database object scripts/source code. Follow versioning standards established by the team.
Have code reviewed with Technical lead prior to moving the code to QA environment
Create ControlM/Redwood job documents, create Change requests, and work with ControlM/Redwood to get them created and scheduled.
Use ServiceNow ticketing system for opening, handling, and closing tickets and
change requests.
Follow SOX procedures for code deployment.
Perform production support.
Monitor batch processes daily/weekly/monthly and resolve job failures as quickly as possible.
Work with ControlM/Redwood group on re-run/re-start instructions.
Be willing to perform this off hours during weekdays and weekends.
Fulfill ad-hoc requests for data pulls, updates, or minor enhancements.
Work effectively in a team environment.
Develop strong working relationship with team members, Manager, Commissions team analysts, DBA team, Project Manager, and other IT groups.
Independently work on tasks without step-by-step Supervision
Communicate progress or issues clearly either verbally or through email.
Escalate issues or delays that would impact deadline as early in the process as possible.
Work in an office environment twice a week
Education:
Bachelor’s degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience.
Experience:
Experience including but not limited to
15+ years of experience in Software development
12+ years of experience in Oracle 12c or 19c
12+ years of experience in Oracle PL/SQLdevelopment including experience using features like Analytical functions, merge statements, WITH clause, oracle partitioning, job logging, exception handling, performance tuning
3+ years of experience in a Data Warehouse environment
...Brown & Brown is seeking an Employee Benefits Producer for our growing office in Albuquerque, New Mexico! No prior insurance experience is required - Must have successful B2B sales experience! We offer our sales executives an opportunity to join a dynamic team...
...career thrive with VOLT! Volt is immediately hiring for a Maintenance Mechanic on the 3rd shift in Rockwall, TX. As a Maintenance... ...~ MUST have 3 years or more of maintenance experience in an industrial or manufacturing environment. ~ High School diploma or equivalent...
...clients, a large physician organization, is looking for a Registered Dietician Nutritionist to join their team. The position is... ...Job Description: Our client is looking for a Registered Dietitian Nutritionist who is passionate about helping patients with chronic...
...We are growing and looking for native-fluency Mandarin Chinese-speaking tutors to provide one-on-one and small group tutoring for children... ...Articulate, native-fluency Mandarin speaker Strong English speaking and writing skills Bachelors degree, Masters degree...
...Los Angeles full-service law firm seeks talented Legal Billing Specialist to join their growing organization. Legal Billing Specialist should have at least 3 years of experience working in a law firm in the billing department and have experience using legal billing software...