Manager I.T Group Database
Yousuf Group of Companies
Role Tools & Technologies Database Installation, Creation, Manage security, profile and user accounts, RMAN, Data Guard, Export, Import, Migration, Upgrade, Replication, Performance and Tuning, Troubleshooting, Oracle Database 10g, 11g,(ASM), TOAD, SQLPLUS, ENTERPRISE MANAGER, CuteFTP. Maintenance Oracle servers(9i, 10g, 11g) with high availability production multi-tier environment with RAC & Cluster Oracle8i(8.1. 7.4), Oracle9i(9.2. 0.8), Oracle10g, 11g Operating Systems Sun Solaris, Linux, Unix, Windows 2000/2003 server, Windows XP Installation, Troubleshooting, Monitoring, Backup and Recovery, Performance Tuning and Coordinate with the Application developer's team with 10+ different physical locations. Oracle Developer 6i/9i Forms & Reports installation and connectivity issues to the Database. I am Monitoring Real Time Replication with 6 different Physical locations all around Pakistan. Take decisions with coordination of higher management in critical situation. Coordination and correspondence with Oracle Corporation(USA, INDIA) during any critical situation to resolve errors & bugs. Created Package to find out the replication data errors between locations and then synchronize the all location to master location. Managed database issues like Managing and configuring files of a database(Table spaces and Data files), managing schema objects(tables, indexes), managing rollback segments, managing users by assigning them privileges through roles, and quotas, performing daily Hot backups and export backups through batch system, Securing database access through Privilege, Role and Resource Management, Monitoring the performance of the database, tuning the database when required(like EXPLAIN PLAN, Tuning Memory, Monitoring locks and latches on system resources.) Convert a legacy software data into the Oracle 8i database.