PROFESSIONAL SUMMARY

• Over 7+ years of professional experience in Oracle Database Administration
• Expert in areas of Oracle 11g/10g/9i/8i, PL/SQL, SQL, SQL*Plus, SQL*Loader.
• Experience with Building RAC, Data Guard, ASM, Flashback and RMAN
• Experience in Various Flavors of UNIX – Linux, Sun Solaris, HP-Unix and IBM – AIX.
• Implemented 10g RAC/11g RAC with ASM files system using Oracle clusterware.
• Implemented Data guard(Physical Standby) for RAC databases.
• Migrated Non ASM databases to ASM.
• Experience with Real Application Testing (RAT)
• Experience with High Availability features ( RAC/ DG/ ASM / Flashback / RMAN)
• Implemented uni-directional table level replication using Oracle Streams.
• Upgraded 10g databases to 11g.
• Good knowledge of 11g new features.
• Experienced in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.
• Installation, Configuration and administration Oracle Golden Gate
• Refresh and Cloning using Datapump and RMAN with Commvault, VERITAS Net Backup & TSM.
• Expertise in Maintenance, Patching, Cloning and troubleshooting.
• Excellent knowledge in User Managed / RMAN backups and Recovery.
• Experienced in Database Point in Time Recovery and Tablespace Point in Time recovery.
• Enforcing security by creating roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts.
• Good understanding of Normalization Techniques.
• Created and modified Database objects like Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures and Packages.
• Experience in Working with Oracle Support to resolve issues and open TAR / SR
• Enforcing data integrity using integrity constraints& database triggers.
• Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Excellent Analytical, Communication and Presentation skills.
• 24x7 support provided during on-call schedules.

TECHNICAL SKILLS

Languages : PL/SQL, SQL, SQL*PLUS, C, Java, Shell Scripting
Database : Oracle 11g RAC/10g RAC/9i/8.x, MS Access
Operating System : UNIX, Solaris, AIX, HP-Unix, Linux, Windows 2005/2003/XP/2000/NT
Tools : SQL*PLUS, SQL Developer, TOAD, Sql Navigator, PUTTY, OEM, RMAN, SQL* LOADER, Imp/Exp and Data pump, Aqua Data Studio 4.7, Humming Bird Connectivity, Cygwin –X.
Other Technologies : ODBC, Crystal Reports, MS Office, SFDM, Erwin 4.0/4.2/7.6, Relational Database Design.
Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADDM
Tools/Utilities: RMAN, ASM, Grid Control, Golden Gate, EXP, IMP, expdp, impdp, Maximo

EDUCATION & CERTIFICATIONS:

• Bachelor of Technology, Computer Science & Engineering
• Oracle Certified Associate.

PROFESSIONAL EXPERIENCE

Confidential, Groton, CT Dec 11 – present
Role: Oracle DBA

Environment:-
Oracle 9i/10g RAC/11g RAC, SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, RMAN, HP-UX, IBM-AIX, Sun Solaris, RedHat Linux, Windows, Data guard, ERWIN

Responsibilities:-

• 24 X 7 Production database administration, support
• Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database (Active Data Guard), Replication.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Migration of all Oracle 9i/10g databases/clients to 11g.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Installation and configuration of Golden Gate
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR ,ASM ,Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Partitioning of large tables for better performance and manageability..
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Logical & Physical Database Design
• Capacity Planning and Benchmarking
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, ADDM.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management.
• Provided 24x7support for Production, Development, and test database.

Confidential, Plantation, FL Sep09 – Nov 11
Role: Oracle DBA

Environment :
Oracle 10g/11g, SQL,PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, RMAN, Cygwin –X, Linux , Windows, Data guard , Toad 10.1 , Aqua Data Studio 4.7 ,SQL Server Management Studio.

Responsibilities:-

• Implemented and configured 10g RAC and 11g RAC.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Created Streams environment in unidirectional and table level for replication of data.
• Configured and used Oracle FlashBack for minor recovery of objects in the database.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Implemented Oracle Backup and recovery procedures using RMAN & Import/Export.
• Configured RMAN backups for TSM and Commvault and also resolved backup issues.
• Restoring Database’s from Backups on testing environments.
• Effectively uses database replication, security and availability solutions.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Installation and configuration of Golden Gate
• Replication using Golden Gate
• Applying Quarterly patches and CPU, PSU, One-Off Patches to update Oracle version and to fix the bugs using Opatch utility.
• Effectively uses platform-specific, as well as enterprise, monitoring tools to provide fault and pre-fault performance notifications.
• Provides platform-specific performance tuning, installation and configuration.
• Monitors and manages back-up and recovery as well as capacity planning for all Database platforms
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management.
• Works with management, peers and vendors to provide ongoing monitoring, performance tuning, implementation and fault root cause analysis.
• Creates design, troubleshooting and operational documentation for all systems under management.
• Authors and peer-reviews knowledgebase articles documenting fault root causes and their respective resolutions.
• Provides and receives cross-discipline training in order to ensure maximum availability of systems under management.
• Carries and responds to off-hours communications device in order to provide 24x7 support.
• Actively pursues opportunities, as an individual and as part of a group, to improve knowledge, tools and processes.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE,TKPROF, ASH, AWR, ADDM
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Performed database Point in Time Recovery and Table Space Point in Time Recovery using Transportable Tablespaces.

