SUMMARY:

• 15+ years of experience in IT industry and 10 Years as an Oracle Database Administrator, having hands on experience in database administration, Oracle RAC 10g/11g installation, configuration, upgrades, ASM, RMAN performance tuning, backup and recovery, cloning, production support, migration, database security.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g,11g and 12c in UNIX/LINUX and Windows environment.
• Proficient in Database Administration activities such as Upgrades, Patches, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Developed and maintain database standards as part of DBA Center Of Excellence, develop data migration programs and replication configurations, create and communicate project plans, manage database access privileges, and implement data security policies & standards in adhering to security policies
• Installed and configuration 10g and11g RAC on Red Hat Linux using ASM and RAW devices.
• Upgrade of existing, high available production Oracle databases and PSU patches .
• Implemented RMAN Hot/Cold Backup in manual method using scripts and recovered various Productions, Pre - Production Environment.
• Conversions and migrations from Oracle Version 9i, 10g to 11.2.0.3 and UNIX to Red Hat Linux.
• Experience in Grid control 10g, 11g and 12c and OEM Installation of OMS, Configuring Repository Database and Agents.
• Perform Health checks and proactive monitoring using Oracle Enterprise Manager/Grid Control and UNIX shell scripts.
• Implemented Oracle high availability Solutions like RAC, Data Guard and disaster recovery.
• Ability to perform Oracle database performance tuning tools STATSPACK, TKPROF, AWR, ADDM and ASH reports.
• Installed and configured Dataguard logical standby database primary and standby configuration.
• Perform data conversions and Data loads from legacy systems.
• Tune databases, applications, monitor performance of database servers, related processes CPU, memory, storage, and network.
• Create and maintain wiki documentations for all major installation, implementations and known issues.
• Design, develop and implement Logical and Physical data model modifications for of existing and development of new applications systems.
• Excellent experience in OLTP implementing and managing Very large Oracle databases (VLDB) up to 25+ TB.
• Develop UNIX shell scripts, SQLs, PL/SQL procedures, functions, packages and triggers to support and automate repetitive tasks.
• Experience with Data Modeling, Logical and Physical database design. Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations
• Proficient in using features like Data pump, Flash-Back Recovery, Reusable Table space Management, Log Miner, Transportable Tablespace, Recycle bin.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc).
• Security administration including creating and maintaining user accounts, passwords, access rights.
• Identify db requirements, such as monitoring, analyzing, change activity deployment, and script to monitor.
• Data Guard Configuration, Implementation, Maintenance, Switchover of standby database
• Database and Sql tuning by using Dynamic Performance Views, TKPROF reports, Stats pack/AWR/ASH/ADDM reports of oracle.
• To tune queries to reduce the response time of the queries on the database.
• Oracle Database Design and Sizing
• Oracle database Migration/Upgrade activity.
• Oracle Backup and Recovery Procedures by using user managed method and RMAN
• Export and Import (EXPDP & IMPDP) of databases and their objects, as required.
• Created Database Restore point using Flash Back/Snapshot Standby.
• Worked on Exadata System.Checking Exacheck reports
• Database Instance creation / Cloning
• Database jobs scheduling & monitoring

TECHNICAL SKILLS:

Languages: PL/SQL, SQL, SQL*PLUS, C, Java, Shell Scripting, Perl scripting

Database: Oracle RAC 11g /10g/9i/8.x, MS Access, SQL Server, My SQL

Operating System: UNIX, Solaris, AIX, HP-Unix, Linux, Windows 2005/2003/XP/2000/NT

Tools: SQL*PLUS, SQL Developer, TOAD, PUTTY, OEM, RMAN, SQL* LOADER, Imp/Exp Data pump, VNC Server, ERWIN

Other Technologies: ODBC, Crystal Reports, MS Office, 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, EXP, IMP, RAC

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Oracle Database Administrator

Responsibilities:

• Implemented VPD policy On Production database to control database access .
• Primary Database administrator for several production and pre-production 10gR2 and 11gR2 databases.
• Installation, Configuration and Administration of Oracle 11g and Oracle 10g databases.
• Implementation of High Availability solutions with Oracle 11g/10g, Physical Standby Database Replication.
• Refresh of Database or schema and applications for development and testing purpose.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Partitioning of large tables for better performance and manageability..
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using EXPLAINPLAN, SQLTRACE, TKPROF, AWR and ADDM Reports.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• 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.

