SUMMARY

• Over 7 plus years of experience as an Oracle DBA in Production, Development and Test environments, and transforming business strategies of various Fortune 500 and MNC organizations into efficient and integrated global business solutions.
• 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.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM, STATSPACK, and tuning of SQL scripts using SQL Trace, TKProf, Explain Plan, and Hints.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases, Application Servers and Middle Tiers.
• Creation and maintenance of database Standard Operating Procedures (SOP's).
• Solid understanding of VTL, EDL, Tape Cloning and EMC SAN storage technologies.
• Migrated single instance databases to multinode 10g RAC Real Application Cluster environment for high availability and load balancing.
• Oracle Application server with application of E - business as well as oracle Report server, 10g Portal, Oracle Forms server and Oracle Developer suite.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, ERWIN Data modeling, Logical and Physical database design.
• Management of schemas, objects, partitioning the tables, indexes, USERS and PRIVILEGES 10g OEM Grid Monitoring.
• Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.
• Resolved database network problems using Oracle Net Configuration Assistant(NETCA) and Virtual IP Configuration Assistant (VIPCA).
• Strong experience in working with various project, application and infrastructure teams, in large enterprise projects.

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, SQL Server 2005

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

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

Languages: C, C++, JAVA, Unix shell scripts, PL/SQL, Perl

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

PROFESSIONAL EXPERIENCE

Confidential, Irving, Tx

Oracle RAC DBA

Responsibilities:

• 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). Database Migration from 9.2.0.6 to 9.2.0.8. Reorganize Oracle tables from scratch to Oracle OFA (Optimum Flexible Architecture) standards.
• Proficient in managing Oracle Instance, database storage structure, schema objects. Database Up-gradation from 9i to 10g on AIX environment. Implemented new features of Oracle 9i like Log Miner.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 10g RAC on a test basis.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures. Silent Installation of 9i & 10g client & Server with AIX.
• 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.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the 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. 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.
• 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.
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables.
• Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN.

Environment: Operating Systems: IBM-AIX, Sun Sparc Solaris 64 bit, Redhat Linux, RDBMS: Oracle Database Server 8i/9i/10g, Programming Language/Tools: TOAD, PL/SQL.

Confidential, Schaumburg, IL

Oracle DBA

Responsibilities:

• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have 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. 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.
• Involved in Design and implementation of oracle 10g Dataguard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• 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.
• Automated monitoring the 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 the required information and resolving various issues.

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

Confidential, NY

Oracle DBA

Responsibilities:

• Provide backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade support for approximately 9 Oracle databases.
• 24x7 Production-on call supports for all the production databases with Oracle 8i, 9i, 10G version.
• Implemented Data guard for the production database.
• Administration and support of Oracle Application Server 9i and 10g.
• Stream data between 2 nodes through the use of Oracle Streams.
• Providing technical support to Application Support team for performance and database related issues.
• Implemented backup and recovery strategies using export/import, RMAN.
• UNIX shell scripting as and when required based on the requirement.
• Creating Customized Scripts for Streams Replication based on the Clients Requirement.
• Patched Oracle Database Server 9i and 10g using Opatch.
• Upgrading/migrating Oracle databases from 8i/9i to 10g.
• Tuned production databases supporting the application using Statspack/AWR.
• Refresh development/test databases from copies of production.
• Implemented high availability options i.e. advance replication to ensure prompt response and support multiple users across the globe by maintaining multiple master sites and kept them tied up with Asynchronous replication.
• Implemented high availability options i.e. advance replication to ensure prompt response and support multiple users across the globe by maintaining multiple master sites and kept them tied up with asynchronous replication.
• Shooting performance bottlenecks in application and network.

Environment: Oracle 10g/ 9.0.1.0/9.2.0/9.2.6 , SQL Server 2000, Oracle RAC 9.2.0, SQL, PL/SQL, SQL Loader, OEM, Standby Database with Dataguard, UNIX Shell Scripting.

Confidential, Reston, VA

Oracle DBA

Responsibilities:

• Backup Script creation and Standardization. Performed Database Installation and upgradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used Statspack, TKPROF utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Used SQL* Loader for data import from remote databases.
• Written the control files in SQL*Loader to load the files in database tables.
• Database Installations, Creations and Upgrades of 8i/9i on Windows 2000/NT.
• Analyzed the structures using Analyze command.
• Involvement in all phases of the project life cycle.
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system.
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Worked closely with developers in Designing Schema / tuning PL*SQL/ SQL code.
• Performed Database Tuning for Oracle 8i & 9i servers including reorganization, SGA, kernel, redo log tuning, Rollback tuning.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: ORACLE 10g, SQL, PL/SQL, Toad, Pl/SQL Developer, Cronjob, Import/Export, UNIX AIX 5.1,Windows 98/NT/2000, Confidential -UX, Oracle 9i/8i/7, TOAD, Database Tools/Utilities.

Confidential

Jr. Developer/Oracle DBA

Responsibilities:

• Installing Oracle 10g and upgraded it to latest 10g patch set on Confidential -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 the 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, Confidential -UX 11.23.