SUMMARY

• An accomplished Database administrator wif 10+Years extensive experience in Information Technology. Intensively worked on various platforms. Core areas of skills are Oracle 9i, 10g, 11g Oracle RAC and Data guard on UNIX, Linux, Solaris, HP and IBM AIX using various leading technologies.
• Hands on experience implementing and using (Recovery manager) RMAN, Data guard and ASM (Automatic storage management) for production test, and development servers.
• Hands - on experience wif 10g R2 RAC on a Two-node RAC cluster on RAW Partitions for Voting Disk and OCR using Red Hat Linux Advanced Server 4.0 wif ASM for managing Oracle Database files.
• Experienced in Infrastructure solution DBA. Coordinating storage team to configure teh file systems and working wif sysadmin team to configure teh different OS like Solaris, Linux, HP, AIX and teh patch sets.
• Worked on Real Application Cluster (RAC) as it is a component of teh Oracle 10g database product that allows a database to be installed across multiple servers.
• Worked as a team lead to coordinate onsite-offshore DBAs also Involved wif application, OS admin and EMC storage, backups (BCV) teams.
• Proficient in configuring teh Large Database on 10g RAC environment on Solaris and Linux.
• Experience in UNIX, Linux environment to cross teh performance utilities like CPU utilization, Individual process utilization, IO waits and run quees.
• Hands on experience in physical database design, planning, administration and tuning.
• Experience in database up gradation from Oracle 9.2.0.4 to 10g R2.
• Experience in database up gradation and migration from Oracle 10g to 11g.
• Migrating existing databases and application servers to Oracle 11g.
• Experience in applying teh patches at various level like database level and OS level.
• Expertise in installing different versions of Oracle on Linux, Solaris and Windows NT/2000.
• Experience in supporting different applications like CRM Siebel, Oracle E Business, PeopleSoft, SAP, Kenan Billing and H.P. open view at database level.
• Experience in capacity management Created and managed different kinds of tablespaces, space issues, and extent and storage parameters
• Configured listeners on server side and TNS Aliases on teh clients’ side
• Experience in implementing teh 10g enhancements in Production, Development and test servers.
• Hands on experience in Oracle 10g Databases wif RAC and also non Cluster environment.
• Experience in Implementing teh 10g OEM (Grid) on Linux, AIX, HP.
• Good understanding of Oracle database architecture.
• Hands on work experience in Oracle 10g streams (Replication) configuration.
• Experience in Oracle Enterprise Manager (OEM), Oracle Management Server (OMS) & DBA Studio.
• Experience of Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage
• Reorganized databases to avoid disk rotation for maximum performance.
• Monitoring query performance using, TKPROF and SQLTRACE.
• Diagnosing and tuning performance issues in a multiple application environment, and tuning teh database at various stages.
• Design database storage layout plans based on requirements of application team for databases.
• Experience in Generate Stats pack reports, AWR, ADDM, ASH, SQL advisor for noing teh database performance issues and tuning teh database at various levels.
• Worked in 24x7 production environment and provided on-call and day-to-day support.
• Planning Backup/Restoration Strategy for 24x7 operation support.
• Creating Materialized Views for Replication and using Query Rewrite for Performance.
• Expertise in handling (Size 10+ TB) on OLAP and OLTP environment.
• Experience on Critical (Financial and Telecom) Databases like Online- Banking Databases.
• Excellent team player wif good analytical, planning and interpersonal skills. Highly motivated, enthusiastic and self-starter.
• A proven record in identifying operational problems and providing innovative solutions.

TECHNICAL SKILLS

Operating Systems: UNIX, Solaris8, 9, 10, Red hat Linux AS 2.1, 4.0, 5.0, 5.2 SLES10,11,IBM AIX 4.0, 4.3, 5.2, HP, Windows NT/2000/XP.

Languages: SQL, PL/SQL, C, C++, Java, Perl

