Search by job, company or skills

Oracle DB Performance Tuning DBA

Oracle DB Performance Tuning DBA

NTT Data
Fresher
Not Disclosed
  • Posted 4 hours ago
  • Be among the first 10 applicants

Job Description

Window: M4-M8 (5 months, full FTE) . Location: India, 9-hr day with MT overlap . Reports to: Technical Lead (US)

Mission: Prove the Azure RHEL 12.2.15 platform performs at least as well as Solaris production - using Statspack only (no Diagnostics/Tuning Pack, no AWR/ASH) inside a 12-processor licence cap.

Responsibilities

  • Own the Solaris Statspack baseline and the comparative benchmark on Azure at 12.2.15
  • SQL and instance tuning on the migrated stack: endian-converted data, fresh statistics, Azure storage profile, licence-capped vCPU sizing
  • Month-end-close load simulation (proxy for the Aug 31 fiscal year-end) concurrent-processing throughput tuning
  • SSO/MFA (performance): baseline and validate the authenticated login path end-to-end - App Gateway/WAF → OHS/TLS 1.3 → Pathlock SSO/MFA → EBS session - measuring login latency and session-establishment overhead vs Solaris, and tuning web-entry/TLS configuration with the App-Tier DBA if the path regresses
  • Tune within constraints: no EE management packs, consolidated non-prod DBs, 12-CPU cap capacity recommendations must respect licensing
  • Cutover-weekend performance validation (M7) first Hypercare month stabilization on live workload (M8) incl. tuning-log deliverable

Must-have: 10+ yrs Oracle performance work demonstrated tuning without AWR - Statspack, SQL trace/tkprof, 10046/10053 EBS workload tuning (concurrent queues, close-cycle batch) 19c optimizer/statistics depth.
Nice-to-have: Azure storage performance (premium/ultra disk, ANF) web-tier/TLS latency analysis post-platform-migration tuning licence-aware capacity planning.

More Info

Key Skills

10053

EBS workload tuning

TLS latency analysis

10046

Azure storage performance

About Company