SUMMARY:

• Oracle certified professional with 9+ years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 11g/10g/9i/8i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platform.
• Experience in Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Experience in Backup & Recovery, Disaster Recovery options and Oracle Recovery Manager (RMAN).
• Monitored all teh 11g databases on Red Hat Linux environments by using OEM 11g and 12c.
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM). Grid Control for maintaining many databases together on separate servers
• Experience in SQL server administration and maintenance.
• Experience as On-Call 24x7 production DBA support, application/development DBA, system Storage Management (ASM).
• Expertise in Installing and configuring ASM and RAC for high availability databases
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM)
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement teh business logic
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Solid experience on Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Database Migration & Up gradation from 9i/10g to 11g (Exadata X2 and X3)
• Cloned Database from Production to Test and Development and from Development to Production
• Experience in migration of oracle database to higher version and installing patches
• Experience in SQL tuning and base line tuning.
• Experience in working with Oracle Virtual Machine.
• Experience in quality support and delivery to teh end-user.
• Exporting and Importing of dumps using expdp and impdp.
• Experience in Data Migration 10g as well 11g
• Knowledge of new features in 11gR2, like Omotion, RAC-One Node and replication using Oracle Golden Gate
• Experience on handling databases sized 800 GB to a max of 5.8 tb.
• Having experience in performance tuning issues using AWR and ADDM Reports.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP
• Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and Virtual IP Configuration Assistant (VIPCA).
• Worked on different types of storage structures (SAN/NAS).
• Responsible for interacting with business partners to identify information needs and business requirements
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.
• Excellent interpersonal, strong analytical and problem-solving skills with customer service oriented attitude.
• A very good team player, self-motivated, dedicated in any work environment

TECHNICAL SKILLS:

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003

Databases: Oracle 11gR2, 10gR2 RAC, 9i, 8i, RAC Exadata X2, X3, SQL Server 2005

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control

Data Warehouse Tools: SQL and ETL tools for above database environment and Tableau

Tools: & Utilities Export/Import, RMAN, Golden Gate, Data Pump, Winscp3, ERWIN.

Languages: C, C++, UNIX shell scripts, PL/SQL, perl

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE:

Confidential, NC

Oracle RAC DBA

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS
• Performed upgrades from Oracle 10g to 11g and applied patches
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Performed zero downtime cross platform migration and 11g database upgrade with Golden Gate.
• Good experience in SQL, PL/SQL, Shell Scripting, Data modeling, OLAP, Logical and Physical data model using ERWIN, Backup and Recovery procedures.
• Proficient in managing Oracle Instance, database storage structure, schema objects
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities and Implemented 10g RAC on a test basis.
• Monitored all teh 11g databases on Linux environments and also monitored their performance by using OEM 11g and 12c versions.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Apparently perform SQL tuning and baseline tuning. Experience Flash back
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware
• Adding teh required User Logins, Groups and Users, Granting and Revoking Permission to/from teh users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements
• Installation of Oracle database 10g software with RAC using Oracle Clusterware and Oracle Data Guard setup done for RAC, Installation of Oracle 10g management agent and grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Experience in Data Migration Working with Oracle 10g and 11g.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Experience in implement a variety of solutions for improving teh availability, accessibility, performance, and integration of critical data across teh enterprise.
• Extensively used PL/SQL for designingpackages, stored procedures, functionsand databasetriggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Experience in quality support and delivery to teh end-user.
• Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN

Environment: IBM-AIX, SunSparcSolaris64bit, and Redhat Linux, Oracle Database Server 10g/11g, Golden Gate, PL/SQL

Confidential, Des Moines, IA

Sr. Oracle RAC DBA/SAP

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS
• Performed upgrades from Oracle 10g to 11g and applied patches
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold)
• Worked in AES encryption in oracle 10g and 11g by using DBMS Crypto package.
• Upgrade databases from Oracle 9i to 10g, 9i to 11g, 10g to 11g (Exadata X3)
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Experienced on installation, configuration with OracleOEM(10g to 12c).
• Proficient in managing Oracle Instance, database storage structure, schema objects
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Implemented Logical, Physical and Conceptual Data Modeling using ERWIN Data Modeler to visualize data structure to effectively organize, manage and moderate data complexities.
• Involved & performed Production Change Requests for PRD major DB changes.
• New DB creation, Existing DB deletion, various DB Housekeeping activities
• Experience with SAP application using with BR tools.
• Implemented 10g RAC on a test basis
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures
• Installing ASM environment and migrating database from NON-ASM to ASM
• Worked on re-hosting existing legacy databases to new and Exadata(Linux) databases.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Apparently perform SQL tuning and baseline tuning. Experience Flash back.
• Using with BR tools taking backups and adding space and re-organizing table spaces in SAP application.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware
• Adding teh required User Logins, Groups and Users, Granting and Revoking Permission to/from teh users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements
• Installation of Oracle database 10g software with RAC using Oracle Cluster ware
• Oracle Data Guard setup done for RAC.
• Installation of Oracle 10g management agent and grid control..
• Experience in providing Real time data feeds, heterogeity and transactional integrity by using Golden Gate.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Experience in Data Migration Working with Oracle 10g and 11g.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Experience in implement a variety of solutions for improving teh availability, accessibility, performance, and integration of critical data across teh enterprise with Golden Gate.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Experience to Continuous availability and disaster tolerance of critical data systems is more than “after-teh-fact” data recovery by using Golden Gate.
• Experience in quality support and delivery to teh end-user
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules) and Loaded data into Database using external tables
• Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN

Environment: SunSparcSolaris64bit, IBM AIX and Red hat Linux, Oracle Database Server 10g/11g, Golden Gate, TOAD, PL/SQL, BR tools

Confidential, Stamford CT

Oracle DBA/Off-shore Lead/SAP

Responsibilities:

• Configured and installed Oracle 9i/10g Databases; handled migration/upgrades of databases from 8i to 9i and 10g manually and with DBUA.
• Data modeling / Logical database design and implementation (including index design)
• Performed Backup/Recovery using RMAN and established testing standards utilizing teh advantages of 10g Flashback.
• Experience with SAP application using with BR tools.
• Performance tuned application/table design, data access methods, memory allocation, disk I/O, CPU usage and resource contention.
• Installation, configuration and administrating Oracle Golden Gate replication.
• Worked on debugging of databases and applied Oracle patches.
• Monitored Oracle Databases using scripts and OEM for database connectivity, table spaces monitoring and object growth.
• Using with BR tools taking backups and adding space and re-organizing table spaces in SAP application.
• Experience conducting technology audits and performing GAP Analysis.
• Analyzed tables and rebuilt indexes to improve performance. Managed rollback segments, server processes, SGA, online redo log files and data files.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Monitored teh server’s memory, disk, CPU I/O and network to establish baseline and peak performance for applications using UNIX command-line utilities.
• Wrote SQL scripts for DBA functions. Designed and created database objects such as Tables, Indexes, synonyms, database links, views and snapshots.
• Supported Developers and end-users in troubleshooting issues.
• Provided maintenance of User accounts and privileges.

Environment: IBM-AIX, SunSparcSolaris64bit, and Red hat Linux, Oracle Database Server 9i/10g/11g, Golden Gate, TOAD, PL/SQL, BR tools

Confidential, Pittsburg PA

Oracle RAC DBA/Off-shore Lead

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS
• Performed upgrades from Oracle 10g to 11g and applied patches
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold)
• Worked in AES encryption in oracle 10g and 11g by using DBMS Crypto package.
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Proficient in managing Oracle Instance, database storage structure, schema objects
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities and Implemented 10g RAC on a test basis
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Apparently perform SQL tuning and baseline tuning. Experience Flash back
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware
• Adding teh required User Logins, Groups and Users, Granting and Revoking Permission to/from teh users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements
• Installation of Oracle database 10g software with RAC using Oracle Clusterware and Oracle Data Guard setup done for RAC, Installation of Oracle 10g management agent and grid control
• Experience in providing Real time data feeds, heterogeity and transactional integrity by using Golden Gate.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Experience in Data Migration Working with Oracle 10g and 11g.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Experience in implement a variety of solutions for improving teh availability, accessibility, performance, and integration of critical data across teh enterprise with Golden Gate.
• Extensively used PL/SQL for designingpackages, stored procedures, functionsand databasetriggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Experience to Continuous availability and disaster tolerance of critical data systems is more than “after-teh-fact” data recovery by using Golden Gate.
• Experience in quality support and delivery to teh end-user.
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules) and Loaded data into Database using external tables
• Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN

Environment: IBM-AIX, SunSparcSolaris64bit, and Redhat Linux, Oracle Database Server 10g/11g,Golden Gate, TOAD, PL/SQL

Confidential, Raleigh NC

Oracle DBA/Data ware house developer/Lead

Responsibilities:

• Installed Oracle 10g database on Sun Solaris, Red Hat Linux.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
• Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to teh cluster and handled performance tuning using AWR
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database
• Primary DBA for Data warehouse
• Performing Data base design in Data ware housing.
• Expertise involving in Data Walt.
• Has worked on different environments like test, development and production databases.
• Haveworked on backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers and Responsible for upgrade & migrating databases from 9i to 10g, applying patches
• Experience in handling GUI software and OS.
• Database Restore using RMAN, Cold Backup and Export.
• Experience in set up ODI to replicate data from oracle to AS/400
• Knowledge experience with Ethernet and mobility systems
• Experience in Implementation of Oracle Streams for Replication.
• Implemented schema level, table level and bidirectional oracle streams.
• Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.
• Experience in implement a variety of solutions for improving teh availability, accessibility, performance, and integration of critical data across teh enterprise with Golden Gate.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Experience in Data Migration Working with Oracle 10g and 11g.
• Experience in quality support and delivery to teh end-user.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used impdp /expdp and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Optimize JDBC and java stored procedure code. Provide stress testing and scalable using thin vs OCI driver. Web Logic EJB performance tuning.
• Experience to Continuous availability and disaster tolerance of critical data systems is more than “after-teh-fact” data recovery by using Golden Gate.
• Automated monitoring teh databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering teh required information and resolving various issues.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris, Windows XP, Oracle VM, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1,UNIX, Linux 4.0

Confidential, Thousand Oaks, CA

Oracle DBA

Responsibilities:

• Provided production database support to Confidential ’s Research and Development (R&D) and Global pharmaceutical databases.
• Configured and installed Oracle 9i/10g Databases; handled migration/upgrades of databases from 8i to 9i and 10g manually and with DBUA.
• Data modeling / Logical database design and implementation (including index design)
• Performed Backup/Recovery using RMAN and established testing standards utilizing teh advantages of 10g Flashback.
• Performance tuned application/table design, data access methods, memory allocation, disk I/O, CPU usage and resource contention.
• Worked on debugging of databases and applied Oracle patches.
• Monitored Oracle Databases using scripts and OEM for database connectivity, tablespaces monitoring and object growth.
• Experience conducting technology audits and performing GAP Analysis.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Monitored teh server’s memory, disk, CPU I/O and network to establish baseline and peak performance for applications using UNIX command-line utilities.
• Wrote SQL scripts for DBA functions. Designed and created database objects such as Tables, Indexes, synonyms, database links, views and snapshots.
• Supported Developers and end-users in troubleshooting issues.
• Provided maintenance of User accounts and privileges.

Environment: Sun Solaris, Windows 98/NT/2000, IBM X Series, Oracle9i/10g, Oracle Enterprise Manager EXPLAIN PLAN, RMAN, and RAC

Confidential

Jr. Developer/Oracle DBA

Responsibilities:

• Installing Oracle 10g and upgraded it to latest 10g patch set on HP-UX 11.23
• Migrating applications from non-clustered oracle 8i/9i/10g databases to new
• 10g RAC Database environments
• Monitoring and supporting Applications using OEM 10g Grid Control
• Configured two node Oracle 10g RAC cluster
• Applying patches
• Created PARTIONING of its types like Range, List & Hash by teh specific use
• Implemented Oracle Streams for Replication.
• Implemented schema level, table level and bidirectional oracle streams.
• Registering Databases to Oracle 10g GRID
• Registering Databases to RMAN Catalog
• Planning and scheduling Backups, RMAN, taking Logical Backups
• Experience in Export/Import and Datapump.

Environment: Oracle 9i, RAC, ASM, Oracle 10g Grid Control, Oracle 9i, HP-UX 11.23

Confidential

Jr. Developer/Oracle DBA

Responsibilities:

• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Responsible for writing database programming to Store/Retrieve teh information from teh 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 teh Oracle database.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase teh performance.
• Configured scripts to monitor activity with database.
• Implement Hot, Cold and Logical backup plans.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Oracle Configuration. Oracle Tuning. Oracle Patch Administration
• Knowledge experience with Ethernet and mobility systems
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them
• Creation of Users and Granting them privileges and roles
• Performed Database Tuning. Performed Database Security and Integrity.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate teh data loading.
• Monitoring teh data loading jobs and tuning teh Sql queries.

Environment: Oracle 9i, Sun, TOAD