Oracle Database
Resume:
Hassan Khalid
Bloomington,IL
Employer Details : ********@*****.***
PROFESSIONAL SUMMARY:
Senior level Oracle certified Database Administrator with over10 years of solid hands-on experience in handling multiple Oracle, Cassandra and DB2 databases in heterogeneous environments such as Solaris, HP-UX and Windows. Well exposed to state of the art RAC implementations, DataGuard, GoldenGate, routine DBA production support, development and related database technologies. Received best performance awards on numerous occasions
Professional experience in Oracle Installation, administration, performance tuning, backup & recovery with proven ability at Server side & Client side responsibilities.
Expertise in Oracle RAC, Replication, Standby databases, and database designing.
Proactive and Reactive Database Health checks and server reviews for client database and suggesting changes.
Expertise in handling 24X7 mission critical production databases, versions 11g/10g/9i primarily in AIX / UNIX/LINUX based environments.
Expertise in managing and installation of 11g/12c CDB/non-C DB Active Data Guard.
Successfully upgraded databases from 9i,10g,11g and 12c CDB/non-CDB.
Excellent versatile team player and adaptable for new technologies.
Expertise in working with High volume, and High Transaction databases.
Oracle DBA experience including building objects and maintaining production environments.
Experience in Database Security and Auditing.
Solid understanding of Exadata Architecture.
Performed backups using conventional cold, hot and RMAN backups.
Proficient in performance tuning using Explain Plan, SQL_TRACE, TKPROF, AWR, ADDM.
Experience in using 13c/12c OEM cloud control, TOAD, Data Migrations using export/import, benchmarking using load testing tools
Monitoring of Exadata using OEM 12c.
Solid exposure of Exadata hardware.
Problem determination and resolution for supported application databases and maintenance utilities.
Prepare documents for Client specific and database specific as per requirements by different clients
Sql server database administrator functions including, configuring cold and hot backups, daily disk space monitoring, and database object creation and alters.
Involved in sql server performance tuning using Performance Monitor.
Upgraded SQL Servers from SQL Version 2000 to SQL 2005 and 2008.
DB2 9.7 database administrator functions including, configuring cold and hot backups, daily disk space monitoring, and database object creation and alters.
DB2 10.5, 10.1, 9.7 database administrator functions including, database object creation and alters implementation, reorgs, statistics collection and analysis.
In depth knowledge of architecture, core concepts and creating Cassandra systems.
Add/Remove nodes into Cassandra cluster.
Monitoring Cassandra cluster through node tool.
Monitor Cassandra system logs, opscenter, opscenter-agent logs for errors.
Academic Qualifications:
Bachelor of Computer Science 2006 from Preston University, Lahore Pakistan.
Certifications and Trainings:
Oracle RAC 11gR2 and Grid Infrastructure Certified Administrator
Oracle Certified Professional 11g (DBA Track)
Oracle Certified Professional 10g (DBA Track)
IBM Certified Database Administrator DB2 9.7 for LUW
Cassandra Training (Core Concepts, Skills and Tools)
Cassandra Data Modeling
Cassandra Tuning and Troubleshooting
Oracle 12c Training
Data Guard 11g Training
SQL Server Training
DB2 Training
Tools and Technologies:
Operating Systems
Oracle Solaris10,Red Hat Linux, Windows 2000/2003/2008 Server, Windows XP,Windows7/8.
Databases
Oracle RAC (Real Application Clusters) 9i/10g/11g/12c, Oracle Standalone databases 9i/10g/11g/12c, Oracle Grid Infrastructure, Oracle ASM, Oracle Golden Gate, Oracle Exadata, E-business suite, Microsoft SQL Server2005,2008, Cassandra, DB2 V9.5, V10.1, V10.5
Database tools
TOAD, OEM Cloud Control and OEM Grid Control, Pl/SQL Developer, SecureCRT, AllFusion Erwin Data Modeler, ETL, Spotlight, Solar Wind, Microsoft Management Studio, DevCenter, OpsCenter, Data Studio, IBM Optim 11.3.
Database Utilities
RMAN, Datapump, Exp/imp, Sqlldr, SQLPlus, dbca, netca, NID.
Other Skills
VMWARE Server/Workstation, Web sites Development, Unix Shell scripting
Professional Experience:
Client: State Farm. Bloomington, IL Jul 2015 – Dec 2016
Sr. Oracle DBA
As Oracle DBA responsibilities:
Oracle Database installation and maintenance of 11g and 12cMultitenant on NFS and ASM file systems.
Upgrading multiple databases from 10g and 11g to Oracle 12c Multitenant/non-Multitenant databases.
Oracle Database Upgrades (Single node, Cluster databases, ASM)
Oracle Databases migration from old servers to new servers (Prod/Non-Prod).
Online 12c data migration from NFS to ASM and non-Exadata to Exadata environment.
Installation and manage oracle 11g database Vault.
Upgrade of 27 TB of Revenue Assurance database to increase storage capacity.
Implementing three to five nodes Oracle 11g/12c RAC on Solaris, using NFS and ASM File systems.
Upgrade, Implementing and managing Oracle11g/12c Active/Physical Stand by Data Guard.
Manage Oracle Golden Gate databases.
Clear understanding of Exadata features like Flash cache, Storage Index, HCC and IORM.
Upgrade and manage oracle 12c OEM cloud control to 13c OEM Cloud Control.
Database Performance tuning and optimization.
Running AWR, ASH and Real-Time ADDM reports routinely to check for any potential database performance issue.
Database migration from non-Exadata to Exadata using Data Guard.
Configuring and deploying of Physical Database Backups using RMAN using Net backup.
Configuring and deploying Logical database backups using data pump utility for data migration from production databases to historical database.
Extensive use with 12c OEM cloud controlfor monitoring, administration and performance tuning.
Daily Monitoring Storage Space at Database and OS level.
Routine operational support for business queries.
Creating and monitoring scripts for efficient database monitoring and troubleshooting.
SOA installation and maintenance during testing and implementing of new application server.
Creation and managing Oracle Application Profiles and users.
Creating and managing Database schemas statistics gathering scripts
Expertise in working with High volume, and High Transaction databases.
Oracle DBA experience including building objects and maintaining production environments.
Problem determination and resolution for supported application databases and maintenance utilities.
Perform change management activities using standard change processes in support of application database related changes.
As Cassandra DBA responsibilities:
In depth knowledge of architecture, core concepts and creating Cassandra systems.
Add/Remove nodes into Cassandra cluster.
Upgrade, Installation and patches on multiple Cassandra clusters.
Monitoring Cassandra cluster through OpsCenter.
Starting, stopping and restarting of OpsCenter and agents.
Monitoring Cassandra cluster through nodetool.
Stopping, starting, and restarting of Cassandra server and cluster.
Monitor Cassandra system logs, opscenter, opscenter-agent logs for errors.
Manage and setup alerts in opscenter monitoring tool.
Maintaining backups of all Cassandra.
Environment:Oracle 11gR2,12c, RAC, ASM, Data Guard, Oracle Exadata, Oracle OEM Grid Control 11g, 12c cloud control, Apache Cassandra, Solaris10, Red Hat Linux.
Client: Eisai Inc. NJ Nov 2014 – Jul 2015
Sr. Oracle DBA
As Oracle DBA responsibilities:
Working as Senior Oracle DBA and providing consulting services to a wide variety of clients having diverse environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:
Installation, configuration, administration and tuning of Oracle 10g to 11g/12c Single Instance and RAC databases.
Installation and administration of Oracle 12c CDB databases on multiple servers.
Database Upgrade/migration from 10g to 11g/12c on NFS and ASM file systems.
12c OEM cloud controlinstallation, configuration and administration.
Proactive and Reactive Database Health checks and server reviews for client database and suggesting changes.
Write and maintain generalized scripts to create databases, to get definition of the existing databases, to monitor and maintain databases and their alert logfiles and listener log files, startup scripts, shutdown scripts, RMAN backup and restore scripts.
Good understanding of Exadata Architecture.
Oracle 10g/11g Active/Physical Dataguard setup and administration.
RMAN Backups setup and recommending performance improvement during hot backups.
Deploying Logical backup scripts using export and data pump utilities on both Linux and Unix environments.
Writing Unix Shell scripts for different database monitoring tasks.
Applying latest security patch sets on Databases.
Providing 24/7 support to client databases. Coordinating and executing maintenance tasks on weekends and on-demand.
Creating SR with Oracle Support on any issues and when needed.
Setup and maintain documentation as standards for future usage.
Monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, ASH and 12c OEM cloud control.
Involved in different scenarios of OLTP as well as DSS databases.
Database Security and Auditing through FGA.
Performed backups using conventional cold, hot & RMAN backups.
Performance tuning using Explain Plan, SQL_TRACE, TKPROF, AWR, ADDM, ASH and 12c OEM cloud control.
Prepare documents for Client specific and database specific as per requirements by different clients.
Installation and managing of 3 nodes Cassandra cluster.
Expert in Monitoring Cassandra cluster through nodetool.
Monitor Cassandra system logs and CPU usage through opscenter.
Environment: Oracle 10g,11gR2,12c, RAC, Oracle Exadata, ASM, Data Guard, Oracle OEM Grid Control 11g/12c cloud control, DB2 V9.7, V10.1, Oracle Solaris10, Red Hat Linux, Windows 2003/2008R2.
Warid Telecom (Pvt) Ltd.Lahore, Pakistan Jun 2012 – Nov 2014
Sr. Oracle DBA
Warid continue to challenge and set new performance standards by investing in the future of its employees and seeking knowledge and innovation in order to exceed customer expectations and serve our community.
As Oracle DBA responsibilities: Working as Senior DBA in this organization performed following tasks:
100% involved for implementation TABS billing system.
Planned and implemented 20 million subscribers upgrade project which includes migration of 14TB billing system to new data center along with its database upgrade to 11gR2 in minimal downtime
Supervised the upgrade of 23 TB of Revenue Assurance database.
Oracle Database Upgrades (Single node, Cluster databases, ASM)
Oracle Databases migration from old servers to new servers (Prod/Non-Prod).
Data migration from file system to ASM.
Implementing two and three node Oracle 11g RAC on Solaris10, using NFS and ASM File systems.
Planned and migrated 12TB CDR History database to Oracle 11g. It includes automated CDR transfer from live eliminating cumbersome manual tasks.
Implementing and managing Oracle Active Data Guard10g/11g
Implementing and maintaining Oracle 11g Golden Gate.
Running AWR, ASH and ADDM reports routinely to check for any potential database performance issue.
Configuring and deploying of Physical Database Backups using RMAN using Net backup.
Configuring and deploying Logical database backups using data pump utility for data migration from production databases to historical database.
Extensive use with Oracle Enterprise Manager Grid Control for monitoring, administration and performance tuning.
Creating and monitoring scripts for efficient database monitoring and troubleshooting.
SOA installation and maintenance during testing and implementing of new application server.
Implementing, working and cloning oracle 10g Discoverers on multiple servers
Problem determination and resolution for supported application databases and maintenance utilities.
Perform change management activities using standard change processes in support of application database related changes.
Setup and maintain documentation as standards for future usage.
DB2 9.7 database administrator functions including, configuring cold and hot backups, daily disk space monitoring, and database object creation and alters.
As a DB2 Database administrator daily monitoring alert file for diagnosing all problems.
Environment: Oracle 10g,11gR2, RAC, ASM, Oracle 10g-11gR2 Data Guard, Oracle OEM Grid Control 10g-11gR1,12c OEM cloud control, Unix 9,10, Red Hat Linux 5, IBM DB2 9.7
Oracons Consulting International. Lahore, Pakistan Feb 2007 – Jun 2012
Oracle DBA
Oracons Consulting is specializing in delivering end to end integrated solutions based on highly flexible and stable technology rapidly adapting to client needs.
Having been associated with Fortune 500 companies in addition to local presence and have a strong presence in the Power Sector, Oil & Gas, Construction, Industry, Government, Pharmaceuticals, Leather and other sectors.
As Oracle DBA responsibilities:
Working as DBA and providing consulting services to a wide variety of clients having diverse environments and database sizes, requirements, configurations and corporate cultures. The routine tasks include dealing with:
Oracle Database installation and Maintenance.
Implement two and 3 nodes Oracle 10g/11g RAC databases.
Installation and managing 10g Data Guard.
Create test, development and production databases with assistance from Lead DBA.
Physical Database Backups using RMAN.
Logical database backups using datapump utility.
Running AWR, ASH and ADDM reports to check for any problems in database.
Supported the developers and end-users for accessing the database.
Rotating log files to release space at OS level.
Monitoring Storage Space at Database and OS level.
Documentation of all tasks performed on Production databases.
Daily monitoring of table spaces and adjusting space by adding datafiles
Monitoring system performance (DB and OS through AWR reports)
Daily monitoring of alert log files and checking and correction of errors found
Creation of new partitions and analyzing the tables
Creation and maintenance of new table spaces and assigning quota on those table spaces to users
Applying any required patches and fixing database issues
Migrated Shell scripts and Perl programs from single instance servers to new RAC servers.
Correspondence with System analysts and DBA group for creating required directory structure for daily batch operations.
Deployment of complete batch on RAC servers and manual execution of jobs for testing.
Participated in database stress test session along with DBA group.
Prepare documents for Client specific and database specific as per requirements by different clients.
Environment: Oracle 9i/10gR2/11gR2, IBM AIX 5.3, Window Server 2003/2005, Unix, Linux
Contact this candidate