Database & Middleware Admin
NAMAA TECH.
Total years of experience :17 years, 8 Months
• Expert in managing and maintaining Oracle databases, including installation, configuration, tuning, and performance optimization.
• Experience with various database objects like tables, indexes, views, and procedures.
• Skilled in backup and recovery strategies, including RMAN and Data Guard.
• Applied patches and upgrades as necessary for optimal system performance.
• Tested applications to ensure compatibility with databases.
• Configured high availability solutions such as clustering, replication.
• Developed disaster recovery plans for databases in case of failure.
• Identified, diagnosed, and resolved database errors.
• Performed backup and restore operations on databases using available tools.
• Assisted in troubleshooting complex problems related to database architecture.
• Administered database security by creating user logins to different project staff with appropriate roles.
• Implemented database changes according to established standards.
2
• Creating, managing & configuring Oracle Cloud Database System (DBCS).
• Creating, managing & configuring Oracle Autonomous database.
• Configuring & managing Oracle Cloud GOLDENGATE.
• Migrate database from DBCS to Autonomous database.
• Creating managing NoSQL database MongoDB.
• Creating Managing MS SQL database including high availability. Database & Middleware Admin: 2012 - 2021
EMPLOYEE OF:
Role: Oracle Database & Middleware Administrator.
Key responsibilities:
Riyadh City Project:
As a part of DBA team managing various tasks of Riyadh City project.
o Perform installation, configuration and troubleshooting of RAC & DATAGUARD on PRODUCTION\UAT\STAGE\DEVELOPMENT environment.
o Perform switchover between primary & standby.
o Created services at database level to manage difference applications.
o Schedule & Manage RMAN & DATAPUMP backup operations running on PRODUCTION environment.
o Weekly Clone UAT environment from PRODUCTION.
o Automate restore & recovery operations from backups to test the validity.
o Managing SNAPSHOT database & make it ready for read/write operations.
o Perform installation, configuration and troubleshooting of Oracle WebLogic (forms/Report).
o Perform Database, schema based & objects based recovery on demand.
o Implemented Oracle Database Appliance (ODA) as a part of team.
o Upgraded the Oracle Database Appliance from version 12 to 19 as part of team.
o Keep an eye on alert log file for any issue in database.
o Upgraded Oracle APEX from version 5 to 20.
o Routine tasks of DML/DDL & Compilation of forms/reports.
o Documenting activities of major operations to keep it for future and for knowledge sharing.
o Accomplish tasks assigned by ticketing system (SAMM).
Riyadh Region Project:
o Prepared 47 database & application servers for 47 municipalities outside Riyadh City.
o Schedule & manage backup operations (RMAN / DATAPUMP).
o Prepared centralized database to aggregate data from all 47 databases.
o Created Materialized Views & scheduled jobs to aggregate/refresh data into centralized database.
o Prepared & managing centralized backup server to hold backups of all 47 databases & application servers.
o Prepared TEST & DEVELOPMENT environments.
o Troubleshooting of issues.
o Upgraded database & application to 11g from 10g.
o Restore backups on demand of application & development team.
o Apply upgrade patches to Database & middleware servers.
o Perform routine tasks of DML/DDL operations & compilation of FORMS/REPORTS.
o Accomplish tasks assigned by ticketing system (SAMM).
Role: Oracle Technical Consultant (Oracle DBA/Apps DBA/Oracle Discoverer Administrator).
Responsibilities:
o Installation, configuration & managing of EBS R12.
o Clone application instance for TESTING, DEVELOPMENT & REPORTING environment.
o Perform database refresh for EBS R12.
o Apply Database & Application patches.
o Managing database security by creating multiple users, roles & assigned appropriate privileges.
o Managing & schedule backups.
o Routine check of log files for issue.
o Develop reports using Oracle Discoverer.
o Create, configure & manage databases & middleware (forms/reports) servers.
configuration, tuning, and performance optimization.
• Implementing and maintaining highly available and scalable database environments.
• Troubleshooting and resolving RAC-specific issues.
• In-depth understanding of Data Guard concepts like primary, standby, and failover.
• Experience in setting up and managing Data Guard environments for disaster recovery.
• RMAN for performing database backups, restores, and recovery operations.
• Experience in implementing user accounts, roles, and privileges.
• Managing & configuring middleware applications like Oracle forms & reports, Oracle ADF & Oracle OTD. DBA\Apps DBA: 2011- 2012
EMPLOYEE OF ABAID UL REHMAN ESTABLISHMENT.
Responsibilities:
o Install & configure database.
o Install Client software.
o Create & manage database objects (Tables, Views, Synonyms, Sequences, Materialized Views, Triggers, Function, and Database Link etc.
o Perform IMPORT/EXPORT using traditional export utilities.
o Manage backup jobs & operations.
o Checking alert log file for any issue.
o Manage users, roles and privileges.
o Manage form/reports servers & make compilation of form/reports & object libraries.
• Masters Of Information Technology (M.IT) Continue Virtual University of Pakistan
SQL Oracle DBA Administration I Oracle DBA Administration II Oracle OCA Developer
Board of Intermediate & Secondary Education Gujranwala Pakistan • Matriculation (Science) 2002-2004
B.Sc computer science