PROFESSIONAL SUMMARY

• 8+ years of experience in Information Technology in various roles, my experience has scaled in providing client support, analysis, designing, testing, development, installation, migration, maintenance, Replication, Database Security, RMAN, User management, Performance tuning and monitoring the database using
• OEM Grid Control, and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup & recovery, cloning, and space management, shell scripting using ORACLE 12c/11g/10g/9i, performing the role of Oracle Database Administrator according to the set standards and timelines, Install and configure Container and Non - Container 12c databases, Pluggable databases -
• Architecture, Installation and the concepts associated with 12C database. Convert Non-CDB to Pluggable database.
• Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Configured multiple database instances using ASM instance.
• Troubleshoot performance issues for the RAC instances.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files
• Providing DBA support to multiple Cluster, Non-Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX &Windows Environments.
• Resolved/Diagnose Node Eviction.Add or Remove Node from RAC.
• Configured ACFS and performed RAC health checks.
• Configured and maintained physical standby databases using Oracle DATA GUARD to perform quick disaster recovery.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases.
• Experience in Uni-directional, Bi-directional and Integrated Capture data replication using Golden Gate.
• Configured Replication between different structured Target and source with DEFGEN and COLMAP.
• Experience in using GoldenGate to support data replication monitoring, tuning and capacity planning.
• Data Guard setup with Primary and Standby Databases.
• Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate
• Error handling for restart, logging, production support and status reporting in Golden Gate
• Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Implemented Golden Gate for replication and data migration for Oracle 11gR1 RAC multi nodes on IBM, AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Experience in configuring Golden Gate director for alerts monitoring.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported many Development Databases.
• Golden gate monitoring was done using the cronjobs, where it does report a mail in case of a process a bend or Lag more than threshold and any Checkpoint.
• Worked on Shell Scripts for the GoldenGate monitoring and Trail file system size.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x

RDBMS: Oracle 12c/11g/10g/, Oracle 12c/11g Real Application Cluster (RAC), ASM

Tools and Utilities: RMAN, OEM 13c/12c/11g/10g, TOAD, SQL*Loader, Export/Import, Data pump, Web logic Server, Log dump, Defgen, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations

Languages: C, SQL, PL/SQL, UNIX/NT Shell Scripting.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Ticketing Tools: BMC Remedy, JIRA, NEWS, Service Now

PROFESSIONAL EXPERIENCE

Confidential, Brooklyn, NY

Sr. Oracle Database Administrator

Responsibilities:

• Installed, configured and maintainedOracle 11GR2Real Application Cluster (RAC)4 node RAC on EXADATA X2-2 HALF RACK.
• Installed, configured and maintained Oracle Database 12c.
• Deploy the 12c agents on the target servers and add the target Configuration Items to monitor.
• Plug-in installations on the target servers to extend the functionality of OEM.
• Configure Oracle Advanced Security to implement Transparent Data Encryption at table space, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Setup physical standby’s (DATAGUARD) for several Databases (via OEM as well).
• Implemented DBFS on EXADATA.
• Implemented PARTITIONING using EXCHANGE PARTITION method to improve the performance of the database
• Maintained Data guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Configured disaster recovery databases using Data guard and worked on 11g new feature active data guard
• Converted physical standby databases to snapshot stand by, performed manual switchovers to DR servers.
• Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status
• Upgrade existing 10g/11g databases to 12.1.0.1 on HP database machine using transportable table space method. Upgraded supported versions using DBUA (direct path upgrade).
• Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.
• Capacity planning for the projects owned in the environment.
• Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate.
• Performing the initial load using (expdp and impdp) from source to target.
• Golden Gate performance issues were resolved by splitting the process into subsets, so that performance is improved.
• Troubleshooting Golden Gate process abends, analyzing report files, error log file and discard files.
• Worked on Log dump utility of Golden Gate.
• Performed skipping the transactions which are not necessary using logdump utility.
• Good at altering the Rba for replica during the troubleshoot of Golden Gate based on the transaction type and not missing any transactions.
• Maintenance of Golden Gate process during the batch loads.
• Golden Gate monitoring was done using the cronjobs, where it does report a mail in case of a process abend or Lag more than threshold and any Checkpoint.
• Worked on Shell Scripts for the Golden Gate monitoring and Trail file system size alerts.
• Implement performance monitoring and database tuning using different tools such as SQL Profiler, Database Tuning Advisor and SQL Execution Plan.
• Create, modify, monitor, rebuild and reorganize Indexes (Clustered/Non-Clustered), Constraints (Unique/Check), Views etc.
• Worked on Adding and removing targets to OEM 12c.
• Implement Oracle Multimedia and Text options.
• Backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and for full database backups using data pump.
• Good experience with OVD and resolving connection Issues, registering and removing databases from OVD.
• Database Installation, Upgrades and Patching. Upgrade the binaries by applying patch set and interim patches using opatch and opatch Auto.
• Capacity planning for the projects owned in the environment.
• Configuring the disks and slices for ASM
• Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
• Storage Migrations: Solely responsible for migrating the Prod/Test/Dev/Sit/UAT Databases from Net App to HNAS and to block level storage. (Migrating the databases from Non-ASM to ASM)
• User management, Table space management, file system space management, backups management
• Generate reports needed to provide details with number of tickets closed, current status, average age on tickets to client from Remedy’s Business Analytics tool.
• Execute changes to database based on preapproved change requests
• Installs necessary tools on infrastructure (deploying agents, RMAN FRAMEWORK, control M, RMAN framework, 12c agents)
• Deliver the reports on time as agreed. Follow-up all actions items and provide status.
• Training the new team members on Security Baselines and Installation Qualifications.
• Monitor and educate team with new processes and standards.
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment:Oracle 12c/11g/10gon Unix/Windows, Oracle EXADATA X2-2 HALF RACK 4,7/Oracle 11g, Red Hat Linux 5.8, RHEL 6, AIX 6, OEM 12c, RAC, Oracle Advanced Security, Data guard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, OVD, Performance tuning, opatch Auto, TOAD for oracle 12.1/11.6, SQL developer, Golden gate, Storage Migrations.

