PL/SQL Developer

Job Summary

We are PL/SQL Developer to support the State of New York's Department of Social Services (DSS) in various critical IT initiatives. The ideal candidates should have 4+ years of experience developing and maintaining PL/SQL packages, stored procedures, functions, triggers, and SQL statements in Oracle 12c. Additionally, they should have 4+ years of experience in performance tuning, specifically optimizing SQL and PL/SQL code, and 4+ years of experience working with XML processing and object-oriented programming involving large objects.

Position Tasks & Duties

• Develop System Design.
  • Selects alternative approaches for system and security requirements.
  • Prepares documents for the general design of solutions.
  • Selects alternative approaches for database, communication systems, hardware, network, security, storage, and software configurations.
  • Develops structured diagrams for specifying databases, communication systems, computer or storage area networks, and security or network programs.
• Develop and maintain PL/SQL Packages, Stored Procedures, Functions, Triggers, and SQL statements in Oracle 12c.
• Develop system documentation.
• Develop operational and installation procedures for communication systems, hardware, network, security, storage, and software.
• Develop guidelines and upgrade techniques of new operational procedures for supporting databases, hardware systems, operating systems software, network systems software, security, and client-server systems.
• Develops, compiles, maintains, and documents configurations of databases, servers, computers, security and network monitor systems, packaged programs, macros, utilities, and communication systems.
• Perform System Coding.
  • Create the program code in the .NET and Low Code Application Platform (LCAP) environments.
  • Provide general programming assistance to other ITS programmers/projects as may be needed.
• Test and maintain the program code to meet all the functional requirements.

Minimum Required Skills & Experience

• Minimum 4 Years of Development and Maintenance of PL/SQL Packages, Stored Procedures, Functions, Triggers, and SQL statements in Oracle 12c.
• Minimum 4 Years of Performance Tuning, including tuning/optimizing SQL, PL/SQL code.
• Minimum 4 Years Working with XML Processing and object-oriented programming with large objects.
• Minimum 4 Years Experience with data structures, data manipulation, databases, design, programming, testing, and implementation.
• Minimum 4 Years Experience with technical and user documentation and software conversion.