SUMMARY

• Experience with 8 Years in IT including Production Database Administration and Oracle Database Administration in several environments like Windows, HP - UX, IBM Advanced Interactive executive(AIX), SUN SOLARIS and RedHat Linux.
• Experience on Oracle Virtualization.
• Good knowledge in Oracle Golden Gate software. Experience in data replication in the oracle database environment using Golden Gate software.
• Complete replication and troubleshooting knowledge on Golden gate 11g.
• Done multi-directional replication in oracle golden gate 11g.
• Worked with Oracle 12C cloud.
• Good knowledge in PL/SQL and UNIX Shell Scripting.
• Woked in SQL Server and done log shipping, DB minitoring and Tracing.
• Basic knowledge on PERL.
• Measured and implemented availability solutions using Oracle 10g Real Application Clusters (RAC), Standby Database using Oracle Data Guard.
• Oftenly worked on settingup databases, tuning the database and restoring as well as recovering the databases.
• Documented require topics and explaning them when necessary.
• Monitor and migrated the large databases.
• Helped problems and errors related to PL/SQL.
• Upgrading the databases from 10g to 11g and from 11g to 12c.
• Enough knowledge in monitoring and troubleshooting RAC cluster using Transparent Application failure (TAF), Server control utility (svrctl), oradebug.
• Skilled in concepts like Performance tuning, backuping database and recovery of database, installing and configuration of database, Cloning the database.
• Expertise in Database administration and production support, Upgrading the database, Patching, Space management, Database security, Auditing, Troubleshooting any issues, Database design, Unix shell scripting and documentation.
• Practical experience with Oracle 12c/11g/10g RAC.
• Developed environments on both Physical and Virtual hardware.
• Implementing Solaris Containers to achieve Server Virtualization.
• Experience in using 11g new features Real Application Testing (RAT) and Database Replay(DB Replay) to validate database performance.
• Experience on Oracle monitoring tool including Oracle Application Server monitoring and Oracle Linux monitoring using SAR and TOP.
• Managing Oracle VM architecture, VM Manager Components and VM Sevrer pools.
• Strategic involvement with team for Server virtualization and manageability of infrastructure.
• Knowledge in installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Knowing about Migration and Upgrading the Databases in different environments and versions.
• Proficient knowledge in configuring ASM for RAC databases.
• Good experience in implemention and monitoring of Physical Standby Database for Data Guard disaster recovery technique.
• Configured and authenticated kerberos.
• Indepth knowledge in Data Guard Command-line Interface (DGMGRL).
• Heavily worked on Utilities like RMAN, Data Guard, Data Pump, Flash Back and SQL Loader.
• Done backups and tested crash recoveries using hot & cold backups and RMAN.
• Done operations with EXP/IMP, EXPDP/IMPDP to restore the Dev, Test databases.
• Good subjectation on High Availability Concepts like RAC, Oracle streams, Database Cloning.
• Knowledge in SQL, PL/SQL, Data Modeling and desiging of database physically and logically.
• Regularly worked with RMAN, Data Pump and tablespaces.
• Skillful in using RAC, OEM, TOAD, RMAN and Oracle grid control 12c.
• Worked on Proof of Concept (POC) on OEM 12c Cloud, have good knowledge on 12c.
• Quick and effectual troubleshooting of database and performance problems.
• Expertised in maintaining Oracle large databases (VLDB), ETL, DSS, Data Warehousing and OLTP.
• Exceptional knowledge in DSS/OLPT database systems, implementing and managing large Oracle databases (VLDB) of size 4 TB.
• Knowing about installation and setting up Oracle 12C, 11g R1/R2, 10g, 9i, 8i.
• Implementing database replication using shareplex.
• Handled all DBA work for Business promotional activities.
• Installed and configured Oracle Virtual Directory.
• Worked with IBM Veritas Active - Passive clusters.
• Did Oracle 11g Active Data guard for Disaster Recovery Solution.
• Well expertise in applying Critical Patch Update (CPU Patches) on Databases.
• Experience in Data transfer between SQL Server and Oracle.
• Skilled in Quest Software to resolve issues with Shareplex.
• Knowing how to maintain of schemas, objects & partitioning the tables & indexes.
• Performance Tuned for Optimized results using SQL-Trace, AWR, TKPROF, ADDMreports Explain-Plan.
• Implement automation solutions for Citrix, Cloud (AWS, Azure), Active Directory and Virtualization.
• Experienced the nodes ranging from 2 to 8 and incorporating Dataguarded Exadataclusters for maximum availability.
• Expertise in working with Oracle Architecture, Networking, I/O tuning, Memory tuning, Capacity planning, space management, Performance tuning and optimization.
• Experience in Change Data Capture (CDC) in Oracle 9i.
• Schema design experience using ERwin, expert scripting experience in Perl and all UNIX shell scripting variations.
• Performed numerous tasks tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Replication of Oracle Databases using Logical Standby and Shareplex and Streams.
• Well experianced in PL/SQL, Shell Scripting, SQL, Data Modeling, Partitioning, OLAP, Creation of database logically and physically.
• Very good knowlwdge on Performance Tuning and Optimization.
• Performed well in Oracle 11g features like pooling, caching and sepeartion of tables.
• Demonstration capacity to found root which causes of problems, consider both long and short-term impact of proposed solutions and develop workable solution.
• Having knowledge in Data Migrations using oracle export/import, datapump, sqlldr.
• Experienced in evaluating and capacity planning using statspack historical data analysis.
• Ability to manage multiple project tasks with tight deadlines.
• Virtual Management and configuration.
• Design, configure, implement, integrate and support Citrix products, Cloud (AWS and Azure) and Virtualization (VMware, Microsoft and Citrix).
• Design the virtualization layer based on VMware vSphere 5.0 for the CaaS farm.

