oracle
PL/SQL Developer (5-7 Years)
Zensar
IND
Mid · 5–7 years experience
Onsite
Discovered 4 weeks ago
linuxperlsql
Key Skills for This Role
linuxperlsql
Full Job Posting
Qualifications
- Required Skills & Qualifications
- 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
- 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.
- 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.
- Bachelor's 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.
- 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.
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
- Bachelor's 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.
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.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Zensar
Senior Vulnerability Specialist (Qualys VMDR & QGS Expert)
Bengaluru, IND
Senior
Discovered TodayView →
AI-Enabled Full Stack Developer 2
, IND
Discovered Today
Automation Playwright
Hyderabad, IND
Discovered Today
.NET Tech Lead
Hyderabad, IND
Discovered Today
Business Analyst
, IND
Discovered Today
Senior Vulnerability Specialist (Qualys VMDR & QGS Expert)
Bengaluru, IND
Discovered Today
ACCOUNTS RECEIVABLE
Pune, IND
Discovered Today
NB Java Nedbank 2
Pune, IND
Discovered Today
SDET (L7)
Pune, IND
Discovered Today