PLSQL Developer

Professional Summary
Oracle SQL/PLSQL Developer with experience in designing, developing, and maintaining database applications using Oracle SQL and PL/SQL. Skilled in database programming, performance tuning, data analysis, production support, and application enhancement within enterprise environments.

Roles & Responsibilities

• Develop, test, and maintain Oracle SQL queries, stored procedures, functions, packages, and triggers.
• Analyze business requirements and design efficient database solutions.
• Create complex SQL queries, views, and database objects to support application requirements.
• Optimize SQL queries and PL/SQL code for performance and scalability.
• Troubleshoot and resolve database-related issues, defects, and production incidents.
• Perform data analysis, data validation, and data migration activities.
• Develop and maintain database documentation, technical specifications, and code reviews.
• Work closely with application developers, business analysts, and QA teams throughout the SDLC.
• Ensure database security, data integrity, and adherence to coding standards.
• Participate in change request implementation, deployment, and production support activities.

Required Skills

• Oracle SQL
• Oracle PL/SQL
• Packages, Procedures, Functions, Triggers
• Cursors and Collections
• Query Optimization & Performance Tuning
• Data Modeling
• Exception Handling
• Oracle SQL Developer / TOAD
• Version Control (CVS/SVN/Git)
• Production Support & Bug Fixing

Preferred Skills

• Oracle Forms & Reports
• Jira / Agile Methodology
• Release & Deployment Processes
• Database Performance Monitoring