SUMMARY

• Over 9 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, Unix shell scripting and documentation.
• Hands on experience with installation, configuration and maintenance of Oracle Golden Gate.
• Worked as a team member to provide 24x7on - call production database support.
• Oracle Database Administration experience in variety of different environments like AIX, HP-UX, SUN SOLARIS, RedHat Linux and Windows.
• Worked with Oracle Databases (11g/10g/9i) on Unix/Linux/Windows platforms.
• Planned and implemented DR & high availability solutions using Oracle 11g RAC & 10g RAC, Standby Database (Oracle Data Guard).
• Configured Logical and Physical Database design in 10g & 11g.
• Worked on database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN and manual methods.
• Experience in trouble shooting RMAN issues in performing the Backup and Recovery process.
• Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Performing daily activities and troubleshooting the database issues using OEM Grid control.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE,custom scripts troubleshooting oracle databases using sqltrace utilities.
• Have good Working knowledge of disaster recover models with experience in implementation and recovery of Oracle databases and RAC clusters.
• Experience in Upgrading databases, applying patches.
• Good experience on Oracle Support processes for technical requests through Metalink and other Support Procedures
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Backup and Recovery procedures.
• Experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Supported development, implementation and maintenance of SQL Server database.
• Configured mirroring for SQLServer databases.
• Worked on all backup and restore scenarios for SQL Server databases.
• Proven ability to adapt to demanding schedules and changing priorities and ability to function successfully in a highly stressful and critical environment.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris, AIX 5.1, 5.2, 5.3 RedHat Linux RHEL 2.1, 3.x, 4.x and Windows.

RDBMS: Oracle 11gR2, Oracle 10g, Oracle 9i,Oracle GoldenGate 11.2.1, Oracle 11g (RAC), Oracle 10g (RAC). SQL Sever

Languages: SQL, PL/SQL,UNIX Shell.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp,, TOAD, Golden Gate.

Tools: /Utilities: PUTTY,OEM GRID,SSH,WinSCP,EXPLAIN PLAN, STATSPACK, AWR, ADDM

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Oracle DBA Analyst

Responsibilities:

• Involved in 24x7 support for Production database and applications with on-call pager.
• Installation and creation of 11g RAC databases for Testing, Development and Production.
• Supported upgrades from oracle 11g to 12c.
• Performed migration from 10g to 11g.
• Supported development, implementation and maintenance of sql server database.
• Supported migration, and performance tuning on sql server database.
• Installed and configured oracle 11g RAC for high availability.
• Data Refresh from Production to Test and Development environments using manual method and RMAN Duplication.
• Participated in designing and building OEM environments.
• Proficient in using OEM and grid control.
• Resolving Performance issues.
• Provided disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data. Administer, maintain, and implement policies and procedures for ensuring the security and integrity of the database and evaluate and recommend available database management support products.
• Performed disaster recovery and provided business continuity plan for development and production environments.
• Installed and Configured GOLDEN GATEExtracts/replicat for multiple databases.
• Implemented necessary monitoring scripts for Oracle in unix scripting.
• Cloned environments to create patch test, development and QA environments.
• Performance tuning for optimized results using tools like AWR,SQL TRACE,TOAD.
• Setup of Standby Database(Data Guard). Performing Failover and Switchovers.
• Load balancing, Database/Schema/Table Re-Organization for faster performance using export/import&move procedures.
• Daily Health Check Up of the Database using AWR, ADDM.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Performance tuning with OEM, AWR, ASH.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS NETBACKUP
• Scheduled jobs using Oracle Job Scheduler.
• Partitioning large objects for better performance.
• Scripts for Cold Backup, 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.
• SQL scripts to monitor Table spaces and Extent growth.
• Writing UNIX shell scripts for backup and recovery, import and export procedures.
• Experience in using UNIX utility commands such as grep, awk and sed.
• Monitoring and Optimizing Database Performance.

Environment: Oracle 11g R2,Oracle Goldengate 11.2.1, RAC/11g RAC/10g, ASM, HP-UX, AIX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof.

Confidential, Framingham, MA

