PL SQL Developer 5-7 Years

Zensar Technologies; Pune District; On-site; INR 1,000,000 - 1,800,000; Full time

Job summary

Zensar Technologies Pune is seeking an experienced PL/SQL Developer with 5-7 years of Oracle database development expertise. You will design, develop, and optimize PL/SQL code, work on performance tuning, and collaborate with application teams to deliver scalable data solutions.

Responsibilities include maintenance of complex database objects, data migrations, and automation scripts. Familiarity with GitHub and AQS is required; Perl scripting is a plus.

Qualifications

• 5-7 years of experience in Oracle Database Development.
• Strong expertise in PL/SQL programming, SQL, and database objects.
• Experience with performance tuning and debugging of queries.

Responsibilities

• Design, develop, test, and maintain PL/SQL packages, procedures, functions, triggers, and database objects.
• Translate business requirements into scalable database solutions.
• Tune queries and optimize performance with indexing strategies.
• Support production incidents and troubleshoot database issues.
• Develop data migration, validation, and automation scripts.
• Collaborate with developers, QA, and stakeholders throughout SDLC.
• Participate in code reviews and enforce standards.
• Work with GitHub for source control, branching, merging, and releases.
• Develop or maintain Perl scripts for automation and batch processing.

Skills

PL/SQL

Oracle SQL

Stored Procedures

Functions

Packages

Triggers

Performance Tuning

Query Optimization

Unix/Linux

Shell Scripting

GitHub

AQS

Perl scripting

Education

Bachelor's degree in Computer Science, Information Technology, or a related field

Tools

GitHub

Job description

Job Description:

We are seeking an experienced PL/SQL Developer with 5-7 years of hands-on experience in Oracle database development. The ideal candidate should have strong expertise in PL/SQL programming, database performance tuning, and troubleshooting. Experience with Perl scripting is highly desirable. Familiarity with GitHub version control and AQS (Automated Quality Systems/Assurance Quality Solutions, as applicable) is required.

Responsibilities

Key Responsibilities

• Design, develop, test, and maintain complex PL/SQL packages, procedures, functions, triggers, and database objects.
• Analyze business requirements and translate them into scalable database solutions.
• Optimize SQL queries and database performance through tuning and indexing strategies.
• Support production incidents, troubleshoot database-related issues, and implement fixes.
• Develop and maintain data migration, validation, and automation scripts.
• Collaborate with application developers, QA teams, and business stakeholders throughout the SDLC.
• Participate in code reviews and ensure adherence to development standards and best practices.
• Work with GitHub repositories for source code management, branching, merging, and release activities.
• Develop or maintain Perl scripts for automation, batch processing, and operational support (good to have).
• Ensure proper documentation of technical designs, code changes, and deployment procedures.

Qualifications

Required Skills & Qualifications

Technical Skills

• 5-7 years of experience in Oracle Database Development.
• Strong expertise in:
• Oracle SQL
• PL/SQL
• Stored Procedures
• Functions
• Packages
• Triggers
• Performance Tuning
• Query Optimization
• Experience in database design, data modeling, and ETL processes.
• Hands-on experience with GitHub, including branching strategies and pull request workflows.
• Working knowledge of AQS and quality assurance processes.
• Understanding of Unix/Linux environments and shell scripting.
• Experience in troubleshooting and resolving production issues.

Good to Have

• Knowledge of Perl scripting for automation and batch processing.
• Exposure to DevOps practices and CI/CD pipelines.
• Experience working in Agile/Scrum environments.
• Knowledge of API integrations and data exchange mechanisms.

Preferred Qualifications

• Bachelors degree in Computer Science, Information Technology, or a related field.
• Oracle certification is a plus.
• Strong analytical, problem-solving, and debugging skills.
• Excellent communication and stakeholder management skills.

Key Competencies

• Strong ownership and accountability.
• Ability to work independently with minimal supervision.
• Attention to detail and quality-oriented mindset.
• Strong collaboration and teamwork skills.
• Ability to manage multiple priorities in a fast-paced environment.

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.

Requirements: