• Operation database administrator support and responsible to provide 24x7 database administrative activities over OCI and AWS for client Office Depot and Office Max.
• Hands-on experience in Oracle database 19c administration, database installation, applying patches, and performance tuning and maintenance in Oracle cloud infrastructure (OCI).
• Managed Oracle databases on AWS RDS for backups, snapshot creation, and patching. Deployed database monitoring/health check alerts and sizing issues using oracle cloud control (OEM).
• Installed OEM 13C, deployed OEM agent, registered databases, created OEM users, installed agent bug patches, and upgraded Java JDK using 19c database.
• Refreshing dev and test instances for critical exa-data and AWS databases from production on a regular basis.
• Rebuild indexes, table partitioning, adding/removing disks to ASM, migration of database using data pump, and RMAN cloning.

·       Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.
·       Used Import/Export and SQL * Loader utilities to move data and objects Configured and Tested Backups for Oracle Databases by restoration and recovery.
·       Developed shell scripts and PL/SQL procedures and scheduled CRON jobs and DBMS_JOBS to monitor the database performance and for user management.
·       Implemented data guard with maximum performance configurations and worked with data guard maintenance and troubleshooting.

Basic responsibility as a Database Administrator is the Management of Oracle Exadata at Client side Mobilink Jazz (mobile network operator). 
Monitoring of Performance and tuning issues using OEM.
Managing of Table spaces and data files, their usage and space requirement issues.
Managing backups of databases using Export utility.  Performance tuning using OEM, AWR, ADDM & ASH reports.
Providing DB level support to client for Exadata with RAC setup
Involved in performance tuning & performance monitoring.
Providing 24x7 support for critical production databases.
Migration of Oracle Database (11.2.0.4.0) for Windows operating system to Linux operating system.
Expertise in PL/SQL, Packages, Stored Procedures, Functions, and Triggers.
Creation of Active Data guard 12cR2, Switch Over and Fail over.
Installation, up gradation and migration of PostgreSQL database.
Expertise in Partition table creation, converting Non partition table to partition table with Jobs and procedures to manage partitions.
Creation of Active Dataguard 12cR2, Switch Over and Failover.
Responsible for applying Oracle Database Security Patch Set Update 11.2.0.4.0 Quarterly.
Team member for latest Patch Deployment (Jan 2019) on Exadata Production databases.  Oracle Enterprise Manager Cloud control 13c Installation & Configuration with targets discovery and monitoring rules for Mobilink Jazz.

Managing and supporting the Oracle EBS system at Sharif Group.
Established and performed refresh/cloning Oracle Application Test and Development environments from Production environment.
Setup system and user profiles for Oracle Applications, administer concurrent managers and reports.
Setup Linux Shell scripts for different database monitoring tasks like storage space at databas level (Table space, Archive logs) and OS level with monitoring of data guard status and backups.
Implemented and maintained oracle active data guard 12C with maximum performance configurations and troubleshooting issues regarding connectivity and log shipping to DR (Data Guard).
Developed Linux scripts for RMAN backup, Data pump export / import, purging archive log filesand old backup files.

 Implementation of Oracle Database 11g R2 (11.2.0.4.0) in test Environment on Oracle Enterprise Linux AS 6 Update 5
 Implementation of Oracle Database 12C R1 (12.1.0.2.0) in test Environment on Oracle Enterprise Linux AS 6 Update 5
 Implementation of Oracle Database 11g R2 on & 11R2 Data Guard (11.2.0.2 Single Instance Physical Standby) in test Environment on Windows server 2008 SP1 64-bit used for high availability, data protection, disaster recovery and Real Time Apply .
 Implementation of Oracle Database 12C R2 on Data Guard (12.2.0.2.0 Single Instance Physical Standby) in test Environment on Oracle Enterprise Linux AS 6 Update 5 used for high availability, data protection, disaster recovery and Real Time Apply
 Expert in managing Table spaces, Data files, Oracle instance, Database links, Schema objects and Listener issues in multi user Environment.
 Troubleshoot Oracle Applications and Databases.
 Backup restoration and Recovery using RMAN through Disks.
 Managing backups of database using RMAN.
 Ability to work in the following Operating Systems:
• Windows
• Linux