Senior Oracle Developer PL/SQL, Forms & Reports

3Core Systems, Inc; Chicago (IL); Hybrid; USD 110,000 - 140,000; Full time

Job summary

3Core Systems, Inc. is seeking a Senior Oracle Developer to design, develop, and maintain Oracle databases and applications. You will work with SQL, PL/SQL, Forms, and Reports to deliver robust Oracle solutions for clients.

The role emphasizes hands-on development, testing, and performance tuning, with a hybrid work model requiring three days in the office. Strong problem solving and collaboration are essential.

Qualifications

• 3+ years of experience in Oracle development or software development roles.
• Demonstrable experience with Oracle database development (manual and automated).
• Proficiency in SQL, PL/SQL, Oracle Forms, and Oracle Reports.
• Strong understanding of software development methodologies and best practices.
• Quick problem-solving and analytical skills with attention to detail.

Responsibilities

• Ideate, design, develop, and maintain Oracle databases, applications, and systems.
• Collaborate with the team to create high-quality Oracle software products and ensure testing.
• Monitor and optimize database performance for optimal application performance.
• Identify and report software defects and work with the team to fix them promptly.
• Troubleshoot and resolve technical issues related to Oracle databases and applications.
• Write SQL queries, stored procedures, and triggers to support development for clients.
• Develop and maintain test frameworks for consistent testing of Oracle products.
• Conduct manual and automated testing to uncover defects and ensure quality.
• Perform exploratory testing to identify potential defects and bottlenecks.
• Implement database security policies and procedures to protect data.
• Participate in code reviews and help business users with guidance on the application.

Skills

Oracle SQL

PL/SQL

Oracle Forms

Oracle Reports

Software development

Testing

Job description

Job Title: Senior Oracle Developer PL/SQL, Forms & Reports

Job Location: Chicago, IL, 60603

Work Model: Hybrid

Work Model Details: 3 days a week is mandatory

Experience Desired:

• Demonstrable experience with Oracle databasedevelopment (manual and automated). (3 yrs)
  
• Proficiency in Oracle tools and technologies:SQL, PL/SQL, Oracle Forms, and Oracle Reports (3 yrs),
  

Job Description

Required Skills

• 3+ years of experience inOracle development or software development roles.
  
• Demonstrable experience withOracle database development (manual and automated).
  
• Proficiency in Oracle tools andtechnologies: SQL, PL/SQL, Oracle Forms, and Oracle Reports.
  
• Strong understanding ofsoftware development methodologies and best practices.
  
• Quick problem-solving andanalytical skills with attention to detail.
  

Nice to Have (not required):

• Excellent project managementskills with the ability to oversee multiple projects and meet deadlines.
  
• Strong collaboration skills andthe ability to work independently.
  
• We seek an experienced Oracledeveloper to join our team who will work with other product developers andcreate high-quality Oracle applications and solutions per our customers'requirements.
  
• You will have the opportunityto contribute to our exciting projects and grow within the company byworking with other product developers and creating high-quality Oracleapplications and solutions per our customers' requirements.
  

Tasks & Responsibilities:

• Ideate, design, develop, andmaintain Oracle databases, applications, and systems.
  
• Collaborate with the team tocreate and produce high-quality Oracle software products. Ensure Oracleapplications and solutions meet the highest quality standards throughcomprehensive testing.
  
• Monitor and optimize databaseperformance for optimal application performance.
  
• Identify and report softwaredefects and work closely with the development team to fix them promptly.
  
• Troubleshoot and resolvetechnical issues related to Oracle databases and applications.
  
• Write SQL queries, storedprocedures, and triggers to support application development for clients.
  
• Develop and maintain frameworksto ensure consistent and reliable testing of Oracle products.
  
• Conduct thorough manual andautomated testing to uncover defects and ensure the highest quality ofsoftware solutions.
  
• Perform exploratory testing toidentify potential defects, bottlenecks, and other issues not covered byexisting test cases.
  
• Implement database securitypolicies and procedures to ensure the confidentiality and integrity ofdata.
  
• Participate in code reviews andquality assurance procedures, and provide technical expertise to businessusers of the application.
  
• Stay up-to-date with new andemerging technologies in Oracle database development