Senior PeopleSoft/Oracle DBA

Experis Technology Group; City of Albany (NY); Remote; USD 152,000 - 165,000; Full time

Job summary

Experis Technology Group seeks a Senior PeopleSoft/Oracle DBA for a five-year assignment. The role is 100% remote with a 40-hour workweek from 7 a.m. to 5 p.m. EST, and occasional extended hours by mutual agreement.

Responsibilities include managing Oracle databases in PeopleSoft environments, upgrading versions, applying patches, Data Guard operations, backups, performance tuning, scripting, cloning, and ad hoc reporting, plus coordination with Oracle support.

Qualifications

• 10+ years as Oracle DBA supporting PeopleSoft in enterprise environments.
• 2+ years with Oracle 19c in PeopleSoft/CRM/HCM settings.
• Experience with Exadata, Data Guard, multi-tenant or advanced compression.

Responsibilities

• Administer Oracle databases for PeopleSoft environments.
• Upgrade databases to new versions and apply patches quarterly.
• Perform switchover/failover to Data Guard and gap resolution.
• Backup and recoveries of databases and cloning of databases.
• Write and maintain scripts to support database systems.
• Provide ad hoc reporting and work with Oracle support as needed.

Skills

Oracle DBA

PeopleSoft

Oracle 19c

Exadata

Data Guard

OEM

RMAN

ASM

Unix/Linux scripting

Tools

Oracle Enterprise Manager

Data Guard

RMAN

Job description

Senior PeopleSoft/Oracle DBA

Duration: 5 year assignment.

Work Arrangement: 100% Remote

Weekly Work Schedule: 40 hours per week during the hours of 7 a.m. and 5 p.m. EST.

Occasional extended hours may be necessary by mutual agreement, e.g., Working weekends, past normal business hours.

Rate 120.00 corp. to corp.

Hourly rate with benefits 110.00 (W/2)

There is a government skill evaluation form to be complete with references.

Responsibilities:

• Support the database unit in the administration of Oracle databases
• Upgrading databases to new versions.
• Patching databases quarterly and applying patches to resolve one off bug fixes.
• Conduct switchover or failover to Data Guard instances and gap resolution.
• Backup and recoveries of databases.
• Resolve performance issues.
• Writing and maintaining scripts used to support database systems.
• Database cloning.
• Creation of new databases.
• Ad hoc reporting.
• Work with Oracle support, as necessary.

Required Qualifications:

• Ten or more years of experience serving in the capacity as an Oracle database administrator (DBA) supporting PeopleSoft Financials, CRM and/or HCM.
• Two or more years of experience serving in the capacity as an Oracle 19c database administrator (DBA) supporting PeopleSoft Financials, CRM and/or HCM.
• Two or more years of experience implementing and/or managing database features such as multi-tenant or advanced compression.
• Ten years of experience serving in the capacity as an Oracle database administrator (DBA), including experience administering and supporting Oracle databases in Enterprise environments. Experience must include support of Oracle PeopleSoft environments and may include database administration supporting other enterprise applications and platforms.
• Experience working with Oracle version 19c or higher.
• Hands-on experience with Oracle Exadata, including configuration, monitoring, and maintenance.
• Proficiency in diagnosing and resolving issues related to Exadata performance, hardware, software, and connectivity.
• Familiarity with Exadata’s unique storage architecture, including storage optimization techniques.
• Understanding of networking concepts and protocols as they relate to Exadata.
• Ability to apply patches, updates, and security fixes to both the Oracle Database and Exadata software stack.
• Knowledge of security best practices for Exadata systems, including user access controls, encryption, and auditing.
• Experienced in Oracle Advanced Security (TDE).
• Experienced in Data Guard setup, switchover, fail over and gap resolution.
• Seven years of experience in backup, cloning and recovery strategies of at least 1 TB systems, including: RMAN and Filesystem clone, datapump.
• Seven years of experience identifying problem SQL, analyzing execution plans, and developing tuning options.
• Seven years of experience utilizing Oracle Enterprise Manager (OEM).
• Experience with Automatic Storage Management (ASM).
• Knowledge in Unix and Linux Operating Systems and scripting experience in these environments.