Opportunity Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list. Find me work
dataroles

Oracle DB Performance Tuning DBA

NTT DATA nttdata.com Open
Bengaluru Mid-level Data Architecture & Governance

At a glance

Mid-level Data Architecture & Governance role at NTT DATA. Bengaluru.

Pay not stated Data Architecture & Governance salary

RoleData Architecture & Governance
SeniorityMid-level
LocationBengaluru
PostedNov 19, 2026
Role brief

dataroles summary, based on the employer's posting.

What you'll do

  • Compare Solaris performance with Azure benchmarks using Statspack, staying within the 12-processor licence limit
  • Tune Oracle SQL and instance settings for migrated data, refreshed statistics, Azure storage and licensed CPU capacity
  • Simulate month-end close and improve throughput for concurrent processing workloads
  • Measure and tune authenticated EBS login latency across the web, SSO/MFA and database path with the App-Tier DBA
  • Validate performance during cutover, stabilize the first live-workload month and deliver a tuning log

What you bring

  • At least ten years of Oracle performance tuning experience
  • Hands-on tuning without AWR, using Statspack, SQL trace/tkprof and 10046/10053
  • Experience tuning EBS concurrent queues and close-cycle batch workloads
  • Strong Oracle 19c optimizer and statistics expertise

Who this fits

This suits a mid-level DBA focused on hands-on Oracle performance work across migration benchmarks, EBS workloads and login-path tuning. The assignment runs for five months at full FTE, with a nine-hour workday and overlap with MT; you report to a US-based Technical Lead.

From the employer

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.

Opportunity

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 work

By the team behind dataroles.

Find me work
Opportunity

Data Architecture & Governance work from LinkedIn, X, Reddit and Upwork, in one list.

Each morning you get everything that fits, strongest first.

Find me work

By the team behind dataroles.