Confidential Madison, WI

Oracle Database Administrator

Responsibilities:

• Experience in Design, Creating and maintaining the Oracle Databases 9i, 10g and 11g from the scratch on UNIX, LINUX and WINDOWS environment.
• Configured GOLDENGATE unidirectional in classic capture mode on LINUX
• Installed, Configured and monitored GOLDEN GATE replication
• Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate
• Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in UNIX scripting
• Oracle Installation/Migration of various versions from 9i and 10g.
• Conducted migration across various platforms like sysbase to oracle and SQL server to Oracle
• Expertise in installing, configuring and maintaining Oracle databases on various platforms
• Supported Business, Post go-live by Cloning/refreshing Production to DEV, UAT, TEST and PREPROD Database instances, for testing at Scheduled intervals.
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Logical backups were scheduled for Development, QA and UAT databases using export/import and Data Pump.
• Performed documentation for Cluster ware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g Standby Documentation.
• Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.
• Expertise in Job Scheduling environments like AutoSys & Cronjobs
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Upgraded the database 10gR1 to 10gR2 and applied database patches using opatch utility.
• Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE.
• Implemented Backup and recovery strategies using export/import, RMAN and online backups.
• Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring, for custom scripts troubleshooting using SQLTRACE utilities
• Automated several scripts to monitor various processes, sessions and taking back up’s using crontab.
• Analyzed the user requirements and designed partitioned tables for improving performance.
• Performing the daily Maintenance tasks and interacting with Oracle Customer service when required.
• Used Oracle Streams for Basic and Advanced Data Replication between oracle database servers.
• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Installed VERIDATA tool for comparing data synchronization between SOURCE and TRGET
• Installed and monitored STREAMS one-way replication
• Involved in the 10g 2 Node RAC installation on RHEL 5.4 server
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Involved in the Migration Projects Extensively using Data pump and Rman utilities
• Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool
• Excellent in writing SQL scripts using SPOOL command
• Expert in using Data pump
• Involved in the migration of huge databases of sizes ranging from 100GB to 7TB
• Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Experience in moving the data from one server to another server using SFTP, FTP and SCP
• Building new databases and schemas from the scratch on Linux and UNIX Boxes.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Schema Refreshing of databases using normal copy method and exp/imp utility.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN duplication (with and without backup)
• Involvement in space management, rectification of lock problems, user management.
• Responsible to provide 24 x 7 database administrative activities over different database servers
• Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.
• Configured Oracle Data guard for Oracle Disaster recovery on standalone database
• Troubleshooting ORA errors when occurred
• ASM Disk storage and user Management
• Performance Tuning for the SQL queries by scrutinizing the long running sql queries
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN shell Scripts.
• Performed Schema as well as Table Level Replication using Oracle Streams.

Environment: Oracle 11g/10g/9i, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad 9.7.2.5, PUTTY, FTP, SFTP, SCP.

Confidential, Somerville, MA

Oracle Database Administrator

Responsibilities:

• Performed migration of theoracledatabases whose database sizes vary from 450 GB to 1.2 TB from Oracle11.2.0.3/11.2.0.4 toOracle12.1.0.2 using Expdp/Impdp
• ImplementedOraclePartitioning, Advance Queuing, and Index-Only Tables to enhance performance of large OLTP environments and enhance the online community experience
• Upgrade 11gRAC to 12c RAC and Administering the RAC Environment through SRVCTL and CRSCTL and applied patches in rolling fashion
• Hands on experience in GGSCI utility for administering Extract, Pump, Replicate & reviewing the error logs and troubleshooting abend scenarios.
• Full database, Schema refresh using RMAN, Data pump and Implemented the Backup strategies using RMAN catalog and nocatalog methods
• Configured diskgroups with different redundancy levels and created fail groups and managing and tuning ASM parameters
• Up-gradation of single instance databases from 11.2.0.4 to 12.1.0.2 on Linux
• Programming in shell to create shell scripts that automate the database backups and maintenance
• Responsible for setting up effective monitoring for alerts and capacity analysis. Also, tuning the database environment to insure optimal performance and resource utilization
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Experience in Flashback Technologies, RMAN Active Database Cloning, Virtual private Catalogs and Merging Recovery Catalogs
• Created 12c Multitenant Databases (Oracle 12c Container and pluggable databases) and consolidated database creation in oracle 12c using multiple PDBs
• Implemented Flashback Technology-Query, Table, Drop and Database to undo specific transactions, recovered database objects and rewind entire database to a particular time
• Installation, Configuration and Maintenance ofOracle11g/12c RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases running on Cluster File system.
• Scheduled Oracle Jobs using DBMS SCHEDULER and Backups using CRONTAB
• Configured Listener and TNS names using NETCA for creating the client-server
• Extensively used SQL* LOADER as a tool for loading data.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Applied patch set and interim patches whenever required to make the database software up to date
• On-Call 24x7 DBA support for production databases.
• Wrote new and maintained and extended existing PL/SQL code that was used to convert existing data sets and enhanced the PL/SQL code
• Involved in doing block recovery and backup validations using RMAN. Implemented backup strategy using RMAN,OracleUtilities (Export/Import) and OS methods.
• Implemented Oracle Transparent Data Encryption TDE column encryption and Invisible columns as security feature.
• Configured Heart Beat Table on both source and target to monitor GoldenGate lag
• Implemented Encryption on GoldenGate trail file on both source and target.
• Performance Tuning for the SQL queries by scrutinizing the long-runningSQL queries
• Experience in applying quarterly security patches (PSU/CPU), as well as interim patches for fixing bugs

Environment: ORACLE 11G,12C, TOAD, Flash/Flashback Recovery, RMAN utility, RAC, ASM, DATAGUARD, Exadata, GOLDENGATE, PL/SQL stored procedures, OEM, Data Guard, Flashback, SQL*Loader, Export/Import, Data Modeling, AWR, ADDM, ASH, Explain Plans, TKProf, STATSPACK, SQL* Trace, SQL Developer, UNIX, SOLORIS, AIX, RHE-LINUX

Confidential

Oracle Database Administrator

Responsibilities:

• Installation and configuration of Oracle software 10g version.
• Created databases, allocated system storage and planned future storage requirements for the database.
• Installed Oracle and related tools, upgraded the database and applied patches as and when required.
• Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Configured the Data guard for switchover and failover and thereby providing high availability.
• Coordinated operating system setup/upgrades and infrastructure troubleshooting in partnership with system administrators.
• Implemented Recovery Manager (RMAN) Recovery Catalog performed Complete and Incomplete recovery.
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Implemented Cloning to migrate data from PROD to Test and Dev databases.
• Performed Capacity planning and storage management.
• Estimation of database growth and analysis.
• Reorganization of tables and rebuilding of indexes.
• Maintained a disaster recovery site and planned and instituted disaster recovery process.
• Coordination with the team and ORACLE Support for troubleshooting the database issues.
• Developed UNIX Shell scripts to backup and recover the Oracle databases.
• Modified shell scripts for backup and recovery, Imported and exported procedure, implementing transportable table spaces.
• Worked as a team member to provide 24x7 on-call production database support.

Environment: Oracle 9i/10g, LINUX, Windows 2003 server, OEM, Shell Scripting, PL/SQL

Confidential

Junior Oracle Database Administrator

Responsibilities:

• Provide backup/recovery, problem diagnosis, performance tuning, data reorganization and database upgrade support for Oracledatabases.
• Installed, configured and maintainedOracle10gReal Application Cluster (RAC).
• Installation and maintenance ofOracle10gData Guard for Database Disaster Recovery.
• Involved inbackup and recovery using RMAN.
• Providing technical support to Application Support team for performance and database related issues.
• Performed Logical backup using and full/partial export/import andData Pump.
• Database RestoreusingRMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing differentbackup and recovery strategies.
• Creatingand managing the database objects such as tables, indexesand views.
• Table Partitioning, creating Index Organized tables, Creating Locally Managed Table spaces.
• Responsible in configuring and backing up database usinghot backups, Cold backupsandLogical backups.
• Migration / Up-gradations of Databases.
• PatchedOracleDatabase Server10gusingOpatch.
• Implemented scripts for daily monitoring likedb status, no of extents, free space
• Upgrading/migratingOracledatabases from 8i/9i to 10g.
• Performance tuning on production databases supporting the application using stats pack/AWR.
• Develop, document, and implement security configuration forOraclesoftware and database instances to comply with existing standards.
• Refresh development/test databases from copies of production.
• Performance tuning viaOEM, STATSPACK/AWRfor 9i/10g.
• 24x7 Production-on call supports for all the production databases withOracle10g/9i.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL plus, TOAD, Import/Export Oracle Enterprise Manager, Windows NT/2000, Sun Solaris 2.5/2.6, Red Hat Linux 2.1