PROFESSIONAL SUMMARY

• 8+ years of extensive experience as an Oracle DBA in Production, Test and Development environments.
• Designing, modeling, administration, implementation, troubleshooting, and quality management for several production/test systems on Oracle (8i, 9i, 10g, 11g) Databases. Involved system administrators groups in designing the logical and physical model of the databases.
• Installation, configuration and upgrade of Oracle 10g, 11g RAC.
• Extensive work experience on Single instance, Oracle RAC databases in both OLTP and OLAP environments.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Experience as Oracle DBA providing support to many Production, Development, Test, CRP instances comprising of some of the more complex and challenging environments from versions 9i to 11greleases.
• Installing and Upgrading Oracle Server 10g to 11i, 11gR1, 11gR2, R12.
• Administering Oracle 10g, 11i, 11g Instances.
• Multiple upgrades of Oracle server older versions to newer versions.
• Performed Cross Platform migration of Oracle and Advanced Planning and Scheduling from HP to AIX.
• Configuring, Upgrading and installing Oracle Server 9i/10g/11i/11g.
• Troubleshooting and Administration of Oracle 9i/10g/11g Server.
• Oracle 11g Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories.
• Oracle 10g,11g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Implementing High Availability solutions with Oracle 11g RAC, Standby (Data Guard).
• Installing, configuring and maintaining Oracle Grid Monitoring.
• Extensive knowledge in working with the tools like OEM, TOAD, QUEST, Export/ Import, Stats pack, SQL* Loader, SQL Analyze, TKPROF, Explain Plan, and Oracle Supplied DBMS_PACKAGE.
• Configuring backup software like VERITAS Netback up, Legato Networker for oracle using RMAN tool for backup and recovery.
• Hot and cold Backup and recovery of Oracle 10g, 11g database using tools like RMAN.
• Scripting and scheduling of oracle database backup using RMAN.
• Good experience of Oracle PL/SQL, Procedures, Triggers, Cursors and Functions.
• Cloning of database for development teams, import and export of data.
• Involved in SQL tuning and refreshing statistics of database objects. Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Experience in writing complex SQL Queries, created materialized views.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.
• Proven ability to adapt to demanding schedules and changing priorities.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Involved and implemented with analysts, developers, programmers and project managers in a project system development life cycle (SDLC) phases.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.

TECHNICAL SKILLS

Operating Systems:AIX 7.x/8.x, RHEL (4.0/5.0), Windows 2003/2008/XP ,Windows 7

RDBMS:Oracle 11g/10g/9i/8i, RAC

Languages:SQL, PL/SQL, UNIX Shell Scripting , C++, C#, Html and XML, ASP.NET, PHP, JAVA

Performance Monitoring Tools:Oracle Enterprise Manager, TOAD, Oracle Grid Control

Tools/Utilities:RMAN, OEM, SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Data pump, Data guard

High Availability:Replication using Materialized Views

Performance Tuning:EXPLAIN PLAN, Data Dictionary Views, Dynamic Performance Views, Undo Management Advisor, Memory Advisor, MTTR Advisor, Segment Advisor, AWR and ADDM

PROFESSIONAL EXPERIENCES

Confidential, Buffalo, NY Sept 2010 – Present
Oracle DBA

Responsibilities

• Worked in 24x7 Production Oracle Databases environment.
• Involved in both managing and supporting all Production, Development and Test instances of Oracle Version and Oracle Applications.
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin.
• Experience in cloning, Patching, Installation and problem solving in the Oracle E-Business Suite (EBS).
• Maintaining the Oracle Applications EBS Systems including Oracle databases, Middle tier IAS Applications.
• Working closely with Functional/Developers and helping them in issues.
• Creating and sizing of database objects (tablespaces, tables, and indexes).
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures.
• Management of Users, Roles and Privileges.
• Scripts to monitor online Database objects and SGA.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Experience in Installing, configuring and administrating database in RAC environment.
• Troubleshoot RAC database by verifying alert logs. Configured Rapid connect-time failover and Transparent Application Failover in RAC environment and working knowledge in Maximum Available Architecture (MAA).
• Installed, configured and troubleshoot Oracle Clusterware Cluster Ready Service (CRS) for RAC. Used Oracle 11g specific features like Automatic Memory Management (AMM), Result Cache parameters.
• Adding a Disk group, removing a disk group, movement of data between disk groups in an ASM storage platform.
• Successfully implemented Data Guard on physical, logical standby databases.
• Replicating the tables, schemas and database using the replicating tool Golden gate.
• Managed Resumable Space Allocation using Resumable Time out parameter.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling with utilities like OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Designed ETL jobs and Autosys jobs to extract data from java applications into metadata manager repository
• Responsible for Extract Transform and Loading from various systems to Oracle Data warehouse and developed Loader Scripts for various ETL Operations
• Generated reports for displaying the metadata in the metadata manager using Informatica data analyzer tool.
• Backed-up database and database objects using different techniques such as user-managed backup, RMAN backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Experienced in cloning database using RMAN Duplicate and cold & hot backups.
• Performed full database recovery as well as incomplete recovery using Tablespace Point in Time Recovery (TSPITR). Knowledge of cross platform migration of databases.
• Implemented Change Tracking File with RMAN and reduced the backup time significantly.
• Hot and cold Backup and recovery of Oracle 11g database using tools like RMAN.
• Maintain database security, user roles and access profiles, Involved in taking cold and hot backups.
• Performed installation and configuration of Oracle fusion middleware as team member.
• Daily monitoring and checking the Background Dump File (alert SID Logs) and User Dump Files for errors.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical problem solving and good communication skills with ability to work within team environment and independently when needed.

OS: Sun Solaris 10, Microsoft Windows, UNIX, LINUX
Software: 10g, 11gOAM,R12 OEM Grid Control, RMAN, TOAD
Replication Software/ Tools /Utilities: RMAN, OEM, EXP, IMP, Expdp, Impdp, TOAD, Streams, Shareplex, DataGuard.

Confidential, NJ Jan 2010 – Sep 2010
Oracle DBA

Responsibilities:

• Responsible for maintaining Oracle 10g/11g databases for different clients.
• Implement Physical Standby database for High availability & Disaster Recovery using Data guard.
• Installed, Configured and deployed SOA on single node and cluster node.
• Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces for source and target Data Mapping and Packages.
• Tested different Journalizing Knowledge Modules to ensure better performance.
• Good knowledge of data warehouse architectures, concepts and technologies.
• Conceptual data modeling; logical and physical data modeling.
• Cloning and Patching.
• Good understanding in data modeling, entity-relationship modeling.
• Implemented cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Export and Import of Oracle Internet Directory Single Sign On Users with ldap utility.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and AWR.
• Reviewed the procedures and methods used to manage the staging and productiondata feeds all via materialized views (replication).
• Configuration of OEM11g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc).
• Expert knowledge of oracle data-dictionary & configuration of Oracle Enterprise Manager (OEM): DB Control, Grid Control 9i/10g/11g.
• Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g.
• Oracle 11g RAC Database setup and administration using Oracle Recovery Manager (RMAN) for backups.
• Oracle 11g Application Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, and Responsibilities for the user.

OS: Microsoft Windows.
Software: 10g, 11gOAM, OEM Grid Control, RMAN.
Replication Software/ Tools /Utilities: RMAN, OEM, EXP, IMP, Expdp, Impdp, TOAD, Golden Gate

Confidential, CT Apr 2009 - Jan 2010
Oracle DBA

Responsibilities

