SUMMARY:

• Over Seven (7) years of experience as an Oracle Database Administrator with extensive experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation, migration, upgrading, maintenance of RAC, ASM, DataGuard, GoldenGate and production support of complex database applications.
• Excellent experience in installation, setup, configuration and upgrade of Oracle 10g, 11g and 12c in HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Experienced in Installation of High availability RAC environment (2, 3 and 4 node clusters), upgraded standalone databases to 10g/11g/12c RAC environment and adding a node to the cluster database for high availability.
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Solid hands-on experiences in installation, configuration, performance tuning and troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments and heterogeneous environments (including Oracle to Oracle and Sybase/MySQL to Oracle).
• Prepared OGG lag monitoring scripts and configure OGG monitoring plug-in in OEM 1
• Proficient in establishing the communication pathway between client and server through oracle net listener.
• Experience in establishing dedicated server architecture and shared server architecture through oracle net services.
• Expertise in testing the network through TNSPING utility and TRCROUTE utility to test connectivity from client.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Excellent knowledge in logical backups,Hot/Cold Backup and Recoveryand Cloning of databases usingRMAN with VERITAS Net Backup.
• Managed very large database (VLDB) of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.
• Having hands on experience in installing and configuration of Enterprise Manager Cloud Control 12c.
• Experience in Identifying performance bottlenecks on high volume transaction systems, Analyzing SQL statements, reorganize database objects and design indexes to improve response of queries, tuning heavy data loads, Monitoring and Performance tuning.
• Developed shell scripts for automation of software installation and monitoring of system resources.
• Maintained data protection over the network by using network encryption and developed a secure client connection on the network. Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Applying security patches both Server side and Client side and Performed testing.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control(OEM).
• Proficient in raising TAR withOracle Supportand usingMetalinkto resolve the bottlenecks in the database environments.
• Eliminated pace errors by implementing proactive space monitoring and effective space allocations.
• Budgeting for additional capacity like disk space, software or any hardware installations.
• Data protection over the network by using network encryption and developed a secure client connection on the network.
• Configured the network environment and established connections between various oracle databases using listener.ora and tnsnames.ora.
• Hands on experience of running oracle database on AWS (Amazon Web Services).
• Have good knowledge on the ORACLE EXADATA for the extreme performance of the database.
• Having programming experience in stored procedures, functions, triggers and scheduled jobs.
• Database replication using snapshots, materialized views and advanced replication methods.
• 24*7 production database support with Support to developers & end-users.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS:

Databases: Oracle 12c, 11g, 10g, 9i, SQL Server 2000, 2005

Oracle Products: Golden Gate, Streams, Oracle (Grid Control), OEM (Oracle Enterprise Manager), Oracle Fail-Safe (OFS), RMAN, SQL*Loader, DATA PUMP, APEX, ASM, Oracle Measurement Toll (OMT).

Programming Languages: SQL, PL/SQL, JAVA, C, C++

Operating systems: OEL, RHEL, AIX, Solaris, Windows XP Professional, Windows 2003 Professional.

Other Tools: VERITAS Cluster Manager (Java Console) v3.5, TOAD, Erwin, Putty, Oracle Streams, Quest Share Plex, Rational Suite-Clear Quest, Clear Case

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA

Confidential, Rockford, IL

Responsibilities:

• Setup Oracle database 11g RAC & 12c Databases using Oracle Cluster ware for achieving high Availability.
• Installed OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.
• Installed oracle 11g RAC databases using ASM file system and managing using server control utility (SRVCTL) and CRSCTL to achieve high availability.
• Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC & 12C environment for the Production databases.
• Proficient with Oracle Database Upgrade Assistant for Upgrade and Migration of Oracle Data to higher Versions and Different Platforms.
• Configured Data Guard (DG) broker to manage standby databases for switchover and failover operations.
• Implemented Data Guard Fast Start Fail over (FSFO) to initiate failover to the standby site.
• Performed Active duplication of databases and user-managed (hot/cold) backups through RMAN.
• Performed Point-In-Time Recovery of the database using RMAN.
• Migrating data between different database instances whenever required, using Data pump or expr/imp utilities and RMAN cloning.
• Primary technical resources to upgrade Oracle GoldenGate from 11g to 12c in Exadata environment.
• Troubleshoot GoldenGate erroneous Skipping Transactions using LOGDUMP utility.
• Improved performance of GoldenGate Replicat using Range & BatchSQL Parameters.
• Enabled Fine-Grained auditing at the Object level & specific DML Operations.
• Worked on Data migration from SQL databases to Oracle Databases through MS-Access.
• Proficient in configuration and administration of Oracle net services.
• Experience in configuring naming methods, oracle connection manager, profiles and optimizing performances.
• Diagnosing and resolving most common errors from Oracle net services.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK
• Performance tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components.
• Used the Feature of using SQL baselines for better improvement of database performance.
• Extensive experience in performing VMware activities and monitoring resource bottlenecks in memory, CPU, disk, network issues.
• Research, Implement, Test and configured various performance tuning methodologies including OLTP compression, HCC (Hybrid columnar compression for EXADATA), Exadata Scan query specific - Compress for query high/low, Storage Savings specific - Compress for Archive high/low.
• Disk storage management, allocating sufficient disk space for database management and monitoring the available disk pace to avoid database failure.
• Implemented proactive space monitoring programs for effective and error less space allocations.
• Developed shell scripts for automation of software installation and monitoring of system resources.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks like Backups, exports and imports, archiving old records and verification of such processes.
• Worked on SAP BrTools i.e. BRARCHIVE/BRBACKUP to manage backup/restore administration for SAP Databases.
• Established a secure network connection between various databases for secure communication between the databases over the network.
• Troubleshooting on various problem and generic errors in daily routine.
• Collaborated with project managers, application developers, and system quality assurance to ensure the database integrity, high availability and security.
• Provided 24x7 Support for Production/Development databases.
• Helping other DBAs inRAC, standalone installation of databases with ASM.

