Ahmed Modi

Oracle Database Administrator

614-***-****

adi99r@r.postjobfree.com

PROFESSIONAL SUMMARY

An Accomplished Oracle Database Administrator, and an expert in IT security with over 8 years of experience with extensive knowledge, proficiency, and expertise in Monitoring & Tuning, Migration, Security Implementation, HIPAA, Cloning, Backup & Recovery, Replication. Adept in an assortment of technologies, including Oracle 10g, 11g, 12c, SQL loader, MySQL, and MS SQL server. Possesses remarkable verbal, written, analytical and organizational abilities; with Motivational Management style, and a penchant for building, and retaining, teams that are highly motivated to find innovative solutions. Passionate learner who gracefully and successfully manages multiple priorities and performs exceptionally well under pressure.

TECHNICAL SKILLS AND TOOLS

Installation, configuration and update of

Oracle 11g and 12c using OUI, DBCA,

DBUA.

Monitoring and performance tuning using OEM Console, Toad SQL Developer, Grid Control, TkProf, Explain plan, Statspack/

AWR, ADRCI, ADDM, DRA, Dbms monitor Alert Log, SQL Tuning Advisor, SQL Access Advisor.

Work with Various OS like MS Windows

Servers (2008, 2012, 2014), UNIX, Solaris

8.9.10, LINUX (Red Hat, Ubuntu, Centos)

Backup & Recovery using RMAN

SQL, PL/SQL, UNIX Shell Scripting

Oracle ASM (Clusters) and RAC

Configuration and Administration

Configuration and Administration

Oracle Golden Gate (Data Replication)

Database Security using TDE, Data

Masking, Patching, Data Redaction

Oracle Data Guard

Installation/administration for high

Availability and Disaster Recovery (DR)

Database migration using

Exp/Imp/DataPump, and SQL Loader,

Transportable Tablespaces (TTS)

AREAS OF EXPERTISE

Backup & Recovery

Upgrades & Migration

Database

Database Security & Patching

Transparent Data Encryption (TDE)

Performance Monitoring & Tuning

Installation and Configuration

Capacity Planning

Oracle ASM

SQL Server

Oracle EBS

Grid Control

Oracle Data Guard & Data Pump

Bash/Unix Shell scripting-Automation

Database Cloning

Security

Oracle Application

PL/SQL

IBM Maximo

PROFESSIONAL EXPERIENCE

Sr. Oracle Database Administrator US. BANK Columbus, OH FEB 2018 – PRESENT

Rewrite and implement backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. I also use block change tracking (BCT) which reduced backup time from 8hrs down to 45mins.

Deploy Database security policy and installation, using passwords, privileges and user profiles, Use Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implement the “triple A” (AAA) and database auditing policies as well as data redaction.

Manage database security by creating, assigning appropriate roles & privileges to users depending on user activity, auditing, & performing other security related tasks including Transparent Data Encryption.

Clone databases using RMAN and DATAPUMP utilities for all database sizes.

Extensively using AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.

Monitoring AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS_STATS, Trace Files, System Event Logs for unusual events & took appropriate action according to company policies of incident reports.

Capacity planning (support 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.

Install and administrate Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD).

Capacity planning to meet the demands of the dynamic aspects of storage & memory for the databases.

Perform database Refresh from production environments.

Implementing table and index partitioning to Minimize DB time, increase disk load balancing improving query speed and enable faster parallel query.

Strong time management skills with willingness and ability to prioritize multiple projects/initiatives at the same time.

Successfully migrated all our databases on 11g R2 version 11.2.0.4 to 12c R2 and we basically used datapump and DB upgrade assistant (DBUA) for the process

Part of the on-call production support team for 24/7 on-call production support.

Database Administrator NETJETS Columbus, OH JUN 2016 – JAN 2018

Installed, configured, and upgrade Oracle server database management software using appropriate patches and applications.

Facilitate a wide range of migrations, upgrades, and conversions adhering to applicable backup and recovery protocol.

Monitor and maintain the health of architected databases and database server environments.

Implement and Integrate performance tuning and security features to optimize functionality.

Prepare and maintain database documentation and standards to bolster user management and acceptance activities.

Experienced in data encryption using Oracle TDE to protect the organization’s critical Information and exceeding the Industry standard.

In-depth understanding of security and backup procedures to ensure database integrity.

Experience with various tools, such as SQL*Loader, SQL, RMAN, PL/SQL.

User Management, creation, monitoring and management of database users. Altering passwords and granting/revoking access to system/object privileges, roles and auditing user actions.

Junior Database Administrator KEY BANK Brooklyn, OH APR 2013 – MAY 2016

Performed monthly and annual performance reports for trend analysis and capacity planning.

Successfully installed and configured Oracle 11.1.0.7 Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.

successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Data pump, conventional export/import utility of Oracle 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Database monitoring/maintenance, replication process and performance tuning using.

OEM Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Install and administered GOLDEN GATE in a unidirectional, bidirectional, and broadcast configuration to mainly replicate data and ensure high availability, in a heterogeneous environment, also worked with EXADATA Machines for high performance and availability.

Involved in the installation, configuration and extended support to Oracle 10g two Node RAC with ASM file system on Sun Solaris platform.

Involved in converting a single instance database to Oracle 10g RAC databases.

Education

Franklin University

Bachelor of Computer Science - BS

Certifications

CompTIA Security+ SYO-051

Oracle Certified Associate (OCA)

AWS Certified Solutions Architect – In progress

Contact this candidate