TECHNICAL SKILLS

Languages: MS SQL, MySQL, PL/SQL, T-SQL, Perl, HTML, XML, UNIX Shell, Scripting, C, C++.

ETL Tools: Apache Tomcat, Data modeling, Informatica, Erwin.

Databases: Oracle 12c/11g/10g/9i, MS Access, MS-SQL Server 2000/2005/2008, OEM 12c Grid Control.

DBA Tools: SQL plus, SQL Loader, RMAN, DBUS, Toad, EXP/IMP, OEM, TKPROF

Platforms: Linux, HP-UX, Windows NT, XP, Sun Solaris, AIX, OS X0/OS2.

NETWORKING: ISO 8583, TCP/IP, LAN, SPI, NFS, DHCP.

Other Tools: Golden Gate EMC, NetApp, Streams.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Senior Oracle DBA

Responsibilities:

• Created Pluggable databases for containers that suits to Oracle multitenant Architecture.
• Created and tested advanced replication services which includes Data guard and Golden gate in a single project for high availability.
• Created data guard and tested switchover and failover from primary to standby and from standby to primary using Data Guard broker.
• Restore and Recovering Database by using RMAN.
• Installed Golden gate and Jagent and Veridata for high availability.
• Monitoring all the databases by using ORACLE ENTERPRISE MANAGER (OEM).
• Created, scheduled and test RMAN backup jobs by using OEM.
• Worked with Oracle on high complex Service Requests.
• Worked with Project Manager and application team to advice on capacity planning.
• Generated AWR reports for performance issues.
• Troubleshooting Extract/Replicate process abending and parameter files in Golden gate.
• Duplicated the standby database from primary in a process of Data guard.
• Done Data guard multiple times.
• Consolidate different oracle homes into single oracle home.
• Installing oemagent after installing database and worked with issues related to oemagent.
• Patched the oemagent to prevent bugs and unnecessary unavailability of oemagent.
• Worked with issues related to Exadata.
• Applied PSU patching.
• Applied Bug patches node by node to avoid downtime for application.
• Worked with Oracle GRID control and issues related to listener errors and sqlnet.ora errors.
• Worked with ASM password change and user password change for appliance team to patch server.
• Worked on documenting issues like connectivity in oracle Data guard and golden gate issues and datafile recovery issues.
• Worked on SCN issues to match Primary and Standby databases.
• Restored and recovered the individual datafile and backupset piece.
• Knowledge on Cassandra and Mongo DB.

Confidential, Charlotte, NC

Senior Oracle DBA

Responsibilities:

• Involved in the installation, configuration and support of Oracle 11g R2 databases.
• Upgrade and Migration of Databases from 10g R2 to 11g R1, 11g R2 and applying patches as per requirement.
• Used GoldenGate in moving large moving of transactional data with minimal impact to online systems and performing GoldenGate on process of extract and replication of single instance as well as RAC Databases.
• Performed Database migration from Oracle 9i to 10g.
• Worked extensively on RMAN, incremental and cummulative backup’s.
• Created physical standby databases for active production database.
• Implemented Oracle Critical Patch Update and Patch Set Update. erformed disaster recovery plan.
• Installed ASM Environment and transferred database
• Implemented and maintained database security ex: Users, privileges and assigned Roles.
• Recovered database from accidental table drops, media failures and tablespace drops from previous backup.
• Cloned/Refreshed database using RMAN hot backups and Active Database Cloning.
• Setup and maintained Documentation and Standards.
• Implemented ADDM and AWR reports for monitoring performance issues
• Performed database tuning and performance tuning for performance related issues.
• Installed and configured RAC Database.
• Assisted developers with database activities.
• Worked on Tivoli storage manager (TSM).
• Maintaining data consistency and data concurrency in 12c databases.
• Quickly identified application related issues and solved them.
• Monitoring databases for Space management and Standard services availability checks.
• Involved in Capacity Planning.
• Maintained and solved issues related to remote and local listeners.
• Spooled and changed SYS, SYSTEM, DBSNMP passwords for production and non-production databases and maintained instances using OEM.

Confidential, Round Rock, TX

Golden Gate DBA

Responsibilities:

• Installing Oracle Golden Gate in SQL Server and in Linux.
• Creates Extract/Replicates and moving the trail files from one position to another position.
• Setting up monitoring for oracle Golden Gate.
• Performed Bi-directional and multi-directional replication.
• Pulling History Loads for extract and pump in oracle Golden Gate.
• Worked with migration of databases 11g to 12c.
• Checking for bad data by using Log Dump and alter ER to skip Header and start from exact location.
• Setting up the transactional Extraction and transactional Replication.
• Worked with Oracle Enterprise Manager.
• Troubleshooting the issues related to Extract/Replicates and altering them for exact Relative Byte Address and SEQNO.
• Monitoring and solving Performance Issues like sudden errors of ER by using report file.
• Checking log files and manages the issues.
• Classification of data by using timestamp and replicating that data from source to destination.
• Updating the Version of Oracle Golden Gate.
• Knowing the capture of database and unregister and registering that particular ER to that database as a user.
• Solving Golden Gate Errors caused by database like database vaults.

Confidential, Windsor, CT

Oracle DBA

Responsibilities:

• Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, 9i, 8i databases.
• Architect for the implementation of Oracle Identity Manager, Oracle Internet Directory, and Oracle Virtual Directory.
• Performing duties of managing server roles like Resource Mnagement and Administration.
• Oracle VM Creation using Oracle VM Templates.
• Controlled migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Worked on building standby database, flashback database.
• Worked on RAT techiniques like Capturing database workloads with API’s.
• Fully supported the Production Databases.
• Worked with cloud technologies.
• Responsible for installation and maintenance of Oracle 10g, 11g Data Guard.
• Implemented multiple virtual servers through VMWare running Oracle Enterprise Linux, Windows 2003, and SUSE Linux.
• Created Standby database setup via Data guard for Database Disaser Recovery.
• Enforced and maintained database constraints to ensure integrity of the database.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Created Physical Standby Database for Active Production Database.
• Validating Databases Backup and Restore periodically and Data refreshes from Production to Non-Production environment.
• Creation of Duplicate Databases using RMAN.
• Done Golden Gate Databases and worked with application team/Development Team in Trobleshooting Issues
• Checking and Reading GSS Error Logs, Alert Logs and User trace Files for any issues to solve.
• Experience with Replication concepts and used Golden Gate Software to do the replication.
• Implemented Oracle Patches (Critical patch updates, Patch set updates) on the adherence databases Device.
• Was involved in developing Disaster Recovery (DR) plan.
• Good knowledge in Perl and all UNIX shell scripting variation.
• Performance Tuning for advanced results using Explain-Plan, SQL-Trace and AWR Reports.
• Build and supported 45 RAC Databases with cluster.
• Experience in Oracle OEM Grid Control 12c and OEM 12c Cloud.
• Installed and configures DATAGUARD for 23 databases on file-system and ASM in production Environment.
• Created Data Guard using physical standby database, Implemented log miner, Data guard / Standby both physical and logical standby, performed switch/failover and monitored using Data Guard manager command line and GUI.
• Used 11g features Real Application Testing(RAT) and database Replay(DB Replay) to validate Database Performance.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Writing documentation for RAC Database creation, RAC RDMS installation, Cluster ware installation.
• Experience all kind of DB MONITORING including status and performance.
• Installing ASM environment and transferring database to Non-ASM to ASM.
• Know how to used Logical volume manager (LVM) for configuring local volume.
• Knowledge on Distributed Database Configuration, Creation of Database links and Snapshots using Streams for replication of data.
• Worked with SRVCTL for observing and configuring RAC Environment.

