PROFESSIONAL SUMMARY:

• 5 years of experience as Oracle Data Base Administrator, providing 24x7 production support of development and production 12c/11gR2/ 10g/9i/8i databases on different Platform.
• Installed oracle database server on SOLARIS, HP - UX, WINDOWS NT, LINUX, IBM AIX.
• Installed and Configured 11g/12c standalone DB, 11g R1 3 Node RAC For Data warehouse project with ASM .
• Migrated single instance databases to standalone as well as multimode 10g, 11g R1, R2 RAC environments for high availability and load balancing.
• Continuous review of Business critical Database to proactively identify space issues, performance tuning issues
• Experienced in tuning of ERP jobs, time/CPU consuming SQL Queries
• Hands on experience in Data guard, Grid control, replication, monitoring batch performance.
• Helped application team install and configure of Apache and Tomcat.
• Helped Setting up New SFTP server for Third party customers.
• Worked on many Unplanned power outage and restored the DB .
• Extensive knowledge on database backup/recovery strategy (RMAN),Import/Export & Data pump, Capacity Planning, Oracle configuration management, database cloning, refresh and patch management.
• Established Disaster Recovery plan for Oracle 11g RAC database and 12c standalone database.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those SQL’s for better performance.
• Worked along with developers to SQL tune query using SQL tuning advisor, SQL access advisors and configured SQL plan baseline for some SQL, critical for the applications.
• Experience in using 11g/12c features Flash-Back Recovery, DRAF, AWR, ASM, ADDM, ASH, Recycle Bin, 11g Grid Monitoring.
• Experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), Oracle Reports builder, SQL navigator, Tableau, Forms 6i, SQL developer, SQL* Plus, Oracle Enterprise Manager (OEM), and PL/SQL Developer.
• Skilled in database upgrades 8i to 9i, 9i to 10g R2, 10g to 11g R2 and 11g to 12c.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat, Linux NetApps, Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 95/98/NT/2000/XP

Data Bases: Oracle 12c,11g,10g/9i/8.x/7.x, Oracle 11g/10g Real Application Clusters, (RAC).MS SQL Server 2000/2005/2008

Software Applications: Srvctl, Crsctl Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, ERWIN, IBM RSA, Clusters, Veritas Backup,, SQL Loader

Tools: SSIS, SSRS, SSAS, Informatica

Application Server : IBM WebSphere, Tomcat., Apache, Oracle http Server etc

Languages: SQL, PL/SQL, JSP, C#, C, C++, XML, UNIX Shell Scripting, Perl.

Web Tools: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Chicago IL

Oracle Database Administrator

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project in Confidential for Claims financials and claim center .
• Handled around databases on two node and three node RAC servers.
• Installed 12c two node RAC with GRID and ASM
• Cloned/Refreshed database from production (size of production db 3TB to 8TB)
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Provide capacity planning and space analysis to trend future growth on dbs .
• Planed and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery.
• Provided 24x7 Production support.
• Worked on Performance tuning issues including created SQL Profiles/SQL Baselines and tracing of applications .
• Applied CPU patches.
• Performed block recovery using RMAN.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Partitioned large tables for better performance and manageability.
• Migrated databases from Sun Solaris, HP-UX to REDHAT LINUX.
• Worked along with Informatica team to setup informatica repository.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Environment: Oracle 12c /11g/10g RAC, OEM 12C, ASM, Redhat Linux, Shell Scripting, Linux, Solaris, HP-UX, WAS .

Confidential, Vancouver WA

Oracle Database Administrator

Responsibilities:

• Handled Entire DBA activates on Confidential Vancouver site and maintained around 5 TB production server.
• Involved in the installation of new database 12c on Redhat Linux for Production and development environments.
• Migrated Database from 11.2.0.1.0 to 12.1.0.2.0 for both Production and Development environment.
• Configured flash recovery area, created RMAN scripts and export scripts for regular backups and daily maintenance script.
• Tuned RMAN backups for maximum throughput and configured backup policies.
• Cloned/Refreshed Oracle Databases as per schedules and request.
• Responsible for database backup strategies, database recovery and validation & reporting database statistics.
• Implemented Disaster Recovery plans.
• Worked along with Microsoft server and .NET Team to help setup new application within Confidential.
• Trained and nurture new Junior DBA to handle Daily Oracle activities.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Conversion of database from file system to Oracle RDBMS using tools like SQL Loader, External tables and UNIX shell scripting to automate the process.
• Worked on several shell scripts to maintain the database activities
• Mentoring the Database Performance using automated scripts.
• Answerable for setting and managing User Accounts, Granting required privileges to users.
• Experienced in Security Administration and Space Management
• Perform other regular DBA activities including space management and performance monitoring.
• Assisted in building Data warehouse DB standalone servers
• Involved in setting up oracle http server 11g for in house HP applications.
• Administered and monitored HP ALM (Application Lifecycle Management) tool.
• Maintained legacy database 11g running on HP UX env and presently working on redesigning new application.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting, SQL*Loader and External tables.

