Sr. Oracle Database Administrator
Resume:
HANIF SHAIK
Sr. Oracle Database Administrator
**********.***@*****.***
Professional Summary
8+years of experience as an Oracle Database Administrator having hands on experience in Installation, Administration and Troubleshooting of Oracle 12c/11g/10g/9i for OLTP (multiple instances)/OLAP environment and supported multiple Clusters, Non-cluster and ASM Database in production, development and Testing Servers. Experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, Configured Disaster recovery databases using Dataguard, replicated databases using Golden Gate. Automated RMAN Backups, Datapump, cloning, space management, database security, cloning, migration, EXADATA and documentation. Proficient in supporting databases running on AIX, O.E.L, R.H.E.L, Sun-Solaris and windows platforms.
Professional Experience
Exclusive experience in installing, configuring and upgrading Oracle Software on Sun Solaris, OEL, RHEL, IBM-AIX, HP-UX and Windows Platforms.
Provide day-to-day, hands-on technical support of Oracle based Production and development systems running on various platforms.
Coordinated development and deployment activities very well with project teams and contributed heavily in pre and post deployment stabilization.
Excellent experience in configuring and tuning of Oracle 12c/11gR2/10g RAC, Physical and Logical Standby database (Data Guard), Golden Gate and ASM for high availability of database.
Hands on experience in installation, configuration and troubleshooting of GoldenGate EXTRACT, Unidirectional and Bidirectional replication.
Hands on experience in using Oracle GoldenGate including maintenance and performance monitoring.
Performance tuning GoldenGate replication and used Logdump and report files for troubleshooting.
Having extensive experience on Database administration for DB2 on z/OS and DB2 system installation and maintenance.
Data Migration using exp utility and Schema/Table level replication using GoldenGate.
Migration of oracle databases from 10g to 11g, 10g RAC to 11gRAC and 11g to 12c
Installed 2 node 11g RAC using RAW device and ASM.
Managed 4 node Oracle 10g/11g Real Application Clusters (RAC) databases with ASM Storage.
Managing the RAC databases by using SRVCTL and CRSCTL.
Implemented Oracle RAC with ASM and standalone with ASM in different environments such as development, testing, production and standby databases (both Physical and Logical databases).
Expert in export/import and data pump import to load data in to tables.
Extensive Experience on taking the logical backups of data using oracle DATAPUMP utilities EXPDP and IMPDP.
Solid experience in database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
Creating Physical Standby Database with RMAN Duplicate from Active Database
Experience in RMAN Backup and Recovery, database cloning, flashback technology, Enterprise Manager and Oracle OEM Grid Control and using TOAD, SQL Developer, Serena Version Manager and Business Manager
Experience in Flashback Technologies, RMAN Active Database Cloning, Virtual private Catalogs and Merging Recovery Catalogs.
Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and re-building Standby Databases both Physical by Dataguard.
Expertise in Oracle Architecture, SGA, PGA, Binary structure, Listener, TNSNames, SQLNet, V$, DBA views and Datamodeling, Logical and Physical databases design using tools like ERwin and Rationalrose.
Switchover, Failover, Switching Standby to Primary and Primary to Standby on scheduled basis.
Experience in applying CPU and PSU patches/patch sets to the databases.
Testing the deliveries, Releases, and patches before applying them in the production environments.
Experience on migrating regular database from NON-ASM to ASM.
Hands on experience in designing database schemas as per business requirements.
Proficient in Index rebuilding and Index tuning.
Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, Datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Stats pack and tuning of initialization parameters.
Expertise in planning, implementation and documentation of installation, migration, patching, backup retention policy, recovery, security, auditing, capacity planning, space management and storage allocation (SAN/NAS).
Having good experience in migrating databases in EXADATA RAC environment.
Worked on databases on EXADATA various compression methodologies including OLTP compression, HCC, EXADATA Query specific.
Handles and perform clients and internal Service Request for Incident Management, Problem Management and Change Management.
Performed Database refresh from production to pre-prod, development and testing environments.
Hands on experience in fulfilling DBA daily activities in schema management, user management.
Experience in troubleshooting and resolving problems during the regular maintenance of Oracle database.
Availability as On-Call 24x7 Production DBA and application/development DBA and Oracle Support processes for technical requests through Meta link and Help Desk Ticket applications like USD.
Technical Skills
Operating Systems
HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2,6.1, Red Hat Linux RHEL 4.x,5.x, Windows
Database
RDBMS, Oracle10g/11g/12c.
Languages
SQL, PL/SQL, C, C++ and UNIX Shell Scripting.
DB Management
TOAD 9.5, DB Artisan, SQL Developer and Enterprise
Manager grid.
Tools/Utilities
RMAN, OEM, Oracle Management Service (OMS),
SQL*Loader, ASM, Export/Import, TOAD, Patch
Management, ODBC, DBUA, DBCA, putty, Golden32,
ImpExp32, Grid Control, Data pump, Data guard,
VERITAS Net Backup and MS Access.
Tuning Tools
TKPROF, EXPLAIN PLAN, STATSPACK, AWR and
ADDM, SQLT, SQL TUNING ADVISOR
Work Experience
Client: Anthem, Norfolk, Virginia February 2015 to Present
Role: Sr. Oracle Database Administrator
Responsibilities:
Providing database administrative support and 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5
Experience with large databases (1.5 Tb) for OLTP and OLAP applications.
Performed installation, configuration and maintenance of oracle 11g/12c, 11gR2/12c RAC databases.
Migrated the database from existing Oracle 11g to Oracle 12c and Upgraded the database.
Experience in configuring oracle 10g, 11g Real application cluster (RAC) (2 and 3 nodes) using cluster ware and automatic storage management (ASM).
Performed migration of oracle 10g/11g non RAC single instance to RAC database instances and also upgraded oracle 11g RAC to 12c RAC database.
Experience with 11g cluster maintenance using CRSCTL and SRVCTL Utility for Oracle 11g RAC database.
Taking backup of OCR and VOTING DISK using ocrconfig.
Implemented Disaster Recovery database 10g/11g Data Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.
Monitored and optimized database performance using Oracle Enterprise Manager (OEM) 11g Grid control.
Performed database backups with RMAN incremental and cumulative backups by registering 10g/11g databases in recovery catalog.
Performed complete and incomplete database recovery, data file and table space point in time (TSPITR) recoveries using RMAN and user managed backups.
Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 12c and Production to development refresh.
Monitored database objects, table spaces, data files and control files and extensively used data pump for data migration at table, schema and database level.
Implemented backup strategies using hot/cold, Expdp/Impdp used on the business requirement.
Expertise in scheduling jobs for oracle backend processes in crontab.
Used SQL*loader to move data from flat files into oracle database.
Expertise in performance tuning by building partitioned tables, materialized views, bitmap indexes and index organized tables.
Analyzed data models using ERWIN and made modifications according to requirements.
Experience in Migrating databases to Exadata.
Maintaining and Troubleshooting Exadata Storage and performance issues.
Configuring Enterprise Manager (OEM) 12c for complete control of Exadata environment.
Involved in configuring Exadata X5-2, X5-8 and having hands on experience on smart flash cache, storage index, storage management and migration.
Experience in Migrating NON-ASM databases to ASM and maintained RAC databases on Exadata.
Implemented Disaster recovery for production databases using Data guard and creating physical standby databases, and involved in converting physical to snapshot standby, and also Active Data-guard
Converted physical standby to Snapshot standby and back to physical standby as per business requirement
Setup physical standby’s (Dataguard) for several Databases and configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the Data guard status via command line
Proficiency with Installation and maintenance of replication tool Goldengate by creating extract process, extract pump, and replicate.
Configured GoldenGate Unidirectional and Bidirectional replication.
Worked on Advanced Replication including synchronous and asynchronous scenarios.
Upgrading GoldenGate from 11g to 12c and Expertise on Oracle GoldenGate and be able to configure Golden Gate and troubleshoot the issues related to GoldenGate independently.
Used Logdump utility, Defgen utility in GoldenGate environment and Installed Goldengate in dev, test, prod environment.
Experience in Multitenant Databases (Oracle 12c Container and pluggable databases).
Consolidated database creation in oracle 12c using multiple PDBs.
Implementation of EM12c installation for multiple data centers, POC of OEM 11g grid control and OEM12c.
Experience in applying quarterly security patches (PSU/CPU), as well as interim patches for fixing bugs.
SQL query tuning using reports generated by tools like Stats Pack, TKPROF and SQL*Trace and Explain Plan.
Performed database tuning using Explain plan, Stats Pack, TKPROF, SQL tuning advisor, SQL access advisor, SQL planned management tools and AWR (automatic workload repository), ADDM (automatic database diagnostic monitor) and ASH reports and performed database tuning based on the recommendations suggested by ADDM reports.
Provided significant enhancements and bug fixes to OIM 11g environment.
Provided in depth training on Oracle Identity Manager 11g deployment, configuration, and custom connector development.
Provided ongoing support and enhancements to existing OIM 11g environment.
Assisted in deployment of software environments, integration connectors, and customizations.
Expertise in storage management by managing space, table spaces, segments and extents, Rollback segments and data dictionary.
Resolved database network problems using Oracle Net Configuration Assistant (NETCA).
Implemented Flashback Technology-Query, Table, Drop and Database to undo specific transactions, recovered database objects and rewind entire database to a particular time.
Installed 12c pluggable databases and upgraded from 11g to 12c and managed fusion middle ware products.
Worked on SAP databases and used B.R Tools for taking Backup of databases.
Unix Shell scripting in csh,ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
Provided weekly reports on memory, disk usage, I/O and UNIX utilities.
Responsible in creating and management of table spaces, indexes and rebuilding indexes.
Created triggers, worked with PL/SQL developers in tuning procedures.
Experienced in user management, roles, privileges, auditing and profile authentication.
Experience in documentation on database design, analysis and modifications and performed database monitoring activities including checking alert logs, database lock issues, schemas, users, jobs, table spaces, database objects.
Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metal ink).
Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
24x7 Production database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Environment: Oracle 12c/11gR2/10g, Red Hat Linux, UNIX, OEM Grid Control, RAC, ASM, GlodenGate, Data Guard, Exadata, OPatch, Stats Pack, TKPROF, and SQL*Trace, AWR, ADDM, ASH, SQL*Loader, Stats Pack, SQL*Trace, Explain Plan, SQL tuning advisor, SQL access advisor, SQL planned management, UNIX Shell scripting, export/import.
Client: Standard bank and Trust Co., Lowell, IN March 2012 to January 2015
Role: Sr. Oracle Database Administrator
Responsibilities:
Installed, configured and maintained Oracle (10g&11g R2) databases on Linux 5, HP-Unix 11.X.
Migrated the database from existing Oracle 10g to Oracle 11g and Upgradation of database (from 10.2.0.3 to 11.2.0.2).
Implemented Oracle Partitioning, Advance Queuing and Index-Only Tables to enhance performance of large OLTP environments and enhance the online community experience.
Managed users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager (OEM).
Having extensive experience on Database administration for DB2 on z/OS and DB2 system installation and maintenance.
Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on Cluster File system.
Experience in management of 10g RAC & 11g RAC using ASM/OCFS/RAW on Linux/Unix platforms.
Migrated 10g Non-RAC single instance database to 11g RAC database.
Well conversed using the CRSCTL and SRVCTL tools for maintaining database, ASM and node applications.
Performed health checks regularly on RAC database
Performed backups of OCR and Voting files.
Performed Add-Node procedure on a 2-Node RAC Cluster to add an additional node.
worked on Cluster ware troubleshooting, CRS-ERRORS, CRS-4639, CRS-4530 and CRS-4535 and wait events in RAC environment.
Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.
Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database. Performed replication using Oracle Streams and GoldenGate Technology.
Configured Goldengate extract and replicate during the database character set conversion.
Configured Goldengate Datapump extract to move the trail files from source database server to target database server.
Used DEFGEN utility to create definition files, log dump utility to analyze trail files, implemented heartbeat tables to monitor lag in Golden Gate Environment, Migrated oracle databases with minimal down using Oracle Golden Gate.
Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard fail over and switch over cases.
Applied missing archive logs that were not shipped to the standby database in Data Guard.
Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
Taking the RMAN incremental and cumulative backups.
Installed, Configured and Managed 11g Oracle Enterprise Manager (OEM) grid control for Performance, Administration and Maintenance of Databases. Successfully maintained multiple databases. Experienced in working with tools like TOAD.
Performed performance tuning by using Explain Plan, Tkprof, Statspack, AWR, ADDM and ASH.
Performed logical backup using traditional export/ import and Data Pump.
Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance.
Reorganized databases and Sizing of database objects for effective space management and optimal performance.
Modify database structures as required by developers due to business or application requirements, clone development databases for testing and training.
Partitioning tables by determining the suitable methodology to improve performance and manageability.
Created Materialized views, groups for performing SQL*Loader jobs for data loading and used DataPump jobs for loading the subscriber and history related data at replicated site.
Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
Managed and monitored grants, roles, privileges to users, analyzed tables to generate and gather stats using DBMS_STATS including verifying daily backup logs and alert logs.
Assisted developers in getting database connection from the client using SQL *net.
Assisted architecture team in redesigning application load balancing with addition of new node.
Developed many Batch code for Batch Processing Jobs and implement corn tab through shell scripting.
Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.
Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication, Audit vault, DB vault.
Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer.
Experience in cloning RAC databases using RMAN tool.
Designed and implemented backup and Disaster recovery strategies with RMAN.
Used Erwin tool to develop the data model with entities, relations, lookup tables. Identified attributes keys, foreign keys and candidate keys.
Proactively managed the databases, set up notifications/ alarms using shell scripts for managing any exceptions in day-to-day management of the databases.
Configure Oracle networking components such as the listener, TNS names and other connection protocols for the Oracle client.
Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
Regular DBA activities like database auditing, space management, database issues, locking, managing user groups, tuning, re-organization, re-building of Indexes.
Provided 24x7 on call production support.
Environment: Oracle 11g/10g, Linux, HP-UNIX Windows, RAC, ASM, DBCA, OEM Grid Control, HP Data Protector, Oracle Streams Data Guard, TOAD, GoldenGate, RMAN, VERITAS Net Backup, Data Pump, Tuning, Stats Pack, TKPROF, and SQL*Trace, AWR, ADDM, ASH, PL/SQL, Shell Scripting, SQL* Loader.
Client: Renaissance Venture Capital Fund, Ann Arbor, MI January 2011 to February 2012
Role: Oracle Database Administrator
Responsibilities:
Installed and Configured Oracle 10g/11g databases on Linux and also Upgraded Oracle databases from 10g to 11g.
Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEM Database Control to monitor database.
Involved in applying latest patches on the oracle database and also upgrading the database.
Converted a single instance database to Oracle RAC 10g.
Installation, Configuration and Administration of Oracle 10g/11g RAC.
Performed Add-Node procedure on a 2-Node RAC Cluster to add two additional nodes.
Managed and monitored the Oracle Real Application Cluster (4 node RAC) running on ASM storage.
Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
Created and Managed Standby Database. Installed and configured DataGuard.
Used DataGuard broker to monitor DataGuard configurations on standby database.
Good working and experience in implementing DataGuard and Stand-by databases for fail-over and recovery.
Used RMAN for backups and recovery and configured databases in Catalog server and involved in backup of Catalog database.
Scheduled Oracle Jobs USING DBMS_SCHEDULER and Backups using CRONTAB.
Restoration and Recovery of databases at the times of occurrence of critical failures.
Performed Block Recovery and Data file recovery using RMAN. Assisting in implementation of change control process in production.
Identified and fixed the logical block corruption using RMAN Involved in taking logical backup using Data pump Exp-dp and Imp-dp Utility.
Performed Data load on different databases from flat file using SQL*Loader.
Written Stored Procedures and Triggers for database maintenance and management using PL/SQL
UNIX Shell Scripts for backups.
Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports.
Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.
Configured Listener and TNSnames using NETCA for creating client-server environment.
Created tablespaces and added new data file to increase the size of the existing tablespace.
Creating users and granting appropriate roles and privileges to them to perform their regular tasks.
Day to day maintenance, troubleshooting and tuning of production Oracle database applications, daily monitoring and management network management software.
Provided On-Call 24x7 support for production databases.
Environment: Oracle 11g/10g, Linux, HP-UNIX Windows, RAC, ASM, DBCA, OEM Grid Control, HP Data Protector, Oracle Streams Data Guard, TOAD, GoldenGate, RMAN, VERITAS Net Backup, Data Pump, Tuning, Stats Pack, TKPROF, and SQL*Trace, AWR, ADDM, ASH, PL/SQL, Shell Scripting, SQL* Loader.
Client: ICICI Bank, Chennai, India May 2009 to December 2010
Role: Oracle Database Administrator
Responsibilities:
Installation and creation of 9i and 10g databases for Testing, Development, Production including configuration, backup & performance tuning.
Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually.
Responsible for network configuration and involved in a Client-Server environment using TNS Names, LISTENER, Net Configuration Assistant and other configuration files.
Skillfully used various built in packages like DBMS_OUTPUT, DBMS_SCHEDULER, DBMS_ALERTS and others.
Extensively used SQL* LOADER as a tool for loading data.
Involved in doing block recovery and backup validations using RMAN.
Implemented backup strategy using RMAN, Oracle Utilities (Export/Import) and OS methods.
SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.
Created and Managed users, user profiles, tablespaces, data files, archive log.
Created database links that are required for databases.
Tuning SGA, Rollback segments, Latch contention issues, Optimize sort operations.
Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment.
Involved in importing the production data to lower environments for testing purpose.
Monitoring database using EM grid control and taking proactive measures.
Creating UNIX scripts for automating various jobs.
Provided On-Call 24x7 support for production databases.
Environment: Oracle 9i/10g, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator, SQL, TKPROF, STATSPACK, ASM, AWR, ADDM, Data Pump, RMAN, RAC.
Client: Syniverse Technologies, Hyderabad, India June 2008 to April 2009
Role: Oracle Database Administrator
Responsibilities:
Installed and Configured Oracle 9i database for Testing, Development, Production including configuration, backup & performance tuning.
Created and configured database manually using Oracle Database Configuration Assistant.
Worked on Oracle 9i OEM for regular database management.
Installed and maintained standby databases.
Wrote PL/SQL procedures and triggers to carry out database maintenance tasks.
Applied patches whenever necessary by downloading them from Metalink.
Used EXPORT/IMPORT to do table level and full database imports as per application team requirements.
Created materialized views and snapshots for high end application usage.
Created and used different types of sequences and indexes.
Planning, Installation and Configuration of Oracle 9i on Sun Solaris and Windows 2000 Server.
Performance tuning of database using stats pack reports.
Backup and Recovery operations over all databases, ensuring 100% recoverability using RMAN.
Wrote control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
Created Table space, Data files, Indexes and monitoring them.
Administering database security, Creating Users and granting/revoking roles and privileges.
Multiplexing control files and redo logs for database security.
Designed and created schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
Created UNIX shell scripts to automate batch jobs.
Worked as a member of production DBA team in perfect coordination with seniors and team members
Environment: Oracle 9i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, RMAN, SQL*LOADER, Tuning, Export/Import, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.
Contact this candidate