I have started my career with Oracle 11g. My area of specialization is Oracle Database, especially in the challenging and highly motivated environment to get expertise. My commitment is always with quality of work related to my job. I understand my responsibility, believe in honesty and hard work with discipline.
· 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 (18.104.22.168.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 22.214.171.124.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 (126.96.36.199.0) in test Environment on Oracle Enterprise Linux AS 6 Update 5
Implementation of Oracle Database 12C R1 (188.8.131.52.0) in test Environment on Oracle Enterprise Linux AS 6 Update 5
Implementation of Oracle Database 11g R2 on & 11R2 Data Guard (184.108.40.206 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 (220.127.116.11.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: