PLSQL Programmer

• Develop and Maintain PL/SQL Code: Design, develop, and maintain PL/SQL stored procedures, functions, packages, and triggers to meet business requirements.
• SQL Queries and Reports: Write efficient SQL queries to extract and manipulate data and ensure proper indexing and optimization.
• Performance Tuning: Optimize SQL and PL/SQL code for performance, including query optimization and indexing strategies.
• Database Design: Assist with database schema design, including creating tables, views, indexes, and relationships.
• Data Integration: Work with cross-functional teams to integrate databases with external systems and applications.
• Error Handling: Implement proper error handling and exception management in PL/SQL procedures.
• Testing and Debugging: Perform unit testing, debug PL/SQL code, and resolve issues related to database performance, functionality, and security.
• Documentation: Maintain accurate documentation for developed procedures, functions, and other code structures.
• Collaboration: Work closely with other developers, system administrators, and business analysts to ensure the overall success of database projects.

Required Skills:

• Proficiency in PL/SQL and Oracle Database systems.
• Strong SQL skills and experience with performance tuning.
• Familiarity with database design concepts and data modeling.
• Understanding of data manipulation, triggers, and stored procedures.
• Experience with version control tools (e.g., Git, SVN).
• Ability to troubleshoot and resolve database-related issues.
• Strong problem-solving skills and ability to optimize SQL queries for performance.

Qualifications:

• Bachelors and masters degree in computer application or a related field (or equivalent work experience).
• Knowledge and Experience with Oracle 12c or later.
• 0 2 years of experience.

Interested candidates can send their resumes to swetha.n@camsonline.com