10/18/2022 updated
AU
100 % available
Sr. Database Administrator
Lahore, Pakistan
Pakistan
BSIT24/7 ServicesBankingTelecommunicationsOracle WebLogic ServerTextilesDatabasesDatabase SecurityDistillationFinancial SystemsFurnishingManufacturingSQL Server Management StudioOracle DatabasesOracle ApplicationsPerformance Tuning
Over 8+ years of experience as a Database & Application Administrator in various industries including
Information Technology, Banking, Telco, Hospital, Airport,
Cement Manufacturing, Sugar production, Distillery, Textile, Power Plant, Pharmaceutical, Dairy, Furniture, feed mill etc. and performed different tasks like database administration, EBS apps administration, installation, configuration, upgrades, performance tuning, Patching, Cloning, backup and recovery, production support, cloning, space management, database security etc.
Transitional experience of SQL Server Administration & oracle SSO.
Database and Application Administration support on 24x7 critical production and large databases & Applications using Oracle EBS, Oracle WebLogic, oracle UCM, Oracle database (11g, 12c, 19c, 21c), 11g RAC, ASM, RMAN, EM Grid control for large financial applications & Databases.
Information Technology, Banking, Telco, Hospital, Airport,
Cement Manufacturing, Sugar production, Distillery, Textile, Power Plant, Pharmaceutical, Dairy, Furniture, feed mill etc. and performed different tasks like database administration, EBS apps administration, installation, configuration, upgrades, performance tuning, Patching, Cloning, backup and recovery, production support, cloning, space management, database security etc.
Transitional experience of SQL Server Administration & oracle SSO.
Database and Application Administration support on 24x7 critical production and large databases & Applications using Oracle EBS, Oracle WebLogic, oracle UCM, Oracle database (11g, 12c, 19c, 21c), 11g RAC, ASM, RMAN, EM Grid control for large financial applications & Databases.
Experience
Professional experience0 - 5 years
Languages
EnglishFluent
Project history
Demerger of oracle EBS R12.2.8 & R12.0 & upgraded database from 12c to 19c. Designed complete architecture. Implemented ECM/UCM as standalone and integrated with Oracle EBS 12.2.8, also configured ECM/UCM and PO mobile application. Implemented oracle 13c cloud grid control. Configured RMAN hot backup strategy Configured oracle dataguard and broker for EBs R12.2.8 database and for other oracle databases. Created and deployed shell scripts for automatic monitoring of servers, databases and integrated applications. Provide development and design assistance to development and other application support teams. Created SOP’s for IT department, BCP(IT) & Backup policy. Provide guidance, direction and managerial leadership to junior resources. Develop and manage both long and short-term goals for department and staff. Help develop and execute the department roadmaps. Create, track and update project schedule, communicate project status to the team members and to management.
Oversaw a major upgrade of Oracle e-Business suite from EBS R12.1.3 to EBS R12.2.10 & database 11g to 19c, integrated oracle UCM with EBS R12.2.10, integrated android and iOS applications with EBS and UCM for approvals and to promote paperless environment. Implemented database vault, Database Firewall and TDE (Transparent data encryption) for EBS R12 and its database to enhance database security.
Configured DMZ ( Demilitarized Zone) technology Installed Oracle EBS R12.1.1 & upgraded to 12.1.3 on Oracle Solaris Architecture). Oracle Database upgraded from 11gR1(11.1.0.7) to 11g R2(11.2.0.2) Configured two node RAC with EBS R12.1.3 on OEL and Solaris SPARC RAC to RAC & RAC to Non RAC cloning RMAN Backup on EBS with ASM (Hot Cloning). Configured Data guard in 11gR2 with EBS R12.1.3 Configured RAC to RAC & RAC to Non-RAC Data guard with ASM and Non-ASM in 11gR2 with EBS R12.1.3. Configured Parallel Concurrent Processing (PCP) on Application Tier for Two node RAC. Configured encrypted RMAN backup, incremental backups and recovery