PeopleSoft/Oracle DBA

Job Title: PeopleSoft/Oracle DBA

Work Location: 100% Remote

Long Term Contract

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

If you find this opportunity suitable, kindly share your updated resume. Also, please let me know a good time to connect with you for a quick discussion.

Looking forward to hearing from you!

Job Description

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.