SUMMARY

• Over 9+ years of experience as IT Professional including 7.5 years as an Oracle Database Administrator.
• Around 2 years of Experience as System Administrator.
• Good experience in installation, configuration, Maintenance, Upgrade and Support of Oracle 12c/11g/10g/9i.
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, Oracle support, Cloning, Backup and Recovery, Performance Tuning.
• Migrating and Upgrading teh Databases between different environments and versions.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases.
• Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
• Strong Exposure on RAC, Data guard, Golden Gate.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, ASM, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Performance Tuning for Optimized results using Explain - Plan, SQL-Trace, STATSPACK/AWR, TKPROF and ADDM reports. Proven ability of providing production support for 24X7 on multiple databases.
• Work independently to ensure dat teh databases are operating efficiently and ensure proper backup and disaster recovery methods are maintained.
• Efficient Team Player, hard working, good in analytical and logical problem solving abilities wif excellent communication skills.

TECHNICAL SKILLS

Operating System: AIX, SUN SOLARIS,RHEL,WINDOWS xp,7, NT, 2003 Server,2008 Server

RDBMS: Oracle 12c/11g/10g/9i, SQL Server 200/2005

Software Languages: SQL, PL/SQL, C, C++, Java, UNIX Shell scripting.

Tools/Utilities: RMAN, SQL*Loader, Export/Import, TOAD, Sql Developer

Tuning Tools: EXPLAIN PLAN,AWR,ADDR,STATSPACK,TKPROF

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

Oracle DBA

Responsibilities:

• Providing support (24*7) and troubleshooting tickets.
• Monitoring teh databases using Oracle Enterprise Manager (OEM) and Toad .
• Monitoring Standby Database whether all teh logs transferred to Standby site and applied properly.
• Export and Import of databases from one database to another databases.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Performing Backup/Restore of all teh Oracle databases using RMAN.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Scheduling jobs through oracle Job Scheduler, Crontab
• Recovering Databases when there is any Physical or Logical Corruption.
• Implemented Transparent Data Encryption (TDE) for compliance related databases.
• Responsible for purging and archiving teh production databases.
• Detected locks and resolved in-doubt transactions manually, tuned oracle SQL statement by tracing.
• Monitored teh Golden Gate processes and checking teh performance using teh Golden Gate Director.
• Involved in Database Administration activity like space management, users and roles administration, schema management, checking alert log of all teh databases using OEM.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Environment: Oracle 12c/11.2.0.4, 11g RAC, RMAN, Golden Gate 11g,Exadata, Sun Solaris 10, RHEL, OEM 11g, SQL*plus, Toad, CA Service desk

Confidential, Atlanta

Oracle DBA

Responsibilities:

• Involved in Database upgrade from 11g to 12c.
• Performed Health Checks of teh Databases.
• Performed Backup & Recovery of Oracle databases using RMAN.
• Involved in teh Installation and Setting up replication of databases using Oracle Golden Gate11g.
• Checking teh Alert Logs of production Databases for any errors reported by Oracle.
• Applied Patches for security vulnerabilities as part of every quarterly release.
• Providing ad-hoc support to teh development team, maintenance of teh Database, monitoring database growth and managing space.
• Good experience in managing teh databases using teh OEM grid control like Scheduling backups, performance monitoring, generating reports, email notifications etc.
• Generated AWR reports and analyzed teh statistics for performance issues and resolved them.
• Applied Patches which includes Patch set update (PSU) to resolve Security as well as critical Bug fixes Quarterly.
• Involved in cloning of teh databases for Development and Testing purposes.
• Used Data pump to Export and Import Data between Databases during teh upgrade.
• Extensively worked wif ASMCMD for managing ASM Environment.

Environment: Oracle 12.1.0.1/11.1.0.7, Oracle Golden gate 11.2.1.0, RAC, RHEL 5, Windows server 2008 R2, Sql Server 2005, Toad, OEM, OIM/OAM, Jira.

Confidential

Oracle DBA

Responsibilities:

• Involved in installation, configuration and support of Oracle 11g RAC.
• Involved in implementation of High Availability solutions involving RAC and Data Guard.
• Monitoring Standby Database whether all teh logs transferred to Standby site and applied properly.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Performing Backup & Recovery of teh database using RMAN.
• Reading Alert Logs and User trace Files and diagnosing teh Problem.
• Export and Import of databases from one database to another databases.
• Configuring of OEM to monitor all teh environments from OEM utility.
• Performing DBA activities like Performance Monitoring, Health Check etc.
• Applied Patches quarterly to resolve Security and Critical bug fixes.
• Cleaning ORACLE HOME file system by cleaning log files, alert log file and listener.log files
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc
• Performance Tuning for Optimized results using Explain Plan, SQL Trace, STATSPACK, AWR, ADDM reports.

Environment: Oracle 11g/12c, RAC, Data guard, IBM AIX, RHEL, OEM, SQL*plus, Sql Developer, Remedy,Windows7

Confidential, CA

Oracle DBA

Responsibilities:

• Involved in 24x7 Oracle Production Database Administration.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrade/Migration of teh oracle databases from Oracle 9i to Oracle 10g.
• Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Statspack.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as teh database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
• Implementation of High Availability solutions wif Oracle 10g RAC, Standby Database Data Guard, Replication.
• Created physical standby database (for disaster recovery) from hot backup of primary database.
• Resolved gaps between primary and standby databases (Gap Resolution).
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of teh time.
• Creating Tables, indexes, & triggers to assist developers.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Was involved in developing a disaster recovery (DR) plan.
• Knowledge of teh Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Performing Backup/Recovery of all teh Oracle databases using RMAN.
• Scripts for Health Check of Databases.
• Reading Alert Logs and User trace Files and Diagnosing teh Problem.
• Writing UNIX shell Scripts and Scheduling through crontab.
• Providing Solutions to teh Problems Faced by end Users or Programmers.
• OS level activities like space monitoring of Mount points.
• Scripts for Analyzing of Tables and Rebuilding of Indexes.
• Taking periodic backup of teh database and teh software.
• Automation of Backups.
• Interfacing wif Oracle Corporation for technical support.

Environment: Oracle 9i,10.2.0.2,11.1.0.7,Maestro 7.0,HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3,WebSphere,Solaris5.9,Informatica Power center 8.1x and 8.6.

Confidential

System Administrator

Responsibilities:

• Installed, optimized and configured new servers and application upgrades in existing network environment as per requirements.
• Installed and configured secured environments, VPN Internet connectivity of virtualized server environment and clients.
• Managed and administered Windows/Linux systems - Performed periodic maintenance, provided technical support and executed systems engineering.
• Maintained MS Exchange Server - Performed troubleshooting and provided resolutions for server problems.
• Implemented proper recovery procedures for disasters and administered user-accounts mailbox.
• Maintained teh timely back-up of important data and management resources.
• Assisted in teh timely recovery of data lost due to software crash or hardware failure.
• Conducted periodic performance tests on existing servers.
• Managed and advised teh deployment of new system designs.
• Monitored teh LAN/WAN network environment including routers, switches, firewalls, Internet access and software applications.
• Installation, configuration and maintenance of Windows servers, Cisco infrastructure system network components.
• Performed troubleshooting and diagnosis to hardware/software network failures, and provided resolutions.
• Provided administration support, accessing network systems in their ‘root’ level.
• Administer Microsoft Windows Servers (Active Directory), Microsoft Workstations, and network security devices for 350 users.
• Migrated to Windows 2003 Server/Exchange 2003 Server wif Blackberry Integration Services, Windows Server Updates Services (WSUS), and Microsoft Operations Manager.
• Lowered spam by 75% using firewall filtering wif real-time spam black lists for incoming email.
• Responsible for security equipment, including Watch guard Firebox X1000 firewall wif 60 VPN users and spam blocking utility, as well as Symantec Antivirus System Center and Central Quarantine Server 8.0 and Antivirus for Exchange.
• Backup and restore network data wif VERITAS Backup Exec 10.0

Environment: 10,000+ Windows 2003 R2/2008 R2/ /Servers 20000+ Windows 8/7/XP Desktops/Laptops, Exchange Server, Symantec Antivirus.