Oracle OCI DBA
At a glance
Mid-level Data Architecture & Governance role at NTT DATA. Hyderabad.
Pay not stated Data Architecture & Governance salary
dataroles summary, based on the employer's posting.
What you'll do
- Plan and run migrations from on-premises data centers to OCI DB Systems and Autonomous Databases
- Install and administer Oracle databases across on-premises and cloud environments, supporting production and non-production systems
- Reduce cutover disruption with ZDM, GoldenGate and Data Pump, then carry out major upgrades and CDB/PDB conversions
- Provision, patch and upgrade APEX across development, test and production, and tune APEX applications and ORDS pools
- Build disaster recovery and backup processes with Data Guard, Active Data Guard and RMAN connected to OCI Object Storage
What you bring
- At least eight years as an Oracle DBA, including three or more major enterprise cloud migrations and production APEX administration
- At least eight years working deeply with Oracle architecture, CDB/PDB, ZDM, Data Pump, Transportable Tablespaces and RMAN
- Three years of APEX and ORDS administration, plus Tomcat or WebLogic deployment and REST service security experience
- Hands-on production database administration across OCI DB Systems, Autonomous Database and Exadata Cloud Infrastructure
- Three to five years working with PeopleSoft or another ERP solution
Who this fits
This role suits a senior Oracle DBA with substantial cloud migration experience and production APEX expertise. You’ll work on migrations, upgrades, performance tuning, disaster recovery and ERP-related schemas and applications. The role is based in Hyderabad, India.
From the employer
Senior Oracle DBA – Cloud Migrations, Upgrades & APEX Specialist
We are seeking an experienced Oracle DBA to architect, install and maintain Oracle Database infrastructure in on-prem and cloud infrastructgure. In this role, you will be Orchestrating the lift-and-shift of legacy databases, executing structural database upgrades (e.g., non-CDB to multitenant CDB/PDB), configuring enterprise-grade Oracle APEX environments, and tuning cloud data engines.
Key Responsibilities
- Lead the technical planning and execution of database migrations from on-premises datacenters to OCI DB Systems, and Autonomous Databases.
- Install, configure and administer Oracle Database System in on-prem (or) Cloud infrastructure.
- Support and Tune production and non-prod Oracle Databases.
- Minimize business impact during massive cutovers by implementing Oracle Zero Downtime Migration (ZDM), Oracle GoldenGate (logical replication), and optimized Oracle Data Pump architectures.
- Execute major database upgrades (e.g., upgrading legacy 12c or 11g environments to Oracle 19c, 23c, or 26ai). Drive the transformation from traditional architectures into Container Databases (CDB) and Pluggable Databases (PDB).
- APEX Environment Provisioning: Install, configure, patch, and upgrade Oracle APEX instances across development, test, and production environments within CDB/PDB architectures.
- Partner with the cloud infrastructure engineer to instantiate, patch, configure, and scale cloud database services natively launched via OCI or directly mapped through the Oracle Database Service for Azure (ODSA).
- Set up cross-cloud or cross-region Disaster Recovery environments utilizing Oracle Data Guard and Active Data Guard.
- Setup and verify backup/recovery integrating RMAN with OCI Object Storage for both database files and APEX application metadata.
- Perform deep-dive SQL tuning, AWR/ASH analysis, and memory/I/O tuning to resolve post-migration performance discrepancies.
- Diagnose and optimize performance bottlenecks specifically impacting heavy APEX web applications and ORDS connection pools.
- Lead, participate, build and assist Functional and Developers for designing and developing the Archival, custom OLTP and reporting schema and applications for ERP solutions.
Required Qualifications & Skills
- 8+ years as an Oracle Database Administrator, featuring a proven track record of managing at least 3 major enterprise-scale database migrations to the cloud and managing production-grade APEX instances.
- 8+ years of Deep-dive mastery of Oracle Database architectures, CDB/PDB structures, Oracle ZDM, Data Pump, Transportable Tablespaces, and Oracle Recovery Manager (RMAN).
- 3 years of knowledge and experience of Oracle APEX (architecture and administration), ORDS configuration, Tomcat/WebLogic deployment, and RESTful web service security.
- Production experience managing databases hosted on OCI DB Systems, Autonomous Database (ATP), and Exadata Cloud Infrastructure.
- 3 to 5 years of Experience in working with PeopleSoft or other ERP solutions.
- Preferred Certifications:
- Oracle Certified Professional (OCP) – Oracle Database 19c/23c
- Oracle Cloud Database Service Specialist
- Oracle APEX Cloud Developer Certified Professional (a strong plus for understanding the application layer)
Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Architecture & Governance
Find me workBy the team behind dataroles.