We are seeking a highly experienced and detail-oriented Senior PL/SQL Developer to join our application development team. The ideal candidate will have a strong background in Oracle database technologies and PL/SQL development, with a passion for writing efficient, maintainable code. This individual will work on designing, developing, and maintaining database solutions that support business applications in a fast-paced environment.
Key Responsibilities
- Design, develop, and maintain PL/SQL code including stored procedures, functions, packages, triggers, and views
- Perform database modeling, table creation/modification, and index management
- Analyze and optimize existing PL/SQL code and database queries for performance
- Utilize tools such as EXPLAIN PLAN and TKPROF to identify and resolve performance issues
- Collaborate with application developers, business analysts, and QA teams to ensure high-quality deliverables
- Participate in code reviews and adhere to development best practices and standards
- Provide production support and troubleshoot issues as needed
- Document database structures, processes, and procedures.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or a related technical field.
- Minimum of 8 years of relevant experience in software/database development
- At least 5 years of experience with Oracle PL/SQL development
- Strong understanding of Oracle database platforms (versions 9i, 10g, 11g)
- Proficient in writing and debugging complex PL/SQL code
- Experience in performance tuning and database optimization techniques
- Familiarity with SQL tuning tools and diagnostics (e.g., EXPLAIN PLAN, TKPROF)
- Exposure to Unix/Linux environments and shell scripting is a plus
- Excellent analytical, problem-solving, and communication skills