SUMMARY

• About 7+ years of experience as an Oracle Database Administrator, responsible for database administration, production support, installation, configuration, upgrades, patches, backup and recovery, database security, auditing and space management.
• Knowledge of cloning and database security with Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES, 10g/11g/12C OEM Grid Setup.
• Experience in Upgrading databases and applied patch sets to multiple databases.
• Experience in Data guard (DR) Switchover and failover of RAC and Non RAC databases
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
• Expertise in Database Space Management, troubleshooting and performance tuning.
• Excellent analytical and problem-solving skills.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Experience in using OEM, TOAD, Data Migrations using export/import and Datapump.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Experience on working with data guard physical standby databases.
• Experience in deploying Golden Gate for ensuring high availability.
• Good experience in applying the patches using opatch.
• Good experience in design, installation, administration and support of RAC Databases.
• Experience developing applications using ORACLE SQL, PL/SQL and Shell Scripting.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN.
• Good knowledge on Exadata smart scan and Hybrid columnar compressions.
• Excellent Written and verbal Communication skills and knowledge on Oracle Support processes for technical requests with Metalink.

TECHNICAL SKILLS

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2003

Databases: Oracle 11gR2, 10gR2 RAC, 9i, 8i

Oracle Database Tools: Toad, OEM, SQL Developer, Grid Control, MS SQL

Tools: Utilities: Export/Import, RMAN, Data Pump, CRONTAB

Languages: C, Unix shell scripts, PL/SQL

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE

Confidential, Dallas,TX

Sr.Oracle Database Administrator

Environment: Oracle 10g/11g, RAC, ADEPT, Sun Solaris, OEM, Red Hat Linux, TOAD, PL/SQL, Dataguard, shell scripting, VCS

Responsibilities:

• Buidling databases both standalone and clustered databases (RAC), manually and using ATT tool ADEPT .
• Testing for failover and switchover in High avalibility clustered environment Confidential OS level through VCS(veritas clustered services)
• Implementing post build database tasks, like user creation,role assignment,tablespace setup and data migration using expdp/impdp.
• Setup of golden gate in both unidirectional and bidirectional replication, manager, extract and replicat processes
• Upgrading of golden gate databases and usage of logdump utility for troubleshooting abended processes and traversing trail details.
• Installation of 12c OEM agents on both stand alone and RAC environments for alerts and monitoring,discovering targets and pushing templates.
• RAC databases setup which includes prechecks, Grid infrastructure installation,disk group creation and database setup.
• Usage of srvctl and crsctl utilities for monitoring filesytems,cluster resources,database avaialability on preferred nodes etc.
• ASM monitoring using ASMCMD and asm views for checking disk/disk group status.
• Attending production database issues 24*7, for troubleshooting and outages.
• Patching and upgradation of databases in both RAC, Dataguard and stand alone environments from 10g to 11g and 11.1.x.x to 11.2.0.4.5.
• Performance tuning for long running queries using sql analyzer,explain plan,analyzing AWR and ADDM reports.
• Automation of monitoring for filesystem space,alerting and cleanup,RMAN backup scheduling both level 0 and level1, archive backups using crontab and shell scripting.
• Dealing with block corruption and cloning,restoring,recovery of databases using RMAN.
• Raising Service Requests (SR) with Oracle support and following up with logs,traces and dumps for bug and problem resolution.
• Providing quarterly release support and incidental support to push changes,setting up current compliant organizational standards.
• Maintaining organization compliant standards Confidential both user and database level.
• Performed cross platform migration between unix and linux environments under the migration program.

Confidential, Collierville,TN

Sr.Oracle Database Administrator

Environment: Oracle 10g/11g, RAC, SQL Loader, Sun Solaris 10, OEM, Red Hat Linux, TOAD, PL/SQL, DB Artisan.

Responsibilities:

• End-to-End implementation of High Availability solutions Oracle 11gR2 RAC with ASM.
• Good experience in using 11g RAC utilities such as srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities.
• Performed converting single node instance to RAC and Adding instance to the existing 2 node RAC.
• Experience in application support in partitioning, security, performance tuning, memory management, SQL tuning, statistics gathering, Application audit logs, Oracle RAC, Scheduling, etc
• Experience in Data guard (DR) Switchover and failover of RAC and Non RAC databases.
• Installed and configured Golden Gate for replication.
• Setup parameter files for extract and replicat processes in golden gate.
• Create golden gate user with necessary privileges and investigate replication failures using log dump utility.
• Supported critical golden gate system and tested for impact of multiple extract and replicat processes.
• Rehosting and refreshing of schemas from one host to another by using expdp and impdp utilities.
• Creating Physical design models and estimation of size of data using power designer.
• Experience with RMAN backup and recovery setup.
• Performed SQL query tuning and optimization.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache
• Database Cloning and standby database creation using RMAN and manual method from Production to Test and Development environments.
• Maintaining disks for ASM storage inside the disk group and adding using ASMCA for increasing storage as required.
• Installed Oracle text and created context indexes for accented character search.
• Planned and upgraded DB including patch updates (CPU/PSU/one-off).
• Creating incidents, alerts, blackouts, thresholds using OEM 12c.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, Cumulative and differential Incremental Backups.
• Performance Tuning by using Oracle utilities like AWR, ADDM, Explain Plan, StatsPack, Tkprof, for addressing performance bottlenecks and issues.
• Monitored performance of queries using Explain Plan, TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor.
• Maintained and setup streams for schema level propagation and SQL apply.
• SQL, PL/SQL Programming, Shell Scripting, Partitioning, Logical and Physical Database Design.
• Responsible for optimizing data access and performance by tuning indexes.
• Hands on experience in writing UNIX Shell Scripts for automating various database activities.

