N

NTT Data

Global IT services and consulting provider.

Oracle DBA

Database AdministrationUpdated on Nov 6
Full-timeBengaluru, Karnataka, IndiaNo salary listedIn-person

About the Job

Requirements

  • At least 8 years of experience in data engineering or database engineering, including significant hands-on Oracle performance tuning.
  • Production experience with dbt and understanding of how dbt builds and runs models.
  • Production experience designing and operating Apache Airflow DAGs.
  • Working knowledge of ETL concepts, ideally including Informatica PowerCenter.
  • Working knowledge of Linux, shell scripting, and Python.
  • Use a data-driven approach: measure first, isolate the problem, change one thing, and prove the result.
  • Experience turning one-off fixes into standards or tools used by others.
  • Strong written and verbal communication skills.

Responsibilities

  • Profile slow workflows across the scheduler, Airflow, containers, dbt, and database; distinguish database processing time from framework and orchestration overhead.
  • Set performance baselines and compare results against legacy Informatica runtimes.
  • Identify root causes and explain them to technical and non-technical audiences.
  • Tune Oracle SQL and PL/SQL using execution plans, SQL Monitor, AWR/ASH, and wait-event analysis; resolve optimizer, cardinality, memory, and parallelism issues.
  • Tune distributed queries across database links so processing occurs where the data resides.
  • Design efficient dbt models and materializations, reduce parsing, compilation, and run overhead, and keep large projects fast.
  • Design efficient Airflow DAGs and tasks; reduce scheduling and start-up delays, and improve reliability through retry, restart, and failure handling.
  • Find and fix data accuracy and reliability issues uncovered during tuning.
  • Turn proven fixes into reusable templates, macros, utilities, and shared components.
  • Design shared changes for gradual adoption and safe rollback.
  • Create tuning playbooks, troubleshooting checklists, and automated performance checks that catch regressions before release.
  • Mentor developers and review designs so new workflows perform well from the start.
  • Present findings, options, trade-offs, and measured results to developers, architects, DBAs, and leadership.
  • Work with architecture and database teams to obtain approval for platform-level improvements.

Desired Qualifications

  • Hands-on Informatica PowerCenter experience, including migration to modern platforms.
  • Docker and container-based execution experience.
  • Experience with enterprise schedulers such as Control-M.
  • Experience with large-scale dbt projects or the dbt Python API.
  • Experience with Oracle RAC and parallel execution.
  • Experience with Git-based workflows and CI/CD for data pipelines.
  • Experience in financial services or another regulated industry.

About the Company

NTT Data

Global IT services and consulting provider.

NTT DATA is a global IT and business services provider that helps organizations run and transform their technology and operations. It delivers consulting, industry solutions, cloud migration, cybersecurity, data analytics, and managed services to modernize systems and processes. It differentiates itself through its large scale, deep sector expertise in banking, healthcare, manufacturing, public sector, and automotive, and its broad ecosystem of partners with Microsoft, SAP, AWS, and Salesforce. Its goal is to help large enterprises digitally transform and optimize operations at scale using cloud-native approaches and secure IT environments.

Company size
10,001+
Company stage
IPO
Headquarters
Tokyo, Japan
Founded
1988

Recently Posted Jobs

Explore more opportunities at NTT Data

See more jobs