PLSQL Developer

Job highlights

• 4+ years experience in Oracle PL/SQL development with expertise in stored procedures, functions, packages, triggers, and SQL query optimization
• Develop, optimize, and maintain PL/SQL database applications; perform troubleshooting, performance tuning, data migration, and collaborate with teams to deliver solutions

Job Title: PL/SQL Developer
Location: Bangalore
Work Mode: Onsite
Experience: 48 Years
Employment Type: Full-Time

Job Description

We are looking for an experienced PL/SQL Developer to join our team in Bangalore. The candidate will be responsible for developing, optimizing, and maintaining Oracle database applications, stored procedures, packages, functions, and data processing solutions.

Key Responsibilities

• Develop and maintain complex PL/SQL procedures, functions, packages, triggers, and cursors.
• Write and optimize complex SQL queries for high-performance applications.
• Perform database design, development, troubleshooting, and performance tuning.
• Analyze existing PL/SQL code and implement enhancements and fixes.
• Work with business and technical teams to understand requirements and deliver database solutions.
• Perform data migration, transformation, and validation activities.
• Troubleshoot production issues and provide timely resolutions.
• Participate in code reviews, testing, deployment, and documentation.
• Follow coding standards and database development best practices.

Required Skills

• 4+ years of hands-on experience in Oracle PL/SQL Development.
• Strong knowledge of Oracle SQL and PL/SQL.
• Expertise in Stored Procedures, Functions, Packages, Triggers, Cursors, Collections.
• Strong experience with SQL query optimization and performance tuning.
• Good understanding of Oracle database architecture and data modeling.
• Experience with database debugging and production support.
• Good analytical and problem-solving skills.
• Strong communication and teamwork skills.

Good to Have

• Experience with Oracle 12c/19c.
• Knowledge of Unix/Linux shell scripting.
• Experience with ETL/data migration processes.
• Exposure to Java or any application development technology.
• Experience working in Agile environments.
• Knowledge of version control tools such as Git.

Candidate Profile

• Strong database development background.
• Ability to work independently in a fast-paced environment.
• Willingness to work onsite from Bangalore.