Oracle PL/SQL Developer Job at Smart IMS Inc, Harrisburg, PA

MEpZbklhekJDMWVuRzRQemV5N2JGbDlxb1E9PQ==
  • Smart IMS Inc
  • Harrisburg, PA

Job Description

Job Title: Oracle PL/SQL Developer

Duration (Contract): 8 Months

Client Location: Harrisburg, PA

Location Preference: Onsite

Job Description:
As an Oracle PL/SQL Developer, you will support the modernization of legacy Oracle applications by migrating Oracle Forms solutions to Oracle APEX on Oracle Database 19c. This role involves application development, database programming, performance tuning, system enhancement, and collaboration with technical teams to deliver secure, scalable, and maintainable enterprise solutions.

Key Responsibilities:

  • Analyze existing Oracle Forms applications, data structures, and system integrations.

  • Support the migration and modernization of legacy applications to Oracle APEX.

  • Design and develop Oracle APEX applications and modern user interfaces.

  • Develop and maintain PL/SQL stored procedures, packages, functions, and complex queries.

  • Perform data analysis, data extraction, and scripting to support reporting and application enhancements.

  • Implement application security, user roles, and authorization controls.

  • Conduct performance tuning, debugging, and optimization of database objects and applications.

  • Participate in all phases of the SDLC, including requirements, development, testing, deployment, and support.

  • Create and maintain technical, functional, and system documentation.

  • Support production deployments, release management, and knowledge transfer activities.

Required Skills, Experiences, Education, and Competencies:

  • Bachelor's degree in Computer Science, Information Systems, or a related field.

  • 5 7 years of hands-on experience developing Oracle PL/SQL solutions, including stored procedures, functions, packages, and advanced SQL queries.

  • 5 7 years of experience developing enterprise applications using Oracle APEX.

  • Strong knowledge of Oracle Database, preferably Oracle 19c.

  • Experience with Oracle SQL Developer, TOAD, or similar database development tools.

  • Strong understanding of data modeling, relational database design, and database architecture principles.

  • Experience integrating web services and supporting enterprise application integrations.

  • Hands-on experience with SQL query optimization, performance tuning, debugging, and testing.

  • Strong analytical, troubleshooting, and problem-solving skills.

  • Excellent written and verbal communication skills with experience working in Agile/Scrum development environments.

The hourly range for roles of this nature are $40.00 to $80.00/hr. Rates are heavily dependent on skills, experience, location, and industry.

cyberThink is an Equal Opportunity Employer.

Job Tags

Hourly pay, Contract work

Similar Jobs

Confidential

Inside Sales Representative - Providence, RI Job at Confidential

INSIDE SALES REPRESENTATIVE Providence, RI | Onsite | $55,000 base Year 1 OTE: $80,000$95,000+ | Year 2 OTE: $85,000$120,000+ POSITION OVERVIEW Drive new business with small and mid-sized businesses. Work with CEOs, CFOs, and VP-level leaders to understand ...

Cencora

Remote / Virtual Nursing Assistant Job at Cencora

 ...Our company is on the lookout for a diligent and compassionate Remote / Virtual Nursing Assistant to join our skillful team. We are a forward-thinking healthcare provider dedicated to leveraging technology to deliver exceptional patient care beyond the traditional clinic... 

Confidential

Entry-Level Business Development Job at Confidential

Job Title: Entry-Level Business Development This is an unparalleled opportunity to continue in your sales career in Atlanta GA, with...  ...prospect high-value leads using cutting-edge tools (e.g., Salesforce, LinkedIn Navigator, ZoomInfo) to build a robust sales pipeline... 

Interactive Process Technology LLC

SME Oracle Database Administrator Job at Interactive Process Technology LLC

SME Oracle Database AdministratorRemote At IPT Associates (IPTA), we enjoy solving real-world problems with technology. We work closely with our customers, teammates, experts, and partners to come up with practical solutions that make a difference. Whether it's a government... 

F McConnell and Sons

Warehouse Order Selector Job at F McConnell and Sons

 ...Job Title: Warehouse Order Selector Location: In Person, New Haven Indiana Company: F McConnell and Sons Inc. Pay:...  ...Good physical condition; ability to lift and carry heavy items (up to 50 lbs). Ability to work in a fast-paced environment and meet...