This job offer is not available in your country.

Oracle PL / SQL Senior Consultant

Talent Worxhyderabad, India

6 hours ago

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.

Create a job alert for this search

Oracle Consultant • hyderabad, India