Role: Sr. Oracle PL/SQL Developer
Location: Albany New York
Duration: 24 Months
Description
This individual will provide expert database development support to the CONNECTIONS project during development and maintenance activities to maintain New York States 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 intraagency and interagency 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 rollout of Buildrelated 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 performanceoptimized 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 online 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 Oracles Application Express (APEX).
- 84 months experience with Oracle Database Express Edition (XE) inhouse 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 ntiered clientserver/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