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