Environment: Red Hat Linux 6.4, 6.3, 5.6, Oracle 10g/11g, SQL*Plus, PL/SQL, SQL*Loader,, Toad and SQL Developer, VNC server, OEM 11g,, RMAN and Data Guard.

Confidential, Stamford,CT

Oracle Database Administrator

Responsibilities:

• Primary Database administrator for several retail application customers.
• Worked as team member to provide 24/7 on call production database support.
• Installation, Configuration and Administration of Oracle 9i and Oracle 10g
• Implementation of High Availability solutions with Oracle 10g Standby Database (Active Data Guard), Replication.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Migration of all Oracle 9i/10g databases/clients to 11g.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database’s and applying patches whenever required.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export)
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Partitioning of large tables for better performance and manageability..
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Logical & Physical Database Design
• Capacity Planning and Benchmarking
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• 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

Environment: Red Hat Linux 5.6, Oracle 10g, SQL*Plus, PL/SQL, SQL*Loader,, Toad and SQL Developer, VNC server, RMAN and Data Guard.

Confidential

Oracle Database Administrator

Responsibilities:

• Migration of all Oracle 9i databases/clients to 10g.
• Applying Quarterly patches and Version change patch bundles.
• Implemented backup and recovery procedures using RMAN & Import/Export.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR and ADDM reports.
• Installation and supporting RAC.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Building and Configuring RMAN with Netback up, Legato Backup & HP Data Protector.
• Successfully providing 24x7support 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
• Created users, roles and granted privileges according to the business requirements.
• Provided 24x7support for Production, Development, and test database.
• Setting up new environments (Development, Production).

Environment: Oracle 9i/10g/11g, SQL Server, OEM, RMAN, DBCA, TOAD, Erwin, UNIX, Sun Solaris, Red Hat Linux, AIX, Windows XP, RMAN Backup .

Confidential

Oracle DBA

Responsibilities:

.

• Provided support for all the databases as an operational database administrator
• Configuration and Creation of Databases
• Develop and deploy logical and physical test and production database solutions for Oracle 9i, 10g database
• Worked on recovering data files, control files, block corruption.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
• Involved in the maintenance of the database at Segment level, also user management activities depending on the data access requested by a specific user.
• Upgrade/Migrated the production and development databases from 9i to 10g,
• Installed Oracle 10.2.0.5 on Linux, AIX,Windows 2003 Server, HP-UX and Solaris.
• Going through the day-to-day user requests and troubleshooting the database related problems.
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & move procedures.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions.
• Taking periodic Backup of the Database and the software using RMAN.
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Scheduling jobs using Oracle Job Scheduler.
• Scripts for Cold Backups, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools.
• Monitoring and Optimizing database performance.
• Created scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• SQL scripts to monitor Tablespaces and extent growth.
• System monitoring and maintenance to ensure the high availability.
• Generating administrating Reports of Database on free space statistics, cache statistics and database.
• Creating, altering and dropping data files, tablespaces, and schema objects in the database.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Environment:: Oracle Server 8i,Oracle Server 9i,, SQL, PL/SQL, SQL Server 2000 & 2005, Linux, Shell scripting.

Confidential

Oracle DBA

• OS level activities like space monitoring of Mount point.
• Storage Management, Managing Space, Tablespaces, Segments and Extents.
• Taking Hot and Cold Backups, Exports etc.
• Creating the database tables, setting privileges, indexes, user logins, passwords (security).
• Responsible for monitoring daily and weekly backups, alert logs & space.
• Resolving network related issues.
• Responsible for schema comparison using TOAD.
• Automated the process of analyzing tables every night.
• Installation and configuration of Oracle Client software and Tools.
• Worked with application developers in resolving application issues.
• Responsible for optimizing the queries and application tuning.
• Installed and Implemented Backup & Recovery procedures.
• Proactive database monitoring using automated scripts based on v$views.
• Developer Environments setup using database cloning.

Environment:: Oracle Server 8i,Oracle Server 9i,, SQL, PL/SQL, SQL Server 2000, Linux, Shell scripting.