PROFESSIONAL SUMMARY

• 7+ yearsof experience inOracleDatabase Administration, tuning, development, analysis, design, all phases of SDLC, installation, patches,upgrades, migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, troubleshooting and documentation.
• Experience inInstallation, Configuration and Maintenance ofOracle11g/10gRACwithASMand single instance database.
• OracleDatabase Administration in a variety of environments likeOracleLinux, HP - UX, IBM-AIX, Sun Solaris,RHEL.
• Experience in system Monitoring and DatabasePerformance Tuningusing Explain plan, SQL Trace, TKPROF, AWRand also Cluster Interconnect Tuning (RAC).
• Experience withToad Data modelerandGeneratedetailed reportson existing database structure
• Build complex entity relationship models - bothlogical and physicalDatabase Design
• RMANprocedure for backup and recovery and also cloned database using RMAN Duplicate.
• ManagedOracle server in high availability environments using Failover, Clustering, Mirroring,DataguardandCloningtechnologies.
• Preparing cluster, configuring and Installation ofClusterwareandOracleRAC onRHEL.
• Migrateddatabase from9i, 10g to 11gby usingScriptsand applied patches by Opatch utility.
• Experience in database fullBackup(hot and cold), Incomplete Backup, DataPump Export/Import,SQL BacktrackandRestoreprocedures.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Experience inDatabase creation with RMANjobs and security implementations inOracle.
• Load Balancing, Startup, Shutdown of Individual instances onRACdatabase.
• Installed 12cGridagent on servers and configure12cOEM Grid control.
• Data Loading usingSQL*LoaderandDBVERIFYfor corruption checking.
• Used parameters to configure, install and manageASMinstance in10g RAC.
• Experience in maintenance of Production, Testing,Development,RAC, Standby databases/ DataguardforOLTP, Decision Support Systems (DSS) Data Warehouseenvironments.
• Back-end programming, databaseTriggers, stored procedures and functions usingPL/SQL.
• Experience in usingoracleStreamsfor replication of database.
• Job scheduling using cron, at and batch utility at teh OS level andShell Scriptingfor automatingDBAtasks.
• Experience with new features like Flash-Back Recovery, ASSM, AMM, ASMM, Recycle Bin.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes,User Setup, Roles,Security, Storage and hands on experience innetwork management.
• Experience inERWINData modeling andMS Visiofor E-R diagrams and Logical, Physical layout designs.
• Experience of Auditing,OracleSecurity,OEM, SQL NavigatorandTOAD.
• Experience in Very Large Multi-Terabyte Database (VLDB) and also performed migrations in dis environment.
• Experienced inOracleSupport processes for technical requests through Metalinkand other support procedures.
• DocumentedallOracledatabase installations and database operations
• 24*7Production Database Support to ensure availability, efficiency and recoverability.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i

Languages: SQL and PL/SQL

Application Servers: Oracle Application Server (9i, 10g & 11g), Apache

High Availability: (RAC) Clusterware 11g and 10g

Operating Systems: Sun Solaris, Linux (Red Hat, centos, Windows)

DB Tools: TOAD,SQL*Plus, me*SQL Plus, SQL*Loader, Export & Import utility (regular and data pump), OEM, ASMCMD, Net8, Database Configuration Assistant, Explain plan, SQL Trace, Tkprof, RMAN, QUEST Performance Analysis, Spotlight, TOAD

Data Protection Tools: Flash BackQuery, DataGuard

Programming Languages: SQL, PL/SQL, UNIX Shell Scripts and batch scripting

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

OracleDBA

Responsibilities:

