SUMMARY

• Over 8+ 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 and 12c ).
• Experience in installation and configuration to support data replication in Oracle Database environment.
• 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 for the database.
• Experience in creating Flashback Technologies
• 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 Export/Import, Data Pump and Flashback Technologies.
• Extensive use of Crontab and Autosys in UNIX environment for scheduling routine tasks.
• Created and Maintained Users and Roles with Appropriate Privileges and Profiles.
• Created Tablespaces for Schema's.
• Experience in Transparent Tablespace
• Co-ordination with Confidential for technical support, new products and releases, technical discussion/support.
• Ability to work under extremely tight deadlines and can maintain focus on objectives and processes and troubleshooting, implementation and development skills.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Team Leader

Responsibilities:

• Migrated data on different Oracle versions of 11g(11.2.0.4) and 12cR1
• Installed &configured 12.1.0.1 on different operating systems of AIX and Linux.
• Deploying OEM agents on many servers and configuring the agents on OMS.
• Taking backup of databases using RMAN.
• Responsible for applying PSU patches on most of the production databases
• Worked on Transparent Tablesapce
• Created a physical standby for Disaster Recovery (DATA GUARD).
• Applied Patches includes PSU and Bug-fixes for database performance issues.
• Experienced writing UNIX scripts and troubleshooting issues.
• Installed Oracle Configuration manager on various production environments
• Involved in upgrading the databases from 11gR2 to 12cR1.
• Good experience in managing the databases using the OEM grid control like Scheduling backups, performance monitoring, alerts setting, generating reports in seconds, email notifications, Black out instances during maintenance/down times etc.
• Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose.
• Applied High priority, security patches downloaded from Oracle Support.

Environment: Oracle 11gR2 and 12c (11.2.0.4 and 12.1.01) on RHEL, Health Care and Medical.

Confidential, Minneapolis

Sr. Oracle DBA

Responsibilities:

• Experienced in working and monitoring the databases by using Oracle Enterprise Manager (OEM).
• Supporting both production and development activities.
• Creating of databases for Testing, Development and Production.
• Worked and Export and Imports for refresh activity.
• Provided Daily Health Check Reports for Telecom and Solutions.
• Installation of Oracle version 11g and 12c on Linux.
• Worked on Flashback Technologies.
• Migration of Database from Non-Cloud Server to Cloud Servers.
• Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces and allocation tables to different tablespaces.
• Worked on Transparent Tablespace.
• Worked on PUS Patches for every quarter.
• Working knowledge with Oracle Support

Environment: Oracle 11g, RMAN, SQL*Plus, Oracle OEM, Exports and Imports, People Soft, Finance and Siebel.

Confidential - Illinois

Oracle DBA

Responsibilities:

• Installed 11g Oracle database on Linux and AIX.
• Provided database related services to their development and QA environments.
• Provided Daily Health Check Reports for Telecom and Solutions.
• Created Users and Tablespaces
• Logical and Physical backup procedures.
• Data exports from production and staging databases.
• Tuned production database performances and was instrumental in SQL tuning that improved application response.
• Run oracle AWR to tune the databases.

Environment: Oracle 11g, IBM-AIX, RHEL, Window 2008, Telecom, Solutions, Siebel and ISM.

Confidential - NY

Oracle DBA

Responsibilities:

• Analyzed business requirements and built logical data models that describe all the data and relationships between the data. Designed and implemented physical database
• Installation and configuration of Oracle 10g database server and their version upgrades.
• Installation of Oracle Applications on HP-UX (Single User & Rapid Installation).
• Responsible for performance tuning. Extensively worked SQL tuning, database tuning and operation systems tuning.
• Used several utilities and tools to perform performance tuning & monitoring
• Applied patches, successfully upgraded Oracle. Worked on Storage, Network configurations.
• Developed PL/SQL procedures, assisted /supported dev team with database related issues.
• Designed and implemented Oracle Database, Back up & Recovery.

Environment: Oracle 10g on AIX, Siebel, OBIEE, Hyperion and Finance

Confidential, Missouri

Oracle DBA

Responsibilities:

• Installation, Upgradation and Maintenances of Oracle Server on Linux.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN
• Provided System support for both development and 24/7 production environment.
• Provided Daily Health Check Reports for JD Edwards
• Taking care of all alerts for space issues and user requests.
• Assisted in configuring optimal Oracle 10gR2 RAC architecture.
• Worked on Migrations from 10g to 11g.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Applying patches and Migrations works and work closely with Oracle to keep application environment up to date.

Environment: Oracle 10g and 11g on AIX and Linux, JD Edwards, Siebel and ISM.

Confidential - CA

Oracle DBA

Responsibilities:

• Analyzed business requirements and built logical data models that describe all the data and relationships between the data. Designed and implemented physical database
• Installed 11g Oracle database on Linux and AIX.
• Provided database related services to their development and QA environments.
• Provided Daily Health Check Reports for OEIEE, Hyperion, Finance.
• Created and Configured Databases on Development, Test and Production Environments.
• Applied PSU Patches in all environments.
• Worked on Exports and Imports for different schemas. Designed and implemented Oracle Database, Back up & Recovery.

Environment: Oracle 10g, IBM-AIX, Window 2003, OEIEE, Hyperion, Finance and Siebel.

Confidential - Indianapolis

Oracle DBA

Responsibilities:

• The work involves overall maintenance of ORACLE database, performance issues, tuning, backup, and other database related activities.
• Applied CPU and PSU Patches for every quarter.
• Worked on Exports and Imports for schema refresh.
• Implemented Oracle Replication to enable database fail over incase of system or database crash.
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc which are kept in CRONJOB
• Also worked for network management.
• Day to day performance monitoring and tuning of database.
• Installed and Configured Oracle Data guard for Oracle 10g for the maintenance of Stand by database.
• Created Tablespace, Alter tablespace, Datafiles adding, resizing.
• Creating users granting the permissions and coping with the day-to-day demands and troubleshooting their connectivity, permissions and performance problems.
• Worked with users to determine system requirements.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.

Environment: Oracle 9i and 10g Legacy and Data Pump Exports and Imports, CPU and PSU Patches, OBIEE and Siebel