Senior Oracle DBA

Emergys

Pune District

On-site

INR 3,500,000 - 6,500,000

Full time

11 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Emergys Corp. seeks a Senior Oracle DBA and Migration Specialist to drive complex migrations from Oracle 19c to 26AI Autonomous Database (ADB). The role is embedded in a multi-cloud hosting migration moving workloads from on‑premises to Azure-based fabric with OCI integration.

The candidate must independently diagnose performance anomalies and coordinate secure, audited migrations. You will own end-to-end cutovers, data replication, and security integrations, while coordinating with teams across

Responsibilities

  • Orchestrate zero/near-zero downtime production cutovers using Oracle ZDM and GoldenGate
  • Manage multi-region deployments with isolated dev/UAT/DR targets without disrupting CI/CD
  • Validate system functionality and perform shakeout/performance testing on Prod 2 regions before DNS changes
  • Migrate hardware-based HSM (Thales Luna) to cloud Luna Virtual HSM and ensure compliance with security requirements
  • Troubleshoot vendor interdependencies to resolve caching, timeouts, or key revocation issues
  • Diagnose performance degradation in Oracle 26AI/23c and optimize mixed workloads including ETL and OLTP
  • Analyze SQL*Net parameters and routing to isolate OCI latency from DB engine delays
  • Configure ADB instance modes, resource pools, and connections for varying workloads
  • Lead client rollouts with SQL Developer/Instant Client and Entra ID authentication

Job description

We are seeking a high-powered, critical-thinking Senior Oracle DBA and Migration Specialist to drive the complex migration of our core database tier from Oracle 19c to Oracle 26AI Autonomous Database (ADB). This role is embedded in a fast-moving, multi-cloud hosting migration out of on-premises/legacy environments into a modern infrastructure where Oracle workloads run via specialized fabric seamlessly integrated with Microsoft Azure.

As our sole or primary Oracle subject matter expert, you will not rely on manuals or Tier-1 support scripts. You must possess the native expertise to diagnose intricate performance anomalies across mixed workloads, configure complex third-party security integrations, and confidently challenge Oracle Support when resolving structural engine bugs.

Core Responsibilities:
  • Database Migration & Cutover Execution:
    • Orchestrate zero/near-zero downtime production cutovers using Oracle Zero Downtime Migration (ZDM) and Oracle GoldenGate for continuous data replication and final synchronization
    • Manage a multi-region deployment approach, setting up isolated dev, UAT, and Disaster Recovery (DR) targets without disrupting existing CI/CD pipelines
    • Validate system functionality and execute rigorous shakeout/performance testing on “Prod 2” staging regions prior to modifying production DNS records
  • Enterprise Key Management & Security Integration:
    • Take complete ownership of migrating a highly sensitive hardware-based HSM (Thales Luna Physical Appliance) to a cloud-based Luna Virtual HSM setup
    • Ensure compliance with top-tier U.S. banking security requirements by maintaining a flawless, continuous authentication heartbeat between the Autonomous Database and the Virtual HSM to prevent database lockups
    • Troubleshoot complex vendor interdependencies (Oracle vs. Thales Luna vs. Virtualization providers) to resolve caching, timeout, or key revocation challenges
  • Advanced Performance Tuning & 26AI Optimization:
    • Diagnose and resolve performance degradation unique to Oracle 26AI/23c architectures, including slow DDL/DML processing speeds and network priority issues
    • Optimize mixed workloads that demand massive overnight/early morning ETL batch processing alongside high-concurrency transactional processing (OLTP) throughout the day
    • Perform deep-dive analysis on the Top 50 critical execution plans using AWR miners to mitigate risks associated with optimizer variations between 19c and 26AI
    • Evaluate and advise on new 26AI capabilities, assessing the strategic utility of features like AI Vector Search and parameters governing time zones, formats, and memory allocations
  • Configure Autonomous Database (ADB) instance modes, resource pools, and connection strings (Low, Medium, High workload criticalities) to optimize eCPU, memory (SGA/PGA), and IOPS scaling
  • Manage the specific constraints of an OCI-backed database deployed through Azure Billing/Hardware fabric, utilizing native Oracle Consoles for all direct administration
  • Own client-side rollouts for a large engineering organization (~80-90 users), deploying new SQL Developer/Instant Clients configured with Microsoft Entra ID (OAuth) authentication and localized wallet profiles
  • Deeply analyze SQL*Net parameters, trace logging, and routing profiles to isolate OCI private network latency from actual database engine delays
Required Technical Skills & Qualifications:
  • Autonomous Database Mastery: Proven track record deploying and managing Oracle Autonomous Database (ADB) environments in OCI, with deep knowledge of what parameters remain DBA-managed in a PaaS model
  • Thales Luna HSM Expertise: Direct hands‑on experience integrating Oracle TDE/Wallets with hardware and virtual Thales Luna HSM solutions
  • Data Replication & Migration Tools: Highly proficient in Oracle GoldenGate, Zero Downtime Migration (ZDM), and AWR analysis
  • Multi‑Cloud & Identity Networking: Familiarity with the Oracle Database@Azure ecosystem, private OCI networking (OCI ping troubleshooting), and Microsoft Entra ID OAuth token authentication
  • Vendor Management: Strong capability to drive Oracle Tier-3 support engineers past basic troubleshooting scripts to target and uncover actual engine bugs
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Oracle OCI DBA
Oracle OCI DBA

NTT DATA Services • Hyderabad

On-site
INR 1,800,000 - 2,600,000
Oracle OCI DBA
Oracle OCI DBA

NTT DATA • Hyderabad

On-site
INR 3,000,000 - 4,400,000
Oracle Database Administrator
Oracle Database Administrator

EXL • Chennai

Hybrid
INR 1,400,000 - 2,100,000
Senior Site Reliability Engineer
Senior Site Reliability Engineer

EEHO • Bengaluru

On-site
INR 4,200,000 - 6,600,000
Oracle DBA (L3 /L4)
Oracle DBA (L3 /L4)

Wipro Ltd. • Pune District, Mumbai

On-site
INR 1,500,000 - 4,000,000
Database Administrator
Database Administrator

Natus Sensory Inc. • Bengaluru

On-site
INR 3,500,000 - 7,000,000
DBA Lead
DBA Lead

Litmus7 • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Oracle DBA Lead
Oracle DBA Lead

Ample Success HR • Bengaluru

On-site
INR 4,200,000 - 5,200,000
Senior Database & Azure Migration Specialist
Senior Database & Azure Migration Specialist

Papigen • India

On-site
INR 4,500,000 - 7,500,000
Senior Site Reliability Engineer
Senior Site Reliability Engineer

Virtualbox • Bengaluru

Remote
INR 4,000,000 - 7,000,000