SUMMARY:

• Oracle DBA with over 7+ years’ experience maintaining Oracle Database running on UNIX/LINUX (Sun Solaris, HP - UX, AIX, and RedHat Linux) and Windows and MongoDB (NOSQL).
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge on Database administration for Oracle 8i, 9i, 10g, 11g and 12c with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Experience on NSK which i Confidential eased the production of the company and also involved avoiding the duplicate data and rectifying it.
• Experience on NSK helped in storage of data successfully.
• Experience on NSK helped the i Confidential ease of sales and performance.
• Experience on Oracle Application Express.
• Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and standby database for High Availability and Disaster Recovery purpose.
• Experience in managing Oracle databases running on MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience RAC Clusterware Administration, Configuration and Patching.
• Extensive experience in Data guard configuration, implementing and maintaining standby databases.
• Hands on experience in Grid control, Streams, GoldenGate Replication.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring/performance tuning/diagnostics.
• Extensive experience in Database Backups RMAN (Full/I Confidential emental backups) and in traditional hot/cold backups.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Good experience in writing/editing UNIX Shell Scripts.
• Good experience in Patching and Upgradation. Expertise in upgrading Oracle Development and Production databases from 8i to 9i, 9i to 10g & 11g, 10g to 11g.
• Extensive knowledge and experience on managing very large Data Warehouse databases.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.
• Experience in Flash-Back Technology.
• Experience on MongoDB (NOSQL) administration.
• Experience of developing new applications with faster using NOSQL (MongoDB) database in large size.
• Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
• Experience in Capacity Planning and Bench Marking.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams.
• Experience on Virtual Platforms.

TECHINICAL SKILLS:

RDBMS: Oracle 11g RAC, Oracle 10g RAC, oracle 9i, oracle 8i, Oracle 7.3, SQL Server, MySQL.

Operating Systems: Solaris 9/10, Linux RHAT 4/5,6, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows NT, 2000/2003/2005.

Scripting Languages: T-SQL, Perl Script, Shell Scripting

Middleware Technologies:: Apache, Tomcat.

High Availability, Tuning& Monitoring Products: Oracle 10g RAC, Oracle 11g RACTools: & Utilities: ASM, Data Guard, Grid Control (OEM), Tkprof, Statspack, AWR, ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN, Export/Import, DataPump (expdp/impdp), SQL Loader.

ETL & Reporting Tools: Informatica, Power Center 8.5/8.0,Data Stage6.0,1.0, Business Objects Xi R26.1, Oracle Data Integrator, SAS

Backup Tools: Veritas NetBackup, NetApp, HP OmniBack, TSM, EMC

Programming Languages: C, C++, Asp.Net, XML, HTML, DHTML, CSS, Java

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Oracle DBA

Responsibilities:

• 24x7 Production database and applications support.
• Installed, configured, and maintained Oracle 10g and 11gR2.
• Upgraded databases from Oracle 9i, 10g to 11g.
• Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• 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.
• Applied CPU patches.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN.
• Moving data between databases using Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Partitioned large tables for better performance and manageability.
• Installed and configured GoldenGate for replication.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Worked with Data Pump to take the logical backups of databases.
• Experienced in performing Point-in-Time Recovery.
• Performed Capacity Planning and Bench Marking
• Load and Transform data using SQL*Loader and External Tables
• Logical and Physical Database Design
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Environment:: Oracle 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate

Confidential, Miami, FL

Oracle DBA

Responsibilities:.

• Installed, configured, and maintained Oracle 10g and 11gR2.
• Upgraded databases from Oracle 9i, 10g to 11g.
• Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Responsible for installing, upgrading, patching and configuring the Oracle environment.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive uses of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the users.
• Partitioning and re-organization of table and indexes.
• Configured and implemented Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Written scripts for the automation of backups and clonings
• Migrated databases from HP-UX to IBM AIX.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Used Data pump to take the logical backups of databases.
• Involved in designing logical and physical data models using Erwin.
• Migrated databases from HP-UX to Sun Solaris, and Windows to Linux.

Environment:: Oracle 11g RAC/10g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, Data Pump, SQL*Loader, AWR, ADDM

Confidential, Cleveland, Ohio

Oracle DBA

Responsibilities:

• Provided 24X7 support for all the production and development databases.
• Installed and configured Oracle 10g.
• Performed upgrades from Oracle 9i to 10g.
• Administration of Oracle Applications versions 11i.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
• Applied Oracle Applications and database patches.
• Cloned/Refreshed Oracle Databases and Oracle Applications.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Implement "Stored Procedures and Triggers" based on business plans using PL/SQL.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• 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, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Servers.

Environment : oracle 11g/Oracle 10g RAC/9i/8i, REDHAT LINUX, ASM,OEM (Grid Control), IBM AIX, RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader, AWR, ADDM

Confidential, Nashville, TN

Oracle DBA

Responsibilities:

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases.
• Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Partitioned large tables to i Confidential ease the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Environment:: Oracle 10g RAC/9i/8i, SUN SOLARIS, WINDOWS, OEM (Grid Control), RMAN, Explain Plan, Data Pump, EXP/IMP