Environment: Oracle 11g R2 RAC, Oracle 12c/11g, OEM 12C, Shell Scripting, Linux, Solaris, HP-UX, Oracle Http server, TOAD, sql

Confidential

Oracle Database Administrator

Responsibilities:

• Created new databases, set up backups, export, and other monitoring scripts
• Helped Setting up New SFTP server for Third party customers.
• Managing database security administration and Space Management
• Design, develop, and implement automated data backup and restoration procedures.
• Provide technical support for database maintenance and disaster recovery
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Provided support to Application Database Administrators in designing the database.
• Implement Hot, Cold and Logical backup plans.
• Worked on several shell scripts to maintain the database activities
• Mentoring the Database Performance using automated scripts.
• Answerable for setting and managing User Accounts, Granting required privileges to users.
• Perform other regular DBA activities including space management and performance monitoring.
• Configured encryption for backup and tablespace for few critical database .
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Dataguard,
• Implemented flashback database for critical database .
• Helped application team Install and configure of Apache and Tomcat.
• Helped Setting up New SFTP server for Third party customers.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.

Confidential, AH,IL

Oracle Database Administrator

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project Involved in the installation of 11g/r2 RAC on LINUX environment.
• Administered Oracle 11g R2/10g/9i/8i production, test, development environment on RHEL, IBM-AIX, Solaris, HP and Windows .
• Handled entire DBA activity on server move for Vertas cluster and Dataware house servers
• Configured setting up an OEM configured weblogic for NSN .We have completed this activity in one month whereas motorola took 6 months in completing this activity.
• Installed agent on all the system .Agent installation of all the servers were
• Continuous review of Business critical Database to proactively identify space issues, performance tuning issues
• Experienced in tuning of ERP jobs, time/CPU consuming SQL Queries
• Configured all the RMAN or business servers again with the new RMAN catalog for business server .
• Configured 11g R1 3 Node RAC For Data warehouse project with ASM environment and also did REIP during the Migrataion from NSN to Motorola.
• Worked on removing the Name server Configuration from 2 node active passive veritas cluster and brought server in standard format so they do not depend on Nameserver for listeners .
• Worked on many Unplanned power outage and restore the DB when Mount points got corrupted.
• Performed database cloning to setup test and development database.
• Conducted sizing & capacity planning for Oracle databases.
• Involved in Migration of Database from 9i to 10g and applying patches whenever required.
• RAC Troubleshooting(worked on RAC REIP, SCAN IP issue and DB Unknown issue)
• Worked on maintaining schemas and partitioning tables.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Implemented Reorgs on Monthly Basis on Sox 1 system and Rebuild Indexes for better performance, maintenance of Oracle Database.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Created tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Implemented Dataguard for 3 Node RAC on standalone decommissioned IT server.
• Implemented an OS upgrade for three node RAC, Implemented only on test environment QA and Prod is still under process.
• Brought DR in sync whenever the DR went out of SYNC.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Dataguard, Oracle Advanced Replication, Real Application Clusters, Oracle standby services.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Troubleshooting errors and using the expdp/impdp utiliy on a very regular basis for copying data across schemas.
• Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.
• Monitored Database growth and provide Database capacity planning for applications expansion.
• Applied patches using OPATCH and Patch sets using OUI
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Responsible for database backup strategies, database recovery and validation & reporting database statistics.
• Implemented Disaster Recovery plans
• Responsible for optimizing the queries and application tuning.
• Conversion of database from file system to Oracle RDBMS using tools like SQL Loader and UNIX shell scripting to automate the process.
• Provided support to Application Database Administrators in designing the database.
• Worked on several shell scripts to maintain the database activities
• Mentoring the Database Performance using automated scripts.
• Experienced in Security Administration and Space Management
• Perform other regular DBA activities including space management and performance monitoring.

Environment: Oracle 10g/9g/8i, 11g R2 RAC, Grid Control 10gR5, ASM, RHEL 4, 5, Shell Scripting, Linux NetApps