SUMMARY:

Over 9+ years of experience as Database Administrator, providing 24/7 support of both production and development environments, which includes Database creation, installation, configuration, administration, upgrades, patching, performance tuning, backup and recovery, space management, security, cloning, migration and troubleshooting on both Unix (Sun Solaris, IBM AIX, HP - UX & Red Hat Linux) and Windows environments on multiple versions of Oracle (Oracle 9i/10g/11g).

• Optimized the database performance incidents on RAC databases hosted on the Exadata and non-Exadata platform
• Diagnosed the performance issue with tools TKPROF, 10046 & 10053 trace, Real Time SQL Monitoring, Explain plan, baselines, SQL Plan Management (SPM), SQL Tuning Advisor (STA), DBMS MONITOR(), SQL Profile, AWR reports, ASH reports, ADDM reports, OEM, TOAD, Invisible Indexes etc.
• Expert at tuning SQL queries and PL/SQL procedures.
• Proficient with Tuning, SGA, Buffer Cache, Rollback Segments, and Redo Mechanisms.
• Monitored and Detected Alert Log Files, Listener Log, Redo Log status, trace files and Locks for the database.
• Experience in creating Partitions on Tables and Indexes in order to improve performance.
• Experience in installation and configuration of GoldenGate11g/12c to support data replication in Oracle Database environment.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Experienced in utilizing Golden Gate replication technology for ORACLE Upgrades.
• Thorough knowledge in Oracle RAC environment and upgrade of standalone databases to 10g & 11g RAC environments.
• Experience in Installing and configuring ASM and RAC for high availability databases.
• Cloned Database from Production to Test and Development and from Development to Production.
• Experience in Upgrade and Migration of oracle database to higher version and installing patches.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Designed and implemented Backup and Recovery strategies using conventional and RMAN utilities.
• Hands on experience of database backups and recovery methods like PITR, TSPITR Export/Import, Data Pump and Flashback Technologies.
• Well versed with Veritas Cluster Environment, SAN storage systems, RAID, Logical Volume Manger.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL*Loader Utility.
• Extensive use of Crontab and Autosys in UNIX environment for scheduling routine tasks.
• Created and Maintained Users and Roles with Appropriate Privileges and Profiles.
• Experience working with SQL Server, T-SQL procedures and queries, SSIS, ETL, CLR C# procedures and functions, etc. Exposure to Basic Architecture of 11i OAS, Installation, Up gradation, Cloning, Patch Application of databases of all versions.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Shell ProgrammingRDBMS Oracle 8i, 9i, 10g,11g

Tools: Toad, SQL Developer, Putty, Secure CRT, Lotus Notes, Remedy, Vitalize, DBArtisan

Utilities: SQL Loader, RMAN, DATA GUARD, ASM, OEM Grid Control, DBCASQL: Plus, Export/Import, Data Pump, Golden Gate

Operating Systems: Oracle Solaris 8/9/10, IBM AIX 5.x, Red Hat Enterprise Linux 5/6, Windows Server 2003, Windows XP, Windows 7

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential, West Des Moines, IA

Responsibilities:

