PROFESSIONAL SUMMARY

• Over seven years of experience as an Oracle Database Administrator having hands on experience in database administration, installation, configuration, upgrades, performance tuning, backup and recovery, space management, database security, auditing.
• Worked on 2 nodes, 4 node RAC (Real Application Clusters) databases on HP - UX and Linux.
• Good experience in Installation, upgrades of Oracle 11g RAC cluster ware databases.
• Proactive Monitoring, identifying areas that need to be improved in teh application and database using AWR,ASH, ADDM and 11g OEM Grid Monitoring
• Excellent knowledge in Hot/Cold Backup and Recovery using RMAN.
• Experienced in using 11g features Data pump; Flash-Back Recovery, AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 11gOEM Grid Monitoring.
• Experience in Oracle 10g/11g RAC, Oracle ASM, Oracle Data Guard, and Oracle RMAN.
• Have strong Creating Oracle Data Guard in 11gR2using Data Guard Broker.
• Configured Data guard environments for disaster recovery and high availability.
• Experienced in Oracle Support processes for technical requests through Meta link and other Support Procedures.
• Creating a standby database.
• Configured Data guard environments for disaster recovery and high availability
• Configured RMAN and Recovery Catalog for all database.
• Database Backup for all databases running on RMAN and RMAN mode using RMAN.
• Optimal configuration of SGA and PGA.
• Expertise in monitoring, performance tuning and trouble shooting
• Expertise in Security administration, roles, profiles
• Solid experience with data pumps export and import utilities.
• Checking for Alert log file for errors and monitoring teh Hit ratios.
• Management of schemas, objects, tables & indexes partitioning.
• Oracle Enterprise Manager (OEM) & Oracle Management Server (OMS)
• Support for implementing and upgrading various new and third party application on teh client end.
• Implementing various Production rollouts of applications
• Implementing ASM
• Excellent interpersonal skills and strong analytical, problem-solving skills with an attitude that is oriented towards customer satisfaction.
• Exceptionally good team player, self-motivated, dedicated towards work in any kind of environment.

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, HP-UX (10.x, 11.x) and Windows 95/98/2000/XP.RDBMS Oracle 10g/11g, Oracle RAC (10g/11g)

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD, SQL Plus

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Oracle DBA.

Responsibilities

• Performing all teh Database Administration activity like user and roles administration, schema management, checking alert log of all teh databases
• Worked on 2-node 4-node RAC databases from 300 GB-10tb.
• Monitoring and maintenance of Oracle 11g databases on HP-UX and Linux environments.
• Upgraded databases from 11.1.0.7, 11.2.0.2 to 11.2.03.
• CRS upgrades from 11.2.0.2 to 11.2.0.3.
• Installing 11.2.0.3 RDBMS software.
• 11g agent installations and upgrades.
• Applying patches to RDBMS, CRS, and AGENT.
• Worked on RAC S2S Metro cluster, where teh database will be failover from site1 to site2 using service guard package.
• Configured Emcli setup for databases, which relocates teh OEM targets when failover is done on S2S metro cluster.
• Involved in teh process of tuning and refining queries of various applications.
• Performance tuning of SQL Queries.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Extensive usage of ADDM, AWR, ASH, features of 10g.
• Database refresh using Full expdp and impdp, RMAN DUPLICATE,cloning.
• Schema refresh, table refresh using data pump IMPDP,EXPDP.
• Performed Database migration, which includes migrating data from SQLServer 2008r2 to oracle 11203 HP-UX.loaded data into oracle tables using SQLLDR.
• Created DBlinks between oracle and SQLServer using database gateway for SQLServer.
• Restoration and recovery from backup.
• Monitoring teh table growth, database growth, current users, and system resource usage.
• Implementing standby database to provide high availability of database.
• Sizing teh SGA, sizing teh db buffers, shared SQL area, log buffer based on teh requirements.

Environment Linux, HP-UX, SQL, Toad, Oracle 10g/11g.

Confidential, Coraopolis, PA

Oracle DBA

Responsibilities

• Provide production support for all teh databases with 10g and 11g during teh regular business hours.
• Carried out export/import operations of schemas on all teh production/development/stress and integration databases.
• Monitored teh performance ofdatabaseduring stress testing fromOEM (ORACLEEnterprise Manager).
• Performance tuning via OEM, STATSPACK/AWR for 10g.
• Monitoring ofqueries with high response time andhigh disk reads per execution i.e., Top SQL using OEMand tuning teh same using Explain Plan.
• Tuned all teh production/development/stress/UAT databases supporting teh application using Statspack/AWR.
• Used Automatic Workload Repository (AWR) for analyzing teh database performance.
• Performed User Management by creating, Monitoring and management of database users.
• Created and maintained table spaces.
• Installedand configuredORACLEEnterprise Manager with grid control to manage databases
• Created database objects like tables, views, stored procedures, indexes etc
• WrotePL/SQL blocks andstored procedures for teh tasks of useraddition to databasesand user auditingbased on teh user ids required functions and assigned roles, privileges etc.
• Maintainedand administeredORACLEdatabase security by granting and revoking system/objectprivileges, roles, auditing user actions in teh database.

Environment

ORACLE 10g, 11g on Linux/ Unix, Toad, PL/SQL Developer, OEM, VI editor, AWR/ADDM/ASH.

Confidential, Atlanta GA 

Oracle Database Administrator

Responsibilities

• Design and implementation of new product databases.
• Database Backup Configured implemented and using RMAN catalog.
• Implemented Data Guard (Standby) for our Protection Application Support.
• Creation and maintenance of development and test Database
• Creating teh database, tables, table spaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Deciding teh naming conventions of data file, redo log files, table spaces, and segments.
• Implementation and maintenance in production database.
• Review data load processes and suggest enhancements and quality checks
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Monitored teh performance ofdatabaseduring stress testing fromOEM (ORACLEEnterprise Manager).
• Used Automatic Workload Repository (AWR) for analyzing teh database performance.
• Worked on recovering tables and databases using Flash Recovery.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Automatic Diagnostic package and Automatic tuning package is used for Performance tuning of Queries. It is a database that TEMPhas outstanding performance when dealing with querying data. dis is a relation database, but there are no constraints that are set on teh tables, which allow very fast querying
• Developing Hot, cold and logical backup scripts to automate teh backup procedures.
• Restoration and recovery from backup.
• Optimal configuration of SGA and PGA.
• Checking for Alert log file for errors and monitoring teh Hit ratios.

Environment Oracle 10g/11g, SQL plus, Toad, Linux, Hp-Ux, UNIX

Confidential

Oracle DBA

Responsibilities

• Involved in database Tuning using init parameters, optimizing rollback segments, redo log configuration, and I/O distribution.
• Tuning of I/O, which includes separating data files and redo log files on different locations, separating of data files and index files on different locations, reducing disk contentions.
• Creation of Table spaces, tables, users, roles in Oracle.
• Security administration i.e. managing privileges and roles
• Backups and Recovery i.e. exports/imports, hot backups and cold backups, etc.
• Performance tuning using parallel query.
• Space Management, which includes table space creation, adding new data files.
• Involved in Analysis of accounts department requirements.
• Creation of tables, indexes, constraints, procedures, functions and packages based on teh design.
• Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping for Bank statements transactions data with Bank master.
• Written triggers to enforce integrity constraints.
• Implementation of Cold and Logical backup and recovery procedures.
• Involved in user management by assigning appropriate roles and profiles.
• Managed physical and logical components of database.

Environment SQL*Plus, Red hat Linux, HP-UX, UNIX Oracle 10g/11g.