PL/SQLDeveloper

Spectraforce Technologies; New York (NY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Spectraforce Technologies is seeking a PL/SQL Developer for our New York, NY hybrid role (Tue/Wed/Thu in office). This 6-month engagement focuses on PL/SQL proficiency and shell scripting to support critical business applications.

The ideal candidate has 5+ years of PL/SQL (Oracle) experience, strong shell scripting skills, and a solid understanding of OOP and design patterns. Collaboration with QA, DevOps, and product teams will be key to success.

Qualifications

• 5+ years of professional PL/SQL (Oracle) experience.
• Strong shell scripting experience (Bash, KornShell, or similar).
• Solid understanding of object-oriented programming and design patterns.

Responsibilities

• Design, develop, test, and maintain scalable Java-based applications.
• Write clean, efficient, and well-documented code following best practices.
• Develop, enhance, and optimize complex SQL queries, stored procedures, and database schemas.
• Create, update, and maintain shell scripts for automation, deployment, and system monitoring.
• Collaborate with cross-functional teams including QA, DevOps, and Product Management.
• Participate in code reviews and contribute to team knowledge sharing.
• Troubleshoot, debug, and resolve application performance issues.
• Ensure code quality, security, and performance throughout the development lifecycle.

Skills

PL/SQL

Shell scripting

OOP & design patterns

GitHub

Linux/Unix

Tools

Spring Framework

HTML/CSS

Eclipse

Toad

Maven

CI/CD pipelines

Job description

Job Title: PL/SQL Developer

Location: New York, NY Hybrid - Tues/Wed/Thurs in office

Duration: 6 mons

Required: primary strengths are PL/SQL and Shell Scripting.

Must-Have Skills / Experience

• 5+ years of professional experience in Proficiency in PL/SQL (Oracle
• Strong experience with shell scripting (Bash, KornShell, or similar).
• Solid understanding of object-oriented programming and software design patterns.
• Experience with version control systems (GitHub).
• Exposure to Linux/Unix environment.

About the Role

As part of Technology, you'll have the opportunity to contribute to groundbreaking initiatives that shape the client's landscape. Leverage cutting-edge technologies like Generative AI to increase productivity, streamline processes, and create seamless experiences for clients, agents, and employees. Your expertise fuels innovation, agility, and growth - driving the company's success.

We are seeking an experienced PL/SQL, Shell scripting Developer with a minimum of five years of hands-on experience in PL/SQL, SQL, and shell scripting. The ideal candidate will possess strong technical and analytical skills, with the ability to develop, enhance, and maintain complex applications in a collaborative, fast-paced environment. This role plays a key part in designing, implementing, and supporting reliable technology solutions that support critical business applications.

What You'll Do

• Design, develop, test, and maintain scalable Java-based applications.
• Write clean, efficient, and well-documented code following best practices.
• Develop, enhance, and optimize complex SQL queries, stored procedures, and database schemas.
• Create, update, and maintain shell scripts for automation, deployment, and system monitoring.
• Collaborate with cross-functional teams including QA, DevOps, Application Production Support, and Product Management.
• Participate in code reviews and contribute to team knowledge sharing.
• Troubleshoot, debug, and resolve application performance issues.
• Ensure code quality, security, and performance throughout the development lifecycle.

Required Skills:

• 5+ years of professional experience in Proficiency in PL/SQL (Oracle
• Proficiency in PL/SQL (Oracle).
• Strong experience with shell scripting (Bash, KornShell, or similar).
• Solid understanding of object-oriented programming and software design patterns.
• Experience with version control systems (GitHub).
• Exposure to Linux/Unix environment.

Preferred Skills

• Working knowledge of cloud platforms.
• Experience with Spring Framework.
• Experience with HTML, CSS, Eclipse, and Toad.
• Familiarity with build tools (Maven) and CI/CD pipelines.
• Excellent problem-solving skills and attention to detail.
• Familiarity with Agile development methodologies (Scrum, Kanban).