• Optimized the database performance incidents on RAC databases hosted on the Exadata and non-Exadata platform.
• Diagnosed the performance issue with tools TKPROF, 10046 & 10053 trace, Real Time SQL Monitoring, Explain plan, baselines, SQL Plan Management (SPM), SQL Tuning Advisor (STA), DBMS MONITOR(), SQL Profile, AWR reports, ASH reports, ADDM reports, OEM, TOAD, Invisible Indexes etc.
• Prepared the test cases and conducted the technical talks on Oracle Database 12c features.
• Interacted with the development and architect teams to gather requirements and provided the solutions.
• Involved in process documentation for knowledge sharing across the team.
• Work with Oracle support to resolve Oracle Support Requests (SR) as necessary.
• Conducted Performance Review of Oracle Database for business critical applications with Senior Leadership team.
• Generated Statspack/AWR reports from Oracle 12c/11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
• Completed minimized the space related errors in Oracle Databases by conducting month review with Senior Management and addresses the space issues proactively.
• Provided tuning recommendations and future memory requirements to Primary DBA team to make the changes in Database like table reorg, add enough spaces to database.
• Created a purge script to remove more than one year old data.
• Participated in Oracle Golden Gate 11.2 installation, configuration and management, and supporting Bi-directional data replication.
• Upgraded golden gate from 11.1 versions to 11.2 versions on 11gR2.
• Configured High availability and setup custom monitoring through Heart beat tables using Golden Gate.
• Worked with application team for setting up conflict handlers in Golden gate.
• Used BATCHSQL, RANGE functions to improve throughput in Golden gate REPLICATES.
• Troubleshoot slow running EXTRACTS, REPLICATES and tuning.
• Performed Oracle 11g RDBMS installation, upgrade, configuration, backup, recovery, archiving & purging activities
• Involved in implementing 11g RAC (Real Application Clusters) with ASM disk on Linux servers(RHEL5), AIX 5.3.
• Duplicated RAC Databases in non-production environment through RMAN.
• Migrated database Schemas from Single instance to RAC.
• Upgraded multiple Oracle instances from version 10.2.0.4 to 11.2.0.3.
• Involved in applying CPU/PSU patches to the databases as recommended by Engineering team
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Implemented and troubleshooting Data Guard (Standby) for high availability/disaster recovery purpose.
• Installation and configuration of Oracle Grid Control and installing OEM agents on all the database server hosts.
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like VMSTAT, ISOSTAT and TOP.
• Database recovering using Veritas Netbackup and RMAN.
• Performed backups and recoveries using RMAN/conventional hot & cold backups.
• Extensively used exp/imp & Data Pump utilities to refresh the databases from Production to Test environments.
• Performing daily maintenance tasks like memory management, Tablespace management, Lock conflicts, Indexes and daily health check of Databases.
• Monitored on a regular basis, as part of database preventive maintenance, the database growth, alert logs and arc hive log destination space by setting up alerts through OEM.
• Support for fixing the daily database problems at segment, extent, and data-file and tablespace level.
• Supporting Development and QA team’s requirements in terms of database backup, performance and tuning.
• Responsible for maintaining around 100 databases in Oracle 10.2.0.4 and 11.2.0.3 varying from 2G to 2TB.
• 24*7 Production on Call Support for LDB on rotation basis.

Environment: Oracle 9i/10g/11g, Sun Solaris 5.9/10, Linux (SUSE, Red Hat), IBM AIX 5.3, VERITAS, TOAD, SQL*PLUS, UNIX Shell, RMAN, 11g RAC, Golden Gate, ASM, OEM, Data Guard, Putty, Vitalize

Oracle DBA

Confidential, Dallas, TX

Responsibilities:

• Implemented new Oracle 11G R2 (11.2.0.1) database set up for Dev, Test and Prod Instances.
• Architecting and documenting the project details including physical storage, network layout, backup policy, service request, project implementation planning etc.
• Develop and administer configuration management and User profile configuration with access grants.
• Install, Upgrade and manage Oracle Grid Control.
• Designing and building a reporting database.
• Managing, developing scripts and execution of data replication.
• Monitoring DBMS performance and develops procedures, where necessary, to improve the DBMS environment as required.
• Working on Teradata Administrator for creating profiles, roles and enabling the Query logging when required.
• Performance tuning via AWR and Stats pack . Fine tune Transaction intensive servers i.e. OLTP situations (I/O bottlenecks, SGA, Pinning objects, Sort space, Redo logs) using explain plan, tkprof and identifying the execution plan and tune queries, using Indexes, hints etc . Exporting dictionary statistics from production to stage for tuning.
• Configure full db backups using RMAN.
• Providing Graphical inputs to Manger on CPU busy and daily peak and no peaks timelines of the Teradata System.
• Designing, developing and maintaining Oracle database structures and data in the support of Human Services initiatives
• Supporting Oracle databases, with experience including requirements definition, data modeling, and logical/physical design.
• Manage Oracle RAC database configurations utilizing Veritas Cluster Server (VCS), GoldenGate and Data Guard to ensure maximum availability and data protection
• Install, upgrade and manage Oracle RAC databases with ASM and SAN.
• Install, patch, upgrade, test and maintain all Oracle software.
• Usage of MS SQL Server, DBMS tools and utilities usage for database administration, cloning, backup and recovery, database performance tuning and monitoring.
• Coding PL/SQL & Shell Scripts, Design/Code reviews.
• Involved in writing and modifying PL/SQL procedures and functions used in Java scripts.
• Extracting Data from Mainframe and Loading flat file to Oracle Database.
• Install Oracle RAC 11g on Oracle Enterprise Linux Using VMware Server.
• Create and maintain database partitioning and indices as needed.
• Building Development and Test Databases using flashcopy.
• Configuring Oracle Goldengate to eliminate Informatica Tool.
• Implementation of Golden Gate TDM for Real time Data Warehousing Live reporting.
• Oracle Migrations without down time using Oracle Goldengate 10g TO 11G Cross platform.
• Exadata migration: Played a vital role in migrating 7 TB Production superdome database (Oracle 10g ) to Exadata Oracle 11g environment.
• Configuration of Database, User Creation, Role & Profile Assignment in SAP and Non-SAP environment.
• Use OEM, Oracle Advisors for monitoring.
• On boarding Oracle Identity Management (OIM) Tool for Oracle Databases
• Set up SQL loader and Data Pump as required using shell scripts.
• Schedules and coordinates database maintenance activities.
• Verify that database entities follow approved standards and Enforce database standards for objects.
• Approving all production schema changes and control all migrations of Oracle schema objects.
• Assure that Security Policies are in place and Add/Remove new users as requested by data owners.
• Work with Oracle support to resolve Oracle Support Requests (SR) as necessary.
• Provide after hours and on-call support as required.
• Prepare and maintain Documentation using Sharepoint and MS Office 2007.

Environment: Oracle 9.2.0.8/10.2.03/11.1.0.6/11.1.0.7, RAC, ASM, Solaris 9/10, Windows 2008 enterprise edition, Remedy service desk ticketing system, OEM, Shell scripting.

Oracle DBA

Confidential, NYC, NY

Responsibilities:

• Setup the Database Server for new applications as per business needs.
• Involved in installation and configuration of Real Application Clusters (RAC) running on 2 node clusters.
• Involved in database Upgrade from 10.2.0.2 to 10.2.0.4 In RAC environment node by node.
• Involved in Database migration across the different OS versions.
• Upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4 and later to 11.2.0.1.
• Maintenance of Logical and Physical data guard environments.
• Performed Data Guard switchover/failover as per the requirements.
• SQL Queries/Application and Database performance monitoring and tuning using various tools like ADDM, AWR, Explain Plan, TKPROF and Statspack reports.
• Database managing and monitoring using Oracle Enterprise Manager (OEM).
• Applied Oracle patches as & when needed.
• Configuring parameter file to fix sizes of SGA components in conformity to available resources.
• Cloned databases from PRODUCTION to development, UAT environments using RMAN duplicate.
• Involved in logical backup using and full/ partial export/import and Data Pump.
• Used SQL Loader extensively to extract data from flat files and loading into the new application.
• Performed database analysis, design, coding, testing and implementation of database structures.
• Database Growth and Space management, capacity planning, table partitioning; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.
• Creating and rebuilding indexes in various applications.
• Implement database changes according to application change (adding constraints, columns, new objects).
• Experience on Netback up client with RMAN to automate the backups to tape as per company standards.
• Performed user administration, space administration on development and test database.
• Creating the database, tables, table spaces, and data objects, setting privileges, indexes, user & password management, Security administration.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Performing regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery (Instance, media).
• Monitoring of queries with high response time and high disk reads per execution i.e., Top SQL using OEM and tuning the same using Explain Plan.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Environment: Oracle 11g/10g/9i, IBM AIX 5.3, Sun Solaris, Red Hat Linux, Oracle Enterprise Manager, Toad 8, RMAN, RAC, Data Guard, Remedy.

