SUMMARY:

• Over ten years of experience in the administration, design, implementation and support oracle databases 9i/10g/11g/12c in UNIX / Linux and Windows environments
• Eight years of performing database Backups & Recovery (User managed and RMAN).
• Four years in setup and maintenance of clustered environments. Supporting 9i, 10g and 11g Real Application Clusters (RAC) installations and configuration on Linux, Solaris.
• Extensive knowledge of ASM and DataGuard.
• Performed CPU, PSU, Upgrade, Migration and Database Cloning of Oracle 12c/11g/10g/9i.
• Experienced working with OLAP & OLTP Multi - Terabyte db’s in dev, test and prod environments.
• Proficient in UNIX shell scripts & cron for scheduler for automating tasks.
• SQL tuning and Performance Tuning using AWR (Automated Workload Repository), ADDM, STATSPACK.
• Worked with Oracle technology features such as Partitioning, OEM, Grid Control.
• Seven years of experience in design and development of applications using SQL, PL/SQL on Oracle Database 9i/10g/11g.
• Skilled in using SQL*Loader, Data Pump, Import/Export.
• UNIX Shell scripting for jobs such as but not limited to Checking disk space, Purging old data, Table Space Management, and Automated Backup.
• Install golden gate for the database replication.
• Configure manager, extract and replication of golden gate.

TECHNICAL SKILLS:

Languages: Java Applet, Java, Java Script, C, C++, PHP, XHTML, DHTML, XML

Systems: Unix, Linux, X-Windows, SSH Clients, VMWare, Microsoft Windows Server, XP, Vista

Tools: Oracle Enterprise Manager Grid Control, Quest Software Toad, ERWIN WebLogic, Exceed, Eclipse, JBuilder, Visio, Micro Strategy, Crystal Reports, APEX 4.2

Databases: Oracle 9i - 12c

WORK EXPERIENCE:

Senior Oracle DBA

Confidential, Bethesda, MD

Responsibilities:

• Performed database refresh using data pump from production to dev environment.
• Installed PRISM application, configured and fixed the issues.
• Updated FAR at production, dev and QA environment.
• Verified the dbms jobs running successfully and fixed the broken jobs.
• Troubleshoot and resync the physical standby database at Data Guard.
• Refreshed schema using data pump export/import.
• Created RMAN backup script, scheduled the job and validated the backups.
• Database refreshed and upgraded from 11g to 12c using cold backup.
• Analyzed database performance by running AWR, ADDM and ASH.
• Performed database tuning running SQL tuning advisor to analyze query running slow.
• Monitored, managed tablespace usages and increased the tablespace size.
• Installed the quarterly CPU patches.
• Performed DR exercise and brought the database up using RMAN restore database and recover the database.
• Cloned the database using cold backup.
• Analyzed the disk space usage and deleted the old backups that are more than fifteen days old.
• Configured and run the STATSPACK to analyze instance health, load summary page and high resource SQL statements.
• Install 12c golden gate for the database replication.
• Configure golden gate manager, extract and replicate.

Environment: Oracle 10g/11g,12c with Data Guard, RHEL 5, Windows Server 2008 R2, VMWARE ESX, VERITAS Clustering Services, SQL*Plus, Oracle SQL-Developer, TOAD

Senior Oracle DBA

Confidential, Arlington, VA

Responsibilities:

• Implemented backup and recovery procedures; established disaster recovery and high availability plans for not to have any database down time.
• Troubleshoot and resync the physical standby database at Data Guard.
• Create APEX workspace, Migrate APEX application code from Dev to QA to Prod. Migrate Images and managing users and accounts.
• Deployed Functions, Procedures, Triggers, Packages from Dev to QA to Prod environment.
• Analyzed user requirements, planned system requirements and data flow; conceptualized while defining architectural design resulting in smooth flow of Systems Development Life Cycle (SDLC)
• Deployed the database dump version to the QA environment.
• Performed database character set conversion using CSSCAN and CSALTER.
• Create PL/SQL and DDL scripts and Run at Production, Qual and development environment. Run the DMS(Data Mover Script) at Peoplesoft database.
• Create shell script to check database statistics and run the script through crontab
• Run AWR and ADDM from Grid Control for performance tuning and run SQL tuning advisor to analyze sequel running slow.
• Backup the logical database using data pump.
• Performed RMAN duplicate to clone the database.
• Applied the quarterly patches.
• Extensive experience in database design, Installing, configuring, managing and maintaining Oracle servers 10g/11g/12c.
• Install golden gate for the database replication.
• Configure manager, extract and replicate of golden gate.
• Install and configure high availability solution RAC and Data Guard Active/Active and Active/Passive.

Environment: Oracle 9i/10g,11g with RAC, SunOS 5.8 on Fujitsu Powerpath 850, RHEL 5, VMWARE ESX, Veritas Clustering Services, NetApp 3050, SQL*Plus, Oracle SQL-Developer, TOAD.

Sr. Oracle DBA

Confidential, Vienna, VA

Responsibilities:

• Extensive experience in database design, Installing, configuring, managing and maintaining Oracle servers 10g/11g.
• Performing database upgrades, Installing database and security patches.
• Assisting application developers, and troubleshooting and resolving problems.
• Performing database backup and recovery, performance tuning, SQL tuning,, space management, disaster recovery, data replication and database refresh.
• Migration of Oracle databases from 9i/10g to 11g in HP, SUN and Windows environments.
• Create tables, views, functions, procedures, packages, and database triggers to meet system requirements and functionality.
• Designing and implementing load balancing and failover environments.
• Performing routine database maintenance and administrative functions, including index maintenance and updating of various tables.
• Provides support to end users and Development and QA staff on all database issues.
• Implementation of database schema level objects to support logical/physical model.
• Install, configure and tune the High Availability (HA) features using Oracle Real Application Clusters (RAC).
• Install and configure the OEM Grid Control and deploy agent on the server individually to manage databases from one single point.
• Set up and maintain oracle disaster recovery site using DataGuard.
• Install 11g golden gate for the database replication.
• Configure golden gate manager, extract and replicate.

Environment: UNIX 32/64-bit, AIX, HACMP, LINUX, VERITAS LVM, JAVA, Tivoli, TSM, PERL, Oracle 9i, 10gR2, 11gR2, Oracle OEM, Oracle SQL Developer, RAC, VMWare, RMAN /DataGuard.

Senior Oracle DBA

Confidential, Washington, DC

Responsibilities:

• Provides production database management, administration and disaster recovery for several Oracle 11g relational database management systems (RDBMS) including Data Warehouse and OEM Grid Control 11g hosted on Sun Solaris and RHEL 5 in support of PeopleSoft, Sharepoint, and Java applications.
• Responsibility includes but not necessarily limited to software version control, implementation, quality assurance, space allocation and management, migration, backup, recovery, data guard instance performance monitoring and tuning, applications tuning, capacity planning, standards identification and compliance, problem resolution, new product/release evaluation, support, upgrade and installation.
• Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions and upgrades.
• Deliver strong Performance trouble-shooting and tuning, UNIX scripting and PL/SQL scripting support for Invest projects and critical production issues.
• Possess strong working knowledge of High Availability, Backup and Recovery options and help to implement solutions and automate routine database support tasks.
• Defines and administers database organization, standards, controls, procedures, and documentation. Provides experienced technical consulting in the definition, design, and creation of a database environment.
• Advises applications development staff and users on database solutions to business problems, database management system facilities and capabilities, and the operation and tuning of databases.
• Worked on Linux real application cluster and Oracle 11g Real Application Clusters (RAC).
• Ensures economic and efficient availability of data within adequate safeguards.
• Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
• Develop and maintain expertise in use of automated tools for database maintenance and implementation. Develop, maintain and document shell and sql scripts and batch processes.

Environment: Oracle 9i/10g,11g with RAC, SunOS 5.8 on Fujitsu Powerpath 850, RHEL 5, VMWARE ESX, Veritas Clustering Services, NetApp 3050, SQL*Plus, Oracle SQL-Developer.

Sr. Oracle DBA

Confidential, Arlington, VA

Responsibilities:

• Migrated Oracle 9i databases to 10gr2. Platforms include Windows, Linux, and Solaris.
• Upgraded Several Oracle Ebusiness 11.5.10 to R12.1. Migrated from existing Hp-UX to linux.
• Setup Oracle 10g RAC. Provided scaling and HA architecture. Setup load balancing and webcache.
• Setup Oracle Grid for over 50 databases, application servers, web-logic. Provided all monitoring and tuning.
• Configured large Warehouse using Oracle OWB, Essbase with OLAP features. Installed Oracle across multiple servers. Performed all performance tuning of partitions and cubes.
• Install, patch, and remove Oracle server software. Create, maintain, patch, and remove databases.
• Run periodic health-checking, and schedule and correct problems as needed per contract standards. Set up database backup scripts using RMAN.
• Participate in periodic disaster recovery exercise to recover agency databases.

Environment: UNIX 32/64-bit, AIX, Linux 5/6, RAC, GoldenGate, Tivoli, PERL, Oracle 10gR2, 11gR2, Oracle OEM Grid Control, LDAP, Informatica, CHP/ VMWare, RMAN /DataGuard.

Oracle DBA

Confidential, Springfield, VA

Responsibilities:

• Implements Oracle Real Application Cluster 10g with ASM on Linux platform.
• Creating table spaces, tables, indexes, users and maintaining OFA compliance.
• Responsible for providing day-to-day support and maintenance for more than 100 Oracle databases (24x7 environment).
• Managing database security, creating and assigning appropriate roles and privileges as required by the application.
• Implementing the changes in the database design and modifying stored procedures as necessary.
• Sizing database objects for effective space management and optimal performance.
• Database server tuning. This included tuning the shared pool, database buffers and redo buffers.
• Database backups and recovery.
• Developing scripts for cold backup.
• Responsible for investigating potential problems and issues raised by business users; this includes being on a on-call rotation and carrying a pager as needed.
• Monitor database events and proactively optimize system performance.
• Work in conjunction with other IT, application development, and business groups to understand functionality, scalability, performance, security, and integration requirements from the database perspective.
• Responsible for the project that consolidated all the production and development databases.
• Develop, maintain, and monitor documentation and procedural standards relating to all database projects.

Environment: Oracle 10.2, Netezza Performance Server 4.1, SQL Server 2005, AIX 5.3, RedHat Linux Enterprise Server (4), SQL*Plus.