![Military Spouse Connection mobile logo](https://dn9tckvz2rpxv.cloudfront.net/militaryspouseconnection.jobs/img/logo.png)
Job Information
Motion Recruitment Partners Senior Oracle PL/SQL Developer in Houston, Texas
Senior Oracle PL/SQL Developer
Houston, TX
Hybrid
Contract
$60.79/hr - $65.79/hr
Motion is seeking a Senior Oracle PL/SQL Developer for a contract opportunity in Houston, TX. A Senior Oracle PL/SQL Developer. This role involves designing, coding, and maintaining complex database systems, ensuring their performance, security, and reliability. This role is hybrid with two days a week onsite required.
Contract Duration: 6 months
Required Skills & 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, Table partitioning, Job logging, Exception handling, and Performance tuning
12+ years of experience in Oracle 12c or 19
5+ years of experience in a Data Warehouse environment
Strong Analytical skills to analyze and resolve data discrepancies
Troubleshooting skills
Strong Team Player
Bachelor’s degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience
What You Will Be Doing
Daily 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 quickly
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.
You will receive the following benefits:
Medical Insurance - Four medical plans to choose from for you and your family
Dental & Orthodontia Benefits
Vision Benefits
Health Savings Account (HSA)
Health and Dependent Care Flexible Spending Accounts
Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
Hospital Indemnity Insurance
401(k) including match with pre and post-tax options
Paid Sick Time Leave
Legal and Identity Protection Plans
Pre-tax Commuter Benefit
529 College Saver Plan
Motion Recruitment Partners is an Equal Opportunity Employer, including Veterans/Disability/Women. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Accommodation will be provided in all parts of the hiring process as required under Motion Recruitment Employment Accommodation policy. Applicants need to make their needs known in advance.
Posted by: Heather Allen
Specialization: Software Engineering
Motion Recruitment Partners
-
- Motion Recruitment Partners Jobs