Databases: Oracle 7.3/8.0, Oracle 8i (8.1.5, 8.1.7), Oracle 9i /10g/11g

ERP: Oracle Applications 11.5.9/11.5.10.

DBA Tools: RMAN, Grid, SQL*Loader, SQL*Net8, Erwin, Expdp - Impdp OEM, TOAD, Grid Control, Humming Bird, Golden gate,DRDA

PROFESSIONAL EXPERIENCE

Confidential, Detroit MI

DBA

Responsibilities:

• Supporting GM Confidential project for database responsibilities.
• Installation, upgrading, patching, designing, configuration, tuning and production support for Oracle 11g databases.
• Working on Mobile application servers and pilot database servers.
• Configuring new Logical and Physical standby database using OEM Grid console.
• Configuring cascaded standby databases from physical standby database.
• Working Congo’s to generate repots on daily weekly basis to Confidential team.
• Providing support to application teams for designing and configurations for databases.
• Defining archival and purging scenarios for different tables for pilot databases.
• Coordinate and work closely wif teh Application team, gather requirements from application team.
• Analyzing teh quarterly patches and based on criticality applying Global databases.
• Responsible to apply quarterly security patches to teh database server by using OPatch utility.
• Experienced in monitoring teh databases by using Oracle utility Grid Control.
• Writing Schell scripts to manage teh daily backups and free up teh flash recovery area by enabling cronjobs.
• Providing support to application to code deploy changes on Test and pilot servers.
• Refresh teh databases and schemas when it is required.
• Worked on sizing of database and tables, re-organizing of tables, tablespaces and users.
• Provided Assistance to development team on SQL tuning in mobile applications.
• Server side tuning rebuilding indexes, Analyzing Schemas etc. Schema refreshes using Data pump and Export/Import utilities from Production to DEV, QA and test instances.
• Performance tuning at various levels like DB level, memory and SQL application tuning using AWR, ADDM, SQL Tuning advisor.
• Configure and maintain Data Guard (Physical Standby database) for teh production database and tested for Switchover, failover, activating teh standby to primary and zero data loss wif MAX protection mode..
• Providing solutions to database level at physical and logical designing.
• To implement teh backup, archival and purging policies for production support systems.
• Having experience in vagarious backup strategies like RMAN, and Logical Data pump.
• As part of maintenance activities I do perform restore and recovery to production and non production servers.
• Providing solutions to teh different applications to fulfill their requirements as part of DBA activities.
• Tuning teh databases using various approaches based on applications and scenarios.
• Contacting Oracle for technical support through Meta-link/phone/E-mail.
• Providing 24x7 On Call production support to Confidential

Environment: ORACLE /10g/11g, RMAN, GRID, OEM, DATAGUARD, Data pump, AWR, ADDM, ASSM, SQL, TOAD, Web logic, UNIX,SLES10,SLES11, Linux 5, Nagois, Cognos4.2Detroit MI.

Confidential

Senior DBA

Responsibilities:

• Coordinating wif Oracle support teams to fine-tune teh database and application at various levels.
• Working wif offshore Application and DBA teams.
• Contacting Oracle for technical support through Meta-link/phone/E-mail.
• Working on NAS (NFS File system) sharing across Linux databases and windows application servers using windows security model.
• Working on Oracle 11g new features like ACO(Advanced compression option) and implementing right databases.
• Working wif Oracle for OEM provisioning and Configuration pack.
• OEM Agents’ installation on database servers and configurations.
• HIR(Hosting Inftastructure reviews) for plant databases and datacenter databases servres.
• Providing support to application teams for designing and configurations for databases.
• Redesigning teh backup policies for databases.
• Defining archival and purging scenarios.
• Analysing teh quartely patches and based on criticality applying Global databases.
• Responsible to apply quarterly security patches to teh database server by using Opatch utility.
• Supporting to various application and (PANDA) Weblogic application for implementation.
• Successfully installed and configured multiple RAC instances and databases for a migrating applications starting from DEV to PROD.
• Experienced in monitoring teh databases by using Oracle utility Grid Control
• Experience in configuring and maintaining Oracle Replication by using streams for Data replication from production system to Data warehouse on RAC Environment.
• Worked on sizing of database and tables, re-organizing of tables, tablespaces and users.
• Provided Assistance to development team on SQL tuning in applications.
• Server side tuning rebuilding indexes, Analyzing Schemas etc. Schema refreshes using Data pump and Export/Import utilities from Production to DEV, QA and test instances.
• Performance tuning at various levels like DB level, memory and SQL application tuning using AWR, ADDM, SQL Tuning advisor.
• Configure and maintain Data Guard (Physical Standby database) for teh production database and tested for Switchover, fail over, activating teh standby to primary and zero data loss wif MAX protection mode..
• To implement teh backup, archival and purging policies for production support systems.
• As part of maintenance activities I do perform restore and recovery to production and non production servers.
• Providing solutions to teh different applications to fulfill their requirements as part of DBA activities.
• Tuning teh databases using various approaches based on applications and scenarios.
• Applying teh Oracle patches to teh databases which are related to product bugs and new implementation and ORA-600 errors.

Environment: ORACLE 9i/10g/11g, RMAN, RAC, ASM, GRID, OEM, DATAGUARD, Data pump, AWR, ADDM, ASSM, Humming bird, SQL, UNIX, HP, Sun Solaris 9, 10, SLES10,SLES11, IBM AIX.Los Angeles, CA.

Confidential

Senior DBA

Responsibilities:

• Providing support to 350+ production database servers.
• Co-ordinating teh onsite and offshore DBAteams.
• Working wif different teams like backup, storage and OS teams to provide different solutions at DBA side.
• Contacting Oracle for technical support through Meta-link/phone/E-mail.
• Installation, upgrading, patching, designing, configuration, tuning and production support for Oracle 9i, 10g & 11g RAC databases.
• Installing and configuration Application Server SSO(Single Sign-on).
• Configure OEM, OMS and Agent on Linux servers for back office database servers.
• Agents’ installation on back office database servers and configurations.
• Creating and writing pl/sql procedures, triggers and functions.
• Capacity planning for back office database and Central office databases for holiday seasons.
• Providing support to application teams for designing and configurations for databases.
• Define teh backup policies for BO and Central office databases.
• Defining archival and purging scenarios for BO and CO databases.
• Experience in configuring and maintaining Oracle Replication by using streams for Data replication from production system to Data warehouse Environment.
• Used Golden gate for replicate teh databases.
• Coordinate and work closely wif teh Application team, gather requirements from application team
• Responsible to apply quarterly security patches to teh database server by using Opatch utility.
• Supporting to orpos application and Siebel CRM application for implementation.
• Successfully installed and configured multiple RAC instances and databases for a migrating applications starting from DEV to PROD.
• Experienced in monitoring teh databases by using Oracle utility Grid Control
• Experience in configuring and maintaining Oracle Replication by using streams for Data replication from production system to Data warehouse on RAC Environment.
• Worked on sizing of database and tables, re-organizing of tables, tablespaces and users.
• Provided Assistance to development team on SQL tuning in applications.
• Server side tuning rebuilding indexes, Analyzing Schemas etc. Schema refreshes using Data pump and Export/Import utilities from Production to DEV, SIT and test instances.
• Performance tuning at various levels like DB level, memory and SQL application tuning using AWR, ADDM, SQL Tuning advisor.
• Configure and maintain Data Guard (Physical Standby database) for teh production database and tested for Switchover, fail over, activating teh standby to primary and zero data loss.
• Configuring teh DR setup using SRDF technology, and defining teh consistency groups across teh databases.
• Providing solutions to database level at physical and logical designing.
• To implement teh backup, archival and purging policies for production support systems.
• Convert Non RAC Database to RAC Database using RMAN backups.
• Having experience in vagarious backup strategies like RMAN, and Logical
• As part of maintenance activities I do perform restore and recovery to production and non production servers.
• Providing solutions to teh different applications to fulfill their requirements as part of DBA activities.
• Tuning teh databases using various approaches based on applications and scenarios.
• As part of maintenance activities, I perform archival, purging and re-org for teh production, UAT and SAT DB servers.
• Applying teh Oracle patches to teh databases which are related to product bugs and new implementation and ORA-600 errors.
• Providing 24x7 On Call production support to teh respective teams.

