RELEVANT SUMMARY:
Around 7+ years of IT Experience as Oracle DBA on a variety of UNIX (Solaris, Linux, AIX, HP-UX), Windows platforms having in-depth expertise with all facets of Database design, Administration, Production Support, Installation, Configuration, Patches, Upgrades, Migration, Performance Tuning, Backups and Recovery, Cloning, Space Management, database security, Disk Space, File System Management and Monitoring.

• Experience in Installation and configuration of Oracle 11gR2, 11gR1 & 10g RAC; Oracle11g, 10g, 9i, 8i on Solaris, AIX, LINUX, HP-UX and Windows environment.
• Planning and Implementation of DR Solutions Using Oracle 11g, 10g, 9i (Active, Physical and Logical) Data Guard.
• Worked on development, testing, production and very large databases (VLDB) with sizes of terabytes and excellent customer handling skills
• Worked extensively in Hot/ Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup & IBM TSM.
• Lots of Data Migrations using Export/Import as well as Data Pump.
• Experience working with Materialized Views, Partitioned Tables and Indexes.
• Installation and Configuration of Oracle GoldenGate 10g and 11g with few topologies.
• Installation and Configuration Oracle GoldenGate Veridata and compare the data online.
• Hands-on experience in configuring Oracle Bi-directional Streams for 10g and 11g Databases for High Availability.
• Implementation of OEM 11g, 10g Grid Control and configuring customized monitoring system as per the DBAMON monitoring utility.
• Complete range of Oracle DBA activities including day-to-day production database monitoring, Backup & Recovery using RMAN, Shell Scripting, Partitioning, Trouble shooting production issues, Performance Tuning, Logical & Physical Database design, SQL & PL/SQL skills.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, STATSPACK, AWR and ADDM utilities to fine tune SQL execution plans. Modify init parameters to improve instance/database performance.
• Hands-on Experience on OLTP as well as DSS (Data warehouse) databases with a large-scale (multi TB) database.
• Job scheduling through Autosys, CRONTAB, O/S updates and upgrades, patches loading.
• Provided extensive support for Application development Team for resolving the issues concerning to databases.
• Experienced in Oracle Support processes for technical requests through MOS (Metalink) and other Support Procedures.
• Driving high-availability, secure and robust 24x7 production environments.

Education:

• B.Tech. in Engineering

CERTIFICATIONS:
Oracle10G Certified (OCP).
Certified GoldenGate 10 Implementation Specialist.

TECHNICAL SKILLS:

Database : Oracle 11g, 10g, 9i, 8i, SQL SERVER 2000/2005.
Operating Systems : Sun Solaris 5.9/5.10, HP-UX, IBM AIX, CentOS 4, Windows NT.
Database Tools : OEM, RMAN, AWR, ADDM, TOAD, DB Artisan, IMP, EXPDP, IMPDP,
ERWIN, GRID CONTROL.
Technologies : RAC (Real Application Cluster), ASM, DataGuard, GoldenGate, Streams
Utility Tools : Putty, Hummingbird Connectivity.
Languages : Oracle PL/SQL, Conversant with C, C++, Mat lab.
Change Management : Clear Case, Clear Quest, Remedy.
Scheduling Tools : Autosys, Crontab.

PROFESSIONAL EXPERIENCE:

Confidential, Eagan, MN - Current Assignment Oct 11 - Present

Responsibilities:

• Installation and configuration of Oracle 11gR2 & 11gR1 RAC databases.
• Experience in configuring and managing the Active Data Guard upon 2-node RAC environment.
• Environment Contain around 138 Production database on 2-node RAC with Different replication technologies such as Active Dataguard, Logical Dataguard, Streams, GoldenGate.
• Upgrading databases from Oracle 10g to 11g.
• Performed Switchover and Failover for couple of the Active Data Guard systems.
• Experience in installation and configuration of Oracle GoldenGate 10g and 11g.
• Experience in configuring Extract, Replicat and Manager Process to setup few the GoldenGate topologies.
• Upgraded Oracle GoldenGate 10g to 11g.
• Responsible for deployment of the Veridata and its Agents and perform data comparison while data sources are online.
• Hands-on working experience in Configuring OracleBi-DirectionalStreams.
• Assists developers and application team with issues pertaining to database environment.
• Coordinate with different teams such as Storage, Network and Unix to troubleshoot and resolve the issues with any of the systems.
• Troubleshoot the database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM)
• Driving high-availability, secure and robust 24x7 production environments

