Greetings from Sligo Software Solutions, Inc. !!
This is Srikanth from SLIGO. We have an urgent requirement for Sr. Oracle PL/SQL Developer position with our client.
Title : Sr. Oracle PL/SQL Developer
Location : Albany, New York
Duration : 24 Months
Client : NY State - Information Technology Services (ITS)
Job ID: SLG - 19 - 9622
Respond by: 06/25/24 5:00 PM
DescriptionThis individual will provide expert database development support to the CONNECTIONS project during development and maintenance activities to maintain New York State's Automated Child Welfare Information System for OCFS, LDSS , and Voluntary Agencies.
Duties

• Participating in design sessions to help with database design.
• Serving as the internal Team DBA for CONNECTIONS application.
• Serving as lead database developer for CONNECTIONS, developing complex database packages and procedures to feed data to WCF Service Layer via ODP.NET.
• Serving as lead database developer for CONNECTIONS ancillary applications like AIMS, CCWIS DX, Dynamics CRM, FHARM, OCS, RFI.
• Serving as lead database developer to develop and maintain highly complex database packages for data exchange with applicable intra-agency and inter-agency legacy applications.
• Investigating and troubleshooting Production data issues and code appropriate data fixes.
• Creating and tracking ITSM requests coordinating with the central DBA Team for roll-out of Build-related database changes.
• Supporting parallel development and testing of multiple Application Builds by maintaining the integrity of corresponding development databases.
• Supporting CONNECTIONS Training databases liaising with CONNECTIONS Training Coordinator.
• Supporting CONNECTIONS Batch development and support team with database coding.
• Supporting CONNECTIONS nightly Audit process.
• Catering to CONNECTIONS Audit data requests from OCFS.
• Assisting Data Warehouse Team sharing relevant CONNECTIONS database changes having Data Warehouse impact.
• Mentoring developers in the effective use of performance-optimized SQLs.
• Performing reviews of other developers’ database code to ensure CONNECTIONS database coding standards are adhered to.
• Assisting Testing Team with creating test data.
• Developing appropriate system documentation.

Mandatory Requirements

• Experience (10 Years)
• Develops and implements applications and programs for the backend processing systems used in businesses and organizations.

Requirements

• This is an 100% Onsite
• 84 months of experience writing packages, SQL, PL/SQL, stored procedures, functions, triggers in minimum version of Oracle 11g or higher.
• 84 months of experience performing Oracle database administration activities in a production database environment containing on-line and batch environments - including performance tuning, maintaining the architecture, processes, and database objects of an Oracle database Server in minimum version of Oracle 11g or higher.
• 84 months of experience developing and maintaining applications in Oracle's Application Express (APEX).
• 84 months experience with Oracle Database Express Edition (XE) in-house database administration tasks like create schema, manage privileges, etc.
• 84 months experience working with project staff (both program and technical staff) providing database support in the development of n-tiered client-server/web applications based on defined technical designs.
• 84 months experience in performing knowledge transfers to coworkers of Oracle database developer techniques supporting the development of database structure for new application designs and/or enhancements to existing application designs.
• 84 months experience creating and maintaining PERL scripts.
• 24 months of experience writing Unix/Linux Shell Scripts.
• 24 months of experience using Microsoft SQL Server.
• Résumé