SUMMARY

• Engineering graduate with 8+ years of experience in Oracle database administration (DBA), RAC, SQL and Linux.
• Providing 24/7 on - call support
• Installed RHEL, setup configured 10g and 11g R2 Databases.
• Migrated database from data center to another data center
• Performed refresh.
• Applied CPU, PSU Patches.
• Worked with Oracle on issues.
• Used various methods of Backup and Recovery including user managed and RMAN
• Worked on Windows, AIX, Sun Solaris, HPUX, and RHEL with various flavors of Linux.
• Performed various Instance Tuning activities like tuning SGA, PGA and memory parameters.
• Generated and analyzed statspack, ASH, AWR, ADDM to address areas of concern.
• Worked with Development team on gathering requirements and for performance tuning.
• Developed tip and techniques for capacity planning
• Poses expertise in Building RAC from scratch include OS deployment.
• Written Shell Scripts to automate jobs
• Provide DBA support with proactive monitoring using 10g 11g OEM and cloud Control.
• Build multiple Oracle Data Guard environment for DR.
• Worked with Storage team to carve out partitions for ASM.
• Supported Oracle RAC with Data Guard environment.
• Used Export/import and Data pump for data movement.
• Configured and Worked on Flash Recovery Area (FRA)
• Used SQL Developer, TOAD for ERWIN as tools to manage databases.
• Good knowledge of explain plan and query tuning.
• Good knowledge on Management of schemas, objects & indexes.
• Worked on Migration projects
• Used RMAN’s Duplicate Database feature to clone databases.
• Worked on Redo Log sizing to reduce waits.
• Identified performance bottlenecks and recommended usage of right indexing mechanism.
• Worked on consolidating databases project.
• Very good knowledge on Data Dictionary
• Poses working knowledge on PL/SQL

TECHNICAL SKILLS

Databases: Oracle Database (9i, 10g, 11g and 12c) Installation, patching, database creation, and upgrade, data pump, ASM, Data guard, SQL tuning and Golden Gate, Real Application Clusters (RAC) 10g and 11g Installation.

Operating Systems: Linux, Solaris, HP-Unix

Languages: SQL

Version control: Tortoise SVN

Virtualization: VMWare Workstation, and Virtual Box

Date Modeling: CA Erwin

PROFESSIONAL EXPERIENCE

Confidential, MIDDLETOWN, NJ

Sr.Oracle Database Administrator

Responsibilities:

• Member of DBA team supporting database infrastructure containing 500+ databases by regular administrative
• Activities from database creation to retirement.
• Creating and managing different kinds of tablespaces, monitoring and fixing tablespace space issues on regular basis.
• Creating and managing database objects, users, roles, privileges, profiles.
• Scheduling different kind of jobs, monitoring and fixing of broken jobs on regular basis.
• Performing database refresh using RMAN, Export/Import, and Data pump utilities.
• Migrating large databases to Linux servers with minimal downtime.
• Upgrading from Oracle 9i/10gto Oracle 11g.
• Working within a team of 4 DBA's providing support for both Oracle and SQL Server in Development, UAT, and Production environments with on-call rotation.
• Working with DBA teams throughout the company on developing consistent standards for all SQL Server databases in our Insurance, and Direct Sales divisions.
• Working with System admins to upgrade and virtualize older systems off of end of life servers as well as the upgrade of OS from Windows .
• Worked to implement the new Solarwinds monitoring solution and develop proper alerts and monitoring of our SQL Server inventory.
• Implemented a shared SSRS environment in development and production.
• Heavily involved in the migration of systems and database from the Annuity business into the Investments data center.
• Involved in budget planning and projects for the FY 2015.
• Involved in the planning and execution of a successful disaster recovery test of all systems in Parsippany to the Clinton data center.
• Involved in the migration of the Parsippany Data Center to Clinton.
• Creating logical and physical database design as per application requirement with E/R models and normalization using CA Erwin Data Modeler.
• Authoring change management scripts to production databases.
• Implementing partitions to the tables, also implemented daily/weekly/monthly purge process for dropping/adding partitions.
• Capacity planning for the current and future storage requirements based on database volumetrics.
• Developing queries for complex business requirements using SQL.
• Configuring databases and listeners through Oracle Enterprise Manager (OEM).