Oracle DBA

Confidential, Seattle, CA

Responsibilities:

• Installed and configured Oracle Enterprise Manager 10G Grid Control for Enterprise.
• Configured and managed physical standby database using Data Guard for disaster recovery on a different node for different production servers.
• Performed Data Guard switchover/failover as per the requirements.
• Created monitoring scripts to send alerts in case standby is out of sync.
• Performed disaster recovery for production database which went offline after server was moved to a new box.
• Upgraded and patched Oracle binaries in the development environment and production environment.
• Applied Patches to existing versions.
• Cloned databases on same node and also on different server nodes using custom shell script with hot and cold backups of source database.
• Configuring parameter file to fix sizes of SGA components in conformity to available resources.
• Backup and recovery via RMAN scripts and troubleshooting.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Responsible for setting up production, development, performance and staging database environments.
• Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.
• Performed SQL tuning by using Explain Plan and TKPROF.
• Administered all database installation, creation, modification, and tuning issues of Oracle.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Monitored and audited database access for unauthorized access.
• Do general technical trouble shooting and give consultation to development teams.
• Use of Crontab, DBMS JOBS to automate the monitoring jobs.
• Generated working documentation for the DBA team use.
• Analysis of alert log for error tracing, resolved locking issues.
• Participate in collaborative discussions with team members to monitor progress against enhancement queue and bug resolution.
• Proactively monitor 10g Oracle environments for multiple customers. Resolve database incidents to ensure database availability and stability.
• Day to day troubleshooting like adding space in data files, rebuilding indexes, check alert log file and monitoring of system.
• Worked with Developers and change management team to ensure smooth life cycle progress from development through testing and production implementation.

Environment: Oracle 9.0.1.5/9.2.0.6, 10.2.04, Sun Solaris, Red Hat Linux, TOAD, OEM, Statspack, tkprof, Sun Enterprise 4500, SQL, RMAN, Putty.

Oracle DBA

Confidential

Responsibilities:

• Team member of Infrastructure Team; was responsible for Developing backup and recovery strategy, database tuning strategies, capacity planning etc.
• Configured, installed and administered Oracle database systems and tools.
• Responsible for patching, general troubleshooting, general performance and tuning in 9i Database.
• Upgraded and migrated database from oracle 8i to 9i version.
• Applied patches to the database layer.
• Performed backup and recovery through RMAN and user managed techniques as per the needs.
• Backed up databases in all environments.
• Handled the work related to space management, user management, roles & privileges.
• Managed the backup of database objects/metadata using export / import.
• Monitored the database growth on daily basis and provided solution to the client about database growth trends.
• Provided support to development and QA teams and troubleshooting their issues.
• Performed functions related to allocating and re-organization of table spaces
• Performed the index rebuilding, index analyze and table analyze on periodical basis
• Used crontab utility in UNIX and scheduler in windows for setting up automatic database level tasks.
• Responsible for taking hot backups and logical backups at schema, tablespace and database level.
• Loaded data from flat files using SQL loader.
• Killing Defunct Process and users consuming more resource during peak loads.
• Performed various DBA maintenance task such as rebuilding indexes, validating constraints, reorganizing tables.
• Proactively monitoring of the Alert Logs, Export & RMAN backup activity of all databases.

Environment: Oracle 9.2.0.5, 9.2.0.6, 10.2.0.1, 10.2.0.2,SQL, PL/SQL, TOAD 9.0, OEM 9.0.2, Developer 2000, RMAN v9.2.0.2.0, DBA Studio, Windows XP,SQL*Report, SQL*Loader, Windows 2000,Sun Solaris 5.9,HP-UX