MUHAMMAD AAMIR RAFIQ
Oracle Certified DBA with over 5 years of experience in database administration tasks. Hands-on experience in Oracle database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, migration, data guard, RAC, ASM, Golden Gate and documentation.
United bank Limited Apr 2017 to Present
New York, NY
Install, configure and administer VMware, Oracle VM Server, and AD, Oracle Database 10g/11g /12c and Linux Server.
Upgrade 11g database to 12c.
Provide support for six databases 10g and 11g. (Production, UAT, DR).
Engineering and administration of Oracle standalone and RAC clustered (11g, 12c) database environments.
Configured and provide support two nodes RAC 11g 64 Bit on Red hat Enterprise Linux.
Provide support for WebLogic 11g Application Server.
Successfully implemented physical Standby database using Oracle Data Guard feature for High availability configuration.
Experience in regular DBA activities such as Upgrades, Patches, Cloning, Backups and Recovery Manager, Migration, Performance Tuning, Capacity Planning and maintain compliance, regulatory and audit related documentation for information system.
Fulfilled DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management, and monitoring.
Configured Replication between Oracle and MySQL using Golden Gate.
Assisting with procurement of hardware, software, and services.
Database performance tuning, Trouble shooting database issues, Basic SQL and PL/SQL knowledge.
Troubleshoot Database performance issues using Oracle Enterprise Manager Console.
Maintain daily, weekly and monthly hot and cold backup using RMAN and Data pump.
Write query for extraction of data as per requirement.
SQL tuning and Database performance tuning based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM, Oracle Partitioning, materialized view, indexes and monitor the database performance on daily basis.
Use of tools like Sqlplus, Toad, PL/SQL Developer, OEM, Putty, SQL Developer, Winscp, FileZilla and ftp.
Optimum IT Solution Jun 2016 to Mar 2017
Implemented and maintained oracle disaster recovery site using Data guard on live production database 11g without down time with the help of RMAN.
Supported 12c, 11g, and 10g Oracle databases on Linux.
Participated in implementation of Oracle RAC 11g on LINUX.
Implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
Plan and schedule RMAN backups (hot, cold and incremental backups).
Implementing Data pump, conventional export/import utility of Oracle 10g, 11g for reorganizing Databases/Schemas/Tables to improve the performance.
Novatex Limited May 2012 to April 2016
Oracle Database Administrator
Installation and configuration of Oracle Database 9i/10g/11g Server, Oracle Application Server, WebLogic Application Server.
Deploying Logical backup scripts using export/import and Data pump utilities on both windows and Unix environments.
Writing Linux Shell, Bash, SQL and RMN scripts for different database monitoring tasks.
Providing 24/7 support to databases coordinating and executing maintenance tasks on weekends and on-demand.
Daily monitoring of alert log files and checking and correction of errors found.
Creation of new partitions and analyzing the tables.
Monitoring of any privileges given to users which violated security of database.
Maintained and monitored all patch releases and design various patch installation strategies and maintained all systems.
Implemented and maintained oracle disaster recovery site using Data guard on live production database 10g.
Administered all performance for various resources and ensure optimization for same and provided support to all applications and ensured optimal level of customer services.
Maintained and monitored all system frameworks and provided after call support to all systems and maintained optimal Linux knowledge.
Performed troubleshooting on all tools and maintained multiple servers and provided back up for all files and script management servers.
Perform tests on all new software and maintain patches for management services and perform audit on all security processes.
Successfully migrating Oracle Database from 188.8.131.52.0 to 184.108.40.206.0.
Successfully upgrading Oracle Database version from 220.127.116.11.0 to 18.104.22.168.0 by applying patch.
Proactive Monitoring, identifying areas that need to be improved in the application and database using Stats pack, AWR, ADDM, OEM Monitoring.
HANIYA TECHNOLOGY Feb 2011 to April 2012
Jr. Linux Administrator
Installed and configured LDAP, Mail, Samba, NFS, Asterisk/Elastix/Trixbox and VMware Server.
Hands-on Linux Administration, Hardware Configuration and Software Installation.
Developed and maintained automation Scripts (Batch, Shell).
Administered File Shares, Access Permissions, Disk Management, Schedule Jobs etc.
Responsible for configuring networking concepts like NIS, NFS, SAMBA, LDAP, SSH, SFTP, SNMP, DNS, DHCP, HTTP, NTP, POP, IMAP troubleshooting network problems such as TCP/IP, supporting users in solving their problems.
Maintained all system backup and assisted to restore all procedures and provided required training to all users.
Designed and maintained all system tools for all scripts and automation processes and monitored all capacity planning.
Worked on YUM configuration to patch the servers to the latest OS/Kernel version.
Monitored System Activities like CPU, Memory, Disk and Swap space usage to avoid any performance issues.
Monitored everyday systems and evaluated availability of all server resources and performed all activities for Linux servers.
Assisted to configure and deploy all virtual machines and installed and provided backup to all configuration procedures.
Bachelor of Science in Telecom, Major Computer Science.
PROFESSIONAL CERTIFICATION and TRAINING:
Oracle Certified Associate 11g from Oracle.
Oracle Certified Professional 11g training from Oracle WDP authorized institute.
Oracle Certified Professional 12c training from Oracle WDP authorized institute.
Oracle RAC training.
Linux Server Administration.
Cisco Certified Network Associates (CCNA).
Oracle Database Administration 9i/10g/11g/12c.
OS (RHEL, Centos, OEL, Fedora, MS Server 2003/2008/2012).
Linux/Virtual Server Management (VMware and Oracle Virtual Server).
Performance Tuning & Capacity Monitoring.
Oracle Data Guard /Switchover /Failover Administration.
Oracle RAC & ASM Administration/Installation.
Exposure of Golden Gate.
Data Pump and Export/Import.
Sql*loader and External Table.
Scripting. (SQL, Shell, Bash, Rman, Batch, Cron).
Tool (Sqlplus, Toad, PL/SQL Developer, OEM, Putty, SQL Developer, Winscp, FileZilla).