SUMMARY:

• Over 7 years of technical/consulting experience as Oracle Database Administrator, Data Analyst, Data Modeling and Data Migration in Oracle 9i/10g/11g on Linux, UNIX, & Windows.
• Provided 24/7 on call support for very large databases (VLDB) and Data Warehouse environments.
• Excellent experience in OLTP/DSS database administration, implementing and managing Very Large Oracle Databases (VLDB).
• Implemented High Availability/Disaster recovery using RAC, Physical & Logical standby databases (Oracle Data Guard).
• Experience with Real Application Testing (RAT).
• Implemented Data guard(Physical Standby) for RAC databases.
• Upgraded 10g databases to 11g
• Installation, Configuration and administration Oracle Golden Gate.
• Performing capacity Planning, Backup/Recovery strategies using RMAN and conventional Oracle Hot and Cold backup and Export/Import.
• Experience with High Availability features (RAC/ DG/ ASM / Flashback / RMAN).
• Oracle 10g RCA, Oracle 11g RAC implementation & administration using Oracle Clusterware (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery).
• Experience in Data modeling using Reverse and Forward engineering for creating Logical and Physical Database models using Erwin.
• Experienced in using Oracle Enterprise Manager (OEM) & Grid Control for database monitoring.
• Good knowledge of Flashback Technology, Flash recovery Area, Automatic Storage management (ASM) and RAC.
• Performance tuning of Oracle 10g/11g databases, reviewing Statspack/AWR report for resolving performance bottlenecks and involved in SQL tuning.
• Strong RDBMS, SQL & PL/SQL experience. Written Packages, Procedures, Functions, Triggers to incorporate complex business logic and writing shell scripts to automate day to day tasks.
• Refresh and Cloning using Datapump and RMAN with Commvault, VERITAS Net Backup & TSM.
• Applied patches, performed database upgrades, migrations.
• Strong experience in using tools such as SQL*Plus, TOAD, TKPROF, RMAN and Export/Import.
• Performance tuning using, SQL Trace, Explain Plan, STATS PACK, AWR, ADDM
• Proficient in Capacity planning and bench marking.
• Experience in performing crash recoveries without data loss.
• Experience in Database up-gradation and conversion from Oracle 9i/10g to Oracle 11g.
• Replication using materialized views, streams, Golden Gate.
• Experience in different phases of Software Development Life Cycle which include Analysis, Design, Development and Testing and working closely in implementing DB Auditing and Compliance as well as Oracle and system Security enhancement.
• Strong Analytical, Communication, organizational, Troubleshooting & interpersonal skills.
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, and volatility of the data, recovery time allowed etc.

TECHNICAL SKILLS:
Languages :PL/SQL,SQL,SQL*PLUS,C,Java,Shell Scripting, Perl Scripting.
Databas : Oracle 11g RAC/10g RAC/9i/8.x, MS Access, DB2 UDB
Operating System : UNIX, Solaris,AIX,HP-Unix,Linux,Windows 2005/2003/XP/2000
Tools :SQL*PLUS,SQL Developer,TOAD, SQL Navigator,OEM, RMAN, SQL* LOADER, Imp/Exp and Data pump,
Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM
Tools/Utilities :RMAN, ASM, Grid Control, Golden Gate, EXP, IMP, expdp, impdp, Maximo
Others: EMC, NetApp, Veritas, TSM, HP OmniBak

Education:
Bachelor of Technology
PROFESSIONAL EXPERIENCE

Confidential, Carrollton, TX July 2011 – Till Date
Sr. Oracle Database Administrator

Responsibilities:

• 24x7 on-call production database support.
• Primarily responsible for production support. To keep all databases up and running in production.
• Responsible for Oracle 9i/10g/11g logical and physical databases design, implementation and maintenance.
• Installation, Configuration and administration of 10g RAC/11g RAC environment.
• Upgraded Oracle 9i, 10g databases to 11g.
• Performed extensive tuning / troubleshooting of databases for optimal performance. Tuning the application SQL / lock contention / index usage etc., Monitor object growth and modify segment storage for better performance.
• Applied patches.
• Migrated NON ASM databases to ASM databases.
• Developed strategies for optimal backup and restores procedures.
• Managed and resolved design issues.
• Implemented RAC and Physical Standby databases for High availability and disaster recovery.
• Implemented and monitored RMAN backup scripts on regular basis for successful backup.
• Involved in Database Performance tuning and analyzing Statspack/AWR reports on regular basis to resolve performance bottlenecks.
• Partitioned large tables, created global portioned indexes for manageability and performance improvement.
• Created primary database storage structures (tablespaces), altering, and modifying the database structure according to the business requirement as necessary.
• Developing SQL, PL/SQL stored procedures, packages, functions, triggers and views.
• Created and managed users, roles and profiles, implementing security, granting roles and privileges etc.
• Planning and implementing Backup and Recovery procedures (Conventional Cold & Hot Backups, and RMAN Backups), scheduling daily backups and performed periodic recovery tests.
• Installation and configuration of Golden Gate.
• Replication using Streams and Golden Gate.
• Developed Unix Shell scripts to automate database cloning, backups and database monitoring.
• Performance monitoring and tuning using Explain Plan, STATS PACK, AWR, ADDM, and Oracle Enterprise Manager.
• Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Environment: Oracle 9i/10g/11g, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, ERWIN, RMAN, RedHat Linux, HP-UX, Sun Solaris
Confidential,WA April 2010- Mar 2011

Responsibilities:

• 24x7 on-call production database support.
• Provided primary administrative support for Oracle9i/10g/11g databases in LINUX/UNIX and NT environments.
• Installation, Configuration and administration of 10g/11g RAC environment.
• Created, upgraded, and cloned Oracle databases for Development and testing databases.
• Worked on Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Performed backups and recoveries using RMAN conventional hot backups.
• Created and Maintained database stored procedures, database triggers, and user-defined functions.
• Performance monitoring and tuning using OEM Grid Control, SQL Trace, Explain Plan, STATS PACK, Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM).
• Performed export imports using exp/imp, Data Pump.
• Performed Data loads using SQL Loader.
• Tuning Query performance by creating indexes.
• Monitoring, sizing and tuning undo segments by creating multiple undo tablespaces.
• Database Maintenance and clearing of deadlocks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.
• Optimization of various initialization parameters, batch processes with Tkprof, SQL Trace and explain plan.
• Analyzing tablespaces and removing row-chaining and row migration in tablespaces.
• Designing and developing packages in the database layer, stored procedures, functions and triggers.
• Applied latest patches as per evaluation requirement.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Estimating the space requirements for database growth for future making availability of hardware to support the processes.
• Developing, Implementing and administering database policies and procedures.
• Created users, roles and granted privileges according to the business requirements.
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.
• Assisted application development team with database design and support.

Environment: Oracle 9i/10g/11g, Red Hat Linux, IBM AIX, HP-UX, Sun Solaris, Windows 2000, OEM, SQL* Plus, TOAD, RMAN, ASM.
Confidential,VA July 2009 – February 2010
Oracle Database Administrator

Responsibilities:

• Provided 24x7 production database administration supports.
• Administered several databases including single instance and multi-node RAC instances.
• Upgraded databases from 9i to 10g.
• Performed extensive tuning / troubleshooting of databases for optimal performance. Tuning the application SQL / lock contention / index usage etc., Monitor object growth and modify segment storage for better performance.
• Wrote scripts to automate data loads, performance monitoring and backup.
• Database physical/logical layout design and procedures for production, development, test servers.
• Guided the Operations team in Creating, Cloning, and trouble shooting Oracle Databases, Database Objects Designs, and Partitioning, capacity planning of disk, table spaces, tables, backups and recovery.
• Helped the Production teams in Applications Performance Tuning and providing 24X7 Production Support.
• Performed capacity planning required creating and maintaining the database environments.
• Provided tuning support for SGA (shared pool, buffer pool and log buffer pool etc).
• Managed archived redo files, DB-links & Partitions, loading data for users by using SQL*loader.
• Replication of materialized views (snapshots) with fast refreshes for transfers of information.
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs and cleaning up of these file systems periodically, and also RMAN Hot Backup Scripts.
• SQL and PL/SQL Performance Tuning and Identifying SQL and PL/SQL bottlenecks using PL/SQL Profiler, Explain Plan, and Auto trace, TKPROF and tuned them to suit SLA.
• Gathered Database Instance Statistics & generated reports using STATSPACK.
• Implemented Oracle New features like SPfile, Shared Severs, Locally managed Temporary Tablespace, UNDO Tablespace and RMAN.
• Created Partitions at O/S level, according to DB requirements.
• User Creations with allocation to appropriate tablespaces and quotas with necessary privileges and roles.

Environment: Oracle Server 9i/10g RAC, SQL, RHEL, AIX 5.2, Shell scripting, PL/SQL, MS SQL Server.

Confidential,Hyderabad April 2008 to July 2009

Responsibilities:

• 24x7 Production Database Support
• Installation, Configuration and Administration of Oracle 8i/9i databases.
• Upgraded databases from 8i to 9i
• Created roles, profiles, users and assigned privileges to them.
• Analyzed STATSPACK reports for optimization of DB performance periodically.
• Created different types of Indexes (B tree, reverse key, IOT and function based etc).
• Involved in backup/recover strategy designing and implementation using cold backup, hot backup and RMAN methodologies.
• Configuring the databases parameters, creation, reorganization, extending table space, administer database security, create users, grant/revoke roles, privileges, extended databases storage capacity, performance and monitor, reduce db fragmentation, manage data-files, rollback-segments, extents, rebuilding indexes.
• Provided partitioning of the large tables to reduce the access time.
• Applied patches.
• Detecting and diagnosing production system performance by analyzing oracle trace, log files, analyzing SQL statement, measuring system and database activity.

Environment: Oracle 8i/9i, HP-UX, IBM AIX

Confidential,Hyderabad January 2005 to March 2008
Oracle DBA/Developer

Responsibilities:

• Worked on database backup strategy designing and implementation using cold/hot backup techniques.
• Written SQL, PL/SQL functions, procedures, packages and triggers.
• Monitoring and managing the Storage Usage by Resizing Older Tablespaces, Creation of New Tablespaces and relocation of data files for better Disk I/O.
• Configured Statspack for Tuning databases.
• Database Memory management (shared pool, db buffer cache and log buffer).
• Upgrading, analysis and testing of the test and production database.
• Monitored alert logs, trace files, partition tables and indexes for better performance of the database.
• Database physical/logical layout design and procedures for production, development, test servers.
• Perform capacity planning required to create and maintain the database environments.
• Optimization and performance tuning of database, SGA and SQL*Net/Net8 related problems.
• Installing Oracle 8i on Win’NT Server and Setting up Oracle Clients.
• User Creations with allocation to appropriate tablespaces and quotas with necessary privileges and roles.

Environment: Oracle 8i/9i, Sun Solaris, RHEL, Windows, SQL*Loader, SQL, PL/SQL