• Controlling User access: Creating Users, User system Privileges, Granting system privileges, Creating Role, Creating & granting Privileges to a Role, Changing user password, Granting Object Privileges.
• Backing up system using RMAN backup.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Creating & Maintaining Tablespaces.
• Creating monitoring alerts in OEM 10g Grid.
• Setting new threshold values based on the alert history and business requirements.
• Tuning applications.
• Schema, Table, Database/refreshes/on demand for development teams.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Installation of Oracle clusterware, ASM, Configuring public and private network & VIP. Used SRVCTL utility for managing multiple instances & nodes, Managed & multiplex Voting Disk and OCRfile for maximum RAC availability.
• Experience in job scheduling for Windows, UNIX (crontab).
• Working experience with Very-Large databases (VLDB) up to 4 terabytes, data migration, against Oracle & other databases such as SQL Server, MYSQL etc.
• Shell scripting for the database and application monitoring.
• Capacity planning – space management, ongoing maintenance of production and development environments.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Resolving dataguard DR site sync issues.
• UNIX Shell scripting to simplify the day to day activities.

OS: Sun Solaris 10, UNIX
Software: 10g, 11gOAM, OEM Grid Control, UNIX Shell Scripting, UNIX Cronjobs, RMAN, TOAD
Replication Software/ Tools /Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Expdp, Impdp 

Confidential, CT July 2008 – Mar 2009
Oracle DBA

Responsibilities

• Involved in SQL tuning and refreshing statistics of database objects. Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Used Export/Import and Datapump utilities for full/partial backup.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Performed backup validations using RMAN, Database monitoring, troubleshoot and resolve the issues.
• Oracle Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Roles, Functions for the user.
• Performance tuning of Oracle Database, applications and queries.
• Experience in testing and validating backups using Recovery Manager.
• 24x7 Production Oracle Administrations.
• Maintaining production, development& test databases and applications.
• Upgraded Oracle server Database Version 8.1.7.4 to 10g (10.2.0.4) on Solaris.
• Upgraded Oracle Database 9.2.0.8 to 10g.
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Was involved in developing a disaster recovery (DR) plan.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9i.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Experience in using Flash-Back Recovery, AWR, ASM, ASH and ADDM.

OS: Linux, UNIX, Solaris 
Software: 10g, OEM Grid Control, UNIX Shell Scripting, UNIX Cronjobs, RMAN, TOAD

Confidential, CT Oct 2007 - June 2008
Oracle DBA

Responsibilities

• Taking Backups on scheduled time and monitoring scheduled Backups.
• Designing the logical and physical database structure.
• Management of schemas, objects partitioning the tables & indexes.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Database/Re-organization (database, Tablespaces, tables etc.). Re-org is done from time to time for the primary storage objects like tables, indexes.
• Stress test worked with Test Engineer and evaluated the performance.
• Tuned the slow running concurrent requests.
• Creating the Customized Roles, Responsibilities, groups, Request sets and Application Users as part of sysadmin.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions, Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Database Upgrade from 8.1.7 to 9.2.0.6 and 10g.
• Developed and maintained database designs, Meta data and data dictionaries.
• Rebuilding Database indexes.
• Monitoring table space usages.
• Configuring SQL*Net through tnsnames.ora and listener.ora.
• Upgrading JDK versions from 1.4.2 to 1.5 and 1.6

OS: HP-Unix, AIX, Linux
Software: Oracle database 8i&9i.

Confidential June 2004 – Aug 2007
Oracle DBA

Responsibilities:

• Creating and sizing of database objects (tablespaces, tables, and indexes).
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures.
• Management of Users, Roles and Privileges.
• Database performance tuning, table sizing and administration.
• Scripts to monitor online Database objects and SGA.
• Diagnose the bottlenecks and problems causing poor performance.
• Database reorganization to minimize fragmentation.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Data extraction and Loading using Export/Import and SQL*Loader.
• Responsible for security on production database like creating roles and provide access to application schemas to users and maintain separate table spaces for data, indexes and temporary applications.
• Created different synonyms & views as per business needs. Created materialized views and snapshots for high end application usage.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Experience in implementing hot, cold and RMAN backups and performance tuning of SQL statements

OS: HP-Unix, AIX, Linux, Windows, Solaris, 
Software: Oracle database 8i&9i.

Education

Bachelors in Engineering from Confidential University