Lead Oracle Database Developer / Administrator

Description: Participating in design sessions to help with database design Serving as the internal Team DBA for application Serving as lead database developer for project, developing complex database packages and procedures to feed data to WCF Service Layer via ODP.NET Serving as lead database developer for 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 coding 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 Training databases liaising with Training Coordinator Supporting Batch development and support team with database coding Supporting nightly Audit process Catering to Audit data requests Assisting Data Warehouse Team sharing relevant 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 database coding standards are adhered to Assisting Testing Team with creating test data Developing appropriate system documentation Mandatory Qualifications: Develops and implements applications and programs for the backend processing systems used in businesses and organizations. Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. 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 creating 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. For Immediate Response call View phone number on click.appcast.io, or send your resume to View email address on click.appcast.io TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company. #J-18808-Ljbffr