SUMMARY

• A talented, accomplished senior IT professional with over 9 years of IT experience working as an Oracle Database Administrator, specialized in creating database architectures for the most powerful and complex systems.
• 9+ yearsof professional experience inOracle Database Administration
• Expert in areas ofOracle 12c/11g/10g/9i/8i, PL/SQL, SQL, SQL*Plus, SQL*Loader.
• Experience with BuildingRAC, Data Guard, ASM,GOLDEN GATE/UPGRADATION/ Flashback and RMAN
• Experience in Various Flavors ofUNIX - Linux, Sun Solaris, HP-Unix and IBM - AIX.
• Implemented10g RAC/11g/12C RAC with ASM files system using Oracle clusterware.
• Implemented Data guard (Physical Standby) for RAC databases.
• MigratedNon ASMdatabases toASM.
• MigratedNon RACdatabases toRAC DATABASE.
• Experience withReal Application Testing(RAT)
• Experience with High Availability features (RAC/ DG/ ASM / Flashback / RMAN)
• Implemented uni-directional table level and Schema Level replication using Golden gate
• Upgraded Oracle Grid Infrastructure from to 11.2.0.3/11.2.0.4/12.1.0.1/12.1.0.2
• Upgraded ORACLE databases from to 10g/11g/12c.
• Experienced inOracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database accessandSecurity and auditing.
• Troubleshooting ofPerformanceandTuningproblems in Oracle database using tools likeAWR, ASH, ADDM, SATSPACK, OEM Grid Controland manual scripts.
• Installation, Configuration and administrationOracle Golden Gate
• Refresh and Cloning using Datapump and RMANwith Commvault,VERITAS Net Backup & TSM.
• Expertise inMaintenance, Patching, Cloningandtroubleshooting.
• Excellent knowledge inUser Managed / RMAN backups and Recovery.
• Experienced in DatabasePoint in Time Recovery and Tablespace Point in Time recovery.
• Enforcingsecurityby creatingroles, grantingsystem and objectprivilegeson the Tables, and stored procedures with DBA concepts.
• Created and modified Database objects likeTables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored ProceduresandPackages.
• Experience in Working withOracle Supportto resolve issues and open TAR / SR
• Good experiencein SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• ExcellentAnalytical, CommunicationandPresentation skills.
• 24x7 support provided during on-call schedules.

TECHNICAL SKILLS

Languages: PL/SQL, SQL, SQL*PLUS, Shell Scripting

Database: Oracle12c/11gRAC/10gRAC

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 Datapump, Hummingbird, Connectivity, Cygwin, BMC Remedy, Virtual Ticketing Tool.

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, DBCA, ASMCA

PROFESSIONAL EXPERIENCE

Confidential - Rhode Island

Oracle Database Administrator (DBA)

