Must be local or willing to relocate to Pittsburgh.

 

Job Title:                 Database Administrator IV

Job Family:             Information Technology

Discipline:               Oracle Database

Career Level:          Associate IV

Department:            Technology Services

FLSA Status:           Exempt

 

Overall Purpose:

The Database Administrator IV role uses Oracle’s database software solutions in a secure and efficient manner. The DBA will work closely with Functional Analysts, Project Managers, Software Architects and the Development group.  Oracle DBAs handle capacity planning, evaluate database server hardware/software, and manage all aspects of the Oracle database landscape including installation, configuration, design, patching, and data migration. Additional responsibilities include performance tuning, monitoring, security, backups, troubleshooting, and data recovery.

Role typically requires over 7 years of experience.

 

Job Responsibilities:

  • Keep abreast of changes in oracle standards, technologies and/or methodologies
  • Install and upgrade Oracle database-related software
  • Allocate system storage and plan future storage requirements for database systems
  • Create, review and QC new databases
  • Create, review and QC database storage structures and objects
  • Create, review and QC modification of database components as necessary
  • Create, review and QC database security
  • Ensure compliance with Oracle license agreement
  • Monitoring and optimizing the performance of the database
  • Create, review and QC backup and recovery of databases
  • Consult with Oracle Corporation for technical support issues
  • Tune instance components including SQL and PL/SQL
  • Create, review and QC DDL changes
  • Review and QC application related changes to database design
  • Maintain migrations and refreshes of Oracle data across the enterprise
  • Create, review and QC highly available database systems
  • Develop, review and QC data interface protocols
  • Patching Oracle systems
  • Predicting future Oracle trends for hardware usage and user load
  • Adhere to Change management practices

Technical Skills:

  • Oracle database software and features (9i to 19c)
  • Golden gate
  • Unix/Linux shell scripting experience
  • OEM and management packs
  • Exadata
  • RMAN
  • PL/SQL
  • ASM
  • RAC and cluster ware
  • Data guard
  • AWR, Statspack, Tkprof

Supervisory:
Does not supervise others.


Preferred:
Industry certifications.