PositionPurpose
The Application DBA is responsible for assisting inthe development, testing, and support of the Open and Shared Information System(OASIS). The primary role of the Application DBA is to maintain and optimizethe functioning of Oracle databases (including SQL tuning, PL/SQL tuning, andindex optimization), as well as developing new Back End applications usingOracle 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 activerole in the quality assurance and the quality control of applicationsubmissions for use in the OASIS portal and troubleshooting activities relatedto the optimal performance of the system.
Finally this position will function as an extensionof state staff, developing, and monitoring an effective migration to OASIS andupgrade of current support systems (ie order processing, inventory, andbilling systems). The Application DBA must be familiar with project managementtechniques and principles.
EssentialPosition Functions
Principal Accountabilities
1. Assist internal and external customers toproduce detailed functional requirements of system components to be programmed.
2. Efficiently program modules for use in backendsystems whether it be a new module or an upgrade to existing functionality.
3. Assist in software configurations as requiredsupporting the organizations development needs and schedule.
4. Monitor and assist in tuning systems forgreatest performance.
5. Act as liaison with hosting provider to ensureenvironment is optimized for application performance.
6. Provide planning and technical support formigration activities.
7. Provide assistance to ensure the security ofdeployed applications.
8. Provide technical documentation of workperformed in standard project team format.
9. Recognize and identify potential areas whereexisting applications require change, or where new applications need to bedeveloped.
10. Provide, at a minimum, a weekly writtenperformance and activity report to the project management team.
Authority
1: Verify programming and administration activitiesand validate quality of deliverables.
2: Maintain schedule and prioritization forprogramming and administration activities.
3: Report and coordinate all activity with DMSsupervisor.
4: Work with all team members to ensure that allrequirements are satisfied.
5: Facilitate and participate in design meetingsand customer JAD sessions.
6: Author compliance, application documentation,and performance reports.
Contacts Daily contact with the OASIS team, whichincludes routine contact with other contracted personnel. During the course ofplanning, design, development, and quality control frequent contact may berequired with internal and external staff (both in business units and technicalunits).
PositionRequirements
Please address each of the following requirementsin 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 OraclePL/SQL developer.
3: Generally 3-5 years experience with theadministration of Oracle Databases.
4: Ability to communicate effectively and work in ateam environment.
OASISArchitecture
The Open and Shared Information System (OASIS) isan application framework intended to empower the SUNCOM user community to helpcreate, 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 thePresentation Tier and the SOAP Web services of the SOA Tier.
Language: PHP, C#, Java
SOA Tier
A Web Service conduit between the Presentation Tierand 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 InternetDirectory
Web Services
SOAP/XML RPCs with SUNCOM vendors.
Language: SOAP/XML
A shared environment will be created to facilitatedevelopment and collaboration. External users will be invited to create andenhance SUNCOM applications created for the OASIS framework. Open-Sourcesolutions may be utilized where possible.