SUMMARY

• 8+ Years of extensive experience as Oracle 11gR1/R2/10g/9i Database Administrator.
• Experience as a Production support/Operations DBA with Multi - Terabyte large databases and as well as Development/Engineering/Data Warehouse DBA.
• Hands on experience in 11gR2/10g RAC (Real Application Clusters).
• Experience with various replications software’s like Data Guard.
• Configured & managed Stand By databases both physical, logical Active Data Guard for disaster recovery with and without Data Guard Broker.
• Experience in installation/configuration/administration/Patching of Oracle 9i, 10g, 11gR1/R2 databases.
• Good experience in upgrading the databases from oracle 9i/10g to 10g/11gR1&R2.
• Experience dealing withdatabase migration from UNIX, Solaris, AIX to RHEL.
• Good experience with installing and configuring Grid Control 10g/11g and as well as Agents.
• Experienced in virtual environment with Hands on experience on virtualization (VMware Vsphere) technologies.
• Implementedbackup and recoverystrategies usingRMAN, HOT, COLD backups.
• Experience in Implementing and performing Disaster Recovery using Data Guard.
• Experience Working on E-commerce environment with OLTP databases.
• Expert level knowledge in PL/SQL Programming (Writing stored procedures for Packages Implementing functions, triggers, collections).
• Experience in working with physical & relational models of the database.
• Knowledge of SAN, NAS and RAID storage Technologies.
• Experience in Partitioning large tables in VLDB Data warehouse Environments.
• Good Knowledge on data management ETL tools like Informatica, ODI.
• Supported the system 24x7.Ability to work beyond regular hours.

TECHNICAL SKILLS

OPERATING SYSTEM: UNIX, LINUX, HP-UX, AIX, SUN SOLARIS, WINDOWS NT

TOOLS: /UTILITIES ERWIN, TOAD, ETL, RAC, RMAN, Oracle Migration Workbench, SQL-Backtrack, STATSPACK, SharePlex, AWR, ADDM, OEM, OLTP, SQL* Loader, ASM, Crystal reports 2.5, Grid Control.

RDBMS: ORACLE 8i/9i/10g/11gR1/R2, SqlServer2000,2005,DB2, MS Access

LANGUAGES: PL/SQL, SQL, UNIX Shell scripting, PHP, PERL

HARDWARE: IBM RS 6000 servers, Sun sparc E 4500/5000/450 with EMC symmetric 8530and Raid 1 disk storage, HP 9000/E39, DELL Edge 2550/4500.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i/10g/11g databases on different platforms as well as the clients.
• Upgrading oracle databases from 10.2.0.3.0 to 10.2.0.4.0 , 11.2.0.2.
• Oracle server in installation and configuration on virtual environments.
• Cloned/Refreshed staging environment with production data using RMAN.
• Installing, Configuring and Administering Automatic Storage Management (ASM).
• Installing, Configuring and Administering Real Application Clusters on 2 and 4 node cluster.
• Installing CPU/PSU and other security, bug patches for Oracle databases on Solaris, Linux Platforms.
• Cloned/Refreshed databases for testing/QA environments using export/import, data pump and cold backup.
• Implemented Hot and cold backups, Restore and recovery manually.
• Implemented RMAN backups and Restore and Recovery.
• Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
• Experience in Implementing and performing Disaster Recovery using Data Guard.
• Implemented replication between databases using advanced replication.
• Participating in Auditing of databases like PCI Auditing.
• Helped in migrating terabytes of data between different versions of analytics databases.
• Configuring and maintaining OEM.
• Active participation in code deploy for engineering releases.
• Written PL/SQL, Stored Procedures and also UNIX Shell scripts for monitoring database activities,
• Experienced at SQL*Loader, expdp, impdp, exp, imp and other Oracle utilities.
• Experienced at administering database security by installing Ingrain, create users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users
• Perform capacity planning required to create and maintain database environments.
• Management of schemas, Tablespaces, objects partitioning the tables & indexes.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, TKProf utility.
• Re-organization of database objects (Tables, and Indexes etc.)
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Aided developers in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Used Diagnostic & tuning packs along with AWR & ADDM reports
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Helped build extensive documentation for all Oracle related Administration

