Summary:

10+ years of relevant Oracle DBA experience that includes leading team of DBA’s, people management, database administration, trainer, database design, development and support of oracle 8i/9i/10g/11g (RAC) in production, test and development environment.

Technical Experience:

• Installations and configurations of Oracle database Servers (8i, 9i, 10g, 11g & 12c)/ Grid Control on Linux & Windows servers. As well as manage Oracle DB through SQL PLUS, Grid control, OEM and Putty.
• Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listner, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
• Experience as 24x7 productions DBA as well the application (development) database administrator.
• Experienced in working with very large 24x7 Oracle RAC 10g & 11g databases on ASM of nearly 80GB to 22TB.
• Experience in converting Standalone db to RAC, as well as converting DB from normal file system to ASM.
• Strong in Database design & development, System Analysis, Designer, Linux & Windows server Administration.
• Experienced in resource management like data files with ASM (Automatic Storage Management) (Trouble shooting, Add, Remove Files etc.), online redo log files, control files. Allocating logical storage structures like tablespace, schema and extents as well as configuring Oracle databases on Multi Threaded Servers.
• Experience in database patching, cloning, upgrade, migration & maintaining standby db server (DR).
• Experience with database backup, recovery, and setting up disaster recovery Database servers.
• Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram, DFD etc)
• Expertise in all the phases of Software Development Life Cycle (SDLC).
• Experienced in working with DBVERIFY utility and other method to find Data Corruption.
• Involved in Capacity planning for Databases and Server consolidation
• Transition various IT Database functions (CORP / SALES / FINANCIAL / MANUFACTURING) from international clients like Guitarcenter, Pittsburg Glass work, Blockbuster, Elsevier publishing & Dell segments to offshore team.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, ADDM, AWR, Optimizer Hints, Statspack and TKPROF utility. Participate in testing and the development of performance standards.
• Re-organizing the DB table regularly by removing row migrations and fragmentation Providing the full database dumps and schema/table level dumps to DEV/QA database environments when needed. And also refreshed & migrated full DB using data pump
• Estimating Storage requirements, Creation of Tablespaces and other Database Primary Objects, increasing the storage parameter values, resizing the datafiles, adding new datafiles.
• Active participation in ILM (Information Life Cycle management) initiative. As a DBA worked closely with Application team members in order to implement archive and purging process on all database servers to ensure enough free space at low cost.
• Adding and removing services, databases and instances on oracle CRS using srvctl utility and DBCA utility
• Testing the deliveries, Releases, and patches before applying them in the production environments.
• Design and implement of database backup strategy and performed full, incremental and archive backups using RMAN. Troubleshooting with RMAN backup problem.
• Optimization and fine-tuning the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes.
• Experience in performing DRV (Database Restoration Validation) Test.
• Experience in performing AGENT related activities like Grid Migration / Agent Patching etc.

Professional Experience.

Confidential , NY

Role: Sr. SME Oracle DBA

Responsibilities:

• To do knowledge transition from Client and to implement best practices for DB management for NAB.
• To Lead team and provide technical assistance within team and to Client.
• Implementing Oracle 11g RAC DB for NAB as per RFS (Request for Server)
• Providing technical Training to other SME (Subject Matter Expert).
• Involve in service Activation and De-Activation.
• Setting up Stand-by database as per need.
• Making DB server as per Standards & Compliances.
• Taking interview of Other DBA’s
• Setting up Backup and testing it before handing it to production team.
• Providing co-ordination between India and Australian team
• Involved in performance Test & Daily Maintenance of production which are in GB & TB.
• To do Root cause Analysis.
• Worked on URT (User Revalidation and Testing) as well as SHC (Standard Health Check)
• Involved in call while handing over server to BAU team and taking sign-off.
• Server Consolidation.
• Responsible for creating and maintain knowledge base & Oracle SR.
• Patching DB as per the tested latest version

Environment: SQL & PL/SQL, Oracle 11g RAC Oracle, Import, Export, Expdp, impdp, SQL*Plus, RMAN, OEM, Grid and Net8, Red Hat Enterprise Linux, SUSE Linux 64Bit R5.2 7 MS-servers, lotus Notes, Remedy, Cirat (Change management tool)

