Oracle Expert (Developer)

Job Summary

Role

Database Expert (Developer)

Location

Chennai

Experience

4 - 8 Years

Number of Openings

1

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.

Responsibilities

• 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 Skills

• 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.
• Gen AI, Python, Postgresql knowledge.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.