Environment: ORACLE 12C, 11g, 10g, SQL SERVER, 11g RAC, SRVCTL, CRSCTL, ASM, AIX 5, VMware, LOGDUMP, Data pump, SQL*Loader, SAP BrTools, SLES 11, Listener.ora, Tnsnames.ora.RHEL6, PLSQL, RMAN, TOAD, OEM GRID, DATAGUARD, GoldenGate, CRONTAB, OEM Tuning Pack, Diagnostics Pack, and STATSPACK, FSFO, DBUA.

Senior Oracle DBA

Confidential, Greater Chicago, IL

Responsibilities:

• Extensive knowledge on database administration for Oracle 10g, 11g and 12cwith experience within very large scale database environment and mission critical large systems.
• Excellent experience in installation, setup and configuration of Oracle 10g, 11g and 12c in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Having hands on experience in management and database administration of Oracle applications on Exadata platforms.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
• Expertise in Performing Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle’s regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Experience in a variety of hardware and software platforms including; MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Extensively worked on GoldenGate implementation like installation, configuration GOLDENGATE unidirectional, Bi-directional and broadcast data distribution in classic capture mode on Oracle 11g LINUX.
• Migrated oracle databases using oracle 11g GOLDENGATE.
• Involved in configuring Exadata X2-2, X2-8 and have a good knowledge on smart flash cache, storage index, storage management and migration.
• Installed ORACLE 12c database and Cloud control (12.1.0.3) on Linux 64-bit server.
• Implemented OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM.
• Monitoring all the databases using OEM 12c cloud control.
• Worked in troubleshooting 2node and 4node RAC and implemented 11g New ASM features.
• Extensively worked in setting up physical standby database using Data guard and implemented new 11g feature such as Active Data guard and Snapshot standby database.
• Implemented switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Diagnosing and resolving most common errors from Oracle net services.
• Troubleshooting suggestions for Oracle net services.
• Logging and tracing error information for Oracle net services and contacting Oracle support Services.
• Space management of disk space to avoid bottlenecks and database failures.
• Applying patch set and interim patches using OPATCH for upgrading the binaries.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF, SQL Tuning Advisory.
• Installed SQLTXPLAIN (SQLT) Tool that helps to diagnose SQL statements performing poorly.
• Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performance tuning of the oracle databases using the following tools/utilities: OEM, OEM 12C, AWR, ASH, Explain plan, ADDM, tkprof, DBMS stats.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Extensive Experience with Change Control Management for all database changes.
• Data Refresh from Production to Development and Test environments using Data Pump export/import
• Involvement in space management, rectification of lock problems, user management.
• Supporting Application developers with various performance, connectivity and security related issues on various projects.
• Experience in backups and recovery using RMAN shell Scripts.
• Involved in 24×7 Production Support.

Environment: Oracle 12C, 11g, 10g, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, OEL 5.8, OEM12c, CRONTAB, DATAPUMP, RAC, GoldenGate, Oracle Exadata, RMAN, EXPDP/IMPDP, ASM, DBFS, DataGuard including DGMGRL,OPATCH Utility, TOAD, SQL Developer.OEM 12C, AWR, ASH, ADDM, tkprof, DBMS stats, SQL TXPLAIN (SQLT), Oracle 11g/12c AWR & ADDM, SQL*Trace, TKPROF, SQL Tuning Advisory

Oracle DBA