Environment: ORACLE 9i/10g/11g, RMAN, RAC, ASM, GRID, OEM, DATAGUARD, Data pump, AWR, ADDM, ASSM, Humming bird, X-manager, Golden Gate, SQL Developer, SQL, UNIX, Perl,HP, Sun Solaris 9, 10, Linux AS4.0, IBM AIX.Irving TX. Nov ‘08 - July 2010

Confidential

Senior DBA

Responsibilities:

• Coordinating wif Oracle support teams to fine-tune teh database and application at various levels.
• Working wif customers to gather teh information from teh client. providing differnt solutions to clients and working on various issues Like backup and restore process, Capacity planing...
• Co-Ordinating teh offshore and onshore DBA teams.
• Workng on Change requests and Incidents reports.
• Contacting Oracle for technical support through Meta-link/phone/E-mail.
• As part of Infrastructure DBA role I closely work wif admin team for performance monitoring, defining teh LUN sizes as per teh requirement and availability, and os patch sets, VERITAS net backups at os level.
• Installation, upgrading, patching, designing, configuration, tuning and production support for Oracle 9i, 10g & 11g RAC databases.
• Supporting for OLTP databases which involves logical databases design.
• Providing support to application teams for designing and configurations for databases.
• Supporting for Data warehousing (DW) databases.
• As an Infrastructure DBA working wif Application team, admin team, backups team and storage team to setup new system for teh application deployment, testing and training.
• Writing pl/sql procedures, functions, triggers and packages
• Coordinate and work closely wif teh Application team, gather requirements from application team
• Responsible to apply quarterly security patches to teh database server by using OPatch utility.
• Supporting to PeopleSoft application and Siebel CRM application for implementation.
• Successfully installed and configured multiple RAC instances and databases for a migrating applications starting from DEV to PROD.
• Installation and configuration of Oracle 10G RAC wif ASM on raw devises on Linux, HP and AIX.
• Used SRVCTL & ASMCMD utility for managing multiple instances and nodes.
• Responsible for creating and maintaining OCFS in RAC environment wif help of system administrators.
• Experienced in monitoring teh databases by using Oracle utility Grid Control
• Experience in configuring and maintaining Oracle Replication by using streams for Data replication from production system to Data warehouse on RAC Environment.
• Worked on sizing of database and tables, re-organizing of tables, tablespaces and users.
• Expert noledge of Oracle data-dictionary & involved in installing and configuring of OEM DB Console, Grid Control on 10g/11g.
• Provided Assistance to development team on SQL tuning in applications.
• Server side tuning E.g. Rebuilding indexes, Analyzing Schemas etc. Schema refreshes using Data pump and Export/Import utilities from Production to DEV, SIT and test instances.
• Performance tuning at various levels like DB level, memory and SQL application tuning using AWR, ADDM, SQL Tuning advisor.
• Install and configure Grid control to monitor teh databases.
• Configure and maintain Data Guard (Physical Standby database) for teh production database and tested for Switchover, fail over, activating teh standby to primary and zero data loss.
• Configuring teh DR setup using SRDF technology, and defining teh consistency groups across teh databases.
• Providing solutions to database level at physical and logical designing.
• To implement teh backup, archival and purging policies for production support systems.
• Convert Non RAC Database to RAC Database using RMAN backups.
• Having experience in vagarious backup strategies like RMAN, and Logical
• As part of maintenance activities I do perform restore and recovery to production and non production servers.
• Providing solutions to teh different applications to fulfill their requirements as part of DBA activities.
• Tuning teh databases using various approaches based on applications and scenarios.
• As part of maintenance activities, I perform archival, purging and re-org for teh production, UAT and SAT DB servers.
• Applying teh Oracle patches to teh databases which are related to product bugs and new implementation and ORA-600 errors.
• Providing 24x7 On Call production support to teh respective teams.

