Saxon Global
Oracle DBA
Saxon Global, New York, New York, us, 10261
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.
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.