An experienced IT professional with database skills across Oracle Database Management System. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products.
Currently working in a demanding production support environment managing large volumes of business critical data. A committed team player, self motivated with the ability to communicate at all levels.
Presently looking for a suitable database administrator position with a responsible company.
Experience on ERP system at Master Beverages & Foods Ltd.
Daily Database server and Application server backup .
Recovery by Rman
Forms Development for ERP system
Reports Development as per Requirement.
- To monitor the performance, reporting and tuning of Oracle Databases
-To design database packages and procedures
- Creation and maintenance of SQL queries and routines
- Develop Oracle reports, database procedures
- Modify existing codes to optimize Oracle applications.
- Development of database / software applications that will supply the information necessary to satisfy the requirements of users throughout the organization.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Ensure performance, security, and availability of databases
-Proficient in Complex PL/SQL code
- Oracle ODBC (Excel to Oracle connectivity)
- Database structure design for Tables, views, sequences, synonyms and database triggers.
-Support and troubleshooting of the existing developed applications (Forms, Reports and Interfaces).
- Forms to Import/Export, Drop/Create Users
-Forms to Run Multiple Reports on One-Click for Multiple Schemas
-Backup and recovery By RMAN.
-Design and develop Data base, Create Tables, Views, Indexes and Sequences.
-Enforce data integrity using integrity constraint and database triggers. Well versed with RDBS concepts
- Data Guard
-Networking
- Multiplexing
- Disaster Recovery
- Installing and configuring computer hardware operating systems and applications.
- Monitoring and maintaining computer systems and networks.
- Talking staff or clients through a series of actions, either face-to-face or over the telephone, to help set up systems or resolve issues.
- Troubleshooting system and network problems and diagnosing and solving hardware or software