Confidential, Dallas TX Jul07 – Aug 09
Role: Oracle DBA

Environment
Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS, EXPDP/IMPDP, OEM, Toad 9.0, RMAN, DBCA, Erwin, Linux, Windows.

Responsibilities:-

• Successfully Maintained RAC environments of 3Nodes with ASM file system using cluster ware.
• Involved in Design and implementation of oracle 10g Data Guard both physical/logical standby databases for high availability and disaster recovery.
• Implemented Oracle streams for replication and configured tablespaces for streams administration at database and table level.
• Configuring and using Oracle Log miner and Oracle Flash Back for recovery of the objects.
• Upgrade and Migration of Database’s from 10.2.0.4 to 11.1.0.6 and applying patches whenever required.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control
• Monitored Production Database Using O.E.M and Toad DBA Monitor tools.
• Recovering the database from any kind of crash with the minimum data loss.
• Database Recovery (both complete and incomplete) from different types of failure.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Responsible for maintaining Every Day Backups and also to maintain ASM and Disk Space.
• Performed Database Point in Time Recovery and Table Space Point in Time Recovery with the use of Transportable Table space.
• Applying patches quarterly (PSU,CPU,ONE-OFF) for security and to fix the bugs.
• Responsible for supporting the Oracle databases and ensuring their Performance, Availability and Security.
• Planning the size of the Database, Creation of Database and location of initial data files, redo log files and multiplexing them, editing database initialization parameter file whenever required.
• Implementation and release of Database changes as submitted by the development team.
• Create Production Support databases for testing every Week for developers using Data pump Impdp from Production Backups.
• Maintaining all database objects including Schemas, Tables, Indexes, Triggers, Sequences, Primary and Foreign keys, Views, and all Constraints.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, ADDM,AWR,EXPLAINPLAN, SQLTRACE and TKPROF.
• Maintaining Erwin for all the new database changes Implemented during each release.
• Responsible for the Database Builds on Test, Development databases and Monitor Production database during builds.
• Worked with cross-functional team of marketing team, engineers, and production planners to understand business process and develop functional specifications.
• Written Shell scripts to Monitor activates like availability of Database & Listeners, Space utilization, Gathering statistic for the cost base optimizer, Index rebuilding .
• Good exposure to oracle technologies like AWR, ASM, Flashback and Data Pump Import/Export.
• Worked on External tables for Loading Flat files into Database and also created flat files of existing tables for loading into different environment.
• Provided 24x7support for Production, Development, and test database.

Confidential Sep06 – May 07
Role: Oracle DBA

Environment:-
Oracle 9i/10g, OEM Grid Control, RMAN, RAC, Imp/Exp, Data Guard, SQL, PL/SQL, SQL*PLUS, Perl, Shell Scripting, HP-UX PA RISC.

Responsibilities:-

• Migration of all Oracle 9i databases/clients to 10g.
• Applying Quarterly patches and Version change patch bundles.
• Implemented backup and recovery procedures using RMAN & Import/Export.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE,TKPROF, AWR, ADDM.
• Installation and supporting RAC.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR ,ASM ,Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Building and Configuring RMAN with Netback up, Legato Backup & HP Data Protector.
• Successfully providing 24x7support for production, development, and test database.
• As part of a pilot project to transfer the database administrative activity to overseas, I have documented and coordinated with the people overseas
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, ADDM.
• Created users, roles and granted privileges according to the business requirements.
• Provided 24x7support for Production, Development, and test database.

Confidential Feb05–Aug06
Role: Oracle DBA

Environment :
Oracle 10g/9i/8.x, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Import/Export, OEM, RMAN, Crystal Reports, Developer/2000, Erwin, Shell Scripting, Solaris, HP-Unix, Windows 2000.

Responsibilities:-

• Responsible for installing Oracle Database, setup Instance Creation, Database Space Management.
• Installed patches and upgrades for various bugs.
• Implemented traditional Hot and Cold Backups & Recovery.
• Distributed the data in different Tablespaces by table partitioning to get the high performance and I/O balancing.
• Performance tuning of Database, SQL queries.
• Performed Export/Import and full database scanning.
• Monitoring and resizing Tablespace, relocating data files for better disk I/O.
• Maintained standby databases for production and staging environments.
• Created roles and users and Managed there privileges.
• Responsible for monitoring & resizing Oracle database objects (Tablespaces, Tables, Indexes etc.)
• Responsible for managing Redo logs, Archive logs, Data files.
• Troubleshooting of the database.
• Documented the problems and solution in the failures of production databases.
• Responsible for extensive use of SQL, PL/SQL, SQL*PLUS