What are the responsibilities and job description for the PL/SQL Developer position at Rishabh Software?
Position -PL/SQL
Job type - Full time
Location - Brooklyn, NY
Salary: - $146,000
Note: Due to confidentiality reasons client is only accepting locals and USC. Please apply if you are a USC and local.
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.
Experience required
Required Skills:
- 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.
Salary : $145,000 - $146,000