Database Manager
Virtual Remittance Gateway PVT Ltd
Total years of experience :16 years, 7 Months
• Controlling access to the database by setting appropriate roles managing ACL.
• Controlling data security, including preventing unauthorized access to the data and protecting against other security threats.
• Monitoring, Tuning and ensuring that the database is running to optimal levels
• Direct the Backup and Recovery strategy of the group to ensure that disaster recovery, business continuity and protection of critical data service level agreements are both met as well as improved.
• Installation and configure new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
• Design and implement DR solutions
• Design and implement 12c RAC and Data-guard over RAC solutions.
• Help create documentation of every aspect of Database Management Systems including hardware configuration and maintenance records.
• Prepare the roadmap and implementation plan for the migration and upgrade of current RDBMS version.
• Create UAT Environment for development and testing purpose.
• Configure and schedule database job and auto alerts and notification.
• Adhere to all BCP & DRP roles including Supporting ITSM Services, RCA support to DAS Team, Driving the end to end recovery of systems and effective maintenance of RTO
• Engage and drive support services from associated product vendors and effective maintain and mange inward and outward SLA
* 24x7 remote support and on call Database support
* Upgrade and migration of databases from 10g, 11g to 12c (12.1.0.2) and Oracle E-Business Suite R12 12.1.3 to 12.2.5.
* Provide real-time monitoring of Oracle E-Business Suite R12 (12.1.3), Oracle databases, Oracle Database 10g Red Hat Linux (REHL) 6 and Widnows servers. With 12 C currently in development.
* Documenting major changes to the database Servers and resolving incidents.
* Apply Oracle quarterly patches of the current patch set update (PSU) version and critical patch update (CPU) to databases for bug fixes and security updates.
* Performance monitoring and tuning using a variety of tools and techniques for various database types and sizes.
* Implemented various backup strategies for critical and non-critical databases using RMAN Utility.
* Recover databases to a specific point in time, Using RMAN.
* Monitor and tune the Database at the physical and query level.
* Clone and refresh the databases and Applications from production to development and test environments
* Fixing critical database problems emerging during normal and abnormal operations
* Resizing and reorganization of database objects as part of database maintenance
* Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
* Using ADDM, Automatic Database Diagnostic Monitor and AWR (Automatic Workload Repository) monitoring of system performance, to ensure high levels of performance and availability.
* Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
* Data migration between databases using both Oracle 10g and 12C export/import utility and Oracle 12C exp/imp data pump.
* Scheduled daily Exports/Imports Full backups.
* Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
* Oracle Table partitioning.
* Query Optimizing .
* Maintaining Oracle Application R12 and Activities.
* Monitoring the Oracle Apps R12, 11g Database environments Provide application knowledge in evaluating and improving current business processes Applying patches from Oracle to the instance to resolve application issues.
* Follow up with Oracle Product support through metalink for any issues those functional consultant raises, which require files, system log files.
* Making Sure that scheduled Backup jobs of an instance is going fine.
* Maintaining the Oracle Application using Auto Patch, Adadmin, Adcontroller, Autoconfig, Rapid clone, Adrelink and application utilities.
* Cloning the instances production to Test, Development instance to test, coordinate with testing and development teams.
* Participate in a Team to maintain & support for oracle databases and applications in high availability.
* Generating Statspack report and running tkprof to analyze performance related issues.
* Performance database Health checkups Troubleshooting concurrent Manager issues and Workflow mailer issues.
* Performed system administration activities like creating users, Assigning Responibilities, defining Menus, creating concurrent managers, configure workflow mailer services after refresh.
* Maintaining Oracle APplication R12 and Activities.
* Monitoring the Oracle Apps R12, 11g Database environments Provide application
* Maintaining the Oracle Application using Auto Patch, Adadmin, Adcontroller, Autoconfig, Rapid clone, Ad relink and applciation utilities.
* Cloning the instances production to Test, Development instance to test, coordinate with testing and development teams.
* Participate in a Team to maintain & support for oracle databases and applications in high availability.
* Performnace database Health checkups Troubleshooting concurrent Manager issues and Workflow mailer issues.
* Managing Users, Responsibilities, Menus and Profile options.
* Maintaining Application Security and Database Security.
* Installation and configured Oracle 11g Fusion Middleware Forms and reports.
* Provide technical support to development team in upgrading Oracle Forms & reports 10g to Oracle 11g Fusion Middleware Forms and reports.
* Working with the Development Team to fix the problems in Database and Applications.
* Create and Follow up Service Requests with Oracle Support for Technical Support.
Client:- MN TEXTILE
Role: Oracle Database Administrator
* Provide suppport Oracle Application 12.1.3 and Oracle Database 11g
* Maintaining Oracle APplication R12 and Activities.
* Monitoring the Oracle Apps R12, 11g Database environments Provide application knowledge in evaluating and improving current business processes Applying patches from Oracle to the instance to resolve application issues.
* Follow up with Oracle Product support through matalink for any issues those functional consultant raises.
* Maintaining the Oracle Application using Auto Patch, Adadmin, Adcontroller, Autoconfig, Rapid clone, Ad relink and application utilities.
* Cloning the instances production to Test, Development instance to test, coordinate with testing and development teams.
* Performed system administration activities like creating users, Assigning Responibilities, defining Menus, creating concurrent managers, configure workflow mailer services after refresh.
* Performance tuning.
Client:- SILK BANK.
Role: Oracle Database Administrator
* Provide suppport Oracle Application 12.1.3 and Oracle Database 11g
* Maintaining Oracle APplication R12 and Activities.
* Monitoring the Oracle Apps R12, 11g Database environments Provide application knowledge in evaluating and improving current business processes Applying patches from Oracle to the instance to resolve application issues.
* Follow up with Oracle Product support through matalink for any issues those functional consultant raises.
* Maintaining the Oracle Application using Auto Patch, Adadmin, Adcontroller, Autoconfig, Rapid clone, Ad relink and application utilities.
* Cloning the instances production to Test, Development instance to test, coordinate with testing and development teams.
* Performed system administration activities like creating users, Assigning Responibilities, defining Menus, creating concurrent managers, configure workflow mailer services after refresh.
* Performance tuning.
Client:- GREEN STAR SOCIAL MARKETING PVT LTD.
Role: Oracle Database Administrator
* Provide suppport Oracle Application 11i and Oracle Database 10g On Windows Server.
* PlateForm Migration of Oracle Database 10g and Oracle Application 11i from Windows server to Oracle Linux 5.
* Maintaining Oracle APplication R11i and Activities.
* Monitoring the Oracle Apps 11i, 11g Database environments Provide application knowledge in evaluating and improving current business processes Applying patches from Oracle to the instance to resolve application issues.
* Follow up with Oracle Product support through matalink for any issues those functional consultant raises.
* Maintaining the Oracle Application using Auto Patch, Adadmin, Adcontroller, Autoconfig, Rapid clone, Ad relink and application utilities.
* Cloning the instances production to Test, Development instance to test, coordinate with testing and development teams.
* Performed system administration activities like creating users, Assigning Responibilities, defining Menus, creating concurrent managers, configure workflow mailer services after refresh.
* Performance tuning.
Client:- MULLER & PHIPPS PVT LTD..
Role: Oracle Database Administrator
* Provide suppport Oracle Application 12.1.3 and Oracle Database 11g
* Maintaining Oracle APplication R12 and Activities.
* Monitoring the Oracle Apps R12, 11g Database environments Provide application knowledge in evaluating and improving current business processes Applying patches from Oracle to the instance to resolve application issues.
* Follow up with Oracle Product support through matalink for any issues those functional consultant raises.
* Maintaining the Oracle Application using Auto Patch, Adadmin, Adcontroller, Autoconfig, Rapid clone, Ad relink and application utilities.
* Cloning the instances production to Test, Development instance to test, coordinate with testing and development teams.
* Maintaining Oracle Application R12 and Activities.
* Monitoring the Oracle Apps R12, 11g Database environments Provide application
* Built development, test and production instances of R12.
* Automated hot backups using full RMAN backup
* Applying Patches on Production and Test environment using (Adpatch, admerge) utility.
* Applying Opatch on Oracle EBS R12 Database.
* Configured Oracle Data guard for Disaster Recovery.
* Performed switchover/Failover activity.
* Configure RMAN Backup on Production Instance.
* Configure Oracle Database 11g Gateway for connectivity of Oracle database to non-oracle Databases on PROD.
* Successfully Upgrade Oracle EBS R12 from 12.1.2 to 12.1.3.
* Upgrade Oracle EBS Database from 11.1.0.7 to 11.2.0.3.
* Upgrade Oracle application technology stack,
* iAS_Oracle_home from 10.1.3.0 to 10.1.3.5.
* Form/Reports from 10.1.2.3 to 10.1.2.3.
* Creating SR for technical Issue.
* Cloning the instances production to Test, Development instance to test, coordinate with testing and development teams.
* Performed Application administration like creating users, menus, responsibilities, etc.
* Performnace database Health checkups Troubleshooting concurrent Manager issues and Workflow mailer issues.
Client:- Dammam University (Dammam, KSA)
Project:- Peoplesoft Campus Solution
Role: Oracle Database Administrator
* Cloning PeopleSoft Applications (Single & Multimode)
* Applying Patches (Database & Application)
* Create and Follow up Service Requests with Oracle Support for Technical Support
* Working with the Development Team to fix the problems in Applications
* Monitoring Health Check of servers by background process and by using OAM
* Maintaining Application Security and Database Security
* Managing Users, Responsibilities and Profile options
* Oracle Database 11g:
* Backup and Recovery Processes (RMAN)
* Tuning Oracle Database Space Management (table space, undo segment).
Client:- AL-ABBAS GROUP (PVT) LTD.
Project:- Oracle E-Business Suite R12 Financial, Supplye chain, Order Management
Role: Oracle Database Administrator
* Maintaining Oracle APplication R12 and Activities.
* Monitoring the Oracle Apps R12, 11g Database environments Provide application knowledge in evaluating and improving current business processes Applying pathes from Oracle to the instance to resolve application issues.
* Follow up with Oracle Product support through matalink for any issues those functional consultant raises, which require files, system log files.
* Making Sure that scheduled Backup jobs of an intance is going fine.
* Maintaining the Oracle Application using Auto Patch, Adadmin, Adcontroller, Autoconfig, Rapid clone, Ad relink and applciation utilities.
* Cloning Oracle Applications using with Rapid Clone (Single & Multinode)
* Applying Patches ( Database & Application )
* Create and Follow up Service Requests with Oracle Support for Technical Support
* Working with the Development Team to fix the problems in Applications
* Monitoring Health Check of servers by background process and by using OAM
* Maintaining Application Security and Database Security
* Managing Users, Responsibilities and Profile options
Oracle Database 10g :
* Backup and Recovery Processes (RMAN)
* Tuning Oracle Database
* Space Management (table space, undo segment), Monitoring (alert log, memory, CPU)
I Have done bachelor of Computers Information Technology From Private institute affiliated with University of Sindh Jamshoro, Pakistan with 2.63 GPA in 2003 .