SUMMARY:

• 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, StatsPack, Export/Import, RMAN, Toad, SQL Navigator, Veritas NetBackup, Log Dump, dB visualizer
• TCP/IP, SFTP, TELNET, HTTP, SSL, SSH
• Microsoft Office/Works

PROFESSIONAL EXPERIENCE:

Oracle RAC DBA

• Architecting, planning, designing, developing, deploying and supporting 12C/11g Oracle RAC, 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.
• Extensive use 12C Grid control, shell scripting, OS watcher 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.

Confidential

Oracle DBA/DB2 Administrator

• 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.