Confidential, Dayton, OH

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on IBM-AIX nodes.
• Upgraded databases using Database Upgrade Assistance (DBUA).
• Configured 11.2.0.3 RAC on 3 node cluster. Worked on upgrading RAC database from 11.2.0.3 to 11.2.0.4.
• Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments with Back-end Exadata.
• Implement OGG 12c new features in mission-critical production environments.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Cloning duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Converted Single Node Non-ASM Database to 2 Node RAC ASM Database. We achieved this using Data Guard.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Experienced in implementing Oracle Database advanced security practices.
• Improved performance of REPLICAT process using Range functions in GoldenGate and used some Macros and Tokens in GG
• Helped in developing applications based on Oracle Exadata platforms.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• Maintained the Heart beat tables to check the lag between the sites.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c on RHEL.
• Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard on both physical/logical standby databases in high availability mode.
• Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for the Production databases.
• Proficient in configuration and administration of Oracle net services
• Maintenance of load distribution and checking optimum resource levels of system.
• Conducted health checks on all hosts and vm objects. Alarm mechanism is initiated in vcenter for identifying the resource bottleneck.
• Monitoring resource bottlenecks like memory, CPU, disk, network issues.
• Writing and modifying UNIX shell scripts manage Oracle environments and for Backend Oracle Processes.
• Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.

Environment: Oracle 12c,11g,10g, Red Hat Linux 5.0, TOAD 9.0, RMAN, RAC, Data Guard, ASM, TKPROF, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader, SCP & FTP, CRONTAB, OLTP, HCC, EXADATA, AWR, ADDM, ORACLE STREAMS, GOLDENGATE, 10g &11gRAC Environment, DBUA, OEM Tuning Pack, Diagnostics Pack, and STATSPACK.

Oracle DBA

Confidential, Bloomington, MN

Responsibilities:

• Responsible for installation, upgradation, administration and supporting of Oracle10g database.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10gRelease 2.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Data Refreshing Test and Integration Databases using Transportable Table spaces.
• Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level.
• Experience in establishing the communication pathway between client and server through oracle net listener.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery (TSPITR) using RMAN.
• Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetric.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Stats pack.
• Performed conversion single instance to Real Application Cluster (RAC) database instances.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling and Authentication.
• Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support (Metalink)

Environment: Oracle10g, Red Hat Linux4, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, DataGuard, SQL*Plus, PL/SQL, ASM, ToadV9.7 & SQL, Navigator V6.1, Enterprise Manager GRID, Oracle cost Based optimizer (CBO), ASM.

Oracle DBA

Confidential

Responsibilities:

• Installed, maintained new oracle 9i and 8i instances. Upgraded several Oracle 9i instances from 8i.
• Connectivity with different client programs using ODBC.
• Maintained backups for recovery using RMAN in tapes and disks.
• Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.
• Expertise in cloning using RMAN Duplicate DB and hot backups to create Test, QA, DEV Instances.
• Migration from SQL Backtrack to RMAN as backup utility.
• Periodically fine-tuned and optimized the database performance for data integrity and maintained the databases for the day-to-day DBA activities.
• Redesigned the database backup/recovery scripts to log errors, and to be consistent/ robust.
• Modified and maintained database structures and views for the core system.
• Performed work related to importing and exporting data using IMP and EXP tools in Oracle, file structures.
• Setting up client/server Architecture and distributed processing.
• Reduced DBA off-hours support needs by 60% through planning and proactive monitoring.
• Implemented automated backup strategy using the UNIX shell script and CRON Utility.
• Wrote Shell scripts to automate dba tasks such as monitoring tablespaces, health on daily basis.
• Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.
• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Creating users and database links, snap shots on production and development servers.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 9i, 8i, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database Tools/Utilities, OPS, Shell Scripting, CRON Utility, Oracle reports 9i, IMP, EXP Tool, RMAN, ODBC.

Oracle DBA Support

Confidential

Responsibilities:

• Involved in the installation of Oracle 9i on Linux.
• Execute Hot, Cold and RMAN backups and recoveries.
• Cloning the databases for different environments.
• Upgradation and patching of database in QA and production environment.
• Installing and configuring Oracle networking Architecture (oracle net services).
• Patching to new version of oracle software and creation of database manually
• Creating primary database storage structures (table spaces, rollback segments).
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound backup and Recovery Strategy.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability
• Maintained all documents of Oracle database operations, prepared documentation of database backup and recovery.
• Cloned environments to create patch test, development and QA environments
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Applied High priority, security patches downloaded from Metalink.
• Wrote Shell scripts to automate dba tasks such as monitoring tablespaces, health on daily basis.
• the client users and maintaining the documentation of the database.
• Actively involved in gathering requirements, system design, development, and application support.
• Creating and managing tablespaces and rebuilding the indexes.
• Managing users, roles and privileges, space management and creating storage structures.
• Developed many PL/SQL functions, procedures, packages and triggers.
• Loaded data using SQL Loader to test the application.

Environment: Oracle 9i, IBM-AIX, Sun Solaris, RMAN, ASM, SQL, PL/SQL, UNIX Shell Scripting, Sql Loader, Explain Plan, TKPROF and Statspack.