Oracle Expert (Developer)

BMW TechWorks India Private Limited; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

BMW TechWorks India Private Limited is seeking a Database Expert to develop, support, and maintain Oracle-based applications and related Windows and Linux environments in Chennai. The role combines Oracle PL/SQL, Forms, and Reports with transfer management, scheduling, patching, and Java updates.

4–8 years of experience is expected. Responsibilities include building and optimizing database code, managing file transfers, cron jobs, and certificates, and coordinating with cross-functional teams

Qualifications

• Must have Oracle PL/SQL, Oracle Forms, Oracle Reports.
• Experience with Windows Server administration for file transfers, scheduling, and scripts.
• Experience with Linux administration for shared-file transfers and cron-job maintenance.
• Knowledge of Oracle WebLogic patch installation and certificate handling.
• Java version upgrades and certificate-store maintenance.
• Experience designing and implementing database schemas with data modeling techniques.
• Ability to troubleshoot and resolve database issues while maintaining data integrity.

Responsibilities

• Develop, support, and maintain Oracle-based applications and environments.
• Manage file-transfer tools and Windows Scheduler; maintain start scripts and external tools.
• Coordinate with teams for releases, maintenance, and incident resolution.
• Design and develop Oracle packages, procedures, functions, and triggers.
• Analyze and optimize Oracle queries and code for performance.

Skills

Oracle PL/SQL

Oracle Forms

Oracle Reports

Windows Server administration

GlobalX

Windows Scheduler

Linux administration

Oracle WebLogic

Oracle HTTP Server

Java version upgrades

Data Modeling

Troubleshooting

Documentation

Production support

Tools

GlobalX

Windows Scheduler

Job description

Digital Company > ItO & Quality > Integration & Verification > Hardware verification

Location

Experience:

4 - 8 Years

Number of openings

1

What awaits you/ Job Profile

• We are looking for a Database Expert to develop, support, and maintain Oracle-based applications and the associated Windows and Linux operational environments.
• The role combines Oracle PL/SQL, Oracle Forms, and Oracle Reports expertise with transfer management, job scheduling, middleware patching, certificate maintenance, and Java platform updates.

What should you bring along

• Develop, enhance, troubleshoot, and maintain solutions using Oracle PL/SQL, Oracle Forms, and Oracle Reports.
• Manage file-transfer tools using GlobalX and Windows Scheduler.
• Manage and maintain start scripts and external tools used for work with Fi-Doku.
• Manage transfers from shared locations in Linux environments.
• Create, maintain, monitor, and troubleshoot cron jobs.
• Install WebLogic and Oracle patches in accordance with defined maintenance procedures.
• Create, renew, deploy, and maintain Oracle HTTP Server (OHS) certificates.
• Update Java versions and maintain Java certificate stores.
• Investigate application and environment issues, perform root-cause analysis, and support resolution.
• Maintain technical documentation for configurations, scripts, schedules, certificates, patches, and operational procedures.
• Coordinate with application, infrastructure, and support teams for changes, releases, maintenance, and incident resolution.
• Database Development: Design and develop oracle packages, procedures, functions, and triggers to support application development.
• Performance Optimization: Analyze and optimize oracle queries and oracle code to improve database performance and efficiency.

Must have technical skill

• Oracle PL/SQL.
• Oracle Forms.
• Oracle Reports.
• Windows Server administration relevant to file transfers, scheduling, start scripts, and external tools.
• GlobalX and Windows Scheduler.
• Linux administration relevant to shared-file transfers and cron-job maintenance.
• Oracle WebLogic patch installation and maintenance.
• Oracle HTTP Server certificate creation and maintenance.
• Java version upgrades and Java certificate-store maintenance.
• Data Modeling: Collaborate with data architects to design and implement database schemas and structures.
• Troubleshooting: Identify and resolve database-related issues, ensuring data integrity and security.

Good to have technical skills

• Disciplined approach to production support, change execution, and operational stability.
• Documentation: Maintain comprehensive documentation of database designs, code, and processes.
• Collaboration: Work closely with application developers, business analysts, and other stakeholders to understand requirements and deliver effective database solutions.
• Ability to manage multiple priorities in a structured manner.