Senior PeopleSoft/Oracle DBA

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.

• 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.