SUMMARY

Over 7 years experience in Oracle Database Administration, active data guard, installation, migration, designing, backup, recovery, scripting, performance tuning etc. spanning various industries like in variety of environments like UNIX (Sun Solaris, HP-UX, AIX), RedHat Linux and Windows.

• Extensive experience in implementation, maintenance, installation, administration of Oracle databases 11g/10g/9i/8i running on various operating systems UNIX (Sun Solaris, HP-UX, AIX), RedHat Linux and Windows.
• Installed Oracle 10g/11g RAC software
• Excellent experience in configuring of Oracle 8i, 9i, 10g RAC, 11g RAC, Standby Databases (Active DataGuard) for high availability and disaster recovery.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management, monitoring, scheduling jobs, UNIX Shell Scripting.
• Migrated single instance databases to multimode Oracle RAC environment for high availability and load balancing.
• Solid experience on Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
• Upgrading databases to higher versions, applying patches and patchsets.
• Administration experience in Very Large Multi Terabyte Databases (VLDB) environments.
• Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Datapump, Hot and Cold backups.
• Expertise in Oracle performance tuning using statspack, tkprof, explain plan, AWR, ADDM.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Logical and Physical modeling using Erwin.
• 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.
• Experience in understanding business requirements for analysis, detailed design, database design & development of applications.
• Experienced in Oracle Support processes for technical requests through Metalink.
• Documentation of Oracle database operations
• Excellent verbal and written communication skills. Willingness to learn new technologies, openness to new ideas and ability to learn very quickly.
• Expertise in data migration techniques.
• Data loading using SQL*LOADER.
• Experience with Data Modeling, Logical and Physical database design.
• Excellent experience in managing Very Large Databases (VLDB).
• Experience in replication using Materialized Views, Oracle Streams and GoldenGate.
• Participated in on-call (off hours) schedule in providing technical support.
• Good co-ordination and communication with system administrators, business data analysts and development teams.

Skill Set

Operating Systems:

HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3, 6.1
RedHat Linux RHEL 4.x, 5.x and Windows.

RDBMS:

Oracle8i, Oracle 9i, Oracle 10g (RAC), Oracle 11g RAC, DB2, SQL Server 2005.

Languages:

SQL, PL/SQL, Java, C, PERL, UNIX Shell

Tools :

RMAN, OEM, SQL*Loader, EXP, IMP, DataPump (expdp, impdp), ERWIN, TOAD

Tuning Tools :

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.

Database Modeling :

Erwin 4.0

ETL Tools:

Informatica 5.1 ,Abinitio, Data stage

Other:

EMC, NetApp, Veritas NetBackup, TSM, HP Omni Back, Microsoft Office Tools.

Educational Qualifications:

• Bachelor of Technology.

Professional Experience:

Confidential,Sacramento, CA. May 2011 - Present
Oracle DBA

Responsibilities:

• Production Database Administration support (24x7)
• Installed, configured and maintained Oracle Databases.
• Administering Oracle 11g/10g test, development environment on RHEL, IBM-AIX.
• Upgraded development databases from 10.2.0.2 to 11.2.0.2.
• Backup plan designing and implementation using cold/hot backups for database.
• Performed Cold Backups, Hot Backups, RMAN incremental backups.
• Testing of Backup’s and Documenting backup strategies.
• Database performance monitoring, tuning database and application with efficient database parameters.
• Responsible for SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Worked on replication using Oracle Streams and GoldenGate.
• Wrote shell scripts for purging trace files, alert log and network log
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.
• Designed logical and physical Data Models using ERWIN
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication. Used Oracle Advanced.
• Identify performance problems using wait event statistics. Monitor session-level wait events and collect historical data for root cause analysis Supported the development team at offshore in issue fixing, migrations of code & other support activities.
• Upgradations of Oracle databases from 9i to 10g, 9i,10g to 11g
• Scheduling jobs through Oracle Job Scheduler, cronjobs (UNIX) and Schedule Tasks (Windows).
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Implemented data replication through materialized views, Oracle Streams.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Installed and configured Grid Control to monitor all databases centrally.
• Developed Unix scripts for daily database backups, data retention, purge and other scheduled databases.
• Capacity planning and Bench marking.
• Used SQL LOADER for loading data into database from Legacy Systems and Flat files
• Configuring Active Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Responsible for all database activities such as space management, database security management, rollback segments & creation of DB links between two oracle servers.

Environment: Oracle 11g RAC/10g RAC, OEM (Grid Control) and HP-UX, Sun Solaris, and Red Hat Linux, Windows 2003/NT, Toad, Oracle Data guard, Streams, Golden Gate

Confidential,Sunnyvale, CA October 2009 – April 2011
Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration.
• Oracle 11g/10g RAC installation, configuration and support.
• Review of Database logical and Physical design.
• Table Partitioning, Creating Index Organized tables, Creating Locally managed Tablespaces.
• Focused on separate Partitions like data loads, index creation and rebuilding, backup/recovery.
• Worked with Materialized views.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Applying patches
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrading of the oracle databases from 10g to 11g.
• Standby Database (Data Guard) setup and configuration.
• Global operations and maintaining database.
• Working alongside programmers and contributing to the development process.
• Enabling and analyzing trace files
• Planning and recommendations for optimum performance
• Deciding the naming conventions of datafiles, redo log files, tablespaces etc.
• Created scripts to monitor and manage databases.
• Writing scripts for Backup and Recovery.
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB’s.
• Usage of Partitions to improve the query performance and manageability.
• Installation of Oracle RDBMS server software and version upgrades.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
• Oracle utilities i.e. export/import Data Pump, SQL , Data Guard, ASM and OEM
• Proactive monitoring of databases and applying RDBMS patches, security patches.
• SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Application Tuning: Identifying the sql’s causing I/O bottlenecks, sql’s of high cost and giving recommendations to the development teams accordingly.
• Lock monitoring: Identifying the sessions blocking other sessions and inform the users and resolve the issues.
• Migration of code from development to production instances, database space and file system space monitoring, purging of unwanted data and files.
• Supported production and Non-production instances of Oracle Databases.
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

Environment: Oracle 10g RAC/11g RAC, OEM (Grid Control), Oracle Data guard, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Datapump, SQL*Loader, Data Guard, Import Export, AIX, HP-UX, Sun Solaris and Red Hat.

Confidential,Dallas, TX August 2007 – September 2009
Oracle DBA

Responsibilities:

• Managing, troubleshooting and resolving oracle database and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Working alongside programmers and contributing to the development process.
• Planning and recommendations for optimum performance.
• Utilized Oracle Streams to Capture, Propagate and apply the transfer of data, transactions and events within managed databases.
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager (OEM).
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Used ERWIN for logical and Physical database modeling.
• Developed PL/SQL packages, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Used ERWIN for logical and Physical database modeling.
• Physical Database Capacity Planning and data-files mapping.
• Extensively used cron for scheduling of the UNIX shell script jobs.
• Coordinated with source system owners, day-to-day ETL progress monitoring
• Management of schemas, objects partitioning the tables & indexes.
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus, used SQL*Loader control files to load data from external data sources into Oracle database.
• Tested the loaded data and documented the errors and reporting.
• Defining and Setting backup and recovery procedures.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Taking Periodic Backup of the databases
• Recovery of Database(Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.
• Worked with the business analysts throughout the development cycle, and provided post-implementation support, for data and report issues identified by customers.

Environment: Oracle 10g RAC/9i/8i, OEM (Grid Control), Oracle Datagaurd, ASM, RAC, PL/SQL, RMAN, DataPump, SQL*Loader, HP-UX, Sun solaris, AIX, RedHat Linux.

Confidential,Hyderabad, India December 2004 – July 2007
Oracle DBA/Developer

Responsibilities:

• 24x7 Oracle Production Database Administration.
• Worked on different environments like test, development and production databases.
• Worked on backup/recovery, performance tuning.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Working alongside programmers and contributing to the development process.
• Planning and recommendations for optimum performance.
• Extraction of data from flat files into Oracle Database using SQL*Loader.
• Defining and Setting backup and recovery procedures.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Interacting with users, business managers in gathering the requirements

• Partitioning Strategies for very large tables
  Implementing range, list partitions, hash sub partitions

• Participated in Disaster Recovery Drills, documented database and application validation steps.
• SQL and PL/SQL Programming. Developing PL/SQL Functions, Procedures, Packages,Cursors and Triggers
• Creating tables, views, synonyms, database links, materialized views.

Environment: Oracle 10g/9i/8i, OEM (Grid Control), PL/SQL, RMAN, DataPump, SQL*Loader, HP-UX, AIX, RedHat Linux, Windows.