Lead Database Administrator-Oracle

GENERAL FUNCTION:

Lead/Specialist is viewed as an expert in the administration and support of database technology. Undertakes complex projects requiring additional technical knowledge and makes decisions on ambiguous administrative and support issues. Communicates common goals and direction for the team. May interface with management to provide project updates.

The position is on the Technical/Professional ladder at level 4 in the Database Administration discipline.

DUTIES & RESPONSIBILITIES:

1. Identifies, tests and deploys all database technologies and support tools (detailed knowledge of SMP/E, JCL, TSO,/ISPF, SQL).

2. Ensures system improvements are successfully implemented.

3. Responsible for verifying all data to be entered into database meets set standards and requirements.

4. Designs, enters, audits and maintains large, complex databases.

5. Leads others to identify, test and resolve complex database performance issues (e.g., monitoring and tuning).

6. Performs database system management functions (e.g., software installs, version upgrades and configuration management).

7. Defines and develops database standards, procedures and architecture.

8. Designs data models and DW database designs.

9. Facilitates project planning by establishing work plans, estimates, milestones and schedules.

10. Provides team with technical training and/or mentoring.

11. Other duties as required.

SUPERVISORY RESPONSIBILITIES:

None

MINIMUM KNOWLEDGE, SKILLS AND ABILITIES REQUIRED:


Undergraduate degree or equivalent, with at least 6 years of computer related experience.  With 5 years of Oracle DBA experience.

Experience Required:

Oracle 10G (preferably 10.2.0.4)

OEM Experience

Oracle Software Installations

SQL Tuning using Explain plan or OEM

Oracle Patch Maintenance

Scripting using PL/SQL and/or Unix script

Unix/AIX

Good written and oral communication skills

Nice to Have:

Process development and implementation

Remedy Incident Management

PRSM, Frontier, Wallstreet Applications

TDE (Transparent Data Encryption)

DataGuard