Environment: Oracle8i/9i/10g/11g, Sun Solaris 5.8 sparc/, Linux, SQL Plus, ASM, RAC, Oracle Enterprise Manager (OEM), Shell scripting.

Confidential, Corona CA

Oracle Database Administrator

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g using ASM on Linux machines.
• Migrated/Upgraded oracle databases from 9.2.0 to 10.2.0.3.0.
• Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
• Installed CPU patches on Solaris, UNIX and Linux platforms in RAC and Non-Rac Environment.
• Monitored RAC Instances Using Scripts For Backups, Performance Tuning, to find out Free space at Table Space, table Levels etc …
• Configuration of Automatic Storage Management (ASM), Configuration of Oracle Cluster File System (OCFS2), Installation of Clusterware in order to explore the RAC Database environment
• Created Recovery Catalog database for RMAN backups.
• Created tables, views, stored procedures and monitored insertions and upload of data as part of the Custom Logger built.
• Management of schemas, Tablespaces, objects partitioning the tables & indexes.
• Extensively used Datapump for the export and import of schemas and tables.
• Extensively used SQL*Loader to load the data into the schema.
• Implemented Hot and cold backups, Restore and recovery through RMAN as well as manually.
• Oracle server in installation and configuration on virtual environments.
• Security and Bug Patch implementation for Oracle 10g binaries.
• Written UNIX shell scripts to monitor ASM, listeners, monitor the alerts, RMAN backups, PL/SQL Stored Procedures and Triggers.
• Experienced at, expdp, impdp, exp, imp and other Oracle utilities.
• Created users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users.
• Re-organization of database objects (Tablespaces, Tables, and Indexes etc.)
• Tuning the application using Oracle utilities like OEM, SQL Trace, TKProf and Explain Plan.
• Worked closely with application team members in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Used Diagnostic & tuning packs along with AWR & ADDM reports
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Environment: Oracle 9i/10g/11g, RED Hat Linux, Sun Solaris, Windows 2003,, SQL*Loader, RMAN, RAC, Toad, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Shell scripting.

Confidential, NY

Oracle Database Administrator

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i/10g databases on different platforms as well as the clients.
• Migrated/Upgraded oracle databases from 9.2.0 to 10.2.0.3.0.
• Installed, configured and maintained Physical Standby Databases for the Production databases using Data Guard.
• Built Physical standby databases using Data guard as part of the disaster recovery strategy.
• Installed and configured Oracle 10g RAC using ASM on 2 node Sun Solaris server.
• Applied CPU patches on Solaris, UNIX and Linux platforms in RAC and Non-Rac Environment.
• Installed and configured 10g Grid Control.
• Created Recovery Catalog database for RMAN backups.
• Cloned/Refreshed databases for testing/QA environments.
• Implemented Hot and cold backups, Restore and recovery through RMAN as well as manually.
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager) and AWR.
• Written UNIX Shell scripts to monitor tablespaces, listeners, disk space and database availability, compress/delete old archive logs.
• Experienced at SQL*Loader, expdp, impdp, exp, imp and other Oracle utilities.
• Experienced at administering database security by installing Ingrain, create users, grant/revoke roles, privileges to the users, creating and assigning profiles to the users
• Management of schemas, Tablespaces, objects partitioning the tables & indexes.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, TKProf utility.
• Responsible for applying Oracle Patches and CPU patches.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Aided developers in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Used Diagnostic & tuning packs along with AWR & ADDM reports
• Extensively wrote UNIX shell scripts, PL/SQL, Stored Procedures and Triggers.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues

Environment: Oracle 9i/10g,Sun Solaris 5.8 Sparc/, HP-UX11i AIX 5.1, 5.2, Linux, Windows 2003, SQL*Loader, RMAN, RAC, Toad, SQL Plus, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Shell scripting.

Confidential, MN

Oracle Database Administrator

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i, Oracle 10g databases.
• Migrated oracle databases from 9i to 10g version.
• Perform capacity planning required to create and maintain database environments.
• Created RMAN database backup and used OEM to manage the data, accounts and tuning.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).
• Created a number of database instances for development, testing and production.
• Maintained Development databases, Test databases and applied Patches
• Managed Oracle environment easily and consistently using Oracle Grid Control. Used Grid Control to manage Real Application Cluster.
• Running imports/export utilities, off-line backup, on-line backup various PL/SQL server Applications utilities, used File Transfer Protocol.
• Cloning of databases from production to Dev & QA Databases.
• Provided partitioning of the large tables to reduce the access time.
• Created and maintained databases: Creating table spaces, tables, indexes, views and materialized views.
• Monitored table space size, resizing table space, relocating data files for better disk I/O.
• Created users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Written complex queries and stored procedures using sql *plus and monitored databases using TOAD.
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.
• Experienced at SQL*Loader, expdp, impdp, exp, imp and other Oracle utilities Used ERWIN for Logical Data modeling and creating physical database designs.
• Replicated materialized views with fast refreshes for transfers of information.
• Used STATSPACK, AWR, ADDM, Explain Plan, TKPROF and other utilities for Performance monitoring and tuning.
• Troubleshooting Oracle errors, fine-tune database parameters, and analyze STATPACK reports.
• Configured disaster recovery site with physical standby database for high availability.
• 24*7 production support and on call rotation.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Involved in testing stage of two-node RAC implementation on SUSE Linux.
• Extensively wrote UNIX shell scripts, PL/SQL, Stored Procedures and Triggers.

Environment: Oracle 9i/10g, Toad, SQL Plus, SQL*Loader,, RMAN, RAC, Oracle Enterprise Manager (OEM) Grid Control, ERWIN, RMAN,LINUX,HP-UX11i, AIX 5.1, 5.2.

Confidential

Jr. Oracle DBA

Responsibilities:

• Upgrading, analysis and testing of the test and production database.
• Wrote various scripts to automate data loads, performance monitoring and backup.
• Database physical/logical layout design and procedures for production, development, test servers.
• Guided the Operations team in Creating, Cloning, trouble shooting Oracle Databases, Database Objects Designs, Partitioning, capacity planning of disk, table spaces, tables, backups and recovery.
• Helped the Production teams in Applications Performance Tuning and providing 24*7 Production Support.
• Performed capacity planning to create and maintain the database environments.
• Provided tuning support for SGA (shared pool, buffer pool and log buffer pool etc).
• Managed archived redo files, DB-links & Partitions, loading data for users by using SQL*loader.
• Replication of materialized views (snapshots) with fast refreshes for transfers of information.
• Set up Cron jobs to monitor file systems usage, archive logs, backup logs and cleaning up of these file systems periodically, and also RMAN Hot Backup Scripts.
• Tuned Oracle Initialization Parameters.
• Gathered Database Instance Statistics & generated reports using STATSPACK.
• Implemented Oracle New features like SPfile, Shared Severs, Locally managed Temporary Tablespace, UNDO Tablespace and RMAN.
• Created Partitions at O/S level, according to DB requirements.
• Installing Oracle 8i on Win'NT 4.0 Server and Setting up Oracle Clients.
• User Creations with allocation to appropriate tablespaces and quotas with necessary privileges and roles.
• Performed application SQL tuning using SQL Trace/Explain plan and TKPROF and database tuning for optimum performance.
• Wrote procedures, triggers and shell scripts.
• Cloning databases for development/testing environments.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Environment: Oracle 8i/9i, PL/SQL, Developer 2000, Windows NT 5.0/ UNIX