PLSQL Developer

Genfuse Tech; Bengaluru; On-site; INR 800,000 - 1,400,000; Full time

Benefits offered by this job

Onsite work from Bengaluru

Job summary

Genfuse Tech in Bengaluru is seeking an experienced PL/SQL Developer to join our data team onsite. You will develop, optimize, and maintain Oracle database applications, with a focus on complex PL/SQL procedures, packages, and data processing.

You will work with business and tech groups to translate requirements into efficient queries, perform design and performance tuning, and contribute to code reviews and production support.

Qualifications

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

Responsibilities

• Develop and maintain complex PL/SQL procedures, functions, packages, triggers, and cursors.
• Write and optimize SQL queries for high-performance applications.
• Perform database design, development, troubleshooting, and performance tuning.
• Analyze existing PL/SQL code and implement enhancements and fixes.
• Collaborate with business and technical teams to translate requirements into 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.

Skills

PL/SQL

SQL Query Optimization

Stored Procedures

Performance Tuning

Oracle Architecture

Debugging & Production Support

Analytical Thinking

Team Collaboration

Tools

Unix/Linux Shell

Git

ETL/Data Migration

Job description

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.