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 Qualified (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

📌 Senior Oracle PL/SQL Developer (Pune)
🏢 TalentOne HR Consulting
📍 Pune