Manager Data

Ahmad

Email: **********@*****.***

Phone: 317-***-****

Oracle DBA

SUMMARY:

9+ years of experience in Oracle database administration, system Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions.

Experience in upgrading database from 11g to 12c to 18c to 19c.

Experience in working with 18c databases.

Proficient in oracle dictionary and oracle dynamic views.

Managed and administered databases from command line and 12c/13c OEM.

Expertise in Installation, Configuration, Patching, Migration, Trouble shooting and Performance.

Tuning of oracle databases on UNIX, LINUX and Windows environments.

Built, configured and managed multi node RAC Cluster on RHEL.

Build RAC Clusters from scratch including deployment of Linux operating system.

Experienced with tools/utilities: OEM, RMAN, Statspack, TOAD, SQL Navigator, SQL* Loader and Data Pump.

Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.

Experience in datacenter migration.

Supporting development 24/7 production systems. Providing on call support for mission critical applications.

Performing backups and crash recoveries using conventional hot/cold backups and RMAN.

Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.

Maintained databases upto Exadata X7.

Proficient in writing UNIX Shell scripts to automate business process and daily backup.

Vast Experience with RMAN to implement Backup/Recovery strategies.

Clone databases using RMAN Duplicate.

Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL * Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD.

Experience with setting up and managing standby database using Data Guard.

Intensively used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases.

Good knowledge of Flashback Technology, Flash recovery Area, Automatic Storage management (ASM).

Tune queries using SQL Plan, SQL profiler, Baseline etc.

Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.

Worked on SQL Server 2008 and 2012.

Experience with installing and maintaining Oracle 13c Cloud Control.

Build and managed ASM Disks and Disk groups.

Migrated non-ASM database to ASM.

Experienced in RAID, storage technologies and backup solutions.

Supported the system 24x7. Ability to work beyond regular hours.

Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, and volatility of the data, recovery time allowed etc.

Implemented data replication through materialized views.

Refresh database objects using Data Pump.

Good experience in SQL, PL/SQL, Shell Scripting.

Experience in Data Modeling using Data modeling tools such as Erwin and Toad.

Experience in using 11g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Grid Control.

Skilled in setting up/Installation and configuration of release 11g RAC R2 with ASM and Raw Devices.

TECHNICAL SKILLS:

Operating Systems:

Windows NT/2000/XP, Sun Solaris, HPUX, Red hat Linux, AIX

Languages:

SQL, PL-SQL

RDBMS:

Oracle 18c/19c/12c/11g/10g/9i, MS Access, MS SQL Server 2000, DB2

Tuning Tools:

TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADD

Tools:

RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Patch Management, SQLNET, ODBC Export/Import, Data pump, Data Guard, VERITAS Net Backup, VMware,Exadata,Golden Gate,AWS

EXPERIENCE:

TCF Bank Cincinnati, OH

Oracle DBA

Jul 2017 – Present

Responsibilities:

Involved in 24x7 supports for production RAC databases with on-call pager.

Supported production, development and testing databases of Multi Terabytes DB sizes.

Configuration, troubleshooting Golden Gate issues.

Setup Uni-directional Golden Gate setup.

Setup and managed replication using Oracle Golden Gate.

Worked on Data Migration project.

Migrated databases from Windows platform to Linux.

Upgraded Databases from 11g to 12C to 18c to 19c

Applied patches as per security need and bug fixes.

Worked extensively on datacenter migrations on multiple database versions

Database migration from 11g to 18c

Migrating database from NON-ASM to ASM.

Migrated databases to AWS.

Build new servers on AWS.

Worked on project to migrate databases to AWS instance.

Set up oracle instances on AWS cloud.

Maintained databases and alerts from 13c cloud control (OEM).

Migrated standalone databases to RAC on Exadata.

Worked on 12c Multitenant databases.

Setup unidirectional Golden Gate replication.

Rolling install oracle patch in Oracle RAC 11g,12c and 13c

Upgraded database from 11g to 12c R2.

Cloned databases using RMAN Duplicate.

Installation of 11g, 12c clients/databases on Solaris and Linux.

Complete Build of 4-node 12c RAC Cluster on RHEL.

Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.

Used Performance tuning tools such as tkprof, explain plans, oracle bug and trace files to tune SQL Queries.

Performed database cloning to setup test and development database.

Migrated databases to different data datacenter.

Handled RAC Node hangs and node eviction issues.

Maintaining schemas and partitioning tables.

Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.

