NTT

1 day ago

Windchill Oracle DBA

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI

Last checked: 4 hours agoStatus: Live

Job Summary

Support Oracle databases for PTC Windchill environments by developing and tuning Oracle SQL/PLSQL code, data model objects, and reporting views. Administer database components including memory, tablespaces, partitioning, Oracle Text, and XML DB, and manage performance using tools like AWR/ASH/ADDM, SQL Monitor, and SQL Trace. Handle backup/recovery, cloning, refresh, DR, and upgrades/patching while partnering with Windchill application teams to resolve issues and improve reliability.

Location: Chennai

Workplace: Onsite

Employment Type: Full time

Job Function: IT Operations (Systems/Network Admin)

Seniority: Mid level

Key Responsibilities

•Develop, maintain, and optimize Oracle database objects for PTC Windchill, including SQL/PLSQL code and schema objects.
•Tune custom SQL, reports, and application-generated queries for performance and scalability using execution plans and performance tooling.
•Monitor and troubleshoot long-running SQL, wait events, locking/blocking, and concurrency issues.
•Administer and maintain Oracle databases (memory, tablespaces, redo/undo, Oracle Text, XML DB, partitioning) and handle backup/recovery, cloning, refresh, and disaster recovery.
•Collaborate with Windchill application teams on database designs, customizations, integrations, and perform root cause analysis for production issues.

Key Requirements

•8+ years of Oracle DBA support for enterprise applications, preferably PTC Windchill environments.
•Strong knowledge of Oracle SQL and PL/SQL, including procedures, packages, functions, views, and database objects.
•Experience with Oracle performance tuning (execution plans, AWR, ASH, ADDM, SQL Monitor, SQL Trace) and diagnosing locking/blocking and concurrency issues.
•Proficiency with Oracle database administration tasks such as memory, tablespaces, redo/undo, partitioning, Oracle Text, and XML DB.
•Linux/Unix and shell scripting experience; Oracle OCP and PTC Windchill certification are preferred.

Experience:8+ years

Skills:Root cause analysisPerformance tuningProblem-solvingCollaborationContinuous improvement

Certifications:Oracle OCPPTC Windchill

Tech Stack:OracleOracle SQLPL/SQLSQL scriptsAWRASHADDMSQL MonitorSQL TraceOracle OCPOEMRACASMActive Data GuardRMANData PumpOracle TextXML DBDBMS_STATSSQL

Company Brief

NTT

Dimension Data, operating under NTT Ltd, provides managed IT services, cloud and data center solutions, networking, cybersecurity, and digital transformation services to enterprise customers worldwide.

Industry: Professional Services

Company Size: Enterprise (1,001+ employees)

Revenue: USD 1B+

Growth: Established Company

Valuation: Public Company (Market Cap in USD)

Headquarters: London, United Kingdom

Founded: 1983

Website LinkedIn

Loading job details...

Preparing the role view and application actions.

NTT