Oracle PLSQL Lead

Infosys; Bengaluru; Vor Ort; INR 900.000 - 1.350.000; Vollzeit

Zusammenfassung

Infosys in Bengaluru seeks an experienced Oracle PL/SQL developer to lead development, optimization, and migration projects. You will design and maintain packages, procedures, functions, and triggers while ensuring data integrity and security across complex SQL environments.

Ideal candidates bring 5–9 years of hands-on Oracle database expertise, strong SQL/PL/SQL skills, and familiarity with Unix/Linux. You’ll mentor peers, collaborate with architects, and contribute to release planning and

Qualifikationen

• 5-9 years of hands-on Oracle Database and PL/SQL development.
• Strong SQL/PL/SQL knowledge, including packages, procedures, functions, triggers, views.
• Experience with performance tuning, execution plans, and indexing.
• Familiarity with Unix/Linux and shell scripting.
• Proficiency with Git and Agile development.

Aufgaben

• 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.

Kenntnisse

Oracle DB

PL/SQL

SQL

Performance Tuning

Data Modeling

Unix/Linux

Git & Agile

TOAD

SQL Developer

Tools

TOAD

SQL Developer

Jobbeschreibung

• Primary skills:Technology->Oracle->PL,SQL
  
• Primary skills:Technology->Oracle->PL,SQL
  

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. Good 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.