Environment: Oracle 11g RAC/12C 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 of Grid Infrastructure Installation RAC in Both GUI and NON GUI mode((RAC Silent Mode Installation),Troubleshoot failed root.sh and rerun of it,
• deinstallation& cleanup of clusterware, RAC Database Creation, Active Passive Cluster Setup using Grid Infrastructure, RAC One Node.
• Refresh/Cloningof Database and applications for development and testing purpose.
• RAC Upgrade From to 11g1,11gr2,12c,Nodeaddintion and instance addition in rac environment, Node deletion and instance remove in rac environment, change the Oracle Home of a RAC Database. Applying quarterly psu Patching in grid Environments by opatch and opatch auto and non rac Environment
• Work ON conversion of single node rac to rac node, Single Instance to RAC Conversion using manual Method and rconfig, Workload Management by creating database service as per requirement by client. Working on various issues on RAC (various Node Eviction situation) and non RAC environment by working on raising a sr with oracle support.
• MigratedNON ASMdatabases toASMdatabases.
• MaintainedData Guardto ensure high availability, data protection anddisaster recoveryfor enterprise data.
• Installation and configuration ofGolden Gate
• Implementedbackupandrecoveryprocedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
• ConfiguringData Guardto ensure high availability, data protection anddisaster recoveryfor enterprise data.
• Worked on InstanceTuning, Memory TuningandSQL Tuning.
• WrittenShell scriptsto Monitor activities like availability ofdatabase & listeners,space utilization, gathering statisticfor the cost base optimizer,index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configuredOEM Grid controland intensively usedDiagnostic & tuning packsalong withAWR & ADDMreports.
• WrittenShell scriptsto Monitor activates like availability ofdatabase & listeners, space utilization, gathering statisticfor the cost base optimizer,index rebuildingetc.
• Partitioningof large tables for better performance and manageability.
• Involved inmigrating databasesfrom Windows to Linux, HP-UX to IBM AIX.
• Logical & Physical Database Design
• Capacity Planning and Benchmarking
• PerformanceTuningof Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• ApplyingQuarterly patchesandVersion change patch bundles.
• Provided24x7support for Production, Development, and test database.

Confidential

Oracle Database Administrator (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 configured10g RAC and 11g RAC.
• MigratedNON ASMdatabases toASMdatabases.
• MaintainedData Guardto ensure high availability, data protection anddisaster recoveryfor enterprise data.
• CreatedStreamsenvironment in unidirectional and table level for replication of data.
• Configured and usedOracle FlashBackfor minor recovery of objects in the database.
• Installed and configuredOEM Grid controland intensively usedDiagnostic & tuning packsalong withAWR & ADDMreports.
• Implemented OracleBackupandrecoveryprocedures usingRMAN & Import/Export.
• ConfiguredRMAN backupsforTSMandCommvaultand also resolvedbackup issues.
• Restoring Database’sfrom Backups on testing environments.
• Effectively usesdatabase replication, security and availability solutions.
• Installation and configuration ofGolden Gate
• Replication using Golden Gate
• ApplyingQuarterly patchesandCPU, PSU, One-Off Patchesto update Oracle version and to fix the bugs usingOpatch utility and Auto patch
• Effectively uses platform-specific, as well as enterprise, monitoring tools to provide fault and pre-fault performance notifications.
• Provides platform-specificperformance 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, implementationand fault root cause analysis.
• Createsdesign, troubleshootingand 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 usingSTATSPACK, EXPLAINPLAN, SQLTRACE,TKPROF, ASH, AWR, ADDM
• Worked on InstanceTuning, Memory TuningandSQL Tuning.
• Performed databasePoint in Time RecoveryandTable Space Point in Time
• RecoveryusingTransportable Tablespaces.

Confidential

Oracle Database Administrator

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

Responsibilities:-

• Successfully MaintainedRACenvironments of3NodeswithASMfile system usingcluster ware.
• Involved in Design and implementation of oracle10g Data Guardboth physical/logical standby databases for high availability and disaster recovery.
• ImplementedOracle streamsfor replication and configured tablespaces for streams administration Confidential database and table level.
• Configuring and usingOracle Log minerandOracle Flash Backfor recovery of the objects.
• Upgrade and Migration of Database’s from10.2.0.4to11.1.0.6and applying patches whenever required.
• Installed and controlledGrid Controlto monitorRACand Non RAC instances patched and upgraded the grid control
• Monitored Production Database Using O.E.M and Toad DBA Monitor tools.
• Recovering the databasefrom any kind of crash with the minimum data loss.
• Database Recovery(both complete and incomplete) from different types of failure.
• UsedRMANfor backup and recovery. Performed backup validations using RMAN.
• Responsible for maintaining Every DayBackupsand also to maintainASMand Disk Space.
• Performed DatabasePoint in Time Recovery and Table Space Point in Time Recoverywith the use ofTransportable Table space.
• Applying patches quarterly (PSU, CPU, ONE-OFF)for security and to fix the bugs.
• Responsible for supporting the Oracle databases and ensuring theirPerformance, AvailabilityandSecurity.
• Planning the size of theDatabase, 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 usingData pumpImpdp 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 usingSTATSPACK, ADDM, AWR, EXPLAINPLAN, SQLTRACEandTKPROF.
• 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.
• WrittenShell scriptsto Monitor activates like availability ofDatabase & Listeners,Space utilization, Gathering statisticfor the cost base optimizer,Index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and Data Pump Import/Export.
• Worked onExternal tablesfor Loading Flat files into Database and also created flat files of existing tables for loading into different environment.
• Provided24x7support for Production, Development, and test database.

Confidential

Oracle Database Administrator

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 allOracle 9idatabases/clients to10g.
• ApplyingQuarterly patchesandVersion change patch bundles.
• Implementedbackupandrecoveryprocedures usingRMAN & Import/Export.
• ConfiguringData Guardto ensure high availability, data protection anddisaster recoveryfor enterprise data.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks usingSTATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Installation and supportingRAC.
• Worked on InstanceTuning, Memory TuningandSQL Tuning.
• WrittenShell scriptsto Monitor activities like availability ofdatabase & listeners,space utilization, gathering statisticfor the cost base optimizer,index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configuredOEM Grid controland intensively usedDiagnostic & tuning packsalong withAWR & ADDMreports.
• WrittenShell scriptsto Monitor activates like availability ofdatabase & listeners, space utilization, gathering statisticfor the cost base optimizer,index rebuildingetc.
• Building and ConfiguringRMAN with Netback up, Legato Backup & HP Data Protector.
• Successfully providing24x7support 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
• PerformanceTuningof Databases, Oracle instances, and Applications. Finding Performance bottlenecks usingSTATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Created users, roles and granted privileges according to the business requirements.
• Provided24x7support for Production, Development, and test database.
• Responsible for installingOracle Database, setup Instance Creation, Database Space Management.
• Installedpatchesandupgradesfor various bugs.
• Implemented traditionalHotandCold Backups & Recovery.
• Distributed the data in different Tablespaces bytable partitioningto get thehigh performanceandI/O balancing.
• Performancetuningof Database, SQL queries.
• PerformedExport/Importand full database scanning.
• Monitoring and resizing Tablespace, relocating data files for better disk I/O.
• Maintained standby databases for production and staging environments.
• Createdrolesandusersand Managed thereprivileges.
• Responsible for monitoring & resizing Oracle database objects (Tablespaces, Tables, and Indexes etc.)
• Responsible for managingRedo 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