Consultant - Oracle PL/SQL Job

YASH Technologies, Inc.; Pune District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

YASH Technologies, Inc. is seeking an experienced Oracle PL/SQL Developer in Pune to support, enhance, and maintain database solutions for several enterprise applications.

The role emphasizes PL/SQL development, performance tuning, data integration, and production support to ensure high data quality and reliability. The ideal candidate will have 5+ years of Oracle PL/SQL experience, strong SQL tuning skills, and the ability to work in a fast-paced, global environment.

Qualifications

• 5+ years of Oracle PL/SQL development experience.
• Experience with PL/SQL packages, procedures, functions, and triggers.
• Strong knowledge of SQL performance tuning.
• Experience with large/complex datasets and data quality.
• Experience in production support and debugging data issues.
• Familiarity with transaction management and locking mechanisms.
• Ability to communicate clearly and concisely, both orally and in writing.
• Ability to work in a multi-cultural, team-oriented environment.

Responsibilities

• Develop, maintain, and optimize Oracle PL/SQL code for multiple enterprise applications.
• Design and implement packages, procedures, functions, and triggers.
• Tune SQL queries and optimize indexes, partitions, and data access paths.
• Support data integration tasks and ensure data quality and integrity.
• Provide production support and resolve data-related issues in a timely manner.
• Collaborate with cross-functional teams in a fast-paced environment.
• Adapt to 24x7 support requirements and global travel as needed.

Skills

Oracle Database

PL/SQL

SQL performance tuning

Data integration

Production support

Debugging

Transaction management

Communication

Teamwork

Problem solving

Travel availability

Tools

Oracle SQL Developer

TOAD

Informatica

ODI

RMAN

Job description

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.

At YASH, we’re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.

We are looking forward to hireOracle PL/SQL Professionals in the following areas :

JOB DESCRIPTION:

We are looking for an experienced Oracle PL/SQL Developer to support, enhance, and maintain database solutions for multiple enterprise applications. This role focuses on PL/SQL development, performance tuning, data integration, and production support, ensuring high data quality, reliability, and performance.

ROLE AND RESPONSIBILITIES:

• Strong experience with Oracle Database.
• Advanced proficiency in PL/SQL.
• Expertise in developing packages, stored procedures, functions, and triggers.
• Strong knowledge of SQL performance tuning.
• Experience with indexes, partitions, and query optimization.
• Understanding of database design principles and normalization.
• Experience handling large and complex datasets.
• Ability to debug and resolve production data issues.
• Knowledge of transaction management and locking mechanisms.
• Good problem solving and analytical skills.
• Flexible to work in 24x7 environment.

Specifications

• Strong analytical and problem-solving skills; proven history of successful problem solving with a sense of urgency
• Experience in a version control system and code deployment system
• Experience with full Systems Development Life Cycle, Agile methodology is a plus
• Motivated and competent to contribute time and effort to work assigned
• Ability to communicate clearly and concisely, both orally and in writing
• Ability to organize, prioritize and execute tasks in a high-pressure environment as requested
• Ability to work effectively in a multi-cultural, team-oriented, collaborative environment
• Ability to travel globally

Preferred Qualifications

• Experience with Oracle Forms/Reports or application backend support
• Familiarity with Shell scripting or batch job automation
• Knowledge of data warehousing concepts
• Exposure to ETL tools (Informatica, ODI, etc.)
• Experience with Oracle SQL Developer, TOAD, or similar tools
• Understanding of backup, recovery, and RMAN basics
• Cloud exposure (Oracle Cloud / AWS RDS Oracle) is a plus

Soft Skills

• Strong analytical and problem-solving skills
• Ability to support multiple applications simultaneously
• Good communication and teamwork abilities
• High attention to data accuracy and detail

Experience

• 5+ years of Oracle PL/SQL development experience

At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment.We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.

Our Hyperlearning workplace is grounded upon four principles

• Flexible work arrangements, Free spirit, and emotional positivity
• Agile self-determination, trust, transparency, and open collaboration
• All Support needed for the realization of business goals,
• Stable employment with a great atmosphere and ethical corporate culture