Environment: Oracle 11gR1/R2, 10g & 9i RAC, ASM, Sun Solaris, AIX, Linux, Oracle GoldenGate 11g / 10g, Oracle Streams 11g / 10g, SQL*Plus, PL/SQL, SQL*Loader, RMAN, Putty, Citrix, Erwin, TOAD, OEM 11g Grid control, Perl.

Confidential, Hopkins, MN Jan 11 - Sept 11
ORACLE DBA

Responsibilities:

• Working on a series of on-going development projects within implementation and development (I & D) team.
• Provide development support for DB's, build database for user requests, fix the incidents identified during project development using current information technology.
• Responsible for analyzing system, develop test and troubleshoot sophisticated Database issues under direct supervision.
• Breaking down complex situations to discover and resolve root cause that applies to both technical issues and process issues.
• Experience in evaluate user requirements for new or modified Database.
• Experiencing in providing proactive support to present business flow.
• Experience in Compiling documentation to describe changes made during the development process.
• Experience in supporting SAP database environments.
• Used BRTOOLS for SAP databases to alter/add datafiles/tablespaces, update statistics.
• Used HP ITO console to monitor health of databases and filesystems.
• Resolved many critical issues on Agents, Data Guard based environments databases.
• Experience in working with Oracle 11g, 10g, 9i databases and Oracle 11gR2 RAC databases.
• Refreshed TEST databases on standard filesystems from Production databases sitting on ASM filesystems.
• Experiencing in deploying and troubleshootingOracle 11g Standby databases.
• Performed switch-over/failover using Dataguard, when there is crucial situation and production went unresponsive.
• Created Grid jobs in Grid Control to do automatic database refreshes, full/incremental/archive backups.
• Extensively worked on hang analysis and performance tuning using Oracle grid (ADDM, AWR, SQL access Advisor), and other Oracle utilities.
• Experience in upgrading Grid agent to 11g Agents on Linux, HP and Windows servers.
• Extensively used BMC Remedy ticketing system for production support.
• Working experience with disaster recovery solution using Data GuardBroker - both Physical and logical standby, performed switchover/Failover.
• Provided high degree of coordination between user, technical and application to ensure effective database management
• Provided 7x24 On-call supports

Environment: Oracle 11gR1, 10g, 9i & 8i, Sun Solaris, AIX, HP-UX, Linux, Windows, SQL*Plus, PL/SQL, SQL*Loader, RMAN, Putty, Citrix, Erwin, TOAD, OEM 11g Grid control, Perl.

Confidential, Agilent Tech. - HCL America - Colorado Springs, CO Mar 09 - Dec 10

This project involves Oracle 9i, 10g and 11g databases on multiple UNIX platforms (HP-UX, Solaris, Linux, and AIX) with high availability environment of RAC and Standby servers with ASM. Its primary focus to implement the OEM 11g Grid Control Systems into their environment replacing their age-old tool DBAmon. Configuration of all the events currently being monitored using OEM via Out-of-Box and using OS and SQL UDM's. Also includes supporting the operation task within the environment.

Responsibilities:

• Responsible for the complete implementation of the OEM 11g Grid Control.
• Experience in installation of grid control 10g and 11g agents using various methods.
• The environment is includes 190 servers and around 412 database instances on UNIX and Windows platforms
• Experience in working with the DBAmon tool Perl Scripts to monitor the database environment.
• Experience in Creation of OEM OS and SQL UDM's for the customized events present in DBAmon tool.
• Experience in configuration of Default and Customized notification to the database and server owners and also to Business partners.
• Experience in generating out-of-box and Customized reports and also generation of public reports.
• Provided 7x24 On-call supports

