Senior Oracle PL/SQL Developer
10 Nos.
111053
Full Time
3.0 Year(s) To 6.0 Year(s)
10.00 LPA TO 15.00 LPA
IT Software - Project & Program Mgt / Other
IT-Software/Software Services
B.Tech/B.E. - Computers
Job Description:
- Proficiency in advanced PL/SQL scripting: stored procedures, functions, packages, triggers, and dynamic SQL.
- Ability to design modular PL/SQL code that is reusable, efficient, and optimized for performance and scalability.
- Experience in bulk data processing and using PL/SQL techniques such as BULK COLLECT and FORALL.
- Strong experience in designing normalized and optimized database schemas and understanding ER modeling.
- Expertise in data modeling tools and techniques, including creating and interpreting ER diagrams, defining relationships, and managing referential integrity.
- Ability to make design decisions that ensure scalability, maintainability, and performance.
- Expertise in optimizing SQL queries and PL/SQL code using advanced Oracle diagnostic tools.
- In-depth knowledge of indexing, partitioning, and query execution plans to improve database performance.
- Ability to analyze performance data and suggest enhancements to queries and overall database architecture.
- Experience in designing ETL processes for large-scale data migrations and data integration tasks.
- Strong collaboration skills with cross-functional teams, including business analysts, DBAs, and application developers.
- Advanced troubleshooting skills for diagnosing database issues, debugging complex PL/SQL scripts, and resolving performance problems.
- Familiarity with version control systems such as Git, SVN, or similar tools to track changes in PL/SQL code.
- In-depth knowledge of Oracle database security features, including role-based access control, encryption, and auditing
Experience Required
- 3-6 years of experience in Oracle PL/SQL development with a strong focus on database design, architecture, and performance tuning.
- Proven experience in designing complex database architectures for enterprise-level applications and working with large data volumes.
- Desirable - Oracle Certified Professional (OCP) or Oracle Certified Expert (OCE) in PL/SQL Development or Database Administration.
- Additional certifications related to cloud platforms (e.g., Oracle Cloud Infrastructure), data modeling, or database performance are a plus.
Education Details
Minimum B.E./B.Tech./MCA/M.Tech. or Four Years Graduate program in Computers/IT or equivalent from a recognized Institute/University on company's payroll
Key Skills :
Company Profile
A Large International Consulting Firm
Apply Now
- Interested candidates are requested to apply for this job.
- Recruiters will evaluate your candidature and will get in touch with you.