Previous Job
Previous
PL/SQL Developer
Ref No.: 18-01506
Location: Brooklyn, New York
  • Minimum 7 Years Experience with Development and Maintenance of PL/SQL Packages, Stored Procedures, Functions, Triggers, SQL statements in Oracle 12c.
  • Minimum 7 Years Experience with Performance Tuning including tuning/optimizing SQL, PL/SQL code.
  • Minimum 7 Years Experience working with XML Processing, Object oriented programming with large objects.
  • Minimum 7 Years Experience with data structures, data manipulation, databases, design, programming, testing and implementation
  • Minimum 7 Years Experience with technical and user documentation, software conversion

PROJECT DESCRIPTION: Fair Fares” is a City program designed to serve more than 300,000 working low-income New Yorkers where transit expenses often exceed 10 percent of their family budgets, limiting their ability to access jobs and forcing them to forgo other necessities. This project is to automate the selection of the correct clients and send that selection to the group responsible for creating the fare benefit card

Tasks & Duties
  • Develop System Design
  • Develop and prepares documents for the general design of solutions that meet system and security requirements, including the selection of alternative approaches.
  • Develop specifications for databases, communication systems, hardware, network, security, storage and software configurations.
  • Develop structured diagrams for the specifications of databases, communication systems, computer or storage area networks, security or network programs.
  • Develop and maintain PL/SQL Packages, Stored Procedures, Functions, Triggers, 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 the support of databases, hardware systems, operating systems software, network systems software, security and client server systems.
  • Develop, compiles, maintains and documents configurations of the following: databases, servers, computers, security and network monitor systems, packaged programs, macros, utilities, and communication systems
  • Perform System Coding
  • Create the program code in .NET environment
  • Provide general programming assistance to other MIS programmers/projects as may be needed.
  • Test and maintain the program code to make sure it meets all the functional requirements