Hi all my dear ! i am software engineer, i have 7+ year Experience in ORACLE DATABASE ADMINISTRATOR ; Development , Strong command on ORACLE DATABASE. I can do every task related to Database and linux.
Currently i working as an ORACLE APPS DBA in MTBC Care Cloud US Based Comapany Pakistan.
I have alot of experience in ERPimplementation. I implemented ORACLE ERP in Kohat Textile Mill ltd (Saif group of companies).
Over the years thanks to my thirst for knowledge and experience, I have gained extensive experience in ORACLE Database Base Development and DBA from Multiple Software Companies.
Extensive experience in Database administration, performance tuning ,troubleshooting, debugging, installation on different environment ,Database security, Backup & Recovery, Creating & Managing Database Schemas and technical support using Oracle 10gR2,,11gR2 11g, 12c.
• Working on SQL, PL/SQL for executing DB scripts l, Stored Procedures, Functions and views, tables. etc.....
• Developing, Enhancing, Testing new and existing application using multiple development tools Oracle Forms and Reports (10g).
• Expertise in RDBMS tools.
Applying Patching on DBA and Application
Refresh Stage server
Cloning of Apps server
Backup management of local and non-premises Server(Installed on new jersey US)
Monitoring ORALCE Data Guard and all servers using OEM.
Providing services to all users.
· Oracle core and apps cloning, Disaster recovery.
· Apply patching to upgrade features and enhance security and fix issues.
· Implementation and managing of ORACLE Data guard.
· Implementing of ORACLE EBS ERP of HR/PAYROLL and customize Oracle ERP
· Implementation of ORACLE HR/Payroll E-business Suite 12.2
· Creating tablespace, users and roles for authorized users.
· Installation and maintenance of ORACLE WebLogic Server.
· Installation of MYSQL server, its management and link with form builder
· Take backup and check DB performance.
· Backup and recovery using RMAN
· Installation of Oracle database, RAC and ASM.
· Provide training to all users internally in Head quarter and out stations.
· Installation and configuration of CLI for cloud infrastructure on Linux platform.
· Verification and creating fast formula’s for Payroll module and given training to users.
· Implementation of HR/Payroll ERP.
· ORACLE cluster management and ware development.
· Data cleansing and verifying and then importing in ERP using API.
· Maintenance, surveillance, shared server, Router, Troubleshooting.
· Configuration of CLI after installation of CLI.
· Managing of ORACLE ICS and SOA.
· Use IDCS for cloud for identity management.
· Use ORACLE ADCS for support.
· Implementation of ORACLE cloud infrastructure
· Data migration to cloud.
· Installation of ORACLE 11g Database on server side.
· Give proper training for data entry to users on Organization policy base.
· Client-side installation of software for multiple users.
· Pooling data to Server and then given proper training to users.
· Assign forms and reports to users according on his working and designation.
· Maintenance and daily basis backup of ERP system using RMAN.
· Disaster Recovery of database.
· Creating multiple tablespaces, creating role for different users.
· Backup and recovery of ORACLE Database for data protect
· Installation of ORACLE ASM and data guard.
· Cloning of ORACLE Database after period of every four months.
· Implementation and configuration of Bio metric machine's
I COMPLETED ORACLE DBA TUITION FROM TECHNO-ED and THEN CERTIFIED AS A DBA FROM ORACLE UNIVERSITY and STILL NOW I WORKING AS A DBA
During my education i attended different software companies and got more exp in oracle database development