Index management for better performance, maintenance of Oracle Database.

Developed RMAN scripts for database backup and recovery.

Created, upgraded, and cloned Oracle databases for Development and testing databases.

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.

Performed large batch jobs and tuning of SQL queries and database systems.

Created indexes to facilitate easy user interface implementation and tuning.

Implemented advanced features of Oracle 11g such as Automatic Database Diagnostic

Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

Performed administrative maintenance, monitoring on Oracle database systems in a global.

Provided 24x7 operational supports.

Involved in gathering requirements from end users.

CVS Pharmacy Charlotte, NC

Oracle DBA

June 2014 – Jun 2017

Responsibilities:

Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.

Maintaining databases from all the environments from all pre-production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.

Have a good knowledge in Exadata.

Performed Silent installation on Exadata.

Applied patches on computer nodes, Exadata home and storage cells.

Migrated standalone databases to Exadata.

Implement disaster recovery with use of Exadata.

Experienced in ORACLE 11g and 12c installation, configuration, and upgrading.

Upgraded databases 11g to 12c.

Experience with rolling upgrade to Oracle 11g RAC.

Installation, Configuration, Upgrading, Migration and Maintenance.

Configure, maintain and deploy the Data Guard and grid control.

Installing and maintaining Oracle GRID CONTROL.

Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.

Worked extensively on Oracle Streams.

System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.

Worked with lead DBAs for preparing cluster, configuring, installing Clusterware and Oracle

11g RAC on AIX and HACMP.

Troubleshoot OCFS2 install issues and working with Enterprise Manager.

Design and implement Auditing and other security features for the existing Production systems.

Raised SR and TAR with Oracle Support.

Used Oracle Enterprise Manager (OEM) for administering several databases.

Backup of database Logical and Physical (hot and cold) procedures and using RMAN.

Restore and Recovery of database in case of database crash, disk/media failure.

Applying patches and works closely with Oracle to make Application environment up to date.

Backups & Recovery Maintenance, Databases Performance Tuning.

Typically involved in database Designing, creation and maintenance.

Good working knowledge of SQL, PL/SQL, and shell scripting.

Created users and grant privileges according to the requirements.

Working knowledge on UNIX administration on AIX server.

Provided System support for both development and 24*7 production environments.

Performed automated backups and scheduling using scripting.

Responsible for migration of databases.

Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.

Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.

Involved in designing logical and physical data models using Erwin.

Working Experience with Latest TOAD having new features PL/SQL & SQL Script Debugger, Database Health.

Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace and Query Builder.

Created indexes to facilitate easy user interface implementation and tuning.

Automatic Workload Repository (AWR) for monitoring database performance.

Tested database performance issues (monitoring and tuning) to ensure database optimization.

Fiserv, Menomonee Falls, WI

Oracle DBA

March 2011 – Jun 2014

Responsibilities:

Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.

Maintaining databases from all the environments from all pre-production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.

Experienced in ORACLE 10g installation, configuration, and upgrading.

Experience with rolling upgrade to Oracle 11G RAC.

System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.

Worked with lead DBAs for preparing cluster, configuring, installing Cluster ware and Oracle.

10g RAC on AIX and HACMP.

Installation, Configuration, Upgrading, Migration and Maintenance.

Configure, maintain and deploy the Data Guard and grid control.

Installing and maintaining Oracle GRID CONTROL.

Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.

Worked extensively on Oracle Streams.

Troubleshoot OCFS2 install issues and working with Enterprise Manager.

Design and implement Auditing and other security features for the existing Production systems.

Raised SR and TAR with Oracle Support.

Used Oracle Enterprise Manager (OEM) for administering several databases.

Backup of database Logical and Physical (hot and cold) procedures and using RMAN.

Migration from Linux to Solaris and 32 bit to 64 bit.

Restore and Recovery of database in case of database crash, disk/media failure.

Applying patches and works closely with Oracle to make Application environment up to date.

Backups & Recovery Maintenance, Databases Performance Tuning.

Typically involved in database Designing, creation and maintenance.

Good working knowledge of SQL, PL/SQL, and shell scripting.

Created users and grant privileges according to the requirements.

Working knowledge on UNIX administration on AIX server.

Provided System support for both development and 24*7 production environments.

Performed automated backups and scheduling using scripting.

Responsible for migration of databases.

Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.

Involved in designing logical and physical data models using Erwin.

Education: Bachelors

References: Available upon request

Contact this candidate