PROFESSIONAL SUMMARY:

• I am a great achiever who can successfully manage multiple priorities and perform under pressure tremendously.
• Accomplished DBA Administrator, currently working on for ORACLE Database Administrator. worked on very large production databases performing various DBA roles with in - depth knowledge and proficiency in backup & recovery, security implementations, database design, monitoring & tuning, migration, upgrades, cloning, and replication.
• I am also proficient in an assortment of technologies including Oracle 10g, 11g 12c, MySQL and MS SQL Server across a multitude of platforms (Red Hat Enterprise Linux, Solaris, Unix, and Windows) in production, testing, and development environments.
• I possess extraordinary written, verbal, analytical and organizational abilities.
• I am a proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions.

AREAS OF EXPERTISE INCLUDE:

• Oracle Data Guard & Data Pump
• Oracle ASM
• Grid Contro
• Database Cloning
• Database Security & Patching
• Backup & Recovery
• Transparent Data Encryption (TDE)
• Performance Monitoring & Tuning
• Bash/Unix Shell scripting & Automation
• Oracle Golden Gate & Replication
• Installation, configuration, capacity planning

TECHNICAL SKILLS AND TOOLS

• Oracle Data Guard installation/administration for High availability and Disaster Recovery (DR)
• MS SQL Server Management Studio
• SQL, PL/SQL, UNIX Shell Scripting Installation, configuration and update of Oracle 11g and 12c using OUI, DBCA & DBUA
• Database Security
• Backup & Recovery using RMAN
• Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Grid Control, Explain Plan, AWR, ADDM, & DRA
• Oracle Golden Gate (Data Replication)
• Database migration using Exp/Imp/Data pump, and SQL Loader
• Oracle ASM (clusters) and RAC configuration and administration
• Oracle VM Virtual Box
• Work with various operating systems like
• MS Windows Servers (2008, 2012, 2014)UNIX (Solaris 8/9/10), LINUX (Red HatUbuntu, Centos). Mongo DB.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas Texas

Responsibilities:

• Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. I also used block change tracking (BCT) which reduced backup time from 8hrs down to 45mins.
• Deployed Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented the “triple A” (AAA) and database auditing policies as well as data redaction.
• Managed database security by creating, assigning appropriate roles & privileges to users depending on user activity, auditing, & performing other security related tasks including Transparent Data Encryption.
• Cloned databases using DATAPUMP and RMAN utilities for all database sizes.
• Extensively used AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.
• Monitored 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.
• Experience migrating database objects from development through test & into production environments.
• Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability and disaster relief solution (DATA GUARD).
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for dynamic aspects of storage, memory and growth potential and analyze data growth trends for capacity and resources for the databases.
• Implement table and index partitioning so as to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.
• Conducted quarterly Critical patch updates as well as RMAN backups using oracle suggested strategy methods and other similar types. Initiated database performance tuning and application support

Confidential, MD

Responsibilities:

• Supported daily administration, monitored, tuned and troubleshooted on single instance on Unix/Linux, Windows server 2011 and 2015 (Database sizes ranged from 100GB to 90 TB).
• Implemented a backup and recovery policy under tight SLA times using RMAN and Data Pump.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development & implementation.
• Championed database migration from 10g to 11g as well as 11g to 12c using the Oracle DataPump and DBUA utilities respectively.
• Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2011 and 2015.
• Used range, hash and composite table partitioning which greatly decreased the DB time and SQL Execution time. Also performed instance tuning by changing init.ora parameters and managed region parameters such as shared pool size and db cache size with the use of automatic memory management (AMM) and ASMM.
• Experienced migrating database objects from development through test and into production environments.
• Maintained Database security policy and installation, using passwords, privileges and user profiles. Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented the “triple A” (AAA) and database auditing policies as well as data redaction.
• Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
• Installed and administered GOLDEN GATE software on Unix/Linux platform for both in a unidirectional, bidirectional, and broadcast configuration to mainly replicate data and ensure high availability, in a heterogenous environment, also worked with ORACLE EXADATA Machines X4-2 for extreme performance and high availability of the database.
• Configured Oracle tools like SQL*Net to access the database across the network
• Configured and managed ASM instances on Oracle 11g and 12c.
• Worked in a cross functional team that overseen the Oracle RAC installation & configuration for Linux environments.
• Applied Oracle's quarterly Critical Patch Update (CPU/application) using Opatch utility to install, test, and deploy patches to all database instances.
• Supported daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2011 and 20015 (Database sizes range 100GB to 21TB).

Confidential, MD

Responsibilities:

• Successfully installed and configured Oracle 11.1.0.7 Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Performed monthly and annual performance reports for trend analysis and capacity planning.
• Involved in the installation, configuration and extended support to Oracle 10g two Node RAC with ASM file system on Sun Solaris platform.
• 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 explained plan for periodic performance tuning.
• Implemented Datapump, 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, and backups by developing UNIX scripts.
• Considered reoccurring problems within the structure of a business, brainstormed potential solutions and implemented software change
• Administered a Mongo DB to create, update, delete and read documents, in a limited role.