SUMMARY:

• An insightful Oracle DBA with over 7+ years of hands on experience with Oracle 9i, 10g, 11g.
• Expert - level skills in Installation, Configuration, Upgrading, Patching, Troubleshooting and Performance tuning of oracle databases on different operating platforms.
• In-depth experience with all facets of Database Design, Backups and Recovery, Security Management, Disk Space and File System Management and Monitoring.
• Expertise in using backup and recovery strategies, using cold backup, hot backup and RMAN methodologies.
• Knowledge in Cloning databases for development/testing environments using traditional backup methods such as Export/Import/Data pump utilities. as well as using RMAN.
• Experience in Upgrades of Oracle databases from oracle 9i, 10g to oracle 11gR1/R2 using DBUA.
• Worked on migration of oracle database from Solaris to Red Hat Linux on development, integration and production environment using Oracle Data Migration Assistant.
• In depth noledge of Oracle Database Tuning, Usage of SATSPACK, Database Migration, AWR, ADDM, ASH and UNIX native commands.
• Experienced in Golden Gate Installation and Configuration for database replication purpose.
• Successfully implemented Physical and Logical standby database using Oracle Data Guard feature for High availability configuration.
• Developed RMAN scripts for daily/ weekly backup & recovery. Used Logical backup as full/ partial schemas/database exp /imp, SQLLDR and Data Pump.
• Worked extensively on OLTP/Data warehouse database systems.
• Worked on Sys admin tasks like creating and managing users and their responsibilities.
• Designed backup policies for Single node and multi-node environments using RMAN.
• Proficient in developing Oracle PL/SQL based applications using Oracle Stored Procedures, Functions Packages, Triggers, Materialized views.
• Efficient in SQL query optimization and instance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, Running scripts.
• Install & configure Oracle Enterprise Manager (OEM) Grid Control to maintaining and monitoring databases.
• Expertise in applying various RDBMS & CPU patches using OPatch utility.
• Experience with FTP, SFTP, SCP files on cross platforms
• Experience in writing UNIX Shell scripts to automate business process and daily backup, maintenance, enhancement, designing of data dictionaries and performance tuning.
• Managed many OLTP/Data warehouse database systems.
• Installed and configured 2 nodes server side load balancing RAC (Real Application Clusters) databases on Linux with ASM (Automatic Storage Management) and Data Guard.
• Experience in full life cycle of database administration. Provide 24x7 production supports as on call DBA.
• Strong analytical and problem solving skills. Ability to work within team environment and independently when needed.

TECHNICAL SKILLS:

Operating System: AIX, Solaris, OEL, RHEL Linux, Windows 2008Windows2005, Windows 2003

Programming Languages: PLSQL, SQL, PERL

Database: Oracle 9i, Oracle 10g, Oracle 11g, MySQL

Tools: Oracle SQL Developer, Putty, WinSCP, Toad, PC Anyware,VNC, Xmanager, Citrix server

Application Servers: Oracle R12 eBusiness Suite

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g RAC on Sun Solaris 10 in SIT, DIT, UAT, BDI, BSI, LT, PROD, PROD2 (Data Guard) environments. All installations are configured to Confidential standards.
• Installed and Configured Oracle 11g RAC on RHEL for POC environment.
• Installed, configured and administered Automatic Storage Management (ASM) on RAC instances.
• Installed, configured and administered Data warehousing environment databases like SIT5/L5/P5/P377 etc.
• Applied Jan CPU10, Oct CPU09, Patch Set Update (PSU) 10.2.0.4.1, 10.2.0.4 CRS Patch Bundle 4, Opatch 10.2.0.4.8, and several other Interim patches on all the instances of the RAC.
• Involved in 24/7 support for all the Oracle RAC Instances.
• Developed Monitoring and Maintenance for a large platform of replicated Cluster Databases based on Oracle Grid Control.
• Converted all the above environments from a single node database instance into two node Oracle RAC database using rconfig.
• Resolved errors encountered during the rconfig conversion.
• Planning & Implementing Oracle 10g RAC on Solaris 10 and upgrades.
• Worked closely with Oracle support on issues encountered during the installation of 11g RAC.
• Applied all the post-conversion scripts after the rconfig conversion by specifying cluster interconnects, listener configs and creating services and database in the CRS.
• Gatheird, and administered AWR, ADDM, tkprof, alert logs and explain plan outputs.
• Deployed several release scripts into the above environments.
• Planned and Implemented Oracle 10g schema level Streams and mview replication.
• Monitored and maintained databases sizes ranging from 10 TBs to few hundred GBs.

Environment: Oracle 10g (10.2.0.3/ 10.2.0.4 ), Oracle 11g, Oracle 10g RAC, Data Guard, Oracle 10g Grid Control, TOAD, RMAN, Sun Solaris (64- Bit) 10

Confidential, OH

Oracle DBA

Responsibilities:

• Installed and Configured 3 node 11.2.0.3 RAC with Data guard setup on Linux.
• Installed oracle Stand alone databases on Solaris and Linux platforms
• Applied patches (Patch sets and CPU patches) and worked closely with Oracle to make Application environment up to date
• Upgrade/Migration of Databases from Oracle 10g to 11g.
• Implemented Data guard for faster Disaster Recovery and implemented Golden Gate for database replication.
• Creating new user accounts, profiles, and roles and assigning them to users. Assigning users to groups and granted privileges and permissions to appropriate groups.
• Configuring Oracle 11g/10g databases on an active/passive veritas cluster
• Worked closely with developers in schema design and SQL tuning, performed database capacity planning, performance tuning at system level, database level, and SQL level.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target databases with the Catalog.
• Performed installation and configuration of agents on target databases
• Cloning of Databases for QA and Development from Production databases
• Extensively used Oracle utilities -Export, Import, data pump and Sql loader etc.

Environment: Oracle 10gR2/ 11gR2, AIX, RMAN, Datapump, OEM Grid Control

Confidential, Irving, TX

Oracle DBA

Responsibilities:

• Responsibilities include maintaining databases, monitor daily database activity, implement customer requirements, coordination, performance tuning.
• Installed and configured Oracle 10g 11g Databases on AIX and Linux Operating systems on Development, UAT and Production Systems.
• Designed and Implemented database security using Oracle roles and privileges. Set up the password for new users and tan managed users and their respective sessions.
• Maintenance of the RMAN repository database and configuration of backup policies.
• Installed and administered RAC databases.
• Installed and Configured Golden Gate Setup for replication.
• Creating Indexes, rebuilding indexes, analyzing indexes to improve the performance of query.
• Monitored the various database activities by developing shell scripts and using various tools.
• Worked closely with Developers to develop, maintain and evaluate PL SQL codes and troubleshooting other issues.
• Upgraded Databases from Oracle 10.2.0.4 to 11.2.0.2
• Extensively used Oracle Flash back features.
• Widely used Oracle Grid Control for monitoring the database activities.
• Coded and implemented PL SQL packages to perform Application Security and batch job scheduling.
• Setup, Configured Oracle Data Guard using physical standby database.
• Implemented Dataguard Standby (with FAL), performed switchover failover.
• Patched Oracle databases using OPatch utility.
• Used OEM to monitor Database health, Bottlenecks, session information, table privileges and user roles and grants.
• Monitored scheduled jobs for backups, gathering statistics, AWR reports, data guard status reports, disk space utilization report
• Using Oracle Database Upgrade Assistant for Upgradation and Migration of oracle database to higher version and other platforms.
• Generated triggers for data integrity, created views to resolve complex queries.
• Database Cloning to create Test and Development environments from Production.
• Imported and exported files, databases, schemas and tables using import and export dump features of Oracle database 10g.
• Identifying the poorly performing queries using Explain Plan, TKPROF, and assisting the developers in optimizing and tuning the SQL and PL SQL code using SQL trace.

Environment: Oracle 11g,Oracle 10g,Oracle 9i, Red Hat Enterprise Linux, SUN Solaris 2.7, Oracle RAC, Tkprof, Oracle Enterprise Manager, RMAN, SQL developer, Materialized ViewsExplain Plan, expdp impdp utilities, Oracle database upgrade assistance, Automatic

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Provided high availability (24/7) to the business for very large AMS database with size of 30+TB
• Ensured tier-one production database systems' performance, integrity and security with proactive bottleneck identification (450 SQL Server db, 80 Oracle db, 5 Confidential Informix instance and 10+ Very large databases).
• Performance engineering on Database loads and analyzing poorly performing jobs reported by business. (well tuned like from 4hrs to 10sec, 24hrs to 2hrs )
• Capacity planning and resource management for Large & medium size Databases based on db growth reports along with statistics of database space usage reports
• Performed Database auditing and ensured security controls for SOX
• Performing Disaster recovery exercise for business critical applications on schedule window.
• Archiving & purging the historical data from OLTP database to warehouse database.
• Preparation of design document for new development / enhancement projects.
• Identifying/Plan the best database backup and recovery strategy for the production databases
• Based on day to day work identified the recurring problems and come up with strategic long term solutions. (me.e. JDBC time-out error, Deadlocks, Blocking, IO waits, Oracle parameter tuning ..)
• Maintaining Code check out and check in through Confidential configuration control tool clear Case.
• Provided Change Management, Incident Management, Problem Management, Service Request Management, Task Management using BMC Remedy tools
• Leading, guiding and mentoring Onsite/Offshore database team with Code Review.
• Transforming logical database model to physical database model and giving complete architecture with Disaster Recovery Plan

Environment: Oracle 11g/10g/9i/8i, MSSQLServer 2008/2005/2000, Confidential AIX 5.4 (64bit edition)

Confidential

Oracle DBA (RMAN Backup)

Responsibilities:

• Working on failure SRs and resolving the backup related issues.
• Installed, configured, created and maintained Oracle databases.
• Performed database backup and recovery using recovery manager.
• Implementing RMAN backups to newly build servers.
• Extensive experience in RMAN recovery testing, RAC and stand alone database.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Refreshed schema using Export/Import. Created the database, table space, tables, indexes, set privileges and user logins.
• Identifying Resource Intensive SQL Queries and Give them to Development Team to TUNE the SQL Queries.
• Cloning / data refreshing of test and development databases based on business users requirement.
• Optimizing RMAN backup scripts.
• Giving on-call DBA support.

Environment: Confidential AIX 5.4 (64bit edition), Linux & Windows.

Confidential

Database Administrator (DBA)

Responsibilities:

• Maintaining Oracle databases working for IFS application
• Implemented and supported 11gR2 RAC with ASM on OEL 5.7
• Working on Oracle database related tickets (iServe)
• Refreshing test / dev databases using RMAN backup
• Configuring RMAN backups
• Monitoring databases through OEM grid control
• Daily backups checking
• Re-Org databases on regular intervals
• Installing & Configuring Oracle in new servers remotely
• Working with iLo & Xmanager while installing Oracle on new Linux servers
• Disaster Recovery planning, configuration & maintenance
• Configured Oracle GoldenGate (11.2.1.0.1 ) for table level replication

Environment: OEL 5.7, Windows 2005, Putty, Xmanager, WinSCP.

Confidential

Database Administrator (DBA)

Responsibilities:

• Maintaining ERP IFS Application.
• Giving project access rights to the application users.
• Administering oracle 10gR2 RAC database
• IFS Server & Client application installation.
• Configuring / Installing WEB module.
• Deploying presentation objects in application.
• Applying BUG Fixing / Report patches to application.
• Cloning the database on regular intervals.
• Granting roles & privileges to the Oracle users.
• Maintaining UAT database.
• Taking RMAN & Export backup every day.
• Periodic trimming of log files.
• Database space management.
• Periodic Re-Organizing of Database.
• Evaluating & Enhancing performance of database by analyzing AWR & ADDM reports.
• Monitoring database activity through Oracle enterprise manager and killing any hanging sessions.
• Reducing the wait events by distributing IO across various physical disks (Getting input through monitoring OEM continuously at heavy business hours)
• Identifying Resource Intensive SQL Queries and Give them to Development Team to TUNE the SQL Queries.
• Rebuilding unbalanced indexes.
• Compiling invalid objects after patch deployment.
• Pasting new EXEs’ in CITRIX presentation server.

Environment: Windows 2003, Oracle 9i,10g.

Confidential

Junior DBA

Responsibilities:

• Installation of Oracle 9i windows.
• Patch up-gradation from 9.2.0.1.0 to 9.2.0.8.0.
• Maintaining Oracle 10g database on Solaries5.0
• Checking DR database.
• Configured DataGuard using rman backup
• Monitoring the Datagaurd to synchronize with Production Database.
• Switchover of Physical standby database for role changing in order to do routine maintenance on Primary database.
• Ensuring Health of Database by Monitoring alert log and Archive Generation.
• Sizing of database, space management (Sizing of tables, indexes, rollback segments & tablespaces).
• Generating statspack report weekly once.
• Export,Import & Rman backups.
• Analyzing tables of database daily, weekly basis.

Environment: Solaris 9, Windows 2003, Putty, VNC, WinSCP