PL/SQL Developer

Responsibilities :-

• Designing databases and ensuring their stability, reliability, and performance.
• Design, create, and implement database systems based on the end user's requirements.
• Improve application's performances.
• Prepare documentations for database applications.
• Memory management for database systems.
• Develop database schemas, tables and dictionaries.
• Ensure the data quality and integrity in databases.
• Fix any issues related to database performance and provide corrective measures.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Provide authentication and authorizations for Database
• Develop best practices for database design and development activities.

Technical Skills :-

• Solid experience in writing SQL queries and PL/SQL programming.
• Implementation of Stored Procedures, Functions and Packages.
• Good Knowledge in writing Cursors, Triggers.
• Experienced in using Tables, Synonyms, Sequences, Joins and Sub Queries, Analytical Functions.
• Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
• Experience in implementation of backup and recovery strategies.
• Having good Knowledge in Bulk Loading, Exception Handling, Dynamic SQL, Ref-Cursors.
• Working with collections and Records& reports.
• Basic knowledge in UNIX.
• Having working experience on MySQL.
• Experience in Data migration using import and export.
• Development of high quality database solutions
• Provide timely scheduled management reporting