Oracle PL/SQL Developer

JPS Tech Solutions Pvt Ltd; New Jersey; On-site; USD 100,000 - 150,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd is seeking an experienced Oracle PL/SQL Developer to design, implement, and optimize Oracle PL/SQL programs and SQL routines. You will collaborate with business users and cross-functional teams to deliver scalable database solutions in a fast-paced environment.

The role emphasizes performance tuning, database administration, and ensuring data security, with opportunities to work on Oracle EBS front-end and backend components.

Qualifications

• Bachelor’s degree in Computer Science or a related field.
• 5+ years of experience in Oracle PL/SQL development.
• Strong proficiency in SQL programming, with experience in performance tuning.
• Experience with database administration and troubleshooting.
• Oracle Certification preferred.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL scripts, stored procedures, packages, and triggers.
• Optimize SQL queries to ensure maximum performance and scalability.
• Collaborate with business users to analyze requirements and design technical solutions.
• Perform database administration tasks such as backups, restores, and data migration.
• Troubleshoot and debug production issues, ensuring quick resolution.
• Ensure data security and compliance with internal policies and standards.
• Collaborate with cross-functional teams to deliver high-quality solutions.
• Participate in code reviews and solution design sessions.
• Escalate issues and report project progress to management.
• Handle multiple projects and tasks simultaneously.

Skills

Oracle PL/SQL

SQL performance tuning

Database troubleshooting

Communication skills

Team collaboration

Java/JSP

Finance/Accounting familiarity

Education

Bachelor’s degree in Computer Science or related field

Tools

Oracle EBS

Forms (Oracle EBS front-end)

Job description

Job Description:

Key Responsibilities:

• Design, develop, and maintain Oracle PL/SQL scripts, stored procedures, packages, and triggers.
• Optimize SQL queries to ensure maximum performance and scalability.
• Collaborate with business users to analyze requirements and design technical solutions.
• Perform database administration tasks such as backups, restores, and data migration.
• Troubleshoot and debug production issues, ensuring quick resolution.
• Ensure data security and compliance with Canon's internal policies and standards.
• Collaborate with cross-functional teams (Business Process Reengineering, Development) to deliver high-quality solutions.
• Participate in code reviews and solution design sessions.
• Escalate issues and report project progress to management.
• Handle multiple projects and tasks simultaneously.

Qualifications:

• Bachelor’s degree in Computer Science or a related field.
• 5+ years of experience in Oracle PL/SQL development.
• Strong proficiency in SQL programming, with experience in performance tuning.
• Experience with database administration and troubleshooting.
• Strong knowledge of Oracle EBS backend tables and functional knowledge in OTC.
• Familiarity with the Oracle EBS front-end functionality (forms).
• Experience working within SDLC methodologies (Agile, Waterfall).
• Excellent problem-solving, analytical, and communication skills.
• Ability to work with both functional teams and business users.
• Java/JSP experience is a plus.
• Experience in Finance/Accounting is a plus.
• Oracle Certification preferred.

Job Description:

Key Responsibilities:

• Design, develop, and maintain Oracle PL/SQL scripts, stored procedures, packages, and triggers.
• Optimize SQL queries to ensure maximum performance and scalability.
• Collaborate with business users to analyze requirements and design technical solutions.
• Perform database administration tasks such as backups, restores, and data migration.
• Troubleshoot and debug production issues, ensuring quick resolution.
• Ensure data security and compliance with Canon's internal policies and standards.
• Collaborate with cross-functional teams (Business Process Reengineering, Development) to deliver high-quality solutions.
• Participate in code reviews and solution design sessions.
• Escalate issues and report project progress to management.
• Handle multiple projects and tasks simultaneously.

Qualifications:

• Bachelor’s degree in Computer Science or a related field.
• 5+ years of experience in Oracle PL/SQL development.
• Strong proficiency in SQL programming, with experience in performance tuning.
• Experience with database administration and troubleshooting.
• Strong knowledge of Oracle EBS backend tables and functional knowledge in OTC.
• Familiarity with the Oracle EBS front-end functionality (forms).
• Experience working within SDLC methodologies (Agile, Waterfall).
• Excellent problem-solving, analytical, and communication skills.
• Ability to work with both functional teams and business users.
• Java/JSP experience is a plus.
• Experience in Finance/Accounting is a plus.
• Oracle Certification preferred.