Sr. Oracle DBA

Responsibilities:

• Apply patches every quarter released by oracle for stand-alone and RAC Instances.
• Strictly adhere to SLAs defined for Incidents, SRFs and Database refresh from production to Non-production environments.
• Excellent client facing and presentation skills.
• CPU patching (EMPTY HOME and IN PLACE) for stand alone, RAC databases.
• Performance tuning using various tools like OEM, AWR, ADDM and custom made scripts.
• Worked on Oracle Binaries Installation.
• Worked on Database Up-gradation.
• Worked on User Management.
• Involved in Space Management and Capacity Planning.
• Segments,Constraints, Roles, Privileges, space management and configuring database listeners.
• Computing the statistic of database through monitoring dynamic and performance tables regularly & Implemented SQL scripts to monitor & to get information on Freespace, Extents and Tablespaces.
• Monitoring critical grid alerts and alert log for Critical databases.
• Excellent planning and management of deliverables assigned.
• Identifying and resolving Locks issues.
• Creating service request (SR) with oracle support for critical issues.
• Creating and implementing change requests.
• Tune and create query baselines for performance improvements.
• Providing 24x7 support and On-call Support.
• Attend client calls and telepresence.

Environment: Oracle RAC, 11G r2,10G,ASM,AIX,Hp-unix,Sun Solaris,Red Hat Enterprise Linux, OEM.

Confidential, Wilmington, DE

Sr. Oracle DBA

Responsibilities:

• Installation of Oracle Database servers.
• Oracle 10g, 11g Standalone Installations and configuration on AIX machine.
• Database Migration from source to target using RMAN, EXPDP.
• Data Pump (EXPDP/IMPDP) Usages for schema backup and refresh.
• Troubleshooting the issues while installation.
• Oracle Client Installation on Windows application server.
• Segments,Constraints, Roles, Privileges, space management and configuring database listeners.
• Generating AWR report for performance analysis
• Using OEM console to monitor database.
• Planning and scheduling backups using Crontab (UNIX) and Scheduler (Windows)
• Creation of DB LINKS
• Monitoring and optimizing Performance of the Database
• Creating and designing schemas as a part of development.
• Creating, Handling, Closing of SR’s for several issues
• Creating and maintaining the change record for the migration.

Environment: Oracle 11g/10g,IBM AIX, Sun Solaris, Red Hat Linux, Windows 2003, SQL*Plus, Grid Control, TOAD.

Oracle DBA

Responsibilities:

• Supporting production database system 24*7.
• Primary point of contact for client for production database support.
• Installation and Configuration of Oracle 10g RAC.
• Migrating Oracle databases from windows to Linux.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implemented Hot, Cold and Logical backup plans.
• Database patching using opatch.pl Perl script.
• Proactive database monitoring using 10g grid control.
• SQL tuning using Statspack, AWR, Explain plan, Tkprof.
• Installation, Configuration and Maintenance of Logical and Physical Standby databases.
• Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups for OLTP, Data warehouse, and Business object repositories. Fix backup failures, address and implement resolutions.
• Conducting sizing& capacity planning for Oracle databases.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth.
• Upgraded Oracle 8i, 9i databases to Oracle 10g.
• Applied patches to Oracle Databases.
• Monitoring Growth of tables and undertaking necessary re-organization of database objects as and when required.
• Responsible for optimizing the queries and application tuning.
• Oracle Database monitoring, troubleshooting and resolved the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment: Oracle 10g/9i RAC,IBM AIX, Sun Solaris, Red Hat Linux, Windows 2003, Streams, SQL*Plus, Grid Control, TOAD

Confidential

Oracle DBA

Responsibilities:

• Provided support for all the databases as an operational database administrator.
• Installed and configured Oracle 8i databases.
• 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.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Analyze, design and implementation of the Database for e-commerce system.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.
• Proactive database monitoring using automated scripts based on v$views.
• Frequent Database audits to ensure the SOX standards were not violated.
• Developer Environments setup using database cloning and refresh procedures.

Environment: Oracle 9i, SQL, PL/SQL, Sun Solaris,Shell scripting.