Job Description:
Trigyn's direct government client has an immediate need for Lead Oracle Database Developer / Administrator in Albany, NY.
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
• 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 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 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.