Confidential , India

Role: Project Lead DBA

Responsibilities:

• To do knowledge transition from Client and to implement best practices for DB management.
• To Lead team and provide technical assistance within team and to Client.
• Installation of oracle 11g RAC & Converting standalone DB to RAC with minimum down time.
• Migration of DB from one platform to another & Migration of DB to ASM from normal file system.
• To maintain & create standby database & to manage backup and Recovery.
• Scheduling and Maintaining Database Backup and Recovery.
• To implement change management process.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, ADDM, AWR, Optimizer Hints, Statspack and TKPROF utility. Participate in testing and the development of performance standards.
• Involved in performance Test & Daily Maintenance of production which are in GB & TB.
• To do Root cause Analysis & Providing technical assistance to customer as a RAC issues
• Responsible for creating and maintain knowledge base & Oracle SR.
• Monitoring Health of all production DATABASE & Resolving Trouble ticket within given SLA.
• Managing & creating Database user as well as to do Database Space management.
• To Refresh Data from prod to test by cloning DB or by Export / Import & Expdp /Impdp Utility.

Environment: SQL & PL/SQL, Oracle 8i, 9i, 10g & 11g RAC Oracle, Import, Export, Expdp, impdp, SQL*Plus, RMAN, OEM, Grid and Net8, Red Hat Enterprise Linux, SUSE Linux 64Bit R5.2 7 MS-servers, I-support & delta shield. (Change management tool)

Confidential , India

Role: Primary DBA

Responsibilities:

• User & Object Management.
• Scheduling and Maintaining Database Backup and Recovery.
• Database Export and Import (used expdp and impdp).
• To provide assistance to developer for database driven applications.
• Maintenance of production.
• Tuning Oracle Database for better performance of Application.
• To do Root cause Analysis
• Providing technical assistance to customer as a technical expert of oracle (DBA).
• Responsible for creating and maintain knowledge base.
• Monitoring Health of all DATABASE
• Resolving Trouble ticket within given SLA.
• Managing & creating Database user as well as to do Database Space management.
• To Refresh Data from prod to test by cloning DB or by Export / Import & Expdp /Impdp Utility.
• To do Regular Health Check of Database.

Environment: SQL & PL/SQL, Oracle 8i, 9i, & 10g Oracle, Import, Export, SQL*Plus, RMAN, OEM, Grid, Data pump and Net8, UNIX Sun Solaris 5.8, Red Hat Enterprise Linux, SUSE Linux 64Bit R5.2, MS-servers, IASS

Role: Primary DBA

Responsibilities:

• Managing over all day to day Administration Oracle 9i, 10g & 11g database.
• Configuring and Installing Oracle DB software.
• To do HEALTH CHECK of all DATABASES on regular basis as well as to resolve all trouble ticket / Incident within SLA.
• Applying CPU Patches on all version with one of patch if needed.
• Database Performance tuning in production and development environment.
• Monitoring & performing backup, restoration of Oracle 24X7 Database by RMAN.
• Tuning from offshore client’s SQL, Procedure, I/O etc.
• Technical support and trouble shooting for production environment.
• Establishing network connectivity with client.
• To manage database security.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, ADDM, AWR, Optimizer Hints, Statspack and TKPROF utility. Participate in testing and the development of performance standards.
• Partitioning and Purging of Data regularly.
• Creating services for application.
• Writing Script and scheduling that in crontab.
• Creating Document related to Day to day task that what I have to perform as DBA.
• Creating Document by studying over all application, database and system.

Environment: SQL & PL/SQL, Oracle 9i, 10g & 11g as well as Oracle 10g R2 RAC, Import, Export, SQL*Plus, RMAN, OEM, Grid, Data pump and Net8., UNIX Sun Solaris 5.8, Red Hat Enterprise Linux, SUSE Linux 64Bit R5.2, MS-servers, IASS

Confidential ., India

Primary DBA

Responsibilities:

• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager), Statspack, and V$ dynamic views
• Upgraded database from 9i/10gR1 to 10gR2.
• Adding and removing services, databases and instances on oracle CRS using srvctl utility and DBCA utility
• Testing the deliveries, Releases, and patches before applying them in the production environments.
• Design and implement of database backup strategy and performed full, incremental and archive backups using RMAN. Troubleshooting with RMAN backup problem.
• Configured and maintaining DataGuard (Physical Standby database) for the production database and tested for Switchover, Fail over, activating the standby to primary with zero data loss
• Optimization and fine-tuning the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes.
• Monitor and Tuning of Database Performance by using various optimization techniques.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, ADDM, AWR, Optimizer Hints, Statspack and TKPROF utility. Participate in testing and the development of performance standards.
• Re-organizing the Database table regularly by removing row migrations and fragmentation using export and import utilities
• Providing the full database dumps and schema/table level dumps to DEV/QA database environments when needed.
• Estimating Storage requirements, Creation of Tablespaces and other Database Primary Objects, increasing the storage parameter values, resizing the datafiles, adding new datafiles.
• Active participation in ILM (Information Life Cycle management) initiative. As a DBA worked closely with Application team members in order to implement archive and purging process on all database servers to ensure enough free space at low cost.
• Provide database administration on production, testing and development database servers. Creation of database objects like tables, indexes, stored procedures, snapshots and views etc. Creation of users and roles and maintaining system security.
• Coordinating with Developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, Security, backup & Recovery, SQL coding guide lines etc.
• Clone/Refresh of Production databases to Testing and training environments.
• Interacted with Oracle Support for resolving various critical database issues
• Responsible for 24x7 on-call support as per schedule.
• Monitoring & performing backup, restoration of nearly 50 Oracle DB (supporting 24X7 10g RAC Database, 10g Single Instance Database & Oracle 9i Database which are in TB) by FRA, RMAN on windows 2000 server, Red Linux 32 bit & SUSE Linux 64 bit
• Troubleshooting Database error for all databases of my segment.
• Providing consultancy and solutions on various issue of Database Performance.
• Providing consultancy on backup & Disaster recovery
• To create Backup Policy and to Set Disaster Recovery DB server.
• Installing & Configuring cluster ware, RAC software, creating & Administrating RAC Database.
• To install OEM and Agent.
• To manage Database through Grid control.
• To perform AGENT related activities.
• To Maintain and monitor new server CONFIGURATION CHECKLIST
• To CONFIGURE 10g RAC, ASM Data Guard Database on Grid.
• Creating new BLACKOUTS & DR Blackout.
• To set standard MONITORING THRESHOLDS & associate database to it.
• To set standard NOTIFICATION RULES & associating it with target.
• To Create USER DEFINED METRICS (UDM):
• To make GROUPS and to assigning it to proper group.
• To Assign TARGETS to the ROLES
• To create ADMINISTRATOR ACCOUNT.
• Changing HOST NAME to FULLY QUALIFIED NAME
• To Decommission the TARGETS from GRID CONTROL
• To INSTALL ORACLE 10G GRID AGENT & INSTALLING PUTTY
• Responsible for Agent and Grid Migration.
• Creating Document related to Day to day task that what I have to perform as DBA.
• Creating Document by studying over all application, database and system.
• Appling Patches to Upgrade Database as well as for security purpose (CPU Patches).
• To check Security Policy applied on Database properly or not.
• Upgrading test Database from 9i to 10g using dbua
• To do HEALTH CHECK of all DATABASES on regular basis as well as to resolve all trouble ticket under SLA.
• To Implement CT (change ticket) and task ticket within given SLA (Service level agreement).

Environment: Oracle 10g Real Application Cluster, Grid, Physical and Active Standby, RMAN, ASM, Red Hat Linux, SUSE Linux 64Bit & Remedy, SQL & PL/SQL, Oracle 11g & 10g R2 RAC, Import, Export, SQL*Plus, RMAN, OEM, Grid, Data pump and Net8, Windows 2003, Windows 2000, Red Hat Enterprise Linux, SUSE Linux 64Bit R5.2, Remedy