• Supported 100+ databases ranging in size between 30Gb to 50Tb.
• Planned and Implemented Disaster Recovery (DR) and High Availability usingRAC, andData Guard.
• Installed and configuredRAC(2 node) and Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.1 to 11.2.0.3.
• Performed health checks in RAC instances usingCrsctlandSrvctlutility.
• Performed Database refresh from Production RAC environment to TEST RAC environment.
• Experience in monitoring and managing of Oracle instances usingEnterprise Manager Grid Control(OEM grid) 10g /11g/12c.
• Starting and stopping teh agents to clear metric alerts and collectingADDMreports in OEM.
• Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.
• InstalledGloden Gatefor replication of database on 11gR2 RAC environment.
• Involved in Tuning teh RAC interconnect Finding RAC wait events. And Tuning teh RAC using theEnterprise Manager Grid Control.
• Performed various tasks onASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Create thorough documentation of installation procedures and administrative tasks in teh clustered environment.
• Generated and automatedStatspack/AWRreports from Oracle 11g/10g/9i database and analyzed teh reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.
• Used Explain Plan, Oracle hints and creation of new indexes, identifying teh join methods (Nested/Hash/Merge join/Sort merge join) between teh row sources for tables, to improve teh performance of SQL statements.
• Addressed developers/testers requests to clone production databases for teh purposes of testing using RMAN.

Environment: Oracle 11gR1, 11gR2,11.2.0.3,12c RHEL 5.8, HP-Unix 7, Solaris 10, OEM, DBUA,RMAN, EMC SAN, Oracle Enterprise Manager Grid Control, RAC, ASM, Data guard, SQL*LOADER, AWR, ADDM, ASH, VPD, Oracle Wallet, Data pumps, Exports/Imports.

Confidential, RICHMOND, VA

Oracle DBA

Responsibilities:

• At PNC me was part of Oracle Support team so primary focus was to provide 24*7 production support.
• Maintain and Support Oracle databases 12C, 11g R1/11g R2/10gR2/10gR1/9iR1/9iR2 in Solaris, AIX, Oracle Linux platform.
• Patched and upgraded teh oracle databases.
• Responsible for support of 1000+Productiondatabases ofTerabytes in size, 2500+ UAT, DEV & TEST databases sizing 100G to Terabytes.
• Active member of Conversion team; PNC acquired National City Corp(NCC) almost 2+ yrs ago. As a part of dis team, me has migrated Legacy NCC databases to PNC standards. dis includes setting up backup strategy, oracle database environment, disaster recovery setup, monitoring setup etc.
• Complete range of Oracle DBA activities including day-to-day production database monitoring, Backup and recovery using RMAN, Trouble Shooting production issues, Physical Database design.
• Managed thedatabases in Sun Virtual Environment. Also maintained teh database which had O/S cluster for failure scenario.
• Worked with Grid Controlfor various day to day oracle DBA tasks.
• ResolveIncident and Service Requestsin teh tickets queue and proactively resolve database related problems, based on alerts triggeredby OEM or BMC Patrol Monitoring Tool.
• Supportand monitor databases toensure Service Level Agreementson uptime, capacity, health and functionality.
• UsedOracle Apexfor various tasks like managing database inventory etc.
• Actively maintainedOracle Database Project, dis has 4 production RAC databases (sizes 20+ TB) with each 8 nodes, 15+ DEV/TEST/QA/Break FIX 8 node RAC environment.
• Collaborate with Oracle Support for bugs & issues resolutions and personal research.
• Provided valuable inputs for variousperformance tuningissues.
• Worked with crontab and Oracle Jobs to manage, schedule various database jobs for backup, maintenance, password change etc.
• Refreshed non-production environments from production database backup for developers.
• Followed change control, Information Security and IT audit standards and procedures for any DBA activity.
• Analyzed, planned, managedand evaluated processes dat determinedatabase quality, design and functionalityper SAS standards
• Worked collaboratively with developers and management to establish Oracle development and production standards.
• Developed task definition and execution strategies.

Environment:Oracle 9i, 10g,11g, 12C, Unix shell script, Grid Control, Data Guard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR andStatspack Reports, EXPDP/IMPDP,EXP/IMP, PL/SQL, RMAN, Crontab, Tivoli Storage Management for DB tape backups,BMC Patrolfor DB monitoring.

Confidential, Monroe, MI

ORACLEDBA

Responsibilities:

• Responsible for administration and supportingoracle11g, 10g and 9i databases
• Worked on DR project.
• Worked on cloning databases.
• Trouble shouted node hand issues.
• Worked closely with different team during migrations.
• Managed Materialize Views servers.
• Applied CPU/PSU patches.
• Worked on Windows database servers.
• Performed various tasks using grid control.
• Worked on writing scripts to automate various tasks.
• Worked on offshore team.
• Performance tuning of applications and teh databasesOracle11g/10g/9i
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Intensively used 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for teh health check of teh databases, and used teh notification tool to send teh alerts in OEM Grid Control.
• Remove unnecessary histograms in highly volatile schemas.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Database dot release upgrades usingoracleuniversal installer and catpatch.sql.
• Applied various recovery scenarios for complete and incomplete recovery in case of failure
• Performed Security administration tasks, setup users accounts, passwords, roles, profiles and quota

Environment:Oracle9i, 10g, and 11g, Toad, SQL plus,OracleEnterprise Manager (OEM), RMAN, Unix, ASM, Solaris 10,OracleStreams, RAC, AIX 5.1, 5.2, Shell Scripting.

Confidential, Rochester, MN

OracleDBA.

Responsibilities:

• Performing all theDatabase Administrationactivity like space management in database, user and roles administration, schema management, checking alert log of all teh databases
• Monitoring database events as part of aProduction support and level 1staff.
• Experienced withRMAN,BACKUPandRECOVERY,POINT-IN-TIME RECOVERY (PITR)of databases.
• Performed cross platformmigrationsfromOracle10g toOracle11g ( Solaris-Linux)
• Experienced withcross site (active-active)data replication usingGloden gate.
• Hands on experience working withGloden GateDirectorand configuredODIto useOracleGloden GateforChangeData Capture.
• Proficient inmigratingdata base from9i/10gto11gby applying latestpatch sets.
• Implemented zero downtime migration and upgrade of 10g to 11g database usingOracleGloden Gate.
• Replicated certain columns from a table and also certain valuesfrom columnsby usingOracleGloden Gate.
• UsedOraclestreamsfordata migrationand data distribution.
• ConfiguredRAConoracle11g RAC.
• Involved in administration of over 150Oracle11g/10g R2instances.
• ImplementedOracleadvanced securityacross various database levels.
• DevelopedOracleForms and Reports for teh user interface; a data load using PL/SQL andSQL*Loader; andUnix scriptsto download and manipulate files
• Development of PL/SQL and WebPL/SQL stored procedures.
• Developed and performed thequalityassurance activities and unit testing.
• InstalledSybaseASE (15.0.x), REP 12.6 in AIX, Loading FACETS, HIPAA
• ProficientinOracleMaterialized view replications.
• UsedData guardfor data migration from various database’s.
• Installation and maintenance ofOracle11gdatabase.
• Extensively usedErwinfordata modelingandDimensional Data Modeling.
• Involved in teh process oftuningand refining queries of various applications.
• Implementing10g Data guardwith one physical database
• Converted a single instance database toOracleRAC 10g.
• Optimizationand tuning SQL queries usingTRACE FILE,TKPROF,EXPLAIN PLAN.
• Extensive usage ofADDM, AWR, ASSM,features of 10g.
• DevelopingHot, cold and logical backupscripts to automate teh backup procedures.
• DatabaseExport/Importand evaluating teh Backup and Recovery Procedures periodically & performing backups usingRMAN.
• Restoration and recoveryfrom backup.
• Cloningof application from production environment to test environment and application ofpatches.
• Moving data from development to production throughtransportable tablespace exports.
• Monitoring teh table growth, database growth, current users, and system resource usage.
• Implementingstandby databaseanddatabase replicationto provide high availability of database.
• Sizingthe SGA, sizing teh db buffers,shared SQL area, log buffer based on teh requirements.
• Continuous monitoring of database performance during peak and non-peak loads usingSTATSPACK
• Involved in team management, team building exercises for theDBAteam.
• Installation, Implementationand maintenance ofOracledatabases.
• Create teh users, roles,schemas with suitable permissions
• Creating and managing teh database objects such as tables, indexesand views
• Creating and managing teh database storage structures which include index table spaces, rollback table spaces and rollback segments
• Accomplish day-to-day requirements of User Community.

Environment: Windows2000, SUNSOLARIS,Oracle9i, PL/SQL,OracleEnterprise Manager, SQL*Loader, Shell scripts.