Citizenship/Background Investigation Level:

U.S. Citizen, Public Trust

Position / Years in the profession:

Database Administrator, 17 years of total IT experience with 9 years as an Oracle DBA

Professional Accomplishments, Certifications, Education and Training, Awards,  and Active Memberships:

§  B.S., Computer Science and Engineering.

§  Oracle Database 12C Administrator Certified Professional (OCP)

§  Oracle RAC 11g and Grid Infrastructure Certified Expert (OCE)

Experience relevant to  Database Administration Services Task Order:

§  Specializing in Oracle HA (highly available) database environments & solutions such as RAC, Exadata, DataGaurd and Golden Gate database replication (active/passive & active/active).

§  Experience in Linux, SUN SOLARIS, AIX, and Windows environments.

§  Excellent experience in Installation and configuration of Oracle 9i, 10g,11g,12c on Sun Solaris, Linux and Windows environment.

§  Experienced in GoldenGate Install, Configuration, Maintenance, Trouble Shooting and Upgrade.

§  Experience in applying patches for upgrades and various problems.

§  Experienced in implementing ASM for data storage and raw devices for clusterware files in RAC environments.

§  Extensive Experience in designing and maintaining Oracle Database in Clustered environment (RAC) on both Windows and Unix.

§  Great depth of knowledge in planning and implementing physical and logical structures of a very small database to very large database.

§  Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g RAC environment.

§  Configured RMAN for full and incremental backups and used RMAN to create standby databases, for recovery, to migrate database from file system to ASM

§  Experienced in using 11g features Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, ASMM, Grid control, and Recycle Bin.

§  Created and Managed Production database as well as Development/Test environments using tools like OEM, Performance Pack, SQL Navigator, TOAD, PL/SQL and SQL*Loader.

§  Plan, Implement and test disaster recovery using RMAN and custom written shell scripts.

§  Create and maintain oracle Data Guard configuration for disaster recovery and to manage planned maintenance.

§  Strong working experience in Install/Upgrade and Migration, troubleshooting of Oracle script files creation (using SQL, PL/SQL) for creating, maintaining, tuning the database, tuning the parameters as and when the situation demanded.

§  Database monitoring and tuning, application and queries using AWR,ASH,ADDM, OEM  and custom scripts.

§  Experience in taking logical backups of data using oracle data pump utilities expdp and impdp to move Oracle data from a database or schema to another.

§  Good exposure to data transfer using advanced features like Transportable tablespace in export/import utility tools.

§  Worked as a team member to provide 24x7 on-call production database support.

Technical Skills:

§  IBM AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Linux, Oracle VM Server, VMware and Windows XP/7 ,  SUSE Linux ,Exadata X5-2

§  SQL and PL/SQL, SHELL programming, SED/AWK.

§  Oracle 9.x ,10.x and 11.x,12.x, DB2

§  Oracle DBA Support for Oracle 11i and Enterprise Applications

§  Veritas Cluster, Oracle Cluster ware and OCFS.

§  Oracle 9i/10g/11i/12C RAC, Standby Database, Advanced Replication, Oracle Streams, Clustering and Data Guard Setup, Automatic Storage Management and Configuration and Tuning and Materialized Views

§  Golden Gate, Oracle Streams and Oracle Advanced Replication

§  Erwin, Toad, Formatter Plus, PLSQL Developer and SQL Tools.

§  Oracle Enterprise Manager, 12C Grid,  Stats Pack, Export/Import, RMAN, Toad, SQL Navigator, Veritas NetBackup ,Log Dump, dB visualizer

§  TCP/IP, SFTP, TELNET, HTTP, SSL, SSH

§  Microsoft Office/Works

Relevant Experience

Oracle RAC/GoldenGate  DBA

November 2012 - Present

Ø  Architecting, planning, designing, developing, deploying and supporting 12C/11g Oracle RAC, ASM Flex, Exadata, Golden Gate, Streams, DataGaurd and ASM environments.

Ø  Performance tuning on queries that were poorly performing to identify ways to improve response time and through put.

Ø  Upgraded Oracle 11G RAC databases to 12C RAC with Zero down time method using Golden Gate.

Ø  Create High Availability 11g and 12c RAC Linux clusters (ranging from 2 to 6 nodes) utilizing Data

Guard in compliance with Oracle's Maximum Availability Architecture (MAA).

Ø  Implemented DataGaurd (Standby) for high availability/disaster recovery purpose and configured the database to Switchover and failover.

Ø  Performed database and SQL tuning troubleshooting using AWR, ASH and ADDM on Real Application cluster.

Ø  Migration from AIX Oracle database to Exadata.

Ø  Administration of Oracle Active Dataguard Physical standby.

Ø  Zero Downtime Migration to Oracle Exadata with Oracle GoldenGate

Ø  Replaced Oracle Streams to Golden Gate with Zero downtime.

Ø  Configured bi-directional Replication using Golden Gate Integrated capture and Integrated Apply.

Ø  Configured Golden Gate Active-Active Replication with Conflict Detection and Resolution (CDR).

Ø  Performed POC for testing DDL and DML replication across Databases.

Ø  Configured Golden Gate Replication for 15TB data from Oracle Databases to Bigdata.

Ø  Involved on NIC failover/Application FCF testing on Oracle 11g RAC.

Ø  Investigate Replication failures using Golden Gate LogDump utility.

