Oracle DB Performance Tuning DBA

Bengaluru

Posted:15 hours ago

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.

Skills Required

Oracle Performance Tuning Azure SQL Statistics Azure Storage Capacity Planning Database administration Microsoft Azure Linux and shell scripting SAP and ERP

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You