Must Have(s):
- Oracle EBS
- Roll out a new version of EBS – 12.2.9
- Oracle 19c
- Migration to OCI – not confirmed, but trending that way
- 7+ years of Oracle EBS – VCP, Endeca, OEM, OTM, OBI, Golden Gate, Replication, VCP
- Back-End is a Rack/RAC
- Run everything in ADO
BASIC FUNCTIONS: Responsibilities of the NBT Senior Oracle Database Administrator include but are not limited in performing Oracle DBA tasks and operations of existing corporate data including coordination, capacity planning, configuration, design, data migration and to ensure a stable information systems environment. Additional responsibilities include performance monitoring, security, backups, troubleshooting, and data recovery. This role will be expected to assist with providing technical leadership & mentorship within the DBA team while expanding outside of their core team to provide technical direction and guidance to other NBT Departments, Teams & Partners. This individual will be required to work nights and weekends as needed.
Minimum Qualifications:
- 7+ years’ experience administering Oracle database solutions
- 5+ years’ experience administering Oracle eBusiness Suite (EBS) application environments
.
Preferred Qualifications:
- Bachelor’s degree in Computer Science, Information Systems, or a related scientific or technical degree; or equivalent work experience
- Production DBA experience with ability to work with Development and other Solution teams on DB architecture and design.
- Expert knowledge of Oracle Architecture and Concepts. General RDBMS, Database tuning, SQL tuning, Database Statistics, Database upgrades, Database Installation, Configuration and Patching including RAC
- Significant experience with Oracle,12c and 19c architecture and database design, and related Oracle technologies (Partition, TDE Encryption, etc.) on Linux and Windows systems
- Significant installation, configuration, upgrade, and patching experience with Oracle eBusiness Suite (EBS) application environments, preferably R12.2.x with Database 19c
- Significant experience with performance tuning, capacity planning, and optimization of database environments, preferably 12c and 19c
- Demonstrated experience writing & optimizing SQL and PL/SQL and writing scripts using Shell and/or Python and automating routine DBA tasks
- Experience optimizing database solutions for multi-terabyte and multi-tenancy database architectures (CDB & PDB)
- Demonstrated experience working with Data Replication, Database Security, Encryption, Compression and Data Masking/Redaction technologies
- Working knowledge of Oracle Enterprise Manager Grid Control and/or Cloud Control
- Working knowledge of Oracle database administration on Exadata platforms
- Working knowledge of high-availability solutions and architecture (RAC, DataGuard, RMAN, GoldenGate)
- Experience working with US Based and offshore teammates
- Oracle OCP or OCM certification(s)