First Career Centre
Recruitment Specialists
About
Sectors
Services
Process
Contact
Job Openings
POST : PL/SQL Oracle Developer
Back
Apply
LOCATION : Chennai
TECH STACK :PL/SQL Oracle Developer
REQ EXPERIENCE :4 years
JD :
Job Summary We are looking for an experienced PL/SQL Oracle Developer with strong hands-on experience in Oracle database development, PL/SQL programming, query optimization, and database performance tuning. The candidate will be responsible for developing, maintaining, and enhancing database solutions based on business requirements. Key Responsibilities Develop, maintain, and optimize Oracle PL/SQL programs, procedures, functions, packages, and triggers. Write complex SQL queries and optimize them for performance. Design and maintain database objects including tables, views, indexes, sequences, and constraints. Analyze business and technical requirements and translate them into efficient database solutions. Perform database performance tuning and troubleshoot SQL/PLSQL-related issues. Develop and maintain stored procedures, functions, packages, and database scripts. Perform data migration, data validation, and reconciliation activities as required. Debug and resolve production issues related to database applications. Collaborate with application developers, business analysts, QA teams, and other stakeholders. Participate in code reviews and ensure adherence to development standards. Prepare technical documentation for database solutions and processes. Support application releases, deployments, and production activities. Required Skills 4+ years of hands-on experience in Oracle PL/SQL Development. Strong expertise in SQL and PL/SQL programming. Good knowledge of Oracle database architecture and database objects. Experience with stored procedures, functions, packages, triggers, cursors, and collections. Strong understanding of query optimization and performance tuning. Experience with complex joins, subqueries, analytical functions, and indexing. Good debugging and problem-solving skills. Experience in handling production support and issue resolution. Knowledge of Unix/Linux shell scripting will be an added advantage. Good communication and teamwork skills.
Apply Here