Job
Description
Job requisition ID :: 82839 Date: Jun 6, 2025 Location: Bengaluru Designation: Senior Consultant Entity: Job Title: Oracle PL/SQL Senior Consultant Location Workplace: Hyderabad or BLR Job Type: Full-time Job Description: An Oracle PL/SQL Developer is responsible for developing and maintaining Oracle database applications using the PL/SQL programming language. Developing and maintaining Oracle database applications using PL/SQL. Designing and developing database schemas, stored procedures, functions, and triggers using PL/SQL. Optimizing database performance by tuning SQL queries and PL/SQL code. Developing and executing test plans to ensure the quality and accuracy of PL/SQL code. Troubleshooting and resolving issues related to PL/SQL code. Responsibilities: Designs, develops, implements, and maintains custom oracle applications written in PL/SQL and supports back-end data processing in PL/SQL Good Experience in SQL Analytical Query, Performance Tunning concepts. Knowledge about oracle architecture 9i and 18c different and ETL Process Design and Develop database objects like Stored Procedures, Functions, Packages and Triggers. Develop database for Ref Cursor, Collections, Dynamic SQL and Exception handling Able to work on Collections like PL/SQL Records, PL/SQL Tables, and Nested Tables in PL/SQL blocks and Bulk Collection. Good Experience Oracle Partitioning is a key feature Must have experience in creating scheduler jobs, Views, Materialized Views. Should have good understanding in Indexing. SQL Query tuning using different tools. Clear understanding of query plan. Perform code reviews to ensure code quality, standards compliance, and best practices. Debug and troubleshoot PL/SQL code to identify and resolve issues. Collaborate with cross-functional teams to gather and analyze requirements. Design and develop database schema, tables, and relationships. Create and optimize SQL queries and PL/SQL code for efficient data retrieval and manipulation. Ensure data integrity, security, and performance in database operation. Collaborate with application developers to design and implement database structures that meet application requirements. Optimize database performance through indexing, query optimization, and other tuning techniques. Implement and maintain database security measures, such as roles, privileges, and access controls. Monitor and troubleshoot database issues. Excellent problem solving, issue identification, analytical and technical documentation skills. Strong interpersonal skills and ability to work well in a team environment. Understand SDLC process and tools, agile program management concepts and version control. Qualifications: Bachelor’s degree in Computer Science or a related field. 6 to 8 years of proven experience in Database Development. Strong proficiency in ORACLE SQL, PL/SQL. Proven experience as a PL/SQL Developer in a senior or lead role. Strong problem-solving skills and the ability to work collaboratively in a team environment. Exposure to cloud hosting and IT domains such as CI/CD pipelines and automated testing. Excellent communication and interpersonal skills.
