1 year, possible extension. Knowledge, Skills and Abilities: Required: Demonstrated experience with developing web-based applications Demonstrated experience with object-oriented development techniques Demonstrated experience with PL/SQL programming and development skills Demonstrated experience with databases Demonstrated experience with Oracle Application Server Create stored procedures and functions for maximum reuse and minimum code maintenance Demonstrated experience with Unix/Solaris Servers with Oracle Application Server and Oracle Database Server 10g Demonstrated experience with Intel/Windows Servers with SQL 2008 Demonstrate proficiency at PL/SQL development for Oracle databases including development of Oracle packages, stored procedures, functions, triggers, and scheduled jobs Preferred: Excellent verbal and written communication skills Ability to communicate effectively with technical and user staff Experience with T-SQL programming and development skills Ability to design modular applications using packages Experience with managing data retrieval for Front End applications Ability to bulk bind collections to increase the speed of data movement operations Ability to invoke native dynamic SQL to develop high-level abstract code Ability to encapsulate data manipulation statements in stored procedures and packages Ability to perform complex data manipulation with cursors Ability of leveraging EXCEPTIONs to handle runtime errors Experience with creating triggers to handle data integrity and derivation Experience with utilizing weak and strong cursor variables for dynamic SQL Experience with denormalizing data with user-written functions Ability to create global variables in bodiless packages for session processing Education/Experience: 5+ years direct experience with developing web-based applications 5+ years direct experience with object-oriented development techniques 5+ years direct experience with PL/SQL programming 5+ years direct experience with databases 5+ years direct experience with Oracle Application Server Tasks: Monitor daily operational activities and handle errors resulting from activities to include data interfaces with internal and external entities and resulting reports. Interpret and provide analysis of data selected as a result of COMPAS daily operational activities. Monitor financial activity from internal and external entities. Analyze Oracle database packages, procedures and functions and determine modifications needed or validity of changes requested by the business unit to these objects. Assist Oracle Database Administrators, Oracle Form and Report Developers and Web Developers with gathering requirements, database and application testing and validation of affected data and determine where modifications are required. Analyze and maintain program specific Application Configuration of MQA's Licensing System. Develop and analyze PL/SQL for database to meet the needs of the Business Unit. Conduct comparative analysis of database for alignment with current Statutory, Rule and Business Requirements. Provide PL/SQL programming. Maintain SCCS (Source Code Control System) for the management of internal code changes. Provide development and maintenance of Perl scripts and Unix Shell Scripts. Provide MS SQL database administration inclusive of data design/modelling, monitoring, and performance tuning. Provide SQL programming inclusive of stored procedures, functions, triggers, DTS packages, scheduled jobs, and linked Servers. Provide configuration management (SourceSafe administration) for SQL database objects. Provide change management in a code promotion role in partnership with development team. Provide web Application Server system administration, monitoring, trouble-shooting, and performance tuning. Provide analytical services on systems to implement user-defined requirements. Provide analytical services on systems to identify operational efficiencies. Facilitate collecting system requirements with the business program staff. Produce work estimates to implement user-defined requirements. Perform testing on system changes to meet user-defined requirements. Provide analytical services on DOH IT processes to identify operational efficiencies. Follow DOH IT processes and coordinate with other DOH IT staff to ensure compliance with DOH standards. Process tickets to correct system errors or implement user-defined requirements. Test code created to satisfy system fixes or user-defined requirements.