Confidential, Plano,TX

Sr.Oracle Database Administrator

Responsibilities:

• Member of DBA team supporting database infrastructure containing 500+ databases by regular administrative
• Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Configure Golden Gate for high availability, real-time apply and Zero-down time upgrade
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "run Installer" and perl based utility "opatch".
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes ( Confidential database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Performed Installation and configuration of Oracle … database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Experience in 12c Multitenant databases
• Experience in 12c container and pluggable databases
• Constantly monitor the performance (V$ dynamic performance views Confidential peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.

Confidential, Charlotte, NC.

Sr.Oracle Database Administrator

Responsibilities:

• Interact with several teams like Web services, application, System-Admins and Documenting the steps involved and rolling out the action plan.
• Responsible for database, client installation Software for 9i & 10g Enterprise Edition.
• Apply CPU, DST, RDBMS patches as per the requirement.
• Migrate databases across Database servers (Non-RAC to RAC and RAC to RAC).
• Create databases for development, testing and production (including RAC databases and NON-RAC databases).
• Perform refreshes from Non-RAC database to a RAC environment.
• Security Administration including the management of profiles, roles, users and their privileges.
• Configure and mange RMAN backup using GRID.
• Clone databases with various strategies like Cold/Hot/Logical Refresh and RMAN Backup.
• Object/Schema level re-org whenever the fragmentation is found.
• Add/configure the database for database monitoring in Grid
• Hands-on experience and working knowledge of Oracle RAC 11g GoldenGate in Linux/UNIX environments.
• Experience in new Installation and implementation of GoldenGate
• Worked on Restore and Recover of databases.
• Basic Administration of Data guard database.
• Administrate RAC service with SRVCTL.
• Instance migration from one server to other server.
• Implemented Critical Patch Updates which Oracle provides for each server.
• Cloning from cluster database to Normal database and Cloning from Normal database to cluster database.
• Performed number of Media recoveries, tablespace and datafiles recovery and point in time recoveries.
• Created monitoring base line templates in Oracle 10g Grid based on different thresholds as per the database requirements
• Created Backup jobs in OEM Grid for databases.
• Document the SOP and capture the evidences during Change control in Production databases and Validated Systems

Confidential, Chicago, IL

Oracle Database Administrator

Responsibilities:

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 2GB to 3TB .
• Created Oracle RAC 11gR2 databases with ASM File system on Oracle Exudates Servers.
• Troubleshoot installation errors both independently and with Oracle support (via My oracle Support)
• Create oracle databases on configured servers using both the DBCA & Database creation scripts.
• Configure Golden Gate for high availability, real-time apply and Zero-down time upgrade
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control.
• Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, RAW Devices
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Analyzing schema of databases created to collect statistics using the DBMS STATS package.
• Use AWR/ADDM for 10g Statistics management & database tuning following creation of new databases and periodically thereafter.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance
• Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus.

Confidential

Sr.Oracle Database Administrator

Responsibilities:

• Oracle 10g Installation on UNIX OS and Windows.
• Oracle 10g database cloning, patching.
• Database creation as per project requirements
• Space management database using OEM.
• User Management & Security Management
• Taking Physical and logical backups of the databases.
• Maintaining Prod, Test.
• Transferring data using Export-import, Datapump.
• Daily Logical Backup and restore for UAT database.
• Used Tools - Oracle Enterprise Manager (OEM), Toad.
• Monitoring the system resources using vmstat, iostat, top etc.
• Renamed the Database.
• Creation of database objects & of table, indexes
• Changed init.ora parameter.
• Gathering statistics using Statspack.
• Check alert log & backup log file for possible oracle errors
• Managing stand by database, MIS database & Test database.
• Co-ordination with users & responsible for quick solutions to their problems.
• Reorganization of Table spaces to reduce the number of data files within the tablespace.

Confidential

Oracle Junior Database Administrator

Responsibilities:

• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.
• Write database documentation, including data standards, procedures and definitions.