SUMMARY

• Over 10 years of experience as Oracle Data Base Administrator, providing 24/7 production support for Production, Test and Development (11g,10g/9i/8i) databases on Various Platforms.
• Experienced in working mission critical environments including DBA Team of 30 DBA’s, 6000 Databases in 1000+ servers and 1800+ Applications.
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g
• in UNIX/LINUX, Solaris and Windows environment.
• Experience in different environments like HP - UX, SUN SOLARIS, Linux and Windows.
• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR Support, Cloning (HOT/COLD/RMAN), Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Designed, modeled, normalized and implemented logical and physical models
• Proficient in server side programming like Procedures, Functions, Database Triggers, Packages using PL/SQL.
• Experience in maintenance of SQL Server in a VLDB environment & experience in troubleshooting and resolving database problems.
• Used tools like Power designer and Erwin to do reverse engineering tasks, Created DDL scripts to implement Data Modeling changes.
• Discussed on various denormalization, partitioning and indexing schemes for physical model.
• Participated in business requirement gathering sessions.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Used database technology data warehousing STAR schema, SQL-Loader, Oracle SQL-Plus.
• Experience with High Availability features (RAC/ DG/ ASM / Flashback / RMAN)
• Experienced in installing, upgrading and configuring enterprise manager servers
• In-depth noledge and experience in full life-cycle of Application deployment which includes Data architecture, Logical and physical database design, Data modeling using Erwin, Writing sql,pl/sql codes for application, testing teh application Following stage deployment and load testing and finally go live to production.
• Did scripting wrote stored procedures and packages per teh application requirement such as to load bulk data into tables. Also used PLSQL to write/created triggers on tables to fire at various incidents like insert, update, delete etc.
• Wrote Backup Scripts to automate teh processes like RMAN, and developed Scripts to automate datapump exports for specific schemas on which teh clients need a quick restore, and Developing SQL scripts for maintaining administration tasks.
• Experienced in using 11g, 10g features Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, 10g Grid Monitoring, Recycle Bin.
• Experienced in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
• Experience in managing Web based OLTP/DSS database systems with over 2 TB in size.
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment.
• Dealing with database security, auditing and SOX compliance.
• Experienced in loading data from flat files using SQL LOADER and EXTERNAL TABLES.
• Oracle Support processes for technical requests through Metalink.

TECHNICAL SKILLS

• Oracle 8i, 9i, 10g, 11g
• Real Application Clusters (RAC)
• Performance Tuning, Quest PA
• Distributed Databases
• Disaster Recovery Solutions
• Physical and Logical Standby Databases
• GOLDEN GATE
• Database Design
• Data Modeling (Erwin)
• Installation, upgrade, patches
• Cloning
• Perl/Shell Scripting
• ORACLE8i,9i,10g,11g,DB2,
• TOAD,SQL Developer and SQL Navigator
• Recovery Manager (RMAN)
• Cold and Hot backups
• VERITAS Netback up
• Data Pump and Flash-back Recovery
• Partitioning tables and Index on tables
• Data Replication (Oracle Streams)
• Oracle Enterprise Manager (OEM)
• Solaris, HPUX, Linux, AIX, Windows
• SQL Loader and External Tables
• Database Security and Auditing

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA.

ORACLE DBA

Environment: ORACLE 9i, 10g and 11g, UNIX, AIX, Exadata

RESPONSIBILITIES:

• Member of 24x7 support team on both production and development databases with on-call pager.
• Implemented multiple number of Oracle High Availability solution using Oracle 11g Physical Standby. Maintained dataguard and Trouble shoot issues.
• Implemented Fast Start Failover on Dataguard on Oracle 11.1 and 11.2 for teh purpose of Instant failover whenever teh Primary database is down for over a pre-determined time period, teh time period being decided upon teh Client individual limit.
• Highly involved in Implementation of Exadata servers.
• Worked on Exadata servers and many migration works.
• Implemented oracle RAC server for 2 node and 3 node in Dataguard environment.
• Did capacity planning and Created new 4 node clusters on AIX boxes and moved over few crucial existing databases to cater better performance and auditing too.
• Implemented high level Auditing on databases for security reasons on Hospital records.
• Enabled alerting on specific actions performed by both DBA and Users.
• Created Procedures and PLSQL blocks to enable auditing on, teh audit output of Users is stored in database and teh output of Sys Users is stored infiles in teh file system as teh Hospital Data was critical and teh need was to setup Audit and sub sequential alerts sent to teh concerned teams for monitoring purposes.
• As these various audit trails quickly grow out of control when database activity increases teh two challenges of maintaining file system size and table size were addressedto maintain size limits.
• Created teh relevant procedures, plsql blocks that enable teh Audit and Password verification across 10g and 11g platforms, and teh scripts needed to purge teh data.
• Arcsight Connectors and Loggers were used to retrieve teh data and teh Email Alerts were individually sent to teh required recipients.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Developed shell scripts to automate teh processes and to proactively monitor teh database.
• Creating table spaces, tables, and users for custom applications.
• Performed multiple Upgrades for teh database versions at 10g for which oracle support is no longer provided.
• Minimize teh risk factor and centralize teh administration work.
• Provide clients with Oracle database administration services, specializing in performance tuning and database process automation.
• Refreshing database using export/import schema level and Full databases.
• Perform other regular DBA activities including space management and performance monitoring.
• Maintenance of databases including Oracle patching,backup and restore of database and datafiles.

