RE: DB2/400 - Oracle Database Analyst
Location: Durham /NC
Duration :6 months

1. BASIC PURPOSE. Give a brief statement of the overall principal
purpose or function of this position.
Support the development teams in analyzing system
requirements to develop logical and physical entity relationship models and
deploy modeled objects. Support the production systems, and be responsible
for physical database changes and additions on multiple platforms (iSeries
(AKA AS/400), pSeries (AKA RS/6000)). Mentor other DBA team members when
appropriate. Provide project team support for query optimization.

2. NATURE and SCOPE/PRINCIPAL ACCOUNTABILITIES. List the major
duties, activities, responsibilities and end results for which this position
exists.
DB2/400 - Oracle Database Analyst
* Job Duties
* Design database objects (Logical and Physical) and processes in IDA
* Creation of any database object in DB2/400 Database
* Help resolve RI conflicts and record deadlock problems in Oracle and
DB2/400
* Execute and monitor data fixes as necessary
* Participate in Business Recovery tests at remote sites for both
iSeries and Oracle platforms.
* Communicate effectively with Project Leaders and team members in
IT&S Department
* Mentoring and Cross Training other DBA team members
* Liaison between external resources and internal resources for
database projects.
* Follow current standard Change Management policies for the
department, as well as standards, policies and procedures that are specific
to the Information Management Team.
* Create and implement database portions of project plans.
* Provide project estimates for DBA skills to project managers.
* Turnover change management promotion process for all iSeries objects
including IFS objects.
* CVS change management processes relating to IDA.
* Manage security on iSeries and Oracle platforms, including object
security and authorization lists
* Creation of any database object in Oracle Database
* Help resolve communication issues between Oracle and DB2/400 (Access
Manager & Oracle Transparent Gateway)

Oracle and DB2/400 Administration
* Job Duties
* Monitor daily Oracle backups
* Monitor Oracle Table Spaces and Data file status for space
constraints
* Monitor Oracle database performance as needed
* Execute and monitor data fixes as necessary
* Troubleshoot remote database connections (to other Oracles and to
iSeries)
* Recover Oracle database from RMAN/TSM system at DR test site
* Tuning of queries for better performance on iSeries and Oracle.
* Coordinate multi-platform promotions.
* Maintain appropriate level of communication with UG's vendor of
choice for Oracle Support

3. KNOWLEDGE, SKILL, EXPERIENCE and MINIMUM EDUCATION REQUIRED. State
the minimum formal education and years of work experience required to
satisfactorily perform the position's duties. Include specific educational
requirements and list any positions, which may lead to this position.
A Senior Database Administrator should have the following skills
* DB2/400 experience (5 or more years)
* Relational Modeling Experience
* Experience with both command line and Ops Navigator database
functionality.
* Exposure to Oracle.
* Experience with system and application monitoring tools.
* Experience in a software development environment.
* Experience with RPG/CL for the iSeries environments.
* Experience with SQL/DDL and DDS for both iSeries and Oracle
environments.
* Experience and knowledge of Change control systems.
* Familiarity with Web Based Development Technologies and Web
Applications
* Must be willing to work on all platforms and databases in use at
United Guaranty
* Ability to adapt to a rapidly changing environment
* Experience mentoring and cross training
* Working knowledge of the IFS on iSeries and transferring IFS objects
using Turnover.
* Working knowledge of journals on iSeries and how to use them for
audit purposes.
* Time management, planning, and organization skills.
* Excellent oral, written communication skills.

General:
* Any DB2 Universal, AIX experience, IDA and TSM experience a plus
Additional Pluses:
* Oracle Administration experience
* DB2/400 experience
* DB2 Universal
* TSM experience
* Knowledge of J2EE and Java