Consultant - Oracle PL/SQL

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 hire Oracle 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