SUMMARY

• Installations and configurations of Oracle database Servers (8i, 9i, 10g, 11g & 12c)/ GridControl 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 24x7productions 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 and development, System Analysis, Designer, Linux and 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 and 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
• 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 and 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

Senior SME Oracle DBA

Responsibilities:

• Knowledge transition from client & 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 and 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 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 maintaining knowledge base & Oracle SR.
• Patching DB as per the tested latest version

Environment: Oracle 11g RAC Oracle, SQL &PL/SQL, Import, Export, Expdp, impdpSQL*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

Subject Matter Expert

Responsibilities:

• Knowledge transition from Client and implemented best practices for DB management.
• Led team and provided technical assistance within team and to Client.
• Installed Oracle11g RAC & converted standalone DB to RAC with minimum down time.
• Migrated DB from one platform to another & migrated DB to ASM from normal file system
• Maintained and created standby database and managed backup and Recovery.
• Scheduled and Maintained Database Backup and Recovery.
• Implemented 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.
• Participated in testing and the development of performance standards.
• Involved in performance test & daily maintenance of production which were in GB & TB.
• Involved in root cause analysis & provided technical assistance on RAC issues
• Responsible for creating and maintaining knowledge base and Oracle SR.
• Monitored health of all production database and resolved trouble ticket within given SLA
• Managed and created database user as well as database space management.
• Refreshed data from prod to test by cloning DB or by Export / Import & Expdp /Impdp Utility

Environment: Oracle 8i, 9i, 10g & 11g RAC Oracle, SQL &PL/SQL, Import, Export, Expdpimpdp, 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

Primary DBA

Responsibilities:

• User and Object Management. Scheduled & maintained database Backup and Recovery
• Database Export and Import (used expdp and impdp).
• Provided assistance to developer for database driven applications.
• Maintenance of production database
• Tuned Oracle database for better performance. Involved in Root cause Analysis
• Provided technical assistance to customer as a technical expert of oracle (DBA).
• Responsible for creating & maintaining knowledge base. Monitored health of all database
• Resolved Trouble ticket within given SLA.
• Managed and created Database user as well as to do Database Space management.
• Refreshed data from prod to test by cloning DB or by Export/Import & Expdp /Impdp Utility. Responsible for regular Health Check of Database

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

Confidential

Primary DBA

Responsibilities:

• Managed over all day to day Administration Oracle 9i, 10g & 11g database.
• Configured and Installed Oracle DB software.
• HEALTH CHECK of all DATABASES on regular basis as well as resolved all trouble ticket / Incident within SLA.
• Applied CPU Patches on all versions with one of patch if needed.
• Database Performance tuning in production and development environment.
• Monitored and performed 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.
• Established network connectivity with client.
• Managed 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.
• Participated in testing and the development of performance standards.
• Partitioned and Purging of Data regularly.
• Created services for application.
• Written Script and scheduled that in crontab.
• Created Document related to Day to day task to perform as DBA.
• Created Document by studying over all application, database and system.

Environment: Oracle 9i, 10g & 11g, Oracle 10g R2 RAC, SQL &PL/SQL, Import, ExportSQL*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

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.
• Added and removed services, databases and instances on oracle CRS using srvctl utility and DBCA utility
• Tested the deliveries, Releases, and patches before applying them in the production environments.
• Designed and implemented database backup strategy and performed full, incremental and archive backups using RMAN. Troubleshooting with RMAN backup problem.
• Configured and maintained DataGuard (Physical Standby database) for the production database and tested for Switchover, Fail over, activated 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.
• Monitored and Tuned 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.
• Participated in testing and the development of performance standards.
• Re-organized the Database table regularly by removing row migrations and fragmentation using export and import utilities
• Provided the full database dumps and schema/table level dumps to DEV/QA database environments when needed.
• Estimated 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.
• Provided 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.
• Coordinated with Developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, Security, backup and Recovery, SQL coding guide lines etc.
• Cloned/Refreshed 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.
• Monitored and performed backup, restoration of nearly 50Oracle 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
• Troubleshoot Database error for all databases of my segment.
• Provided consultancy and solutions on various issue of Database Performance.
• Provided consultancy on backup and Disaster recovery
• Created Backup Policy and to Set Disaster Recovery DB server.
• Installed and configured cluster ware, RAC software, creating and Administrating RAC Database.
• Installed OEM and Agent.
• Managed Database through Grid control.
• Performed AGENT related activities.
• Maintained and monitored new server CONFIGURATION CHECKLIST
• Configured 10g RAC, ASM Data Guard Database on Grid.
• Created new BLACKOUTS and DR Blackout.
• Set standard MONITORING THRESHOLDS and associate database to it.
• Set standard NOTIFICATION RULES & associating it with target.
• Created USER DEFINED METRICS (UDM):
• Made GROUPS and assigned it to proper group.
• Assigned TARGETS to the ROLES
• Created ADMINISTRATOR ACCOUNT.
• Changed HOST NAME to FULLY QUALIFIED NAME
• Decommissioned the TARGETS from GRID CONTROL
• Installed ORACLE 10G GRID AGENT and INSTALLING PUTTY
• Responsible for Agent and Grid Migration.
• Created Document by studying over all application, database and system.
• Applied Patches to Upgrade Database as well as for security purpose (CPU Patches).
• Checked Security Policy applied on Database properly or not.
• Upgraded test Database from 9i to 10g using dbua
• Did HEALTH CHECK of all DATABASES on regular basis as well as resolved all trouble ticket under SLA.
• Implemented CT (change ticket) and task ticket within given SLA (Service level agreement).

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

