Description

You will design, develop, and maintain complex PL/SQL programs, stored procedures, triggers, and packages within enterprise-level systems.

Responsibilities

• Design and maintain robust PL/SQL programs, stored procedures, triggers, and packages.
• Tune SQL queries for performance optimization using Oracle tools and best practices.
• Monitor and troubleshoot database performance issues using OEM and other diagnostic tools.
• Collaborate with application, QA, and DevOps teams to integrate database solutions and support deployments.
• Participate in database design discussions regarding indexing, partitioning, and storage management.
• Document technical solutions, queries, and procedures for maintainability and compliance.

Required Skills

• 10+ years of professional experience in Oracle development.
• Expert-level proficiency in SQL and PL/SQL.
• Extensive experience designing database objects including tables, triggers, procedures, and partitions.
• Proven ability to write and optimize complex SQL/PLSQL queries for data analysis and processing.
• Deep knowledge of SQL tuning, SQL traces, SQL*Loader, and other Oracle utilities.
• Hands-on experience with Oracle Enterprise Manager (OEM) for monitoring and performance optimization.
• Experience with Java and integrating database logic with Java-based applications.
• Strong debugging, troubleshooting, and performance improvement capabilities.
• Any Graduate degree.

Preferred Skills

• Experience with transaction monitoring and third-party diagnostic tools.

Key Skills

Education

Any Graduate