SUMMARY

• Over 5 years of experience in Oracle Database Administration and Production Support, and having knowledge and experience in every aspect of Database Creation, Installation, Upgrades, Patches Oracle Software, Cloning/Refresh, Backup and Recovery along with Disaster Recovery, Managing Users and Security, Oracle Data Guard, Performance Monitoring and Tuning, Troubleshooting production issues, Disk Space Management, Task Scheduling, Real Application Clusters (RAC), and Oracle Flashback Technology based on Unix (Linux), and Windows Operating Systems.
• Extensive experience in Data Migration with traditional exp/imp, Logical backups using full export Data Pump, RMAN.
• Experience in configuration, Implementation, troubleshooting, switchover and failover of Physical Standby Data Guard on 10g and 11g.
• 24x7 on - call and day-to-day production environment support and maintenance including remote database support.
• Experience in Administering Oracle Database using OEM (Grid Control).
• Provided DBA support for production systems and various lower environments databases size from 15 GB to 5 TB.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Performed Migration, and Upgrade of databases to 11g and 10g.
• Experience in Backup & Recovery techniques of databases running using RMAN.
• Implemented Physical Backups (offline/online) and Logical Backups including Datapump.
• Well versed in database upgrades and deployments in production and lower environments.
• Database Refresh/Clone and remapping of data from Production to Development and from Development to Test environments and used duplicate commands of RMAN.
• Experience with using 3rd party tools like SQL DEVELOPER and TOAD to manage the environment.
• Experience in Performance Tuning, Scripting, Disaster Recovery Techniques, Backup and Recovery for Oracle 10g/11g databases.
• Experience on Oracle Architecture, SGA, PGA, LISTENER, TNSnames, V$ GV$ and DBA views.
• Experience in monitoring, optimizing oracle database for Performance Tuning using tools like AWR, ADDM, ASH, STATSPACK, TKPROF, EXPLAIN PLAN, and SQL TRACE.
• Performed Transportable Tablespaces (TTS) using Datapump and Implementation of multiplexing control files and redo log files management.
• Created and modified Database objects like Tables, Indexes, Views, Sequences and Triggers.
• Extensive experience in Extracting, Transforming and Loading (ETL) data using SQL*Loader, External Table.
• Experience in creating partitions on tables and indexes for managing large tables and performance improvement.
• Worked with development and operations staff in resolving problems quickly and efficiently.
• Assisted and monitored RAC, Data guard, and Standby database performances for high availability.
• Assisted in Physical and Logical design of database. Experience in Shell scripts for database.
• Ability to work in high pace environment, in team as well as to take individual responsibility.
• Fairly good hands-on experience working with Oracle Support using Metalink and other support procedures to troubleshoot day-to-day database issues.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Sun Solaris, HP-UX, AIX, Windows, MS-DOS.

Databases: Oracle 12C/11gR1&R2/10g/9i, RAC, Non-RAC, SQL Server 2005, 2008.

DBA Tools: Oracle Enterprise Manager (OEM), Grid Control, Cloud Control, Toad, SQL Developer, SQL*Plus, SCP, NSLOOKUP, SSH, PuTTy, CygWin, SecureCRT, VPN, NetApp, Telnet, WinSCP, TCP/IP, Remote Desktop Connection, FileZilla, Network Pump, Team Viewer.

Database Utilities: DBCA, DBUA, NETCA, SRVCTL, CRSCTL, cellcli, asmcmd, OCRCONFIG, ASMCA, SQL*Plus, DBV, SQL*Loader, RMAN, Data Guard, DataPump, Exp, Imp, Expdp, Impdp, Opatch, Golden Gate, Exadata, etc.

Performance Tuning: Grid control, Toad, Quest SQL Optimizer, STATSPACK, TKPROF, AWR, ADDM, ASH report, Explain Plan.

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl, Ksh, Bash.

Web Tools: HTML, XML, HTTP, TCP/IP, Metalink, MS Visio, Planview, Singleview.

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Oracle DBA

Responsibilities:

• Supported databases in production as well as lower environments and managed multiple Oracle 11gR2/11gR1/10g databases in fast paced operational environment.
• 24X7 Production database support, monitoring and on call support to ensure a proactive problem recognition and resolution of database issues.
• Monitoring various targets through Oracle Enterprise Manager (OEM) Grid Control. Monitoring Tablespaces and Datafiles utilization.
• Applied Oracle quarterly patches and also CPU/One Off Patches and bug fixes to multiple databases in production and lower environments.

Confidential, Reston, VA

Production Support/DBA

Responsibilities:

• Performed database, schema and table level refresh with EXPDP/IMPDP.
• Created the databases, tablespaces, tables, indexes, setting privileges and user logins.
• Extensively worked on UNIX, Linux, VI editor to setup monitor for log files, file systems, databases and servers.
• Participated in supporting user requests and daily maintenance duties and in the 24x7 L2 on-call primary support rotations with other L2 team members.