SUMMARY

• Seeking an opportunity for professional growth as Oracle DBA and increased responsibility towards handling projects in an organization wif a vision towards the future, wherein an atmosphere conducive to the sharing of ideas
• Learning, and growth as emerging technologies grow, can be utilized in fostering a more technically and technological knowledgeable tomorrow
• CRS Installing, upgrading, patching and troubleshooting
• CRS resource managements: Adding/Deleting/Relocating Instances, DB, listener, node apps, Services
• Managing OCR and Vote disk backup
• Clusterware management wif HACMP on AIX, Service Guard on HP - UX and Clusterware on Linux
• Configuring the Clusterware resources for resource failover: Instance / Service
• Working on RCA for Node evictions in different operating systemsReal Application Clusters
• Installing, configuring and managing RAC
• Configuring the raw disks for Oracle RAC in AIX, HP-UX and Linux
• ASM, ASMLib/oracleasm and SAN layout for RAC
• ASM clustered database on Linux HP-UX and AIX
• Installing and testing Oracle Transparent Application Failover (TAF)
• Monitoring and Managing RAC performance issue using AWR, NMON, RDA and OSWatcherMigrations
• Migrating database from 9.2.0.5 to 10.2.0.3 and 10.1.0.5 to 10.2.0.3 and across OS platforms using Gloden Gate 9.x/10.x software
• Configuring Data pump, Extract and Replicate Groups.
• Migrating Oracle Clusterware from 10.1 to 10.2, 10.1 to 11.1 and 10.2 to 11.2GRID
• Installing OEM agents and managing databases using GRID ControlTuning
• Proficiency in looking Database Design to resolve SQL performance for oltp, reporting and ETL
• Explain Plan, AWR / Statspack, ADDM recommendations, Hints, Parallel Query option
• Installation of Oracle 9i/10g Tuning Packs and Quest SQL optimizerManaging
• RDBMS: 9i/10g - Installing, upgrading, patching and troubleshooting
• Database creation: RAC database and standalone database
• Database Restore: Exp/Imp and RMAN for building standby database, Reporting Database, PITR
• Backup and Recovery: using Export/Import, RMAN wif MML VERITAS Netbackup, EMC Networker
• Disaster Recovery: Data Guard Setup and management physical and Logical standby database creation
• Storage management: LVM (RAW device) and ASM
• Character set conversion

TECHNICAL SKILLS

Database Systems: Oracle 9i, Oracle 10g and Oracle 11g

Clusterware: 10.1.0.5, 10.2.0.3, 10.2.0.4 and 11.1.0.7 wif/wifout OS clusters

Languages: Perl, Shell scripting, C, C++, SQL, PL/SQL

Operating Systems: HP/UX 11.23/11.31, Solaris 9, AIX 5.3/6.1, RHEL 3/4/5, Citrix 4.x, VMS

Platform: HP Rx 8640/7640/4640/3600 servers, Blade Servers bl860c/bl870c, Superdrome IBM p6 595, p6 590, p6 570, p6 520, IBM blade JS23 /JS43 HP Storage EVA and XP

Tool: TOAD, DB Artisan and Gloden Gate, BMC Patrol and Remedy

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

Sr Oracle DBA

Responsibilities:

• Install, Setup and configured 10g/11gRAC on Red Hat Linux, AIX using Automatic Storage Management
• Implemented a number of performance tuning modifications; both wif batch jobs and pl/sql procedures
• These modifications included diagnosing wait events, tuning IOTs, modifying Streams capture and apply parameters, designing custom “AQ flow control” utilities, and configuring batch jobs to run more efficiently wif Streams.
• Created a number of automated utilities, which provide information about, and resolve problems wif performance. Intelligence of these utilities is to address issues in terms of elapsed time, parsing, unnecessary sorts and a big picture of sql area
• Administration of all database objects, including tables wif blob, clusters, indexes, views packages and procedures troubleshoots wif regards to database problems
• Work wif shell scripts for RMAN backup and configuration of netbackup. Played a lead role for rman backups for client datacenter.
• Installation of Gloden gate Replication 10.4 for one-way replication to a Reporting Database and conversion of streams processes.
• Administration and applying patches to the gloden gate
• Involve in Query re-write process and updated main page inbox queries and utilize Oracle Tuning Advisor to recommend a new approach.
• Did extensive research for Outer Joins on ANSI standards for Oracle 9i, 10g and Sql Server DB. Demonstrated peer dba's to re-write wif my new approach and documented all improvements wif Explain Plan for OLD and NEW Query
• Creating and Maintaining Tables, Partitioning, Indexes, Materialized Views, Parallel Execution, Global Temporary Tables, Triggers, Stored procedures.
• Installed 10g GRID Server, OEM agents and managing databases using GRID Control

Environment: Oracle 11g/10g RAC, Oracle 9i, OEM, ASM, Web sphere, AIX, Solaris, Quest Toad, Gloden gate 10.4, windows 2008 server

Confidential - Bowling Green, KY

Sr Oracle DBA

Responsibilities:

• Worked as Lead Architect DBA and supported multiple applications including CernerMillinneum, Healthcare Basics and design, build of SurgiNet Application that benefits its major health partner for easy Surgical Workflow like Surgical Procedures - Surgical Scheduling - Perioperative Documentation - Inventory & Supply Chain - Intraoperative Documentation - Preference Cards - Postoperative Documentation - PowerChart - Surgical Reporting - Operational.
• Design the configuration of 10g extended RAC to support business continuity wif DR standards
• Install, Setup and configured extended 10gRAC on HP-UX wif Jumbo Frames across datacenters
• Created oracle database, tables, materialized view,objects wif storage parameters based on quarterly growth requirements of the system.
• Installation of Oracle 10g Grid and respective agents on databases, application servers. Predefine templates wif group option to monitor Prod, UAT and Dev Databases
• Responsible for rman backups and improvement to backup wif incremental back by adding block change tracking feature of Oracle 10g Rel-2
• Installation, configuration, applying patches of Gloden gate Replication 9 for bi-directional replication to master and regional databases of commonwealth state healthcare systems.
• Set up of ADDM and AWR report. Working wif developers to resolve performance issues and support production release
• 24x7 support as on call dba and during integration / patch update release

Environment: Oracle 10g RAC, Oracle 9i/8i, HP-UX11i, Gloden gate 9, Web logic 10g, J2EE, SQL Server 2005

Confidential San Jose, CA

Sr Oracle DBA

Responsibilities:

• Design the configuration of 10g RAC wif Data guard configuration wif DR concepts
• Install, Setup and configured 10gRAC on AIX wif raw files,
• Created oracle database, table spaces using LVs and support performance issues on instance, sql tune.
• Installation of Oracle 10g Grid and respective agents on databases, application servers.
• Responsible for rman backups and created rman scripts for full / incremental backup, Datapump scripts
• Set up of ADDM and AWR report. Working wif developers to resolve performance issues and support production release
• Responsible for database, schema refresh and roles, privileges, permissions
• Helped guide the team to develop test strategies for UAT, Unit, Volume and Stress testing. Identified the technical architecture to handle high volume transactions (Fill up 3 tier, Load balancing, etc) Environment migration strategy (Dev, QA, UAT, PROD).
• Tune complex sql to implement in Reporting System
• 24x7 support as on call dba and long hours to accomplish assign task

Environment: Oracle 10g RAC, Oracle 9i/8i, Grid, SAP 4.6c, Gloden gate 9, Remedy, HP-UX11i, Redhat Linux, windows server

Confidential, Phoenix, AZ

Oracle DBA

Responsibilities:

• Up gradation of database from 9.2.0.5 to 10.1.0.5 and from 9.2.0.5 to 10.2.0.3
• Modifying the database structures as necessary to accumulate application growth
• Responsible for Managing Database Files, schema objects, table spaces, objects and disk spaces.
• Done
• Installation of Oracle 10g Grid and respective agents on databases, application servers.
• Responsible for rman backups and created rman scripts for full / incremental backup, Datapump scripts
• Set up of ADDM and AWR report. Working wif developers to resolve performance issues and support production release
• Responsible for database, schema refresh and roles, privileges, permissions
• Helped guide the team to develop test strategies for UAT, Unit, Volume and Stress testing. Identified the technical architecture to handle high volume transactions (Fill up 3 tier, Load balancing, etc) Environment migration strategy (Dev, QA, UAT, PROD).
• Tune complex sql to implement in Reporting System
• 24x7 support as on call dba and long hours to accomplish assign task
• Modified various existing Pro*C reports and Pl/Sql code.
• Developed numerous forms, reports and utilities using Oracle forms 4.5, Pro*C

Environment: Oracle 10g RAC, Oracle 9i/8i, Grid, Gloden gate 9, Web logic 10g, Pro*c, windows 03

Confidential

Oracle DBA

Responsibilities:

• Refreshing of Databases
• RMAN Backup and Recovery procedures wif Lagato/VERITAS as MML
• Logical Backups (export/import) Tasks
• Applying Critical security patches
• Database Creation and Reorganization
• Creating Primary database structures altering according to the user requirements
• Modifying the database structures as necessary to accumulate application growth
• Responsible for Managing Database Files, schema objects, table spaces, objects and disk spaces.
• Maintenance of Development, Production, QA Test Databases
• RMAN backup and recovery procedures and conventional shell scripts
• Controlling and monitoring user access to database
• Refreshing of Databases
• RMAN Backup and Recovery procedures wif conventional shell scripts
• Logical Backups (export/import) Tasks
• Creating Primary database structures altering according to the user requirements
• Modifying the database structures as necessary to accumulate application growth
• Responsible for Managing Database Files, schema objects, table spaces, objects and disk spaces
• Maintenance of Development, Production, Reporting, QA Test Databases and Data guards
• Controlling and monitoring user access to database
• Monitoring the database growth on weekly basis archive mount points, table spaces
• Designed and implemented pre and post processing Pro*C programs for the PRISM ETL process.

Environment: AIX 5.x.