Oracle PL/SQL Senior Consultant

1 week ago

Bengaluru India Talent Worx Full time

Job Description

Talent Worx is a growing services & recruitment consulting firm, we are hiring for our client which is a leading Big4 Consulting firm and provider of financial intelligence, data analytics, and AI-driven solutions, empowering businesses worldwide with insights for confident decision-making. Join to work on cutting-edge technologies, drive digital transformation, and shape the future of global markets.

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.

  • Senior Software Engineer – SQL/PL-SQL

    5 days ago

    India Oracle Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job Title: Senior Software Engineer – SQL/PL-SQL & Oracle APEX Developer (Data Analysis)Profile:We are seeking a highly skilled Senior Software Engineer with 10+ years of hands-on experience in data analysis, Oracle SQL/PL-SQL development, and enterprise application delivery. The ideal candidate brings robust expertise in designing and optimizing ETL...

  • Oracle PL/SQL Senior Consultant

    1 week ago

    Bengaluru, India Talent Worx Full time

    Talent Worx is a growing services & recruitment consulting firm, we are hiring for our client which is a leading Big4 Consulting firm and provider of financial intelligence, data analytics, and AI-driven solutions, empowering businesses worldwide with insights for confident decision-making. Join to work on cutting-edge technologies, drive digital...

  • Technical Consultant

    1 week ago

    Bengaluru, India Oracle Full time

    Oracle is leading the digital revolution. We are empowering nearly half a million businesses to thrive in the age of skyrocketing connections. Join us and play an instrumental role in masterminding the software that will have a truly global impact. OFSS Consulting is part of the Financial Services Global unit and provides a variety of consulting services...

  • Technical Consultant

    1 week ago

    Bengaluru, India Oracle Full time

    Oracle is leading the digital revolution. We are empowering nearly half a million businesses to thrive in the age of skyrocketing connections. Join us and play an instrumental role in masterminding the software that will have a truly global impact. OFSS Consulting is part of the Financial Services Global unit and provides a variety of consulting services...

  • Senior Software Engineer – SQL/PL-SQL

    5 days ago

    India Oracle Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    We are seeking a highly skilled Senior Software Engineer with 10+ years of hands-on experience in data analysis, Oracle SQL/PL-SQL development, and enterprise application delivery. The ideal candidate brings robust expertise in designing and optimizing ETL pipelines, developing scalable PL/SQL solutions, and building secure, user-friendly applications using...

  • Senior Consultant-Java/ PL/SQL

    1 week ago

    Bengaluru, India Oracle Full time

    As a consulting business, customer relationships are the heart of growing our business. We are ambassadors at the customer site both to create the right relationship and trust from the customers and to deliver high quality projects, services and advice. Our skills and capabilities are Consulting’s most important asset. Position Description We are seeking...

  • Senior Consultant-Java/ PL/SQL

    1 week ago

    Bengaluru, India Oracle Full time

    As a consulting business, customer relationships are the heart of growing our business. We are ambassadors at the customer site both to create the right relationship and trust from the customers and to deliver high quality projects, services and advice. Our skills and capabilities are Consulting’s most important asset. Position Description We are...

  • Staff Consultant

    3 weeks ago

    India ORACLE Full time

    Job Category Consulting As a consulting business customer relationships are the heart of growing our business We are ambassadors at the customer site both to create the right relationship and trust from the customers and to deliver high quality projects services and advice Our skills and capabilities are Consulting s most important asset Position...

  • PL/SQL Developer- Core Banking

    3 weeks ago

    Bengaluru, India Oracle Full time

    Intermediate consulting position operating independently with some assistance and guidance to provide quality work products to a project team or customer that comply with Oracle methodologies and practices. Performs standard duties and tasks with some variation to implement Oracle products and technology to meet customer specifications. Career Level - IC2...

  • PL/SQL Developer- Core Banking

    5 days ago

    Bengaluru, Karnataka, India Oracle Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Intermediate consulting position operating independently with some assistance and guidance to provide quality work products to a project team or customer that comply with Oracle methodologies and practices. Performs standard duties and tasks with some variation to implement Oracle products and technology to meet customer specifications.Career Level -...