Overview
On Site
$60.0000 - $65.0000
Full Time
Skills
Pl/SQL
AutoSys
ControlIM
With clause
Merge statements
Job Details
Title: Senior PL/SQL Developer
Location: Houston, TX
Duration: 6+ Months
Payrate: 60$-65$
Day-to-day:
- 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.
- Use Oracle Analytical functions, MERGE statements, WITH clause, Partitioning, Job logging, File handling, External tables, and Exception handling in the Oracle PL/SQL code.
- Optimize code by following performance tuning techniques and coding standards established within the team.
- Create and test Unix scripts to transfer reports from Unix server to Windows share using sFTP server
Must-haves:
- 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.
Benefits:
The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, (paid time , paid sick and safe time , hours of paid vacation time, weeks of paid parental leave, paid holidays annually - AS Applicable)
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.