Sign upLog in

PL/SQL Developer

Macpower Digital Assets Edge Private Limited

Brooklyn, NY

Apply
JOB DETAILS
SALARY
$146,000–$146,000 Per Year
SKILLS
Claims Management, Communication Systems, Community and Social Services, Computer Programming, Computer Security, Computer Servers, Computer Systems, Data Structures, Database Administration, Database Design, Database Programming, Database Triggers, Documentation, Hardware Administration, Information Technology Consulting, Microsoft .NET, Multiplatform/Cross-Platform, Network Monitoring, Network Programming, Network Security, Network System Hardware, Network System Software, Network Systems, Object Oriented Programming (OOP), Operating Systems, Operational Support, Operations Planning, Operations Processes, Oracle, Oracle PL-SQL, Performance Tuning/Optimization, Requirements Management, SQL (Structured Query Language), SQL Databases, Security Monitoring, Social Work, Software Configuration Management, Software Development Lifecycle (SDLC), Storage Area Network (SAN), Storage Software, Stored Procedures, System Lifecycle, Systems Administration/Management, Technical Writing, Testing, XML (EXtensible Markup Language)
LOCATION
Brooklyn, NY
POSTED
12 days ago
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.
  • DSS is experiencing a growing demand for comprehensive systems lifecycle application development across various computer platforms. This includes a range of critical systems, such as client eligibility and recertification, employment/work engagement services, and claims management systems, all essential to the operation of DSS programs. Periodic refinements are required to ensure these applications remain at optimal service levels. It is essential to maintain a project portfolio that accurately reflects both the business needs of users and the operational workload of DSS. As a result, there is a need for IT consulting resources to support the expanding responsibilities within DSS.
Position Tasks & Duties:
  • Develop System Design.
  • Develops and prepares documents for the general design of solutions that meet system and security requirements, including selecting alternative approaches.
  • Develops specifications for databases, 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.
Must Have 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.

About the Company

M

Macpower Digital Assets Edge Private Limited