SUMMARY:

• Over 7+years of total IT experience and worked as an Oracle Database Administrator on different platforms covering Red hat Linux, Unix, HP - Server, Sun Solaris, IBM AIX and Windows which includes Installation, Management, Administration, Backup and Recovery, Maintaining and Tuning of Oracle RDBMS.
• Database Administrator with 7+years of experience in Installation, upgradation/migration, Administration, Backup and Recovery, Maintaining and Tuning of Oracle RDBMS.
• Implemented supporting Oracle databases 8i/9i/10g/11g in variety of different environments including Unix, Sun Solaris, Red hat Linux IBM-AIX, HP-UX, Microsoft Windows Servers and Linux.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data guard, Replication.
• Expertise in 11g features like Database Replay, Partitioning, Schema Management, Transaction management, Caching and Pooling, Resiliency, Case sensitive passwords, Virtual columns and Security.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Expertise in Oracle Golden Gate installation, configuration,
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Networking, troubleshooting.
• Proven ability of providing production support for 24X7 on multiple and large databases of over 4 TB using Oracle 11g,10g RAC, 9i, 8i,
• Experience with Oracle database including SQL, PL/SQL, and UNIX shell scripts.
• Expertise in using Golden Gate to support data replication in the Oracle database environment.
• Installed and configured Golden Gate 9.5. Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Expert in Shareplex Admin Skill set in Oracle problem resolution Knowledge RAC/ASM & Data Guard Solution
• Expertise in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Installed, configured and maintained ASM enabled RAC and single instance databases.
• Expertise in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Upgrade/Migration of Databases from Oracle 9i to 10g.
• Expertise in maintaining Database Security using auditing.
• Implemented Replication of Oracle Databases using Logical Standby and Streams and Shareplex.
• Expertise in designing and implementing Oracle databases, cloning of databases and setting up RAC database.
• Proficient in all DBA responsibilities such as Instance tuning, user management, space management, monitoring.
• Migrated single instance databases to multi node 10g RAC environment for high availability and load balancing.
• Expertise in Data transfer between SQL Server and Oracle.
• Hands on experience in writing UNIX Shell Scripts.
• Extensive performance tuning experience, specializing in instance tuning, Oracle9i and 10g RAC tuning and SQL optimization.
• Installation, configuration, upgrade and performance tuning of Oracle RAC.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN.
• Managing Users, roles and privileges, space management Creating storage structures, Performance tuning.
• Expert in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using Recovery Manager.
• Point-In-Time Recovery through RMAN.
• Worked in both OLTP and DSS environments.
• Implemented oracle streams, data guard physical standby databases, expert in BCV’S, SRDF, and managing of partitions and clustering of tables.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).

TECHNICAL SKILLS:

Operating Systems: Unix, AIX 4.3, AIX 5.3, Red Hat Linux RHEL 3, RHEL 4, RHEL 5,, Fedora, Ubuntu, Solaris10,9,8, HP-UX. Windows (NT 4, 2000/2003 Prof/Adv Server, XP Professional)

Databases: Oracle 11g/10g RAC/9i/8i, Microsoft SQL Server 2005,2008

DB Utilities: SQL Navigator, SQL*Loader, Sql*Plus,10g OEM, Grid Control, RMAN, DBCA, DBUA, 10g Data Pump, Toad, Data guard, Export / Import, TKPROF, Statspack.

Scripting: Shell Scripting Korn & Bourne

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

Tools: Oracle Enterprise Manager, TOAD 8.5, SQL Developer, Putty, F-Secure Client, Hummingbird, SQL*PLUS, iSQL*Plus, Cute FTP, Smart FTP 1.0, ERWIN 4.14, SQL- Navigator, ERWIN, Golden gate, MS Visio, Database Replay, LogMiner and Flashback data Archive.

Languages: SQL, SQL, PL/SQL, C,C++,UNIX Shell Scripting, Perl, XML,HTML., Data modeling, Erwin, Apache Tomcat, core java

WORK EXPERIENCE:

Confidential, San Ramon, CA

Senior Oracle DBA

Responsibilities:

• Provided production support for the 24x7Oracle database availability.
• Maintenance and monitoring of oracle 11g/10g database instances hosted on Linux and Sun platform.
• Installed and implemented 10g/11g RAC with 4 nodes.
• Configured Data guard to provide high availability by implementing Physical stand by database.
• Cluster Installation and Configuration, Administering databases in clusters for high availability
• Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
• Responsible for installing and configuring Golden Gate 10.2 on Oracle Servers
• Responsible for upgrading Golden Gate 10.2 to Golden Gate 11.2
• Expertise in MS SQL Server 2008 Installation, Configuration, Maintenance, Backups & Restores, Security Management, DTS import/export, Performance Tuning.
• Setup of High Availability of the database using RAC, Standby, Data guard.
• Worked on advanced Replication including synchronous and asynchronous scenarios.
• DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
• Implemented database replication using shareplex.
• Proficiency using Oracle Golden Gate utility.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Experience in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
• Simulated copy of production databases into test databases for the application and upgrade testing.
• Supported and advised the development teams on database related issues.
• Assisted developers in tuning SQL statements in the applications.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Worked on Distributed Database Configuration, Creation of Database links and Snapshots used Streams for 2 way replication of data.
• Upgraded Dev and Test instances to 11g.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Space Management which includes table space creation, adding new data files.
• Implemented 11i on an active/passive VERITAS Cluster Server (VCS) when 11i was not cluster-aware
• Managed Table spaces, Rollback Segments, Redo Logs and other database object.
• Oracle installation, creation of database, which includes physical and logical design.
• Recovered databases and clone applications Using RMAN.
• Assisted developers in creating stored Procedures, Triggers, Functions, Cursors and Packages.
• Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables, Indexes etc,
• Responsible for memory and Application tuning of the databases using the Oracle utilities like OEM, SQL Trace, TK Prof and Explain Plan.
• Installed Oracle Application Express on Oracle 11g.
• Upgradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans.
• Taking periodic Backup of the Database and the software using Recovery Manager and VERITAS.
• Generated regular Stats-Pack reports for the performance tuning of the databases.
• Experience with DBUA/Export and Import to migrate the database.

