• 24x7 Production database and applications support.• Installed, configured,upgrade and maintained Oracle 10g and 11gR2. • Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.• Restoration and Recovery of databases at the times of occurrence of critical failures.• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.• Performed… Show more • 24x7 Production database and applications support.• Installed, configured,upgrade and maintained Oracle 10g and 11gR2. • Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.• Restoration and Recovery of databases at the times of occurrence of critical failures.• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.• Performed block recovery using RMAN.• Moving data between databases using Data Pump.• Performed large batch jobs, and tuning of SQL queries and database systems.• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.• Partitioned large tables for better performance and manageability. • Installed and configured GoldenGate for replication.• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.• Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.• Written PL/SQL Stored Procedures, Packages, Functions and Triggers. • Worked with Data Pump to take the logical backups of databases.• Experienced in performing Point-in-Time Recovery.• Performed Capacity Planning and Bench Marking• Load and Transform data using SQL*Loader and External Tables• Logical and Physical Database Design• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference. • Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.Environment: Oracle 11g, Oracle 10g with RAC, SQL Server, Red Hat Linux, IBM AIX, ASM, OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump and SQL*Loader Show less

Responsibilities:• Installed, configured, and maintained Oracle 10g.• Upgraded databases from Oracle 9i, 10g.• Involved with installation and maintenance of ORACLE 10g RAC and Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.• Responsible for installing, upgrading, patching and configuring the Oracle environment.• Implemented Oracle database backup & recovery solutions using RMAN.• Extensive uses of Oracle Data pump Exports/Imports… Show more Responsibilities:• Installed, configured, and maintained Oracle 10g.• Upgraded databases from Oracle 9i, 10g.• Involved with installation and maintenance of ORACLE 10g RAC and Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.• Responsible for installing, upgrading, patching and configuring the Oracle environment.• Implemented Oracle database backup & recovery solutions using RMAN.• Extensive uses of Oracle Data pump Exports/Imports utility for moving data among the servers.• Performed large batch jobs, and tuning of SQL queries and database systems.• Created User accounts, Roles and granting required access permissions and privileges to the users.• Partitioning and re-organization of table and indexes. • Configured and implemented Oracle Streams.• Implemented downstream capture at the destination database using Oracle Streams.• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.• Written scripts for the automation of backups and cloning• Written PL/SQL Stored Procedures, Packages, Functions and Triggers. • Used Data pump to take the logical backups of databases. • Involved in designing logical and physical data models using Erwin. • Migrated databases from Windows to Linux and IBM AIX.Environment: Oracle 10g with RAC, SQL Server, Red Hat Linux, IBM AIX, ASM, OEM (Grid Control), RMAN, Explain Plan, Data Pump, SQL*Loader, AWR, ADDM Show less

Responsibilities:• Provided 24X7 support to client for all the production and development databases.• Installed and configured Oracle 10g.• Performed upgrades from Oracle 9i to 10g. • Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.• Applied Oracle Applications and database patches.• Cloned/Refreshed Oracle Databases and… Show more Responsibilities:• Provided 24X7 support to client for all the production and development databases.• Installed and configured Oracle 10g.• Performed upgrades from Oracle 9i to 10g. • Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.• Applied Oracle Applications and database patches.• Cloned/Refreshed Oracle Databases and Oracle Applications.• Responsible for optimizing the queries and application tuning. • Perform SQL tuning and assist developers with coding PL/SQL.• Installed and Implemented Backup & Recovery procedures. • Implement Hot, Cold and Logical backup plans.• Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.• Defining and Implementation of backup and recovery strategies. • Train other regular DBA activities including space management and performance monitoring.• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters and Oracle Standby Servers.Environment: Oracle 9i Oracle 8i, Oracle 7.3, SQL Server 2000, Red Hat Linux, ASM,OEM (Grid Control), IBM AIX, RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader. Show less

Responsibilities• Designed and Implemented a Database System that handles NICON Inventory System• Installation and administration of Oracle 8.x Database using different administration tools.• Perform Oracle Database and Dev 2000 maintenance and installation tasks. • Worked as a team member in establishing training center in Lahore.• Handle technical student’s problems regarding Database Administration, Dev 6,6i and O/S. • Teaching Oracle 8i & 9i DBA Tracks and Developer… Show more Responsibilities• Designed and Implemented a Database System that handles NICON Inventory System• Installation and administration of Oracle 8.x Database using different administration tools.• Perform Oracle Database and Dev 2000 maintenance and installation tasks. • Worked as a team member in establishing training center in Lahore.• Handle technical student’s problems regarding Database Administration, Dev 6,6i and O/S. • Teaching Oracle 8i & 9i DBA Tracks and Developer Tracks. Show less