• Support for OFSA financial database warehouse
• Perform import/export of schemas / tables across various databases
• Installation and configuration of Oracle 11g on AIX p-series Server.
• Configuration & implementation of database & archive backup scripts on production servers
• Installation of Oracle 10g client on Windows machines
• Perform index-rebuilding for partitioned indexes.
• Perform segment reduction on tablepaces
• Reduce SGA size according to memory advisor and AWR recommendations.
• Design, test and implement backup and restore procedures on PRODUCTION server.
• Run routine health checks on UAT and production databases.
• Used Oracle STATSPACK utility to gather database statistics
• Ensure OS filesystems do not exceed critical thresholds
• Configuration of passive Dataguard on PRODUCTION server.
• Administration, monitoring and performance tuning of AIX & Linux Systems.
• Backup and recovery of live & backup server at Ziauddin Hospital.
• Installation of Oracle Business Intelligence on Linux.
• Installation of Oracle E-Business Suite on Linux AS 4.0
• Used ADPATCH to apply patch on PRODUCTION systems.
• Cloning of PRODUCTION & TEST instances.
• Responsible for cloning of PRODUCTION servers for backup purpose.
• Register reports on Oracle APPS
• Monitored and optimized the performance of the database, underlying SQL queries and recommended necessary changes.
• Carried out backup, recovery and restoration of database.
• Used Oracle Enterprise Manager to configure memory management, storage options, as well as using RMAN to carry out HOT and COLD backups.
• Implemented central database activities like: monitoring and tuning size of SGA/ Large Pool/Java Pool, multi-plexing the control file.
• Created reports using Oracle Report Builder & Crystal Reports.
• Prepared and designed flowcharts, entity-relationship diagrams, system flowcharts, User manuals & System Administrator manuals for project done in Oracle D2K and VB 6.0.