SUMMARY:

Senior Oracle Database Administrator with a little over 9 years of experience. I have worked on different Versions of Oracle including 10g, 11g and 12c across several OS platforms such as Linux, UNIX, Solaris and Windows. I have successfully provided innovative and solution - oriented database administration with a track record of success. With a team of dedicated DBAs, I contribute to the solutions of daily challenges of database administration with the ability to effectively communicate, prioritize and meet deadlines.

CORE EXPERTISE INCLUDE:

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

TECHNICALS TOOLS AND SKILLS:

• Work with various operating systems like Windows, UNIX, Solaris, LINUX (Red Hat).
• Database security (TDE)
• Backup & Recovery using RMAN
• Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Grid Control, Explain Plan, AWR, ADDM, & DRA
• Database migration using Exp/Imp/Data pump, and SQL Loader
• Oracle ASM (clusters) and RAC configuration and administration
• Oracle Golden Gate (Data Replication)
• Oracle Data Guard installation/administration for High availability & Disaster Recovery(DR)
• SQL, PL/SQL, UNIX Shell Scripting
• Installation, configuration and update of Oracle 10g,11g, 12c, using OUI, DBCA, DBUA

PROFESSIONAL EXPERIENCE:

Confidential, Odenton, MD

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 RMAN and DATAPUMP 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, and 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.
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.
• Installed and administered 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.
• Performed database Refreshes from production environments.
• Implement table and index partitioning so as to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query

Confidential

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 11g to 112c.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Responsible for all database activities such as User management, space management, database security management.
• Implemented the resizing the online redo logs in production and in standby database.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs

Confidential

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 significantly
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures on daily basis using CRON tab.
• Cloned databases using RMAN and DATAPUMP utilities for all database sizes.
• 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, monitoring and auditing user access rights and privileges through their roles and profiles. Performing other security related tasks including Transparent Data Encryption.
• Extensively used AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.
• Generated and automated Statspack/AWR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth. Also monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, and 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. Refreshing both Development and Test instances with data from Production on a regular basis
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.
• Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability using Data Guard Broker and active Data Guard for faster Disaster Recovery Solution (DATA GUARD).
• Capacity planning to meet the demands of the dynamic aspects of storage & memory 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
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures on daily basis using crontab.
• Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Creating, granting and monitoring user access rights and privileges through roles and profiles.
• Providing instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage with the help of AWR and ADDM Reports.
• Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)
• Applying upgrade patch using OPatch for maintenance and interim patches on all the databases.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Performing housekeeping tasks like checking log and trace files.