Environment: ORACLE, SQL*Plus, Oracle 11g/10g,RAC, Microsoft SQL Server 2008, Golden gate, Shell scripting, Red Hat Linux 5,Solaris 10,Unix, VCS, Oracle Enterprise Manager, Data guard, ASM, PL/SQL, RMAN, Toad.

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
• Installed, and applied patches to Oracle software and associated application
• Involved in Database migration from Oracle9i to Oracle 10g.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and ‘rewind’ entire database to a particular time respectively.
• Installed and configured Oracle Golden Gate and Veridata.
• Handled database migration from Solaris to Linux.
• Installed, configured and performed the maintenance of SQL Server.
• Expertise in Microsoft SQL Server 2005 Database Administration including planning, implementing, backup, and recovery strategies.
• Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN, recover and test the backups regularly.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Created Unix Shell scripts to automate database operation.
• OEM installation and configuration for monitoring and performance tuning.
• Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.
• Performed Database and Application Performance tuning using EXPLAIN PLAN, TKPROF, Statspack and SQL Tuning. upgrade and character set conversion of RAC databases with the aid of Oracles Golden Gate utility.
• Installation, Configure, setup of 10g RAC and add new nodes to RAC 10g Cluster to distribute the load.
• Maintained and monitored replication using Shareplex.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Created and maintained all databases required for development, testing and production usage.
• Worked as part of a team and provided 24/7 support when required.
• Implemented Standby Database and Database Replication to realize database high availability. Created partitions for large table to improve performance.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
• Worked on Distributed Database Configuration, Creation of Database links and Snapshots used Streams for 2 way replication of data.
• Expertise in managing data guard configuration using DGMCRL tool.
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self tuning purposes.
• Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.
• Performed Replication of the Production database for setting up instances for the QA and Testing teams
• Responsible for optimizing data access and performance by tuning indexes.
• Partitioning of large tables for fine tuning performance.

Environment: Oracle10g, IBM-AIX, RMAN, SQL*Plus, Golden gate, Shell scripting, Microsoft SQL Server 2005, RHEL4, Unix, SQL*LOADER, Oracle OEM, Putty, Data guard, Oracle Data Integrator.

Confidential, New Jersey

Oracle DBA

Responsibilities:

• Providing 24x7 on call support for the business critical production real application cluster databases.
• Managing two nodes Real Application Cluster databases on Red hat Linux advanced server 2.1.
• Performed Database migration from Oracle 9.2.0. To 10.1.0.3.
• Applied bug patches according to the Oracle Critical Patch alerts.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Backup and recovery utilizing RMAN.
• Performance issue tracking and solution making using Stats pack. Explain plan used to diagnose the long running queries, tuning applied if it required.
• Installation, upgrade, Patching and management of Oracle databases on UNIX and Windows Platforms.
• Created different Unix Shell scripts to help stress analysis tasks.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Custom code migrations to Test and PROD environments using PVCS.
• Performance tuning Using TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM reports for the Better performance.
• Installed and configured the Oracle Golden Gate and also involved in the troubleshooting Golden gate issues.
• Other duties include applying oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance.
• Created new environment for Shareplex replication.
• Maintaining system security, defining of roles, profiles etc.
• Checking CRON jobs. Monitoring Application specific background processes.
• Creating materialized views and materialized view logs to implement the table level replication for the MIS databases..
• Cloned database for development needs.

Environment: SQL*Plus, Shell Scripting, Golden gate, Unix, Redhat Linux, HP-UX, OEM, Oracle 9i/10g.

Confidential

Oracle DBA

Responsibilities:

• Worked with a team of 2 DBA’s, and coordinating with UNIX system administrators for the setup, installations, upgrades of Oracle 9i and 8i databases for test, development, and QA.
• Reconfigured the existing physical database layout, increasing the performance of the complete system by 20%, including better use of the hard disk space.
• Installed, created and maintained new oracle 9i and 8i instances. Upgraded several Oracle 9i instances from 8i.
• Connectivity with different client programs using ODBC.
• Writing scripts to move data files, for monitoring system activities (I/O CPU), memory usage Confidential process level, file growth, user login, and user’s setup.
• 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.
• 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.
• Reduced DBA off-hours support needs by 60% through planning and proactive monitoring. Created new environment for Shareplex replication.
• Maintaining system security, defining of roles, profiles etc.
• Checking CRON jobs. Monitoring Application specific background processes.
• Creating materialized views and materialized view logs to implement the table level replication for the MIS databases..
• Cloned database for development needs.

Environment: Oracle 9i/8i, SQL, RMAN, SQL* Loader, SQL* Net, SQL* Plus, UnixStatspack, Export / Import, UNIX, AIX, Win NT Server