PL/SQL Developer

Macpower Digital Assets Edge LLC

New York, NY, United States

11 days ago

Apply on www.thejobnetwork.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

4 years minimum

Working hours

Regular working hours

Job source

www.thejobnetwork.com

Tech stack

.NET Framework Computing Platforms Client Server Models Software Documentation Computer Programming Information Technology Consulting Databases System Configuration Data Structures Database Queries Desktop Computing Storage Area Network (SAN)

+12 more

Microsoft Network Monitor Object-Oriented Software Development Oracle Databases Performance Tuning Software Engineering SQL Stored Procedures PL-SQL Extensible Markup Language (XML) Data Processing Computer Networking Systems Macros Sql Optimization

Job description

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.

Requirements

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., * 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com

Prepare application

Good distractions

Loading talks and stories from around this role…