Sr. Oracle PL/SQL Developer
Sr. Oracle PL/SQL Developer
Sligo Software Solutions Inc.
Albany, NY
![]()
![]()
![]()
See who Sligo Software Solutions Inc. has hired for this role
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
Description
This 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
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
Description
This 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.
- Experience (10+ Years)
- Develops and implements applications and programs for the backend processing systems used in businesses and organizations.
- 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é
-
Seniority level
Mid-Senior level -
Employment type
Contract -
Job function
Engineering and Information Technology -
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at Sligo Software Solutions Inc. by 2x
See who you knowGet notified about new PL/SQL Developer jobs in Albany, NY.
Sign in to create job alertSimilar Searches
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub