30 Sep
|
Infosys
|
Bengaluru
Job Description:
- Role Overview
- We are seeking an experienced Oracle PL SQL Lead with 5 9 years of expertise in Oracle database development performance tuning and team leadership
- The ideal candidate will be responsible for designing and developing complex database solutions leading a team of developers optimizing database performance and ensuring the successful delivery of enterprise data driven applications
Key Responsibilities:
- Key Responsibilities
- Lead the design development and maintenance of Oracle PL SQL programs including packages procedures functions triggers views and complex SQL queries
- Analyze business requirements and translate them into efficient database solutions
- Review code and ensure adherence to database development standards and best practices
- Optimize SQL queries and PL SQL programs for performance scalability and reliability
- Lead data migration data integration and database enhancement initiatives
- Collaborate with application development teams architects business analysts and stakeholders to deliver robust database solutions
- Troubleshoot and resolve complex database and performance related issues
- Mentor junior developers and provide technical guidance across projects
- Participate in release planning deployment support and production issue resolution
- Ensure data integrity security and compliance with organizational standards
- Required Skills
- 5 9 years of hands on experience in Oracle Database and PL SQL Development
- Strong expertise in SQL PL SQL Packages Procedures Functions Triggers Views Collections Cursors and Exception Handling
- Experience in writing and optimizing complex SQL queries and stored programs
- Strong knowledge of Performance Tuning Query Optimization Execution Plans Indexing and Database Monitoring
- Experience with Oracle SQL Developer TOAD or similar database development tools
- Valuable understanding of Database Design Data Modeling Normalization and Data Warehousing Concepts
- Experience in handling large volume databases and transactional applications
- Exposure to Unix Linux environments and Shell scripting
- Familiarity with version control systems such as Git and Agile development methodologies
- Strong analytical problem solving and communication skills
Technical Requirements:
- Primary skills Technology Oracle PL SQL
Preferred Skills:
Technology->Oracle->PL/SQL
Skills: Performance Tuning, Agile Development Methodologies, Data Modeling, Git, Triggers, Database Design, Functions, Data Warehousing Concepts, Exception Handling, Views, Query Optimization, Cursors, Pl Sql Packages, Database Monitoring, Sql, oracle sql developer , Normalization, Collections, Procedures, Indexing, Oracle Pl Sql, Shell Scripting, Linux, Unix, Toad
Experience: 0.00-0.00 Years
📌 Oracle PLSQL Lead (Bengaluru)
🏢 Infosys
📍 Bengaluru