The company is seeking an Oracle PL/SQL Developer to design, develop, tune, and monitor Oracle-based systems, with a strong background in SQL, PL/SQL, and Java, to work on enterprise-level solutions.
Requirements
- 10+ years of hands-on experience in Oracle Development.
- Expert-level proficiency in SQL and PL/SQL.
- Strong experience in designing database objects such as tables, triggers, procedures, and partitions.
- Ability to write and optimize complex SQL/PLSQL queries for data analysis and processing.
- In-depth knowledge of SQL Tuning, SQL traces, SQLLDR, and other Oracle utilities.
- Hands-on experience with OEM (Oracle Enterprise Manager) for monitoring and performance optimization.
- Experience with Java and integration of database logic with Java-based applications.
Responsibilities
- Design, develop, and maintain robust PL/SQL programs, stored procedures, triggers, and packages.
- Work with application teams to integrate database solutions and ensure data accuracy and consistency.
- Tune SQL queries for performance optimization using Oracle tools and best practices.
- Monitor and troubleshoot database performance issues using OEM and other diagnostic tools.
- Participate in database design discussions and ensure proper indexing, partitioning, and storage management.
- Collaborate with QA and DevOps teams to support builds, deployments, and defect resolution.
- Document technical solutions, queries, and procedures for maintainability and compliance.
Other
- 10+ years of professional experience
- Strong debugging, troubleshooting, and performance improvement capabilities
- Ability to work with application teams
- Collaborate with QA and DevOps teams
- Provide production support