Confidential, Omaha, NE.

ORACLE DBA

Environment: ORACLE 9i,10g and 11g, UNIX, SUN SOLARIS

RESPONSIBILITIES:

• Install 11g, 10g RAC on Linux, AIX, Solaris in two, three and Four Node environments,ASM as storage.
• Worked on backups using cold, hot and backups and also tested various recovery procedures.
• RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.
• Setup different environments like test and dev using database Cloning.
• Review Code for Coding standards and from Performance, reusability, modularity, etc.
• Responsible for rollbacks in case of issues in Production
• Installation of 9i, 10g and 11g databases for Testing, Development and Production.
• Experienced in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed
• description of logical entities and physical tables.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• strong Conceptual and Logical Data Modeling skills
• Document teh plan, execution and process phases and demonstrate teh client for approvals.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required. Write scripts to monitor tablespace and extent growth.
• Responsible for smooth rollout and keeping a check for teh first cycle of Production runs
• Discussed on various denormalization, partitioning and indexing schemes for physical model.
• Worked on Normalization and Denormalization techniques.
• Good Documentation skills and noledge sharing among Team, conducted data modeling review sessions for different user groups
• Configured and used Oracle FlashBack for recovery of objects in teh database.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Applying patches using OPATCH and patch sets using OUI.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Maintain schemas accordingly and partition tables for different scenarios.

Confidential, Memphis, TN.

ORACLE DBA

Environment: ORACLE 9i,10g and 11g, UNIX, SUN SOLARIS

RESPONSIBILITIES:

• Worked on Oracle Golden Gate installation, configuration, troubleshooting GG issues,Dealing issues out of Replication, Reverse Replication and migrate errors.
• Experienced in Implementing Oracle High Availability Solution 10g RAC with ASM and Raw Devices and 10g CRS. Experienced in configuring & Managing teh ASM
• Worked on Relational and Dimensional Data modeling for creating
• Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN
• Trained on building Conceptual, Logical and Physical data model.
• Dropped and recreated all teh indexes for teh foreign keys with new column list.
• Created before update trigger for all teh tables to set teh update date, update user columns.
• Defined relationships and cardinalities among entities.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
• Involved in Designing Project specifications.
• Installed and configured enterprise manager servers.
• Experience of using Oracle Enterprise(OEM), Grid Control, and Data Guard.
• Using STATSPACK to monitor health of database.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Discuss with users in Designing relevant tables, table spaces, and users for custom applications,
• Establish more and proper objects names to make it user friendly environment for them.
• Assist with database capacity palaning with Design and Build team.
• Responsible for decisions in setting exact privileges and managing user accounts.
• Defining and Implementation of Backup and Recovery strategies.
• Planned and implemented Disaster Recovery solutions using Oracle 10g Data Guard (Physical and Logical Standby).
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Regular check on teh AWR reports instnace wise to improve performance.
• Performed database cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Troubleshoot SQL server database performance issues and tune database objects.
• Experience in maintenance of SQL Server in a VLDB environment & experience in troubleshooting and resolving database problems.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.

Confidential, Jacksonville, FL

ORACLE DBA (Performance Team)

Environment: ORACLE 9i,10g and 11g, LINUX, SUN SOLARIS 9, IBM AIX,NT

RESPONSIBILITIES:.

• Primary DBA for 10 production and many plus development and testing databases with database ranging from 100GB to 1TB
• Member of Performance team which gets escalations from Off Shore and Primary DBA’s
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Installation and Maintenance of Data Guard/Standby database.
• Configured and used Oracle FlashBack for recovery of objects in teh database.
• Upgradation of Database from 9i to 10g and applying patches whenever required.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Using teh tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Defined relationships and cardinalities among entities
• Applying critical patch updates (CPU) released by oracle quarterly.
• Discussed on various denormalization, partitioning and indexing schemes for physical model.
• Installed and Implemented RMAN Backup & Recovery procedures.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Configuration of Oracle 10g R2 Grid OEM to monitor database and report on events as defined by teh DBA group.
• Used Erwin Tool to design Physical/Logical design for Database and schemas.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Applying patches using OPATCH and patch sets using OUI
• Capacity Planning & Benchmarking using analysis from STATSPACK reports.

Confidential, Charlotte, NC

ORACLE DBA

Environment: ORACLE 10g RAC, 9i, RHEL 4.x, SUN SOLARIS 10

RESPONSIBILITIES:

• Installing 9i and 10g, 11g databases on LINUX and SOLARIS 10.
• Performed database Cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgradation and Migration of Database from 9i to 10g and applying patches whenever required.
• Maintaining schemas and partitioning tables.
• Worked in cross platform migrations from Windows to Linux, Solaris to Linux
• Worked on database upgrades 8i to 9i and 9i to 10g R2.
• Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Using STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Configuration of Oracle 10g R2 Grid OEM to monitor database and report on events as defined by teh DBA group.
• Creating and drop users, granting and revoking permissions to users/roles as and when required.
• Advanced replication using Oracle Streams.
• Developed and executed processes supporting SOX audits of Oracle Applications environments.
• Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.
• Importing data from flat files into database using SQL loader and External Tables.
• Using teh tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Developed teh strategy for external data load in to Data Warehouse
• Moved nearly 1 gigabyte of data per day from teh source system to teh data warehouse.
• Created custom extraction system that populated a data warehouse star schema.

Confidential, Dallas, Texas

ORACLE DBA

Environment: ORACLE 10g, 9i, RHEL 4.x, SUN SOLARIS 9, HP-UX 11

Responsibilities:

• Involved in 24x7 support for both production and development databases with on-call pager
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Performed database Cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgradation and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Complete system designing, data model conceptual/physical defining tables, relationship between tables, general domains, and screen design/functionality behind teh screen.
• Worked on Entity Relationship Diagram in Models. Reverse and Forward Engineering on Database Models.
• Experienced in dealing with Web based OLTP systems.
• Involved in Database Designing, Logical, Relational Database Diagram, Integrity Constraints and Finally Physical Data Modeling and Normalization.
• Created components detailed design specifications using UML (class, activity, sequence and collaboration diagrams).
• Designed Data models using Erwin tool
• Performed DB2 installation and configuration.
• Created database reports on DB2 database.
• Create and drop users, granting and revoking permissions to users/roles as and when required.
• Deploying 10g Grid Agents to target servers.
• Using STATSPACK to check health of database.
• Performance tuning of Oracle Database Objects by fixing row chaining.
• Applying critical patch updates released by oracle quarterly.
• Advanced replication using Oracle Streams.
• Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.
• Managed teh PHYSICAL STANDBY including Switchover and Failover scenarios.

Confidential, Iselin, NJ

ORACLE DBA

Environment: ORACLE 10g, 9i and 8i, LINUX, SUN SOLARIS 9, IBM AIX

RESPONSIBILITIES:

• Involved in 24x7 supports for both production and development databases with on-call pager.
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Installation and Maintenance of Data Guard/Standby database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgradation and Migration of Database from 9i to 10g and applying patches whenever required.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Using teh tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Used SQLTRACE, TRACE ANALYZER,DBMS APIS to troubleshoot performance issues
• Used ORADEBUG, 10046 and 10053 Trace for troubleshooting teh performance issues
• Installed and Implemented Backup & Recovery procedures.
• Automation of backup by creating scripts.
• Tested different recovery scenarios.
• Experienced in using 10g feature Flashback option.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Applying patches using OPATCH and patch sets using OUI
• Capacity Planning & Benchmarking using analysis from STATSPACK reports.

Confidential, Philadelphia, PA

ORACLE DBA

Environment: ORACLE 9i and 8i, LINUX, SUN SOLARIS 9, IBM AIX

RESPONSIBILITIES:

• Involved in 24x7 supports for both production and development databases with on-call pager.
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Performed database Cloning to setup test and development database.
• Installation and Maintenance of Oracle database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading Database from 8i to 9i and applying patches whenever required.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Using STATSPACK to monitor health of database.
• Used ORADEBUG, 10046 and 10053 Trace for troubleshooting teh performance issues
• Installed and Implemented Backup & Recovery procedures.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Write SQL scripts to monitor tablespace and extent growth.
• Applying patches using OPATCH and patch sets using OUI
• Capacity Planning & Benchmarking using analysis from STATSPACK reports.

Confidential, Fort Worth, TX

ORACLE DBA

Environment: ORACLE 9i and 8i, LINUX, SUN SOLARIS 9

RESPONSIBILITIES:

• Installing 9i for TEST and Development.
• Developing shell script to automate teh processes.
• Create table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Installed and Implemented Backup & Recovery procedures.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Write SQL scripts to monitor tablespace and extent growth.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Upgrading and migrating teh databases.
• Applying standalone RDBMS patches.
• Capacity Planning & Benchmarking.
• Database export/import using exp and imp utilities.
• Data loads using sqlloader utilities.

Confidential

ORACLE DBA

Environment: Oracle 8i, UNIX, Windows NT/2000 and Linux.

RESPONSIBILITIES:

• Installation of Oracle on UNIX and Windows.
• Performed installations of oracle 8i and Sql server databases.
• Writing Oracle scripts for teh SQL and PL/SQL requirements for various applications.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Optimization of teh SQL queries to meet teh performance requirements.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Creating users, granting required roles and allocation of table space quotas.
• Installation and using Oracle Enterprise Manager for some of teh maintenance tasks.
• Worked with DW team for loading data to warehouse databases.
• Performed Table space Management and Rollback table space Management.
• Transaction Management and Security Management.
• De-fragmentation of database objects