Role - Oracle DBA Client - NY Govt. Department NYSLRS 3 years (with opportunity for extension) Rate - 100-110/hr on C2C Work Auth - All Except H1B 100% Remote JOB DESCRIPTION Please note: Require fifteen or more years of experience serving in the capacity as an Oracle database administrator (DBA) supporting PeopleSoft Financials, CRM and/or HCM. Responsibilities: The New York State has recently installed a modernized retirement benefit administration program. The implemented platform is an Oracle PeopleSoft solution. NYSLRS requires individual(s) with Oracle DBA skills to work with our in-house Oracle DBA team to support the database unit in the administration of Oracle databases. •Upgrading databases to new versions.
- Patching databases quarterly and apply 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.
Mandatory Qualifications: - Fifteen or more years of experience serving in the capacity as an Oracle database administrator (DBA) supporting PeopleSoft Financials, CRM and/or HCM.
- Oracle Certified Master (OCM) certification.
- Five years of experience supporting an Oracle PeopleSoft implementation of a retirement benefit administration program.
- Experience working with Oracle version19c.
- One year or more experience with Oracle Cloud (OCI).
- 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.