Confidential , India

Role: Oracle DBA – Production Support

Responsibilities:

• Monitoring & performing backup, restoration of nearly 150 Oracle 24X7 Database which are in tera bytes by RMAN/shell scripting on windows 2000 and UNIX Sun Solaris.
• Troubleshooting Database error on nearly 150 databases.
• Providing consultancy on various issue of Database Performance, backup & Disaster recovery
• To take Backup of All database, that may be Cold backup, Hot backup or logical backup i.e. using Export utility.
• Creating Document related to Day to day task that what I have to perform as DBA.
• Creating Document by studying over all application, database and system.
• To create Test server.
• To create Backup Policy for Database on windows 2000 by RMAN.
• Upgrading test Database from 9i to 10g using dbua
• Monitoring Health of all DATABASE
• Resolving Trouble ticket within given SLA.
• Managing & creating Database user as well as to do Database Space management.
• To Refresh Data from prod to test by cloning DB or by Export / Import Utility.
• To do Regular Health Check of Database.
• To Restore and Recover the database from backup during time of Crash.

Environment: SQL & PL/SQL, Oracle 10gR1, Oracle 9i & Oracle 8i, Import, Export, SQL*Plus, RMAN, OEM and Net8, Windows 2003, Windows 2000 & Sun Solaris, Oracle Designer.

Client: Confidential

Role: Oracle DBA /Support

Responsibilities:

• Installation, configuration and creation of instances in Linux and Windows Environments Of oracle 9iAS, Oracle 10g AS, & Oracle 10g database.
• Installation of Oracle 10g Real Application Cluster.
• Managing over all day to day Administration Oracle 10g RAC database.
• Configuring and Installing Oracle Internet Directory.
• Configuring OEM for Standalone / OMS.
• Database Performance tuning for development team.
• Monitoring & performing backup, restoration of Oracle 24X7 Database by RMAN.
• Tuning from offshore client’s SQL, Procedure, I/O etc.
• Technical support and trouble shooting for the development team.
• Establishing network connectivity with client.
• To manage database security.
• Writing oracle Technical content.
• To check & validate database file as well as segment using dbverify utility.
• Cloning Oracle 9i database to make test database server.
• Upgrading Oracle 9.2.0.1 database to Oracle 10.1.0.2 using dbua utility.
• Loading xml file data into oracle user table & oracle table data into xml files.
• Creating Physical Standby database

Environment: SQL & PL/SQL, Oracle 10g, Oracle 9i & Oracle 8i, Import, Export, SQL*Plus, RMAN and Net8, Windows 2003, Linux Enterprise Edition Red Hat, Oracle Designer, Putty, Remote desktop, Toad.

Confidential , India

Oracle DBA/Support Engineer

Responsibilities:

• Database Installation, Physical Storage Configuration, Object Management & Managing Physical DB files.
• Technical Support, including patches.
• Database Creation. & Database Backup and Recovery of Oracle 10g database by scripting and RMAN.
• Database Export and Import on Oracle 10g database.
• To provide proper connection to client on database.
• Creating backup policy and implementing it.
• Installation of new versions oracle RDBMS and Patching of Oracle DB.
• Tuning & managing over all Activity for 24x7 Oracle databases.
• Providing solution to client and to do troubleshooting related to oracle Database.
• Making document related to all the Activity performed for Managing Database.
• Writing oracle Technical content & Monitored the alert logs, and trace files.
• Maintaining the database security by granting of roles and privileges to the users.
• Mirrored the control files and multiplexing the redo log files.
• Developed & Maintained Crontab Shell Scripts to Schedule the Daily Oracle Hot Backups.
• Installation of Operating system windows 2000 server & professional.
• Installation of SQL-Server 2000.
• Database Backup and Recovery of SQL-server 2000.
• Database Export and Import of SQL-Server 2000.

Environment: Oracle 10g Real Application Cluster, Grid, Physical and Active Standby, RMAN, ASM, Red Hat Linux, SUSE Linux 64Bit & Remedy.