Hybrid Manager, ADBA Database Performance Specialist – Performance Tuning, Shell Script, Python, OEM

Posted 2 days ago

Apply now

About the role

  • ADBA Specialist responsible for Oracle 19C database performance tuning in UK projects. Collaborating with application teams and performing 24x7 monitoring and analysis in a hybrid support environment.

Responsibilities

  • Monitor OEM, AppDynamics, and Dynatrace tools for database performance.
  • Support application teams during planned CRQs, including pre- and post-implementation activities.
  • Identify high CPU/IO-consuming SQL queries and recommend tuning improvements.
  • Assist application teams with SQL fine-tuning and performance troubleshooting.
  • Utilise database data dictionary views for in-depth analysis.
  • Monitor database wait events and raise Oracle SRs when required, ensuring follow-up.
  • Collaborate with L3 teams on performance and query tuning.
  • Develop Shell, Bash, Python, PL/SQL scripts as needed.
  • Perform data purging activities in alignment with retention policies.
  • Reorganise tables and manage partitioning to enhance performance and capacity.
  • Support export/import activities and perform logical table or schema refreshes.
  • Generate and analyse AWR, ASH, and ADDM performance reports.
  • Conduct performance tuning using standard Oracle utilities, including coe/sqlhc, profiles, and baselines.
  • Provide support during month-end processes and incident management across P1–P4 levels.
  • Document incidents and conduct root cause analysis.
  • Monitor blocking and long-running sessions.
  • Perform listener and alert log analysis.
  • Manage MView refresh requests and handle session termination with required approvals.

Requirements

  • Experienced in Oracle 19C database performance tuning.
  • Skilled in OEM, AppDynamics, and Dynatrace monitoring tools.
  • Proficient in Shell or Python scripting.
  • Strong analytical and problem‑solving abilities with a structured approach.
  • Open‑minded, solution‑oriented, and able to communicate clearly with technical and non‑technical teams.
  • Engineering qualification or equivalent experience.

Benefits

  • Opportunity to work on mission‑critical systems supporting large‑scale UK operations.
  • Exposure to advanced performance monitoring and tuning tools.
  • Experience in 24x7 operations, enabling strong learning in high‑availability environments.
  • Collaboration with cross‑functional teams across VOIS and global stakeholders.
  • A hybrid work model encouraging flexibility and work‑life balance.

Job title

Manager, ADBA Database Performance Specialist – Performance Tuning, Shell Script, Python, OEM

Job type

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

Professional Certificate

Tech skills

Location requirements

HybridPuneIndia

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job