Position Purpose
The Application DBA is responsible for assisting in the development, testing, and support of the Open and Shared Information System (OASIS). The primary role of the Application DBA is to maintain and optimize the functioning of Oracle databases (including SQL tuning, PL/SQL tuning, and index optimization), as well as developing new Back End applications using Oracle PL/SQL. In this capacity the Application DBA will fully understand:
- Advanced Oracle Database Administration;
- Advanced PL/SQL Development;
- Relational Database Theory;
- JAD session facilitation and requirements gathering;
- Technical and documentation requirements; and
- Level of application support required.

Additionally this position will also take an active role in the quality assurance and the quality control of application submissions for use in the OASIS portal and troubleshooting activities related to the optimal performance of the system.

Finally this position will function as an extension of state staff, developing, and monitoring an effective migration to OASIS and upgrade of current support systems (ie order processing, inventory, and billing systems). The Application DBA must be familiar with project management techniques and principles.

Essential Position Functions
Principal Accountabilities
1. Assist internal and external customers to produce detailed functional requirements of system components to be programmed.
2. Efficiently program modules for use in backend systems whether it be a new module or an upgrade to existing functionality.
3. Assist in software configurations as required supporting the organizations development needs and schedule.
4. Monitor and assist in tuning systems for greatest performance.
5. Act as liaison with hosting provider to ensure environment is optimized for application performance.
6. Provide planning and technical support for migration activities.
7. Provide assistance to ensure the security of deployed applications.
8. Provide technical documentation of work performed in standard project team format.
9. Recognize and identify potential areas where existing applications require change, or where new applications need to be developed.
10. Provide, at a minimum, a weekly written performance and activity report to the project management team.

Authority
1 . Verify programming and administration activities and validate quality of deliverables.
2 . Maintain schedule and prioritization for programming and administration activities.
3 . Report and coordinate all activity with DMS supervisor.
4 . Work with all team members to ensure that all requirements are satisfied.
5 . Facilitate and participate in design meetings and customer JAD sessions.
6 . Author compliance, application documentation, and performance reports.

Contacts Daily contact with the OASIS team, which includes routine contact with other contracted personnel. During the course of planning, design, development, and quality control frequent contact may be required with internal and external staff (both in business units and technical units).

Position Requirements
Please address each of the following requirements in your response:
1 . Bachelor's Degree in Computer Science, Information Systems or other related field. Or equivalent work experience.
2 . Generally 3-5 years experience as an Oracle PL/SQL developer.
3 . Generally 3-5 years experience with the administration of Oracle Databases.
4 . Ability to communicate effectively and work in a team environment.

OASIS Architecture
The Open and Shared Information System (OASIS) is an application framework intended to empower the SUNCOM user community to help create, enhance and evolve SUNCOM's growing online toolset. Its 3-tierarchitecture can be broken down to:
Presentation Tier
Portal
The main end-user entry point for OASIS
Handles authentication and security
Language: PHP, HTML, JavaScript, CSS
User Applications
Interfaces to various SUNCOM datasets
Language: PHP, C#, or Java; HTML, JavaScript, CSS
APIs
Classes for abstracting communication between the Presentation Tier and the SOAP Web services of the SOA Tier.
Language: PHP, C#, Java
SOA Tier
A Web Service conduit between the Presentation Tier and Data Tier.
Abstracts calls to diversified data sources.
Adds Object-Oriented context to datasets.
Language: C#
Data Tier
Oracle databases
Mostly Oracle 10g
Packages enforce authoritative row-level security
Language: PL/SQL
LDAP Directories
Users are stored in an instance of Oracle Internet Directory
Web Services
SOAP/XML RPCs with SUNCOM vendors.
Language: SOAP/XML

A shared environment will be created to facilitate development and collaboration. External users will be invited to create and enhance SUNCOM applications created for the OASIS framework. Open-Source solutions may be utilized where possible.