Ø  Installed and configured Oracle 12c RAC with Flex ASM and ACFS shared storage for Golden Gate.

Ø  Extensive use 12C Grid control, shell scripting, OS watcher, SQLT and other analytical tools to performance tune mission-critical Production environments.

Ø  Setup backup and recovery procedures using RMAN.

Ø  24X7 Support of several Oracle RAC OLTP databases on ASM.

Verizon Business

Oracle DBA/DB2 Administrator

September 1999 – November 2012

Verizon provides communications, information, and entertainment products and services to consumers, businesses, and governmental agencies worldwide I am an active member of Customer Care DBA group that has been vested with an important task of managing Databases related to core applications critical to business. As a member of this group I had been actively and proactively supporting various online and in-house applications such as ACSS - Automated Customer Support System, IVR, and Prime Biller, Single View and express Trak and providing administrative support for oracle stand-alone databases and RAC environments

Ø  24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Ø  Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose.Upgrade of Databases from 10g to 11g.

Ø  Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.

Ø  Installed and configured Oracle 10g/11g RAC high availability.

Ø  Installation of Oracle cluster ware, Configuring public(SCAN) and private network and VIP

Ø  Experienced with SRVCTL, OCR and Voting Disk of 10g/11g RAC

Ø  Installed and configured all components of the 10g Application Server on Solaris environment.

Ø  Scheduling maintenance and health check of the application and databases using dbms_scheduler.

Ø  Proactively monitoring, identifying areas that need to be improved in the application and database using StatsPack, AWR, ADDM.

Ø  Implemented flash back technology with ASM option to use alternative ways for point in time recovery and to reduce recovery time in the situation of database crash.

Ø  Determine possible backup, restoration and recovery strategy using RMAN (level 0 and level 1 backup) and incremental updated backup.

Ø  Administration of Oracle Dataguard Physical standby.

Ø  Recovery and Cloning of databases using RMAN  with VERITAS Net Backup

Ø  Used Data Pump utilities like expdp/impdp for logical backup.

Ø  Developed UNIX shell scripts and setting up cronjobs that automate database monitoring.

Ø  Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.

Ø  Implemented database auditing, data security and Remediate high-risk violation in production environment.

Ø  Performance Tuning for long running queries using TOAD, STATSPACK, AWR reports, analyze, DBMS_STATS, SQL trace, explain plan. Re-designing of tables into partitioning tables. Analyzing existing table structures and fine tuning if required

Ø  Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand-alone instances.

Ø  Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Ø  Gathering schema stats and monitoring the index usage.

Ø  Provided all kinds of DBA support to development teams as well as production support to various applications.

Ø  Responsible for setting and managing user accounts, and granting required privileges to users.

Ø  Provided 24x7 on-call support for the production databases.

Ø  Served as the DB2 DBA for the development, installation, and support of all online applications including implementation of various Amex projects.

Ø  Designed and documented monthly updates load process and scripts.

Ø  Installation of DB2 instances on AIX.

Ø  Excellent experience working on multi node environment with database sizes ranging from a few GB to multi terabytes.

Ø  Performing tasks for DASD projections/revisions, index analysis, review explains, and table partitioning strategy for DB2 on Z/OS.

Ø  Defining procedures, triggers and resolving issues on performance, backup/recovery, data integrity, database availability and other requirements for DB2 and IMS.

Ø  Build data refresh procedures for Model office and training subsystem databases.

Ø  Extensive use of Platinum tools RC/Update, Log Analyzer, Plan Analyzer, Boole and Babbage, IBM's MVS and DB2 utilities to manage the DB2 and IMS objects.

Ø  Participated with Data conversion team for converting legacy Data.

Ø  Implemented a Disaster Recovery Solution for the database.

Ø  Did capacity planning for the existing database when the data was supposed to increase and new schemas added.

Ø  Implemented db2 fixpaks and did migrations, client installations and upgrades.

Ø  Altered tables and added check constraints and referential integrity

Ø  Created and maintained databases, tablespaces, tables, views, Stored Procedures, Triggers and indexes

Ø  Interact with business team and development teams for incorporating new functionality

Ø  Participated in enterprise-wide application and database production releases

Ø  Developed shell scripts to handle DBA tasks and alerting systems

Ø  Documented plans and procedures in terms of backups, restores and disaster recovery

Ø  Data maintenance activities like REORG, RUNSTATS, LOAD, UNLOAD, IMPORT and EXPORT

Ø  Tuning application queries, databases and systems for best performance

Ø  Performed performance tuning and capacity planning using the parameters of dbm configuration file & db configuration file and various db snapshots

Ø  Achieved great performance improvement by migrating to p690, lesser maintenance. Down time and maintenance window was reduced.

Ø  Collaborated with developers to devise DDL and DML, in addition to contribution to code walk-thru's to analyze SQL code efficiency.

Ø  Ensured that developers adhered to standards during program preparation and implementation by assessing program SQL, verifying efficient access path, giving security access, and providing support.

Ø  Extensive DB2 DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.

Ø  Migrating data from DB2 7.1 to DB2 8.2.

Ø  Performance monitoring and tuning for DB2 databases

Ø  Creating EXPLAIN tables and running the visual explain utility on SQL statements.

Ø  Production support to various db servers and participated in On-Call rotation on weekly basis

Ø  Configured and implemented the server including setting up the database filesystems (with sudo root access privileges) and implemented the full physical design.