Environment: Oracle 8i, 9i, 10g, & 11g Sun Solaris, AIX, HP-UX, Linux, Windows, SQL*Plus, PL/SQL, SQL*Loader, RMAN, Putty, Citrix, Erwin, TOAD, OEM 11g Grid control, Perl.

Confidential, Dallas, TX Sept 08 - Mar 09
ORACLE DBA

Responsibilities:

• Involved in Installation of Oracle 10g/11g - RAC database on Sun Solaris, Red Hat Linux, and HP-UX.
• Supporting multiple databases for production, development, test and staging purposes on various environments.
• Applying patches both Server side and Client side.
• Experience in database Upgradation and Migration from 9i to 10g.
• Handled day-to-day activities on 9i and 10g servers
• Migration of productiondatabase from one server to another.
• Resynchronized standby databases when they are out of sync. Also built standby databases using RMAN backups manually & using grid Control.
• Coordinated with UNIX administrators for space management on various servers.
• Performed many table-level, schema-level, database-level refreshes using Traditional and Datapump import-export utilities.
• SQL and PL/SQL tuning using various diagnostic tools like Explain Plan, Trace, TKPROF, ADDM, AWR
• Server managed backup & recovery using 9i and 10g RMAN, logical Export/Import as the backup & recovery tool, developed SQL Scripts for cold and hot backups
• Customize and Implement SQL * Loader utility for loading the data
• Experience in Refreshing Pre-Prod, Development and Test Environment using Production data.
• Creating Users, Schemas, Tablespaces, Tables, Partitioned Tables and Index, Indexes, Sequences, Synonyms on 8i, 9i and 10g
• Responsible for administration of SQL Server databases including backup / recovery, user management and disk space management.
• Created databases and users using SQL Server Enterprise Manager.
• Refresh SQL Server databases with production data.
• Experience in working with partitioned database environment.
• Respond to database fatal alerts in Quest Foglight.
• Database Performance Tuning, Memory Tuning, Application Tuning. Performed tablespace shrinking when necessary to retain space.
• Created roles and enabling, disabling roles on all databases(8i, 9i, 10g)
• Provided 24x7 on-call supports

Environment: Oracle8i, 9i & 10g, HP-UX,Linux, Solaris, Windows, SQL*Plus, PL/SQL, TOAD, RMAN, Putty, Quest Foglight/Spotlight, DB Artisan 8.1.1, Rational Clear Case/Clear Quest.

Confidential, Plymouth, MN Aug 07 - Aug 08
ORACLE DBA

Responsibilities:

• Installation and configuration of Oracle 9i/10gbinaries and databases.
• Real application cluster (RAC) 9i/10g Installation, configuration, managing Nodes, node addition deletion and monitoring.
• Installation, creation and administer the ASM databases.
• Experiencing in the DatabaseDecommission.
• Experience in Backup and Recovery using RMAN with TSM as media manager layer and used Autosys as the scheduler.
• Experience in Refreshing Pre-Prod, Development and Test Environment using Production data.
• Involved in refreshing lower environment schemas with production data periodically using EXP/IMP and Data Pump
• Apply regular CPU patches.
• To develop logical and physical design of the database and estimate size of the database objects.
• Creation of users with passwords and assigning them tablespaces like user data and temporary, granting privileges (system and object) through roles and profiles.
• Generated SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Application Query tuning on all modules using Tkprof, Explain plan & Statspack.
• Responsible for applying Oracle Patches using the OPatch utility.
• Monitoring Database Activities, Checking for tablespace Availability, Checking the Alert Log File for errors, and monitoring the Hit Ratios.
• Experience in creating and refreshing the Materialized views.
• Experience in Monitoring of the database using the OEM Grid Control.
• Experience in working with Oracle Identity Management and Oracle Internet Directory.
• Experience in installation of Grid Agent on the database and application servers.
• Experience in working with Application Development teams to design the database architecture (logical and physical) and build database objects to meet project needs.
• Change management using ClearCase/Remedy.
• Documented standard procedures and policies.
• Provided 24x7 On-call Support for all the Production databases.

