Professional Resume References 

Project Description: Ramco Systems Limited is a global provider of Enterprise solutions and various Information Technology Services. The project involved in developing complex queries using SQL and PL/SQL and later assigned the job of a DBA for backup/recovery and performance tuning.

Responsibilities:

• Designed the user interfaces for the entire workshop management module which deals with the customer service. It comprises of issuing gate pass, service booking, cost estimation, job creation and billing. Developed Stored Procedures, Triggers and Packages to validate the data.
• Performed database data modeling using CA-ERwin as a data modeling tool.
• Extensively worked on the backup/ recovery of the database on a daily basis using RMAN.
• Loaded/ Unloaded data from/ to the external flat files to/ from database using SQL*LOADER.
• Performed Export/Import of database objects, schemas using Export/Import utilities.
• Implemented Performance Tuning using UTLBSTAT and UTLESTAT.
• Developed database using Quest TOAD.
• Generated reports based on business requirements.
• Created and modified the different database objects suchas tables, indexes, sequences, functions, procedures, packages.
• Developed forms and reports using Oracle forms 4.5 and Oracle Reports 2.5 depending on the client requirements.
• Created SQL scripts for static data of Database.