Environment: ORACLE 9i/10g/11g, RMAN, RAC, ASM, GRID, OEM, DATAGUARD, Data pump, AWR, ADDM, ASSM, Humming bird, X-manager, SQL Developer, TOAD, SQL, UNIX, HP, Sun Solaris 9, 10, Linux AS4.0, IBM AIX., H.P. open view, Service manager.

Confidential, Pleasanton CA

Senior DBA

Responsibilities:

• To work wif teh development team to performance tune teh application and support for teh developing teh applications.
• Co-ordinate wif development team to tune teh applications and Database related issues and resolve teh issues.
• Provided 24x7 On Call production support including remote support.
• Configuring teh Databases on RAC (Real Application Cluster) Environment across multiple servers.
• Configuring RAC on SAN storage and supporting teh RAC databases on UNIX environment.
• Monitoring Cold, Hot and RMAN backup scripts of teh databases supporting different applications and taking backups.
• Creating and Monitoring Indexes, Solving Index fragmentation Problems by rebuilding teh index.
• Configured and maintaining Data Guard (Physical Standby database) for teh production database and tested for Switchover, Fail over, activating teh standby to primary and zero data loss.
• Configured teh logical standby database for teh reports generation purposes.
• Used teh standby database for doing different operations like taking backups, recoveries, collecting statistics and running various reports wifout disturbing teh production database.
• Installed and configured ORACLE Enterprise Manager to monitor teh Databases.
• Involved in query performance, SQL application tuning using TKPROF, SQL TRACE for session, STATSPACK, Explain plan.
• Supporting for teh database level security enhancements.
• Created different types of Indexes (B tree, reverse key, IOT and Bitmap etc), different types of partitions (List, Range, Hash, Composite etc) on different tables.
• Involved in 10g Databases Perform Tuning using of AWR, ADDM, and ASSM.
• Involved in apply teh patches at Database level and operating system level
• Monitoring teh security breaches, logs, database and log space, user activity and resource utilization of production environment.
• Monitored teh database growth and forecasted teh disk storage requirements.
• Involved in Scripting like automation of scheduled backups using schedulers.
• Monitoring teh Hit Ratios and tuning teh System Global Area (SGA) accordingly.
• Implemented Partitioning on huge tables to improve teh performance and reduce teh maintenance to finite window operations.
• Working wif EMC team to configure teh BCV backup and cross checking teh consistency of teh Databases.
• Configuration and monitoring teh RMAN Backups wif Data protector.
• Creating and monitoring teh different tablespaces like user, Undo, temporary Table spaces.
• Creating teh database level user, profiles, and assigning default tablespaces and profiles to teh users.
• Understanding of table space layout, volume layout, RAID striping techniques.

Environment: ORACLE 9i/10g, RMAN, RAC, ASM, OEM, DATAGUARD, Stats pack, AWR, Data pump, TOAD, SQL, PL/SQL, UNIX, Shell script, Sun Solaris 9, 10, Linux AS4.0, IBM AIX 5.2, Humming Bird.

Confidential, Waltham MA

Senior DBA

Responsibilities:

• Installation, configuration and patching of Oracle 9i and 10g on Solaris and Linux servers, Defined instance specific parameter files for ASM and RDBMS instances.
• Involved in creating teh database on Shared Disk Subsystem on RAW partitions and put teh Database in Archive Log Mode.
• Configured listener.ora and tnsnames.ora as on when required for clients.
• Configured and Maintained Oracle RMAN Backups.
• Password file was created for network autantication of teh Administrator.
• Taking Oracle traces and providing teh output of tkprof and explain plan utilities to teh development team. And generating stats pack reports as on when required.
• Working on Fire-fight issues and improve performance during slow system response.
• Database reorganization regularly for removing row migrations and fragmentation using export and import utilities.
• Involved in backup jobs automatic scheduled and monitoring teh backups.
• Apply teh Patches at teh Application, Database level.
• Taking care of tablespace related issues like increasing teh storage parameter values, resizing teh datafiles, adding new datafiles.
• Creating different users and granting them appropriate privileges and roles.
• Providing teh full database dumps and schema/table level dumps to DEV/QA database env.
• Cloning teh database.
• Interacting wif other teams frequently in order to resolve different issues.
• Used Shell Scripting extensively to set up various jobs like backups, Housekeeping, and user deletion.

Environment: ORACLE 9i/10g, RAC, RMAN, Export-Import, Data guard, TOAD, SQL, PL/SQL, UNIX, Sun Solaris, Linux, AIX.

Confidential, Buffalo NY

Lead DBA

Responsibilities:

• Incident and problem ticket resolutions for tickets received from teh Global service desk (GSD).
• Co-ordinate wif development team to performance and tune teh application and Database related issues using explain plan SQL trace and generating teh reports.
• Diagnosing and tuning performance issues in a multiple application environment, and tuning teh databases at various stages.
• Replicated database using Golden gate.
• Creating database on UNIX, Solaris, Linux and Windows System, Design a Complete architecture of teh entire database including production as well testing database.
• Configuring teh Databases on RAC Environment on servers.
• Involved in teh RAC servers configurations and working on RAC systems like UAT DEV and PRD.
• Creating and monitoring teh different table spaces like user, Undo, temporary Table spaces.
• Creating new user accounts, profiles, roles, and privileges and assigned to teh user based on application team and providing security.
• Creating Snapshots to get teh remote database data into teh local database.
• Implemented Partitioning on huge tables to improve teh performance and reduce teh maintenance to finite window operations.
• Creating and Monitoring Indexes, Solving Index fragmentation Problems by rebuilding teh index.
• Transported tablespace from production database and plugged-in it in development database for teh usage of developers.
• Taking teh Cold and Hot backups of teh database. And export full database up on application team request.
• Taking Differential backups of teh database using Recovery Manager (RMAN) Regularly on to disk.

Environment: ORACLE 9i/10g, OEM, RMAN, RAC, Expdp-Impdp, SQL, PL/SQL, Golden Gate, Shell Scripting, UNIX, AIX, Sun Solaris, Linux.

Confidential

DBA

Responsibilities:

• Creating database on Solaris, Linux and Windows System, Design a Complete architecture of teh database including production as well development and testing database.
• Creating and monitoring teh different table spaces like user, Undo, temporary Table spaces.
• Involved in creating teh new user management and security enforcement.
• Password File was created for network autantication of teh Administrator.
• Snapshots were used to get teh remote database data into teh local database.
• Implemented Partitioning on huge tables to improve teh performance and reduce teh maintenance to finite window operations.
• Monitoring row chaining and row migration.
• Loading teh data from flat files to Oracle database using SQL loader.
• Transported tablespace from production database and plugged-in it in development database for teh usage of developers.
• Performing Database import/export to transport various database objects, database changes and updates across environments.
• Taking teh Cold and Hot backups of teh database regularly.
• Involved in configured Physical Standby database for teh production database and tested for Switchover, Fail over, activating teh Standby to Primary and No data loss.

Environment: ORACLE 8i/9i, SQL Loader, Export-Import. SQL, PL/SQL, UNIX, Sun Solaris, Linux, Windows.