PL-SQL/Oracle Developer - Local to FL
Posted 4 days ago by RedSalsa Technologies, Inc.
Negotiable
Undetermined
Remote
Remote
Summary: The PL-SQL/Oracle Developer role involves providing technical support and development for the WIC data system and its interfaces with various applications. The contractor will be responsible for troubleshooting, documentation, and recommending operational efficiencies while adhering to coding standards. The position requires extensive experience in SQL/PL-SQL development and database management. This role is remote and requires a high level of technical expertise in Oracle databases and related technologies.
Key Responsibilities:
- Conduct daily development and technical support for the WIC data system and its interfaces.
- Troubleshoot work requests and provide solutions to processing and development issues.
- Maintain and submit documentation of system performance and maintenance activities.
- Identify and recommend operational efficiencies and conduct evaluations of new technologies.
- Analyze and document technical requirements for system fixes and enhancements.
- Produce work plans for implementing infrastructure requirements.
- Create scripts for system fixes and enhancements adhering to coding standards.
- Conduct testing of scripts and document test results.
- Produce system documentation for fixes and enhancements.
Key Skills:
- A minimum of ten years developing and modifying SQL/PL-SQL scripts for Oracle Database RDBMS.
- A minimum of ten years in maintaining and tuning RDBMS related to customer-based objects.
- A minimum of ten years gathering report requirements and publishing reports.
- A minimum of five years creating objects in business intelligence applications (e.g., Qlik, PowerBI, Tableau, Splunk).
- A minimum of two years with non-traditional No-SQL and Object-Oriented databases.
- A minimum of two years utilizing Cloud-Hosted database service platforms.
- Experience in RDBMS conversion between platforms.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Title: PL-SQL/Oracle Developer
Location: Tallahassee, FL/ Remote
Duration: 12 + Months
Job Description.
6. CONTRACTOR RESPONSIBILITIES:
6.1. SERVICE TASKS: Contractor will perform the following tasks in the time and manner specified:
6.1.1. Conduct daily development and technical support for the ongoing operation of the WIC data system and the interfaces with the EBT system, Florida ACCESS, IBM Watson, and other supported system applications as directed by the Department.
6.1.2. Troubleshoot work requests and provide solutions to daily processing and development issues as directed by the Department.
6.1.3. Maintain and submit documentation as directed by the Department of system performance of the WIC Data System database including all interfaces and any system maintenance and adjustments undertaken including work requests to correct process errors.
6.1.4. Identify and recommend operational efficiencies to improve system performance and processes. Conduct new software or hardware evaluations. Investigate and recommend new technologies that will improve or support current and identified business processes as directed by the Department.
6.1.5. Analyze and document technical requirements for infrastructure system fixes, modifications and enhancements as directed by the Department.
6.1.6. Produce a work plan to implement infrastructure requirements for database system platform fixes, modifications and enhancements as directed by the Department.
6.1.7. Maintain and submit documentation of analyses of system performance, software and hardware evaluations, new technologies, business and technical requirements and work estimates as directed by the Department.
6.1.8. Create scripts for system fixes, modifications, enhancements, interfaces and integration processes that adheres to all applicable coding procedures, standards and techniques as directed by the Department.
6.1.9. Conduct testing of scripts for system fixes, modifications and enhancements including support of customer User Acceptance Testing. Document test results as directed by the Department.
6.1.10. Produce system documentations for system fixes, modifications and enhancements as directed by the Department.
Skills:
5. CONTRACTOR QUALIFICATIONS AND EXPERIENCE:
Contractor staff assigned to this agreement must possess the following minimum qualifications and experience:
5.1. A minimum of ten years developing and modifying SQL/PL-SQL scripts for creating, maintaining, augmenting, and reporting on data in an Oracle Database RDBMS.
5.2. A minimum of ten years in maintaining and tuning a RDBMS in relation to customer-based objects stored in the RDBMS.
5.3. A minimum of ten years with gathering report requirements from customers, translating them into code, analyzing the results for integrity and validity, and publishing the report to an application platform.
5.4. A minimum of five years with creating objects (e.g., reports, dashboards) in business intelligence and reporting applications such as Qlik, PowerBI, Tableau, Splunk.
5.5. A minimum of two years with non-traditional No-SQL, Object-Oriented, Key-Value, In-Memory databases.
5.6. A minimum of two years with utilizing Cloud-Hosted database service platforms.
5.7. Experience in RDBMS conversion between platforms.