Oracle PLSQL Developer

Infosys; Bengaluru; In loco; INR 650.000 - 1.000.000; Tempo pieno

Descrizione del lavoro

Infosys in Bengaluru is seeking an Oracle PL/SQL Developer with 2-3 years of hands-on experience to design, develop, and optimize PL/SQL programs and SQL queries. You will work with development and QA teams to ensure reliable data services and performance.

The role involves data modeling, debugging, and contributing to deployment readiness in an enterprise environment, with a focus on security and efficiency.

Competenze

• 2-3 years of hands-on Oracle Database and PL/SQL development experience.
• Strong knowledge of SQL, PL/SQL, stored procedures, functions and packages.
• Experience with debugging, tuning, and performance optimization of PL/SQL code.

Mansioni

• Develop, test, and maintain Oracle PL/SQL programs, packages, procedures, functions, triggers, and views.
• Write and optimize complex SQL queries for data retrieval, reporting, and support.
• Design, develop, and model data; troubleshoot issues and ensure availability and security.
• Support data migration, integration, and ETL processes; participate in code reviews.

Conoscenze

Oracle

PL/SQL

SQL

Performance tuning

Formazione

Bachelor's Degree in Engineering or equivalent

MCA/M.Tech / M.Sc or equivalent (preferred)

Strumenti

SQL Developer

TOAD

Descrizione del lavoro

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

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

Key Responsibilities Develop, test, and maintain Oracle PL/SQL programs, packages, procedures, functions, triggers, and views. Write and optimize complex SQL queries for data retrieval, reporting, and application support. Perform database design, development, and data modeling activities. Analyze and troubleshoot database-related issues and provide timely resolutions. Support data migration, data integration, and ETL processes. Ensure database performance, integrity, security, and availability. Participate in code reviews and adhere to database development standards and best practices. Collaborate with application developers, business analysts, and QA teams during development and testing phases. Prepare technical documentation and support deployment activities.

Required Skills 2-3 years of hands-on experience in Oracle Database and PL/SQL Development. Strong knowledge of SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, Views, and Cursors. Experience in writing complex queries and performance optimization techniques. Understanding of database normalization, indexing, and data modeling concepts. Familiarity with Oracle development tools such as SQL Developer, TOAD, or equivalent. Experience in debugging, troubleshooting, and performance tuning of PL/SQL code. Knowledge of database security principles and data management practices. Good understanding of software development lifecycle (SDLC) and Agile methodologies.

Educational Qualification Bachelor's Degree: B.E / B.Tech or equivalent Master's Degree: MCA / M.Tech / M.Sc or equivalent (preferred) The ideal candidate will possess strong Oracle PL/SQL development skills, a passion for database technologies, and the ability to deliver reliable, high-performance database solutions in a fast-paced enterprise environment.