Senior Oracle PL/SQL Developer

Talentone HR Consulting LLP

  • Pune, Maharashtra
  • Permanent
  • Full-time
  • 2 months ago
  • 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 DetailsMinimum 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

Talentone HR Consulting LLP