SUMMARY:

• Over 7 years of Strong experience as an Oracle Database Administrator involved in Database Support and Implementation projects on multiple platforms. This includes Fresh Implementations, Migrations, Upgrades and Configuration of Oracle Real Application Clusters (RAC), Database Security, Golden Gate and Data Guard for Disaster Recovery Sites on Oracle 10g and 11g Databases.Proficient in Performance tuning and SQL Tuning. Possess excellent communication skills and analytical abilities.
• Proficient in database administration involving in installation, configuration, tuning and migration of databases along with database design and management.
• Have worked on projects involving Support and Implementation of Dataguard for Disaster Recovery and Grid infrastructure (RAC).
• Created and maintaining Oracle Data - Guard configuration of primary and standby databases. Configured Clients Applications failover (TAF-FCF-FAN), created multiple services for dataguard configurations and complete site failover setup by using DB ROLE CHANGE system event trigger. Managed dataguard advanced compression for network traffic by providing better protection and network utilization to reduce redo transfer time. Configured cascade standby for offloading and data replications across multiple disaster recovery sites. Configured Data Guard Broker and Observer to implement FSFO.
• Database migration and upgrades 10g to 11g. Efficiency in zero or minimum downtime database upgrade using Logical standby/Goldengate and Transportable Tablespace for cross platform migration.
• Experience with Real Application Clusters 11gR2 RAC database administration in Linux environment multi-node configurations. Migrate single instance DB from file system to ASM multi-node RAC environment for high availability. Effective storage management of Database components using ASM for better performance, ASM Diskgroup operations through SQL/ASMCA/ASMCMD, create/rebalance/drop and other advance 11g ASM operations. Proficient in Oracle CRS and its components like daemons and processes.
• Setup the RMAN Backups for all the production databases satisfying RTO and RPO. Leading in performing periodic Disaster Recovery Drill and testing RMAN backups with various scenarios.
• Use of Oracle RMAN as the primary utility for cloning, backup/restore & disaster recovery solutions. Managing the Backup strategy, instance strategy and storage strategy for multiple test/development environments using RMAN.
• Experience with performance tuning, troubleshooting and perform database monitoring to ensure the database run at peak performance. Resolve performance tuning related issues, Sql tuning, wait Events and identify most expensive Top Sql statements etc. Performed capacity planning of Oracle database servers Storage, CPU and memory. Provided technical assistance and guidance to application support staff and project teams.
• Using AWR report proactive-reactive, tkprof and Explain plan, Resolve a hung database, running a database health check. Handled database server tuning, applications tuning and maintain documentation.
• Configured OEM Grid control 12c to manage, monitor and administer the various Databases. Using Active Session History Analytics (ASH), Real-Time Automatic Database Diagnostic Monitor (ADDM) and Compare Period ADDM.
• Helped Oracle E-Business Applications Team (EBS) for Installation and configuration of Oracle e-Business Suite R12.1.1.
• Upgrade R12.1. To 12.2 and RDBMS upgrade from 9.2.0.8 to 11.2.0.3, applying patches, and cloning
• Experience in shared APPL TOP configuration in E-Business suite.
• Knowledge and experience with multi-node and multi-tier application environments.
• Setup all application users and work on all application issues, Create custom concurrent programs and standard mangers, defining concurrent managers.
• Tuning and trouble-shooting concurrent managers
• Strong experience in AutoPatch, Upgrade, Adadmin, Autoconfig, Adctrl, Adsplice, Adrelink, AdMergePatch, Adop, License Manager
• Built-in appropriate security measures for Database user access controls to minimize risks to other system and network. Maintain data integrity, managing profiles, resources and database security. Using OS utilities Tripwire/ TCP wrappers, transparent data encryption (TDE) and Oracle Advanced Security (OAS). Integrate Oracle audit with SYSLOG
• Deployed Oracle patch set update (PSU), one-off patches and Bug fixes for Grid Infrastructure environment (RAC) or single instance database. Automatic or Manual patching.

TECHNICAL SKILLS:

Databases: OLTP Oracle Databases11g/10g/9i/8i.

DBA Skills: Database Maintenance, Disaster Recovery, Security Management, HA Management, RAC, ASM

Tools: /Utilities: CRON, TOAD 10.1, OEM Grid Control 12c, Data pump, export/import, SQL Loader, RMAN, DBNEWID, AWR, ADDM & Oracle Golden gate, Data Guard

Shell Scripting: UNIX Shell Scripts on Sun Solaris and Linux platform

Operating Systems: RHEL 3.0/4.0/5.2/5.6/6.5 , Solaris 10, SunOS 5.10, Oracle Linux OEL

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