Environment: Oracle 10g/9i, 10g RAC, Sun Solaris, IBM AIX, Hummingbird Connectivity 4.2, Autosys, BMC Remedy, RMAN, TSM Media Management.

Confidential, Broomfield, CO May 05 - July 07
Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 10g / 9i.
• Keeping database up-to-date by applying patches.
• Database creation/maintenance of database instances, Managing logical and physical database structures and rollback segments.
• Experience in Database operation upon the Real Application Cluster (RAC) Database (9i, 10g).
• Online Node Addition, deletion, instance addition, deletion from RAC cluster.
• Install creation and administer the ASM databases.
• Experience in Audit Validation and Compliance Reporting.
• Migrating schemas from development to test and test to production databases.
• Experience in relational database design,data warehousing.
• Created index or rebuild index in order to improve query performance in Oracle.
• Managed System Users, security and system monitoring for development / production environment.
• Planning Backup & Recovery procedures, Performing Backup and Recovery activities (both in archive & no archive mode) using RMAN, Data Pump & Export/Import Utilities.
• Database Migration from one server to another server.
• Good Knowledge of SDLC environment.
• Experience in creating and refreshing the Materialized views.
• Administered Oracle 10g / 9i and Infrastructure support (315 GB) using Oracle OEM Grid.
• Using RMAN, Oracle Enterprise Manager, and DB-Verify Utilities for backup recovery issues.
• Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
• Experience in troubleshoot and resolve problems that may be application related and/or database related
• Creation and Maintenance of Oracle Data Guard.
• Performed installation, configuration, deployment, migration and upgradation of oracle database servers.
• Experience in Data warehousing and data marts.
• Experience in working Close to Application development team.
• Experience in Building new environments and Decommission the old environments.
• Performed Database Performance Tuning and Monitoring of Databases.
• SQL tuning using Explain plan, Tkprof. Familiar with Rule and Cost based optimizers.
• Experience in working close with the developers.
• Performed Database Security, Auditing and Shell Scripting.
• Experience working with Application development teams to repartition and migrate data
• Provided System support for both development and 24/7 production environment.

ENVIRONMENT: Sun Server E10K, Sun E4500, Sun Solaris 5.8, AIX, Oracle 9i Enterprise Edition, SQL, SQL*Loader, Exp/Imp, RMAN, Oracle Enterprise Manager (OEM) Grid, DDL and DML.

Confidential, Chicago, IL Dec 04 - May 05
Database Administrator

Responsibilities:

• Installation and Configuration of Oracle 9.2 / 8.1.7,
• Creation of schema objects, capacity planning and space management.
• Establishment of SQL*NET connection for remote administration of databases.
• Implement and maintain database security (create and maintain user ids and roles, assign privileges).
• Participate in database Upgrade and Migration projects
• Performed table, schema level, tablespace level export and import.
• Managing of Tablespace for different users by granting quota on Tablespaces.
• Backup and Recovery set up through RMAN, Export / Import utility.
• Administration and Tuning of the Database.
• Implemented TCP/IP based network on Oracle Database Server with NET8 option
• Loaded data into Oracle Database tables using SQL*Loader.
• Perform general technical trouble shooting and give consultation to development and QA teams.
• Maintained Standby Database minimizing downtime during database crash.
• Used Export/Import utilities to migrate databases.
• Generating statspack report and monitoring the performance of the database.
• Used hints, Explain Plan for SQL tuning and optimization.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Tuned database Initialization files to ensure constant high performance and availability.
• Performed Auditing upon request on users, tables or transactions.
• Installed various third party applications to monitor database.
• Written scripts for database and specific user backups for scheduled tasks.
• Monitoring the CPU usage, IO statistics, CPU time to identify any OS level performance killers.
• Responsible for administration of Windows 2000/NT/XP and UNIX environments.

ENVIRONMENT: HP-UX v 11.x, AIX, Oracle 10g/9i Enterprise Edition, SQL, SQL*Loader, Exp/Imp, RMAN, Oracle Enterprise Manager (OEM) Grid, Windows 2000, TOAD.