EXPERIENCE SUMMARY

• Over all 7+ years of IT experience as an Oracle Database Administrator providing 24/7 production and development support of Oracle 11g RAC,10g RAC, 9i, 8i, 7.x.
• Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Experience in query optimization, cloning, patches, up gradation, migration, troubleshooting, TAR support, space management and UNIX Shell Scripting.
• Excellent experience as an Oracle DBA in various platforms such as Sun Solaris, HP-UX, AIX, Red Hat Linux, Windows etc.
• Plan, install, configure and perform upgrades of Oracle software on various platforms.
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database(Data Guard), Materialized views, VCS, Streams Replication, Golden Gate.
• Experience in database administration of OLTP and Data Warehousing applications.
• Experience with Systems Analysis, Design and Data Modeling.
• Backup and recovery with RMAN.
• Recovery of Databases (Recovering from Media failure, Recovering Tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
• Experience with writing PL/SQL Packages, Stored Procedures, Functions and Database Triggers.
• Proficient in SQL, PL/SQL Programming, Shell Scripting and analyzed Batch programs.
• Worked on 4 nodes Linux RAC with ASM.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
• Used DataPump (expdp,impdp) to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, Datapump, TOAD.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Experience with oracle ERP and interfacing with Oracle ERP.
• Automated many common tasks using crontab including Backups, exports and imports, archiving old records and verification of such processes.
• Worked on OLTP/DSS database systems, implementing and managing Large Oracle databases (VLDB).
• Expertise on upgrading and patching of CRS, ASM and Oracle RDBMS.
• Good Knowledge of SQL Server.
• Worked on different types of storage structures (SAN/NAS).
• Strong analytical and problem solving skills, a very good team player and also has the ability to work independently when needed and a quick learner of new technologies.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

Operating Systems

UNIX (Sun Solaris 8, 9,10/HP-UX 10.x,11.x/IBM AIX 5.1,5.2,5.3,6.1), RHEL 3.x, 4.x,5.x, SLES 9 and Windows NT/2000/2003

Relational Databases

Oracle 8i, Oracle 9i, Oracle 10g RAC, Oracle 11g RAC, SQL Server, TERADATA

Data Modeling Tool

ERWIN, Designer 9i

Tuning Tools

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPAK, AWR, ADDM

Tools and Utilities

RMAN, Import / Export, DataPump, SQL*Loader, ASM, TOAD

ETL Tools

Informatica 5.1, Data Stage 6.0

Querying/Reporting

PL/SQL, SQL

Languages

SQL, PL/SQL, C, C++, JAVA, VB, UNIX Shell Scripting

Administration Tool

Oracle Enterprise Manager, SQL Navigator, BMC Patrol, Spotlight

Protocols

FTP, SFTP, Ssh, Telnet, TCP/IP

Other

EMC, Veritas NetBackup, IBM TSM, TAM, NetApp

EDUCATION:

Bachelor of Technology in Computer Science.

PROFESSIONAL EXPERIENCE

Confidential, Santa Ana, CA Jan 2011 - Present
Senior Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading production and development databases to Oracle 11g.
• Installation, Configuration and Administration of Oracle 11g RAC.
• Applied patches to Oracle Databases and Oracle Applications.
• Applied Oracle Applications and database patches.
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• 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.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Involved in taking Backups using Oracle RMAN (Recovery Manager) and TSM (Tivoli Storage Manager). Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• 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.
• Implemented the replication of data between multiple databases using Streams.
• 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.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 11g RAC, 10g RAC , Sun Solaris Unix, AIX, RHEL, Windows XP, Streams, BART, TOAD, DataPump.

Confidential, Sacramento, CA. Sep 09 - Jan 2011
Senior Oracle DBA

Responsibilities:

• 24x7 production database and applications support.
• Installation, Configuration and Administration of Oracle 9i, 10g RAC and 11g RAC databases for Testing, Development and Production.
• Converted single instance to RAC
• Added nodes to RAC
• Upgraded Oracle different version from 9.2.0.4 to 10.2.0.4 and 10.2.04 to 11.2.0.2
• Involved in Capacity Planning and Optimal setting of Storage Parameters.
• Performed Database administration activities like user and roles administration, schema management and checking alert log of all the databases.
• Involved in database cloning, tuning, patching and monitoring
• Performing Backup/Recovery of Oracle databases.
• Implemented RAC and Standby databases for high availability/ disaster recovery purpose.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Developed stored procedures, packages and database triggers.
• Proactive analysis of systems by running AWR, ADDM reports and taking necessary measures.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock and latch contention.
• Create tablespaces, tables and indexes, sizing the tablespaces, allocating default table space for users.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experience with Systems Analysis, Design and Data Modeling.
• Knowledge of writing Automated Scripts in the cron for backups and restoration.
• Used TKPROF, EXPLAIN PLAN, and STATSPACK to improve the performance.
• Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.
• Involved in design and implementation of standby databases ( Oracle Dataguard ).
• Experience in replication using golden gate, materialized views.
• Replication and Extracting data and applying on production using GoldenGate.
• Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Writing SQL scripts to monitor Archive log gaps in DR, monitor table space and extent growth.
• Working with Materialized views with Query Rewrite, Bitmapped Indexes, etc
• Involved in the migration of databases from Windows to Linux
• Automation of Startup, Shutdown on all production and development databases.
• Handling day-to-day activities.

Environment: Oracle 11g RAC, Oracle 10g RAC, 9i, HP-UX, Sun Solaris, RHEL, AIX , RMAN, ASM, SQL*Loader, DataPump, OEM (GridControl), Golden Gate.

Confidential, Oaks, PA. Oct 08 - Aug 09
Senior Oracle DBA

Responsibilities:

• 24x7 production database and applications support.
• Installation, Configuration and Administration of Oracle 9i, 10g RAC and 11g RAC databases for Testing, Development and Production.
• Converted single instance to RAC
• Added nodes to RAC
• Upgraded Oracle databases from 9i to 10g, 10g to 11g
• Involved in Database Design with Data Architects.
• Evaluating database products and third party tools for the Project.
• Setup of the database environments for the Dev and QA teams.
• Setup of High Availability of the database for business with RAC.
• Reorganizing Tables and Indexes for improving performance.
• Created the database objects based on the requirements for project requirement.
• Table space analysis, space allocations for tables, rollback segment monitoring and as member of application development team.
• Implemented complex business rules using database triggers and constraints.
• Adding, dropping users, creating Roles, and Grants based on the Role of the user.
• Planned and implemented database Backup and Recovery procedures.
• Performed backups and recoveries
• Implemented Hot and Cold Backup and Recovery, cloning of databases using IBM Tivoli Storage Manager (TSM).
• Testing of Backup's and Documenting backup strategies.
• Developed stored procedures, packages and database triggers.
• Involved in design and implementation of standby databases ( Oracle Data guard ).
• Participate in disaster recovery exercises using Oracle DataGuard technologies including Fail-over and Switch-over operations.
• Performed Diagnosis & Tuned database and SQL statements as and when required.
• Managing Production as well as Development Instances.
• Identified and provided solutions for poorly written queries.

Environment: Oracle 11g RAC, Oracle 10g RAC, 9i,8i , Sun Solaris, HP-UX, RHEL, RMAN, ASM, SQL*Loader, DataPump, Toad.

Confidential, Irving, TX. Feb 07 - Sep 08
Oracle DBA.

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Database sizing & tuning
• Installation, Configuration and Administration of Oracle 9i, 10g RAC, 11g databases for Testing, Development and Production.
• Involved in Database migration from Oracle 8i,9i to Oracle 10g, 9i to 11g
• Setup of High Availability of the database using RAC, Standby, Dataguard
• Backup and Recovery
• Database performance monitoring and tuning
• Created the database objects based on the requirements for project requirement.
• Created partitions & indexes for better performance.
• Database Security and Auditing.
• Optimizing the SQL statements for optimum performance by using TKPROF, EXPLAIN PLAN, and STATSPACK, AWR, ADDM.
• Scheduled & automated back-end jobs.

Environment: Oracle 11g, 10g RAC, Oracle 9i,8i, RMAN, OEM, SQL Server 2000, AIX, Sun Solaris, Redhat Linux, Windows, TOAD, SAS, Rational Clear Case

Confidential, Hyderabad, India Jan 06 - Jan 07
Oracle DBA.

Responsibilities:

• Production database administration support
• Installation of Oracle 10g on HP-UX and AIX.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Monitor the scheduled oracle jobs, manage data feeds, verify the log tables and tune the performance of the database.
• Provide user account administration, optimizing SQL queries; optimizing developer code, manage table partitions, large data sets and provide manual reports using SQL.
• Backup and Recovery via RMAN scripts and troubleshooting.
• Cleanup demographic Data Warehouse tables, develop PL/SQL scripts, monitor data feed and data replication, address/resolve data issues.
• Handle service requests from the business using Helpdesk Service Management.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Upgrade of Database from 9i and to 10.2.0.2.
• Partitioned large table spaces to increase the performance of the database.
• Converted dictionary based table spaces to locally managed table spaces to eliminate fragmentation, better performance and reduced maintenance.
• Performed Tuning of various SQL queries to improve the performance of the database.
• Logical and Physical data modeling.
• Hard disk and Database space monitoring.
• Migrated file systems to ASM (Automatic Storage Management).
• General database administration including the management of instances, redo logs, temp space, rollback/undo segments and schema management.

Environment: Oracle 10g/ 9i, HP-UX, IBM AIX, TOAD, OEM, STATSPACK, TKPROF, AWR, ADDM, Erwin.

Confidential, Hyd, India Mar 04 - Nov 05
Oracle DBA

Responsibilities:

• Installation, Configuration, Upgrade, Patching of Oracle RDBMS and Applications.
• The work involves overall ORACLE Database Maintenance, Performance Tuning, Backup, Recovery and other Database related activities.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Installation of 9i, 10g
• Upgrade of Database from 8i, 9i to 10g
• Designing the logical and physical database structure.
• Designing the security and database access strategies.
• Logical and Physical data modeling.
• Create table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• REFRESH/CLONING of Database and applications for development, testing
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions)
• Performance monitoring and tuning using TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM for the Better performance.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Performing backups and recoveries using RMAN conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Partitioning Strategies for very large tables.
• Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Data refresh from production to test and development.
• Assist Programmers and Developers with Oracle problems.
• Write Korn shell scripts to monitor and maintain the Oracle database.
• Write SQL scripts to Monitor Tablespace and Extent Growth.
• Resolve various application failures due to data entry errors or system errors.
• Involves identifying problems and implementing corrective actions.
• Providing Solutions to the Problem Faced by End Users Or Programmers.
• OS level activities like space monitoring of Mount points.
• Automation of Startup Shutdown on all Production and Development Database.
• Daily Health Check of the Database.
• Diagnose and troubleshoot Database problems and failures.
• Ensuring proper online and offline backup. Periodical validation/checking of backups taken.

Environment: Oracle 10g/9i/8i/7.3, SQL, RHEL, AIX, Sun Solaris, Shell Scripting, SQL Server

Confidential, Hyderabad, INDIA Aug 03 - Mar 04
Jr. Database Administrator

Responsibilities:

• Installation of Oracle Database and Oracle products.
• Creating users and maintaining database security.
• Designing and enforcing standards and naming conventions.
• Testing of Backup's and Documenting backup strategies.
• Implementing Backup/Recovery Strategies.
• Writing UNIX shell scripts for backup and recovery.
• Monitored SGA, Shared Memory, Memory Segments, LRUs and Buffers etc.
• System tuning for better performance.
• Creating stored procedures, packages and database triggers.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Writing SQL Loader control files for data loading.
• Database tuning, backup and recovery and general day to day running of the system.
• Start up and shut down databases, to check for locks, monitor and kill user sessions, monitor database performance and other day-to-day tasks.
• Systems analysis and design.

Environment: Oracle 9i/8i/7.3, HP-UX,Windows