Environment: RHEL RedHat Linux, Sun Solaris, Oracle 12c/11g/10g, RAC, ASM, Dataguard, Streams, Golden gate, RMAN Duplication, SQL, PL/SQL, UNIX Scripting, OEM Grid Control, Toad.

Confidential, Jacksonville, FL

Oracle DBA

Responsibilities:

• Expertise in high availability solutions using Data Guard and replication using Oracle Streams.
• Participated in installation of 11g R2 RAC on Linux environment with two nodes and ASM storage.
• Interested in implementing and building multi-terabyte databases on RAC.
• Database migrations from 10g to 11g and apply patching if necessary.
• Developed and managed Oracle Access Manager and Oracle Internet Directory.
• Storage and network recommendations for Oracle VM.
• Worked to move huge transactional data with less effect to online systems by using GoldenGate and performing the process of extract and replication of single instance as well as RAC using GoldenGate .
• Writing Stored Procedures, functions, packages, triggers.
• Communicating with the application team to know the information regarding data migrations.
• Construct Standby Database in manually managed mode, Shell scripts and Cronjobs.
• Experienced with DATA GUARD implementation and point in time recovery.
• Imported data from flat files into databases using SQL loader and External Tables.
• Expertise to check health of database using AWR and STATSPACK.
• Involved in helping customers and developers to troubleshoot server based and databased errors.
• Restored and recovered databases using RMAN within SLA.
• Upgrading WebLogic Servers in developing and testing environment.
• Involved in installation and configuration of unidirectional oracle-to-oracle replicated environments utilizing Golden Gate.
• Involved in managing Oracle RAC database using Golden Gate and dataguard to ensure max data protection.
• Created and maintained failover logical standby database.
• Worked on Pre-processing and analyzing workloads in RAT’s.
• Pre - proceesing and replaying workloads in RAT.
• Used Automatic Shared Memory Management (ASMM) for optimal use of available SGA.
• Created bit-maped indexes for data warehousing databases.
• Worked with latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM manager, Diagnose Extents, Segment Advisor and Query Builder.
• Used SQL Tuning Advisor and SQL Access Advisor to fix bad SQL.
• Involved in migration of databases from standalone(ASM) to cluster environment.
• Managed and monitored the Oracle Real Application Cluster RAC running on VERITAS storage.
• Writing Audit Scripts to enable the Auditing in all Non-Prod and Prod Databases.

Environment: Oracle 10g RAC, 11g, UNIX, Solaris 10, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, EXPLAIN PLAN, DataGuard, Tivoli Storage Manager, Quest, Golden Gate.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Maintenance of Advanced Queues enque and dequeue operations.
• Responsible for administering and supporting production and development Oracle 9i Databases.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository(AWR) for monitoring database performance.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Done Database Maintenance, Data Warehousing and Data Modeling using Erwin.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Applied patch set and interm patches whenever needed and required to make the database software up to date.
• Applied patches, keeping applications software bug free and improving data integrity.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Using DBArtisan, TOAD, and Rapid-SQL for database administration tasks.
• Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• Applied High priority, security patches downloaded from Metalink.
• Configured scripts to monitor activity with database.
• Cloned Environments to create Patch Test, Development and QA Environments
• Created PL/SQL procedures (jobs) to automate maintenance tasks
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, Database Tools/Utilities, STATSPACK, TKPROF, UTL SMTP, SQL*LOADER, Cronjob Oracle forms.

Confidential

Oracle DBA

Responsibilities:

• Proactive database monitoring using automated scripts based on v$views.
• Developer Environments setup using database cloning
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation

Environment: Oracle 10g/9i/8i, Redhat Linux 4.x