This is a full tile role with PNC Bank. 100% remote. USC/GC. Salary us 115-135 based on candidate location.

ASM Storage and SCAN Listener 6 + Years

Linux platform 6 + Years

OLTP, OLAP, Staging, and Data warehouse configuration Yes 6 + Years

Oracle 12c, 18c, and OEM 13c 6 + Years

Oracle 19c RAC Database Administration 6 + Years

Oracle Enterprise Manager 13c 6 + Years

Oracle Enterprise Manager and physical DBA support 6 + Years

Oracle RAC Database Administration 6 + Years

Oracle RAC DBs 18c+ 6 + Years

Performance tuning, migration, data gaurd replication, configuration and security administration 6 + Years

RMAN backup and recovery of the Oracle Database 6 + Years

REQUIRED SKILLS: Senior Database Administrator - 8+ years

• Oracle RAC Database Administration

• Comprehensive background in administration of Oracle Enterprise Manager and physical DBA support in a complex environment.

• Exadata administration

• Previous experience partnering with Oracle on troubleshooting and resolving Exadata appliance issues

• Install, Configure and administer Oracle Enterprise Manager 13c.

• Install, configure and administer Oracle RAC DBs version 18c and above, including the design, configuration and operation of n-node clusters, data recovery, and user/group/role definition.

• Database skills must include: Installation/Patching/Upgrade of the OEM, database software on Linux platform, RMAN backup and recovery of the Oracle Database, performance tuning, migration, data guard replication, configuration and security administration.

• Strong knowledge of the Linux/UNIX environments

• Perform Schema level and Table level data refreshes from Production to Non-Production environments using Data pump EXPDP/IMPDP

• Strong understanding/exp w/Linux/UNIX environments

• Experience with Oracle 12c, 18c and OEM 13c

• Work experience with OLTP, OLAP, Staging, and Data warehouse configuration.

• Strong fundamentals in all aspects of DBA responsibilities.

• Excellent communication skills, customer service and client management skills.

• Highly specialized in Oracle Enterprise Manager 13c with installation and configuration of emails and alerts.

• Specialized in Oracle 19c RAC Database Administration and Technical Architecture, including but not limited to database administration, ASM Storage, SCAN Listener, RMAN backup and recovery, Performance Tuning, Database Refreshes from Prod to Lower Environments.

PREFERRED SKILLS:

• SQL server/MySQL administration is a plus

Degrees/Certifications/Years of Overall Experience Required:

• HS Diploma w/Oracle cert is ok

• Bachelor's preferred (software engineering, computer science, and/or related field)

• 8+ years of related work experience

What will separate an average candidate vs a great candidate on a resume?

• Previous financial institution experience is a plus

Day to Day Responsibilities:

• Monitor database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring for proper capacity and availability.

• Configuration management, performance tuning and administration of mission critical production databases

• Configure Physical standby databases and perform switchover/failover activities. Troubleshoot standby and switchover issues.

1. must come from a large enterprise DBA environment (PNC supports 3,200 Oracle databases) 2. green cards or citizens only (no EADs) 3. must have solid Oracle 19C and bash scripting (writing scripts from scratch) 4. must have heavy performance tuning, data guard and OEM 5. supporting Oracle on Exadata highly preferred 6. Golden Gate highly preferred