Confidential

Oracle DBA - Production Support

Responsibilities:

• Monitored & performed backup, restoration of nearly 150 Oracle 24X7 Database which were in terabytes by RMAN/shell scripting on Windows 2000 & Sun Solaris
• Troubleshoot Database error on nearly 150 databases. Provided consultancy on various issue of Database Performance, backup and Disaster recovery
• Took Backup of All database, that may be Cold backup, Hot backup or logical backup i.e. using Export utility.
• Created Document by studying over all application, database and system.
• Created Test server.
• Created Backup Policy for Database on windows 2000 by RMAN.
• Upgraded test Database from 9i to 10g using dbua
• Monitored Health of all DATABASE
• Resolved Trouble ticket within given SLA.
• Managed and created Database user as well as to do Database Space management.
• Refreshed Data from prod to test by cloning DB or by Export / Import Utility.
• Regular Health Check of Database.
• Restored and recovered the database from backup during time of Crash.

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

Confidential

Oracle DBA /Support

Responsibilities:

• Installed, configured and creation of instances in Linux and Windows Environments of oracle 9iAS, Oracle 10g AS, & Oracle 10g database.
• Installed Oracle 10g Real Application Cluster.
• Managed over all day to day Administration Oracle 10g RAC database.
• Configured and Installed Oracle Internet Directory.
• Configured OEM for Standalone / OMS.
• Database Performance tuning for development team.
• Monitored and performed 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.
• Established network connectivity with client.
• Managed database security. Wrote Oracle Technical content.
• Checked and validated database file as well as segment using dbverify utility.
• Cloning Oracle 9i database to make test database server.
• Upgraded Oracle 9.2.0.1 database to Oracle 10.1.0.2 using dbua utility.
• Loaded xml file data into oracle user table and oracle table data into xml files.
• Created Physical Standby database

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

Confidential

Oracle DBA/Support Engineer

Responsibilities:

• Administrated 24X7 Oracle 10g Production Database on Red Hat Linux Enterprise Edition 3.1 with system support.
• Created Backup Strategies for 24x7 using RMAN and Linux shell script.
• Developed proper client connection with Oracle database as well as technical support to customer related to Oracle Database. Tuned Database as required
• Provided Training to new employee who worked on Oracle Database.
• Database Installation, Physical Storage Configuration, Object Management and Managing Physical DB files. Provided technical support, including patches
• Database Creation and Database Backup and Recovery of Oracle 10g database by scripting and RMAN.
• Database Export and Import on Oracle 10g database.
• Provided proper connection to client on database.
• Created backup policy and implemented it.
• Installed new versions Oracle RDBMS and Patching of Oracle DB.
• Tuned and managed over all Activity for 24x7 Oracle databases.
• Provided solution to client and did troubleshooting related to Oracle Database.
• Made document related to all the Activity performed for Managing Database.
• Wrote Oracle Technical content and monitored the alert logs, and trace files.
• Maintained 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 Daily Oracle Hot Backups.
• Installed Operating system windows 2000 server and professional.
• Installed 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