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