PLSQL Developer
PLSQL Developer
Posted on :
20-10-2023
Employer Active
1 Vacancy
The job posting is outdated and position may be filled
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Req ID : 2284123
The client is requesting local candidates for this position. The work requirements are that this individual is onsite a minimum of 2 days/per week at the 1000 E. Grand Ave location.
The Department of Management is looking to hire an experienced PL/SQL Developer for Iowa Workforce Developments UI Tax Project.
Iowa Workforce Development (IWD) is a state agency committed to providing unemployment insurance for claimants and employment services for job seekers, including re-employment programs. IWD is looking to hire an experienced PL/SQL Developer for the UI Tax Project. This individual will be part of a talented software team that works on mission-critical applications using Agile methodologies. The project aims to enhance IWDs UI Tax system by implementing functionality with the goal of providing better service to both the agency staff and the end-users. The ideal candidate is a leader and strong team contributor who is eager to learn and develop their craft as a software professional and will find great satisfaction in the patient pursuit of excellence. This individual will be responsible for gathering requirements, facilitating requirements sessions with business stakeholders and providing quality.
REQUIREMENTS:
Analyze requirements and create performance, scalable database structures, objects and stored procedures
Analyze, create and tune complex SQL code to ensure optimal performance and data integrity across very large data sets
Troubleshoot database performance issues in an Oracle environment
Must have experience with Performance Tuning. Proficiency with SQL & PL/SQL.
Review and tune code to ensure best practices, quality standards and data integrity
Design and implement approaches to improve database performance, capacity, and scalability
Confer with appropriate managers and peer team members regarding problems with and capabilities of databases
Experience in migrating from Oracle to MySQL or Postgres is a plus
Experience with Oracle database, Elasticsearch, GitLab, MySQL, PostgreSQL a plus
Experience with database migration to a cloud environment is a plus
Excellent communication and reporting skills
Work within a collaborative Agile environment
Requirements
Skill
Required / Desired
Amount
of Experience
Analyze requirements and create performance, scalable database structures, objects and stored procedures
Analyze, create and tune complex SQL code to ensure optimal performance and data integrity across very large data sets
Troubleshoot database performance issues in an Oracle environment
Review and tune code to ensure best practices, quality standards and data integrity
Design and implement approaches to improve database performance, capacity, and scalability
PL/SQL
SQL
Toad / SQL Developer / PL SQL Developer or similar tools
ETL tools like Pentaho Kettle, Informatica
SVN/Git
Experience with Oracle database, Elasticsearch, MySQL, PostgreSQL
Experience in migrating from Oracle to MySQL or Postgres
Experince with database migration to a cloud environment
Excellent communication and reporting skills
Experience using Atlassian Suite - Jira, Confluence, etc.
Required Skills/Experience SQL query and scripting (Including mainframe) TN3270 terminal emulator and SFTP clients HR and timekeeping systems Microsoft Excel and Word Report writing and data reconciliation Strong organization and communication skills Preferred/Not Required Electronic signature services (e.g. DocuSign) Adobe Acrobat Pro Microsoft Active Directory and/or LDAP (User management) Physical access control systems (e.g. ID badge) Content management systems (e.g. website/intranet backend) Software development using Microsoft .NET and/or Oracle Java Business process mapping Form creation and maintenance
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
