| Sr. Oracle PL SQL Developer - HBITS-05-13472-SLG - 19 - 9622-Albany, NY at Richmond, Virginia, USA |
| Email: [email protected] |
| From: Srikanth Vanam, Sligosoft [email protected] Reply to: [email protected] Hi, Greetings from Sligo Software Solutions, Inc. !! SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government. We have an urgent requirement for Sr. Oracle PL/SQL Developer position with our client. Role: Sr. Oracle PL/SQL Developer Location: Albany, New York Duration: 24 Months Job ID: SLG - 19 - 9622 Client: NY State Respond by Date: 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. 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. Rsum Thanks Srikanth V Keywords: information technology procedural language Idaho New York Sr. Oracle PL SQL Developer - HBITS-05-13472-SLG - 19 - 9622-Albany, NY [email protected] |
| [email protected] View all |
| Thu Jun 20 00:42:00 UTC 2024 |