Walk-in | PLSQL Developer

Optimum Solutions; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Optimum Solutions in Chennai is seeking an experienced PL/SQL Developer with 7+ years of hands-on Oracle SQL/PL/SQL expertise. The role focuses on tax processing applications, high-volume banking systems, and secure data management across environments.

The candidate will design schemas, optimize SQL, and ensure robust database security and performance. Hybrid work mode and willingness for face-to-face discussions are required.

Qualifications

• 7+ years of experience in PL/SQL development.
• Experience with Oracle SQL/PL/SQL development and high-volume systems.
• Proven expertise in database design, performance tuning and security.

Responsibilities

• Develop complex SQL and PL/SQL code based on business requirements.
• Design schemas, tables, indexes, sequences, constraints, functions and procedures.
• Design and implement database models and data flows for banking apps.
• Perform SQL optimization and database performance tuning.
• Maintain database security including users, roles and privileges.
• Ensure data anonymization and secure handling across environments.
• Manage databases across development, testing, pre-production and production.
• Contribute to technical analysis, design reviews and code reviews.
• Develop, test and debug database applications.
• Support integration testing, UAT and production deployment.
• Prepare technical specifications and documentation.
• Collaborate with onsite/offshore teams and cross-functional tech teams.
• Mentor developers and promote coding standards.
• Follow Agile/SDLC practices.

Skills

Oracle SQL/PLSQL

Oracle DB development

SQL Query Development

Performance Tuning

Stored Procedures & Packages

Data Modeling

Security & Privileges

Data Anonymization

SDLC/Agile

Data Flows & ER Diagrams

Job description

We are looking for PL SQL Developer with 7+ years of experience for Chennai location. Need candidates who are willing to take F2F Discussion on 20th Aug(Thursday) and can join with 1 week.

Job Title: PLSQL Developer
Experience: 7-11 Years
Location: Chennai

Work Mode: Hybrid

Job Summary

We are looking for an experienced PLSQL Developer / Oracle Developer with 9+ years of hands‑on experience in Oracle SQL and PL/SQL development. The candidate will be responsible for developing and maintaining tax processing applications, database solutions, technical migration projects and high-volume banking applications.

The role requires strong expertise in Oracle database development, database design, performance tuning, debugging, security and data management.

Key Responsibilities

• Develop complex SQL and PL/SQL code based on business requirements.
• Design and develop schemas, tables, indexes, sequences, constraints, functions, procedures, packages and collections.
• Design and implement database models and data flows.
• Perform SQL optimization, database performance tuning and debugging.
• Conduct capacity analysis and proactively resolve database performance issues.
• Implement and maintain database security, including users, roles and privileges.
• Perform data anonymization and maintain secure data across development and testing environments.
• Manage databases across Development, Testing, Pre-Production and Production environments.
• Perform technical analysis, impact assessment, design reviews and code reviews.
• Develop, unit test and debug database applications.
• Support integration testing, UAT and production implementation.
• Fix defects and optimize application/database performance.
• Prepare technical specifications and maintain technical documentation.
• Collaborate with onsite/offshore teams and cross-functional technology teams.
• Mentor developers and conduct peer reviews.
• Promote database development best practices and coding standards.
• Participate in Agile/iterative SDLC activities.

Mandatory Skills

• Oracle SQL / PL/SQL
• 9+ years of Oracle Database development
• Database Design & Data Modelling
• SQL Query Development & Optimization
• Oracle Performance Tuning & Debugging
• Stored Procedures, Functions & Packages
• Tables, Indexes, Sequences & Constraints
• Collections
• Users, Roles & Privileges
• Database Security
• Data Anonymization
• ER Diagrams & Data Flows
• SDLC / Agile methodology