PLSQL Developer

Key Skills: Oracle SQL, PostgreSQL, PL/SQL, Stored Procedures, Performance Tuning, Unix Shell Scripting, Agile Scrum, Schema Design, Data Quality, DB Documentation

Roles & Responsibilities:

• Good hands-on experience in Oracle SQL, PostgreSQL & PL/SQL and strong experience in writing complex Stored Procedures, Packages, Functions, and Triggers.
• Experience in handling large volume of data, along with good knowledge of cursors and advanced bulk collection concepts.
• Good experience in writing SQL queries, with knowledge of performance tuning, ensuring the stability, reliability, and performance of the DB.
• Good knowledge in creating and managing database schemas and schema objects like tables, indexes, partitions, and dictionaries.
• Prepare documentations for database applications.
• Fix any issues related to database performance and provide corrective measures.
• Develop best practices for database design and development activities.
• Good analytical skills and ability to work independently.
• Knowledge of agile scrum methodology.
• Strong Unix development and shell scripting skills.
• Ensure the data quality and integrity in databases.

Experience Requirement:

• 6-12 experience in Oracle SQL, PostgreSQL & PL/SQL development.
• Hands-on experience in creating and optimizing database components such as stored procedures, packages, functions, and triggers.
• Strong exposure to working with large datasets and using advanced performance tuning techniques.
• Experience in schema design and Unix shell scripting.
• Exposure to Agile Scrum practices and ability to work independently with minimal supervision.

Education: Any Post Graduation, Any Graduation