PL/SQL Developer

Trilyon, Inc.

Houston (TX)

On-site

USD 96,432 - 103,320

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading staffing solutions provider in Houston is seeking a skilled Oracle PL/SQL Developer for a 4+ month contract. Responsibilities include designing and maintaining applications using Oracle PL/SQL, optimizing code for performance, and collaborating with various teams. Candidates should possess over 12 years of software development experience, a Bachelor's degree, and significant expertise in Oracle PL/SQL. This role requires onsite presence three days a week.

Qualifications

12+ years of experience in Software development.
10+ years of strong development experience using Oracle PL/SQL.
5+ years of experience in a Data Warehouse environment.

Responsibilities

Design, develop, test, maintain, and support batch applications.
Create and test Unix scripts for report transfers.
Perform Unit testing and end to end System testing.

Skills

Oracle PL/SQL

Analytical functions

Performance tuning

Team collaboration

Education

Bachelor’s degree in computer science

Tools

Oracle 12c or 19c

SVN

ServiceNow

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Trilyon, Inc.. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$70.00/hr - $75.00/hr

Direct message the job poster from Trilyon, Inc.

For over 15 years, Trilyon has been at the forefront of providing comprehensive global workforce solutions and staffing services. Leveraging our extensive expertise across multiple domains such as Cloud technology, Salesforce, AI, Machine Learning, and Technical Writing, we consistently exceed expectations in catering to a wide range of requirements.

Currently we are seeking a “Oracle PL/SQL Developer” for one of our clients that is a leading multination corporation.

Position: Oracle PL/SQL Developer

Location: Houston, TX (Onsite 3 days week)

Duration: 4+ months contract

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

o Create/Modify 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 Use Oracle Analytical functions, MERGE statements, WITH clause, Partitioning, Job logging, File handling using UTIL_FILE, External tables, Regular Expression functions, 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 Work closely with IT Technical Lead/Business team to understand requirements, analyze source tables and relationships, create technical design, follow consistent coding/SVN standards, and provide daily status updates.

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 job documents, create Change requests, and work with ControlM to get the jobs created and scheduled.

o Use ServiceNow ticketing system for opening, handling, and closing tickets and change requests.

o Follow SOX procedures for code maintenance and deployment.

o Monitor daily/weekly/monthly/quarterly batch processes and resolve job failures as soon as possible to fulfill established SLAs.

o Work with ControlM 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 fellow team members, Manager, Commissions team, DBA team, IRW team, 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 be in the 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:

- 12+ years of experience in Software development

- 10+ 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

- Strong Team Player

Additional skills:

• Flexibility, Dedication, Consistency, Integrity, and Enthusiasm a must.Equal Employment Opportunity

Trilyon is an Equal Opportunity Employer, committed to fairness and respect for all individuals. We value diversity in age, disability, ethnicity, gender, gender identity, religion, and sexual orientation, believing it drives innovation and better service. Employment decisions are made impartially, without regard to any protected characteristic under federal, state, or local law. Our diverse team drives innovation, competitiveness, and creativity, enhancing our ability to effectively serve our clients and communities. This commitment to diversity makes us stronger and more adaptable.

Warm Regards,

Signature

Seniority level