SUMMARY

• Over 7+ years of experience in Information Technology as anOracleDBAon Linux, UNIX and Windows operating system environments.
• Experience as a Production support/Operations DBA with Multi - Terabyte 24x7/large databases and as a Development Engineer/Data WarehouseDBA, and development support 11g R2, 10gR2, 9i databases on different platforms with practices for Oracle Database Infrastructure, Standards and Implementation
• Extensive experience in Installations, configuration, Cloning, Security, Patching, Upgrades.
• Implementation of Enterprise wide Database Monitoring enabling Oracle11g Enterprise Manager Grid Control. One stop solution for monitoring every singleOracleDatabase within the global enterprise
• Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.
• Implementation of Oracle Backup and Recovery strategies using COLD BACKUP, HOT BACKUP and RMAN environment.
• Proficient in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management.
• Polished leadership skills with ability to motivate teams to increase productivity.\
• Worked on Middle ware and Oracle Real Application Clusters (RAC) with Data guard/or other replication technologies.
• Performed Tablespace point in time recovery (TSPITR) using RMAN
• Worked on Flash back, High Availability with Oracle Linux Red Hat/VMware & Oracle virtual box environment
• SQL Performance tuning and DBA performance tuning like explain plain, Auto trace, AWR,Statspack etc.
• Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows.
• Performance Tuning of Oracle database using OEM GC, Cost optimizer, SQL analyzer Performance Manager, Stats pack, AWR, ADDM, ASH, RDA, Explain plan (10046), TKPROF, SQL TRACE and Ordebug.
• Installed and configured Oracle Enterprise Manager Grid Control 10g for database monitoring, performance, diagnostics.
• Data transferring using Export/Import utilities and SQL*Loader.
• Expertise in creating and maintaining databases to Oracle Optimal Flexible Architecture (OFA) standards in very large scale database environment (VLDB) and mission critical OLTP and DSS systems.
• Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.
• Involved in writing stored Procedures, Functions and Triggers in PL/SQL to interface application with database system.
• Developed shell scripts for regular administration tasks that include various Cron jobs for alert logs, Backups, restore and recovery.
• Created service requests with Oracle support for troubleshooting database issues.
• Experience in creating partition tables and Materialized views.
• Expertise in Database Security and Auditing.
• Experience in Managing Database Structure, Storage Allocation, Table/Index segments, Undo segments, Constraints, Database Access. Solid understanding of SDLC and CMM models.
• Provided 24 x 7 support and flexible to work beyond regular hours.
• Strong ability to handle multiple projects simultaneously and ability to work independently or in a team environment and function successfully in a highly stressful environment.
• Experience in managing, training and mentoring a DBA team

TECHNICAL SKILLS

Databases: Oracle10g & 11g, Teradata12, SQL server2005/ 2008

Operating Systems: AIX/HP-UX/Windows, Mainframe

Languages: PL/SQL, SQL, T-SQL

Tools: /Utilities: Tidal Scheduler, Facets5.1, Jprofiler, APP Dynamics, PowerCenter9.1

Backup/Recovery: Exp/Imp, Datapump, RMAN backup, SQL Loader, vmstat, nmon, perfmon, AWR, OEM, JIRA, QC, TFS, SVN.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential - NJ

Responsibilities:

• Maintenance of production & development databases including tablespace management, user creation, granting privs, roles etc.
• Automated hot backups utilizing a combination of incremental, differential & full RMAN backups
• Maintaining archive data on appropriate storage devices
• Tracing, troubleshooting with database preforming & tuning issues
• Analyzing WR reports to identify on-going/proactive issues and worked with other team members to find a solution
• Successfully implemented physical standby database usingOracleData guard and Active Data guard feature for High availability configuration in RAC environment
• Providing database & system management for multiple servers
• Using AWR, ADDM and variousOracleAdvisors to tune the database.
• Extensively used DATAPUMP and Import/Export utilities for logical backups.
• ConfiguringOracleEnterprise Manager (OEM) 11g
• ConfiguringOracleGrid Control Agent
• Supported theDBAteam in managing over 80 databases onOracle11g on Windows
• Preformed variousDBAMaintenance tasks such as rebuilding indexes, validating constraints, reorganizing tables
• Responsible for creating users and assigning of roles & privileges
• Assisted Senior DBAs with any issues relating to performance monitoring & tuning by usingoracle supplied tools/software

Environment: OracleServer 10g/11g SQL Server, LINUX/UNIX, SUN OS

Oracle DBA

Confidential - NJ

Responsibilities:

• Install client/serverOracleand MS SQL Server Software
• Wrote scripts to create tables, views, indexes and synonyms required meeting developer needs.
• Working with Java J2EE developers to develop and formulate capacity planning for 11g databases.
• Worked on in house installation ofOracleon different platforms, loaded user data to reproduce the problem, applied newOraclepatch, managed database backup using RMAN, upgradedOracle database 10.2.0.4 to 11.2.0.4.2
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Creating physical databases with multiple table spaces from logical and physical data model
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
• Data migration between databases using bothOracle10g and 11g export/import utility andOracle11g exp/imp data pump.
• Prepared scripts to tune developer SQL codes to maximize result return time
• Worked on large databases inOracle11g with multiple instances using Veritas Cluster.
• Performed cold and hot backup using Oracle's Data pump.
• Provided remote technical support using SSH and terminal services
• Troubleshooting, Restructuring and tuning for optimal performance of existing databases that were poorly designed for heavy hits.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard
• Administer RAC database using OEM
• 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
• Resizing and reorganization of database objects: Tables, Indexes, Rollback segments and Redo log files of existing production and development systems.
• Resizing Tablespaces, Tables, indexes, Rollback segments.
• Design of databases following OFA: Creating Databases schemas, profiles, database links, Snapshots and Synonyms of objects as required to ensure data quality and security to comply with company's business rules.Oraclescripting in Windows/ Solaris and UNIX platform.
• Backup / Recovery methodology specification for mission critical databases
• Performed hot and cold Backups.
• Scheduled daily Exports/Imports to serve as temporary backups.
• Performed proactive and reactive tuning/managing database space utilization and growth
• ImplementingOracleASM and resolving ASM related issues
• Detailed analysis of the business and users requirements by doing various information gathering techniques.

Environment: OracleRMAN,Oracle11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Oracle Database Administration

Confidential - Minneapolis, MN

Responsibilities:

• Responsible for Installation and administration ofOracleRAC 10gR2 andOracleRAC 11gR1 production and development databases.
• Provided 24*7 with an on call pager.
• Performed cloning using RMAN to set up development and test databases from Production database.
• Upgraded the database from 10gR2 (10.2.0.5) to 11gR1 (11.1.0.6).
• Involved in database migration from single instance to 3 nodes RAC Database.
• Creation and Configuring Services using SRVCTL and CRSCTL.
• Managing databases usingOracle10g Grid Control.
• Responsible for installing and maintaining the Standby database.
• Hands on experience in administering Tablespace Management, User Management, UNDO management etc.
• Used Data Guard broker to monitor Data Guard configurations on standby database.
• Good working and implementation knowledge on Data Guard and Stand-by databases for fail-over and recovery.
• ConfiguredOracleStreams for replication between two databases and tuned the streams pool for higher performance.
• Configured Net Backup with RMAN for database backups and restore. Also implemented logical, cold and hot backups.
• Applied patches whenever necessary by downloading them from Metalink.
• Involved in De-fragmenting data blocks of Tablespaces for optimized performance. Also partitioned large tables to increase performance.
• Rebuilt indexes for better performance ofOracledatabase.
• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.
• Performance tuning using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.
• Performed database object sizing (performance tuning of database objects) and space allocation.

Environment: RDBMS (10g,11g), Solaris 8 (SPARC), RHEL4, python, shell scripting, Perl scripting, TOAD, EXPALIN PLAN, TKPROF, EXPORT/IMPORT, SQLLDR, RMAN.

Oracle Developer / DBA

Confidential

Responsibilities:

• Supporting large mission critical databases in a 24x7 environment
• Migration of database from Oracle 9i to Oracle 10g
• Working with database Monitoring and Tuning
• Lead efforts to develop and improve procedures for automating monitoring.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and kern shells, Unix shell Scripting.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL
• 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 Adfa
• Creating databases, objects, roles and privileges Af
• Partitioned large tables to increase the performance Adf
• Configured scripts to monitor activity with database Daf and Implement Hot, Cold and Logical backup plans
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction Fa
• Worked on Oracle Configuration, oracle Tuning and Oracle Patch Administration Af
• Knowledge experience with Ethernet and mobility systems Adf
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them Fas
• Performed Database Tuning
• Performed Database Security and Integrity
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages
• Created partitioning of its types like Range, List & Hash by the specific uses.

Environment: Oracle 9i, 8i, RMAN, SQL*Loader, Sun Solaris, RHEL, Oracle Linux.

Oracle Application / Core DBA

Confidential

Responsibilities:

• As part of a 2-member DBA team, managed and supported more than 50 databases 24x7.
• Personally responsible for about 25 databases. Performed Oracle installations, applied patches, upgraded databases on several instances.
• Database Installations in DR and DC servers.
• Perform logical and physical backups for recovery by using exp/imp, expdp/impdp, OS backups and RMAN tool.
• 24*7 Production Databases Support and Monitoring using Unix Shell Scripts.
• Performing database Backup & Recovery using RMAN and Export/Import Utilities.
• Unix Shell scripting for Automation of DB monitoring, Backup, File-system Size thresholds, Oracle Errors.
• Database Administration Support for all the Application Modules and Development Teams (CCC, WSS, GIS, SSO, CCB, MDAS, MDM, SOA, MIS, EA).
• Performance tuning and troubleshooting of poorly performing programs.
• Perform Daily Monitoring of all Critical instances using and monitor users, Tablespace, memory structures, logs, and alerts.
• Automating Archival process and fragmentation processes through shell scripts.
• Built databases using exp/imp & Data Pump moving data from PROD Databases to Staging/DEV/Test Databases.

Entry level oracle DBA

Confidential 

Responsibilities:

• Involved in documenting of Linux and Windows environment and configuration details
• Creating database objects like tables, views index.
• Involved in user account management.
• Executed Hot, RMAN backup.
• Documentation of database backup and recovery standards.
• Constantly monitoring the performance of database and viewing Alert log files.
• Working closely with developers to get the database requirements.