ORACLE DBA/mobile data admin

Responsibilities:

• Configuration of RMAN backups, Performing restoration, recovery, duplication of databases.
• Setup and Maintenance of the DR Site.
• Proactive Performance management through AWR Analysis, Database re-organisation, Collection of Statistics
• Reactive Performance Tuning by checking OS statistics, examination of AWR, session waits, checking execution plans & SQL Tuning.
• Develop Shell scripts for automated backups
• Monitor Database space usage and Tablespace Growth for storage and space management.
• RAC administration and ASM Administration. Setup of Services and Load-balancing of RAC Services.
• Using external tables for loading customers’ information from excel sheets; utilize windows mobile data terminals devices connected to the database.
• Upgradation of Database from 10g to 11g
• Check the databases for any Invalid Objects and rectify the problem.
• Re-organisation of database objects for space saving and defragmentation.
• Cross Platform Migration of Databases using Data pump.
• Tuning Oracle Database for performance improvement and resolved network configuration and connectivity-related problems. Health Checks to verify the availability of instances and services.

Environment: Oracle 9i/10gR2/11gR2, Linux, SunOS 5.10, HP-UX 11.11, RHEL 5.6/6.2, Shell Scripting, RMAN, Data pump, OEM Grid Control.

Confidential, Bowie, md

ORACLE PRODUCTION DBA

Responsibilities:

• Handling database server tuning, application tuning, maintaining documentation, and capacity Planning and database security.
• Deployed Oracle Patch Set Update (PSU), one-off patches and Bug fixes.
• Resolved performance tuning related issues, Sql tuning, wait Events and identify most expensive
• Top Sql statements etc.., Using AWR, tkprof and Explain plan, resolving a hung database, running a database health check.
• Experienced in supporting Oracle 11gR2 RAC databases on SunOS 5.10, Linux.
• Monitoring and supporting more than 50 databases instances using scripts and daily health check like alert logs, invalid objects, tablespaces usage, long running queries, backups, listener up and running, etc. Writing UNIX shell scripts and set into cronjob to monitoring all databases and send an alerts in email.
• Configured and administered ASM instances and worked on troubleshooting ASM related issues.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration.
• Involved in building backup and recovery plans for critical databases from failures with minimum downtime.
• Involved in creating templates and developing notification methods in OEM grid control 12c to support monitoring functionality for oracle databases and database/application servers.
• Provided Assistance to application team at the time of SQL tuning in applications.
• Responsible for tuning application including rewriting of SQL, partitioning of tables, analyzing jobs and scheduling them properly, etc. . . .
• Performed troubleshooting of database using AWR, ASH and ADDM reports for better performance of in house or Vendor applications.
• Worked on Table partitioning to increase performance.
• Responsible for network configuration and involved in a Client - Server environment using TNSNames, LISTNER, Net Configuration Assistant and other configuration files.
• Created and Managed users, user profiles, tablespaces, datafiles, archive log.
• Monitored and trouble shooted database issues with OEM grid control.
• Customized UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Environment: Oracle 9i/10gR2/11gR2, Windows, RHEL 5.6/6.2, Shell Scripting, RMAN, Data pump, OEM Grid Control.

Confidential, Arlington, VA

ORACLE DBA/Network Sys admin

Responsibilities:

• Administrated a wireless network infrastructure providing access to wired LANs to increase mobility and productivity, create and deliver solutions tied to business growth, organizational development and systems/network optimization. Skilled problem identifier and troubleshooter comfortable managing systems, projects and teams in a range of IT environments.
• Set up new databases and provided all database-related support, creating primary database storage, Monitoring and optimizing the performance of the database.

Confidential, Lorton, va

Junior ORACLE DBA/sys admin

Responsibilities:

• Monitor, document, and control infrastructure performance for response, throughput and availability.
• Resolve escalated hardware and software issues related to LAN/WAN.
• Identify opportunities and solutions for improving efficiencies with emerging technologies.
• Designed and deployed network security solutions, including firewall configuration for local area network.
• Create Oracle database instances using DBCA to conform to Oracle's optimal flexible architecture (OFA) standards
• Create and manage tablespace (datafiles), redo logs, controlfiles on Windows and Linux platforms
• Create and manage Users, privileges and roles and create tables for developers.
• Upgraded databases from 10.2.0.4 to 10.2.0.5 using Patch sets.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Worked on sizing of database and tables, re-organizing of tables, tablespace and users along with installation of the oracle software and patch application for bug fixes.

Environment: Oracle 9i/10g, HP-UX, RMAN, OEM Grid Control, Data Guard, PL/SQL, SQL*Loader, Stats pack, Data pump, AWR, ADDM, SQL Server etc.