Confidential, Hanover, MD

Sr. Oracle Database Administrator

Environment: Oracle 9i, 10g, RAC, Sun Solaris, Toad, HP-UX, ASM,GRID, AWR, OEM, Data guard, RMAN, Shell Scripting.

Responsibilities:

• 24 X 7 Production database support with on call pager
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installation and Maintenance of Oracle 9i, 10g, 11g on IBM-AIX, Red Hat LINUX.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment.
• Minimized downtime during disaster recovery and data corruption using Data guard.
• Management of table space growth, monitoring data files additions, extent growth.
• Worked on several shell scripts to maintain the database activities & implemented automated backup strategy using the UNIX shell script.
• Experience in migrating database from NON-ASM to ASM.
• Creation of cluster indexes, bit-map indexes and creation of index organized tables to enhance performance.
• Use of Data gaurd broker command line utility DGMGRL for setting up configurations,starting and stopping Redo transport services and Log apply services & performing switch overs.
• Performing Database Administration activities like space management, user and roles administration, schema management.
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Good experience in golden gate for cross platform migrations.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Confidential, Danville, PA

Sr. Oracle Database Administrator

Environment: Oracle 9i/10g/11g, Linux, Solaris, PLSQL, Shell Scripting, RMAN, Grid control, Data guard, EXP, IMP, Data Pump, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Responsibilities:

• Provide 24x7 production database support
• Support round the clock deployments
• Install the 11gR2 databases for test, development, production-like, production and standby databases
• Migrate database from Solaris to Linux
• Upgrade Oracle Database from 10g to 11gR2
• Clone 10g and 11g oracle homes for setting up standby databases and recovery purposes.
• Install grid agents and setup the databases per standards for monitoring and scheduling jobs.
• Use traditional export-import and Data Pump for refreshing schemas, tables and different objects
• Use Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Apply security related CPU and One-off patches using Opatch utility, Apply RDBMS Patch set Utility (PSU).
• Maintained oracle databases on both windows( NT/2003/2008).
• Recovery of Database (recovering from Media Failure, recovering tables dropped accidentally, recovering data files, recovering from Block Corruption)
• Generate performance reports and Daily health checkup of the database using utilities like AWR,
• Statspack and ADDM to gather performance statistics
• Work closely with the project teams to deploy their changes in the database and servers

Confidential

Sr. Oracle Database Administrator

Environment: Oracle 9i/10gRAC, RHEL, Sun Solaris, SQL, PLSQL, UNIX Shell Scripting, RMAN, Oracle 10g Grid control, Data guard, SQL*Loader, EXP, IMP, TOAD, Data pump, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Responsibilities:

• Proficient in installation and creation of Oracle 9i, 10g databases in development, Production and QA environments including configuration, backup & performance tuning.
• Designing, documenting and deploying through the various development and production environments.
• Refresh/Cloning of the databases from Production to the Test and Development environments.
• Upgraded database from Oracle 9i to Oracle 10g.
• Installation and Configuration of Oracle 10gRAC and Standby Databases for high availability and disaster recovery.
• Automation of deployment/migration from existing systems (Oracle), monitoring and reporting.
• Database Migration
• Applied CPU, One-off patches using Opatch utility, RDBMS patch set Upgrade (PSU).
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Used Oracle 10g grid control utility.
• Planned and implemented Backup & Recovery using RMAN.
• Implemented Cold Backup and Hot Backup depending on the requirement.
• Refreshed development and test databases from production using Logical Backups (Export and Import).
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, AWR, STATSPACK.
• Daily Health Check Up of the Database using ADDM with the help of AWR report.
• Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.
• Maintaining Database Security by Creating Roles, Privileges, Quotas, and Passwords.
• Troubleshooting and Technical Support on Oracle Database & Oracle Applications and Network Administration using SR, SAR, IOSTAT and RDA.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Confidential

Oracle Database Administrator

Environment: Oracle 10g and 9i, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, STATSPACK

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Latest features of Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets, Cube, Rollup have been used to improve the performance and reduce IO.
• Created Tables, Views, Synonyms, Sequences and Indexes.
• Review of Database logical and Physical design
• Creating and managing users, roles, privileges, profiles, schemas
• Established database backup/recovery strategy for different databases
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure
• Oracle Security Patches Installation on Oracle 10g R2.
• Write and modify UNIX shell scripts to manage Oracle environment
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN.
• Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly

Confidential

Oracle Database Administrator

Environment: Oracle 8i/9i, SQL, PL/SQL, RHEL, Sun Solaris 2.5, 2.6, Shell scripting, Tkprof, Explain plan.

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Installation of Oracle 8i/9i on Solaris platform.
• Experience in working with cold and hot backups and recoveries.
• Installation and creation of databases & worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Created materialized views, Rebuilding Indexes and partitioned tables and Index organized tables.
• Customized database backups for Disaster Planning and implementation.
• Creating profiles and assigning to users.
• Performed database tuning for daily loads and slow response issues by refining queries.
• Monitoring Database for fragmentation and correcting them.
• Creating and implementing backup and recovery strategies.