Objective

To be a lead player in System Design /Database Administration as Senior Oracle DBA.

Education

Post Graduate Diploma in Computer Science 
Master of Science (Mathematics) 
Bachelor of Science

Certifications

Oracle (11g, 10g, 9i, 8i) Certified Professional DBA

Skill Summary

RDBMS

Oracle (11g, 10g, 9i, 8i, 8.x.x, 7.x.x), SQL Server.

CASE Tools

ERWIN, Designer/2000, Silver Run.

Operating Environment

SUN Solaris, IBM AIX, SCO Unix, HP-UX, Linux Windows Servers

Front End Tools

Develeper/2000, Crystal Reports, Hyperion and Goldmine.

Languages

PL/SQL, C, C++, Unix Shell Scripting, Pro*C

Concepts

Internet Computing, Client/ Server architecture and data warehousing.

Hardware

IBM RS 6000, SUN (E5500, E6500), Compaq 1000, HP9000 and Dell Servers.

Other Tools

NetApp, Verities Netbackup, Legato Storage Manager, Legato Networker, Informatica, Discoverer, Grid Control, Oracle Express, Oracle Web DB, TOAD, RMAN,OEM, BCV, Spotlight, Embarcadero DBArtism, Embarcadero Change Manager, Datastage, SQL Expert, STATSPACK, AWR, ADDM, TKPROF, Trace Analyzer, Rational Tool etc.

Expertise

• 24x7 On Call Production support.
• Extensive experience in Database Designing and Modeling using Erwin, Designer/2000 and Silver Run tools.
• Installation and Configuring of Oracle (11g, 10g, 9i, 8i, 8.0.x, 7.x.x). This also includes migration/ upgrade databases from one release to the next release. Applying database patches to stay tune with latest available Database Patches.
• Database Architecture & Administration, Performance & Tuning, Backup & Recovery, I/O tuning, Space Management, Database Security Management, Managing row chaining/migration, Replication support, Oracle Names Server and SQL*Net configuration.
• Extensive knowledge of RMAN Backup and Recovery. Building new Backup and Recovery strategies testing and implementing for various circumstances.
• Excellent in database troubleshooting. Diagnosed/Resolved many long pending oracle bugs/issues under various circumstances.
• Extensive experience in building naming standards (conventions) for database Physical and Logical structures.
• Established and managed Standby/Data Guard (Physical and Logical) databases, Reporting databases, OEM and EBU. Managed Disaster Recovery (DR) using BCV, SRDF and Standby databases.
• Extensive experience of Building new RAC environments with ASM and its administration.
• Extensive knowledge of replication with streaming and SRDF technology.
• Installation and configuration of IAS 2000, 9iAS Portal, Oracle Web Application Server, Oracle Apache Server, Oracle Web DB.
• Writing various UNIX shell scripts in KSH, CSH, BSH for database Backups, Space Management, Performance Monitoring and daily Database health check.
• Programming in PL/SQL, C, C++, Pro*c.
• Administration experience on Sun Solaris, SCO UNIX, HP-UX, Linux, Windows Servers.
• Lead role in resolving production issues on high priority.
• Managed 7TB Data Warehouse and 1.2 TB of OLTP databases. Having experience of managing distributed databases while working with largest organization.

June 2009 –Dec 2009 Confidential 
Sr. Oracle DBA Temecula, CA-92591

Major Responsibilities Involved:

• 24/7 Production database support
• DBA Support for Siebel clinical databases, ODS and Data Warehouse.
• Database Capacity Planning and hardware sizing for existing as well as for new applications.
• Dedicated to revise backup and recovery standards and policies which include implementing incremental backups. Conducted and well documented real time recoveries based on the revised Recovery strategies.
• Upgraded 9i databases to 10g on UNIX as well as Windows servers.
• Designing and delivering new database environments for new applications.
• Resolved many critical performance issues on the production environments.
• Upgraded Grid control from Oracle 10g Rel 1 to 10g Rel 3 with underneath Oracle 11g database
• Deployed Grid Control agents on all Abbott Unix as well as Windows Servers.
• Worked in VMware environment.
• Patching various databases.
• Diagnosing Oracle bugs and thereafter coordinating with Oracle support to resolve them in timely manner.
• Database Performance Tuning, Storage Management, Database Monitoring, Security Management.

Environment:

• Oracle (11g, 10g, 9i, 8i) on Aix, Linux, HPUX and Windows Servers
• Grid Control, Spotlight, BCV, OEM, RMAN, TOAD and AWR, ADDM and Erwin data Modeler
• PL/SQL, UNIX Shell Scripting.

Front End tools: Siebel, Web Logic, Hyperion 
Database Size : 5 TB

Projects

Apr 2007 –Jun 2009 Confidential
Sr. Oracle DBA Torrance, CA-90501

Major Responsibilities Involved:

• 24/7 database support
• Lead role for Designing, implementing and maintaining EDW, Insurance DW and Data Mart databases.
• DBA support for Siebel application
• Capacity Planning and hardware sizing for EDW, Insurance DW and Data Mart.
• Worked with team of DBAs to build, test and implement backup and recovery policies at enterprise level.
• Lead role to built new DB and security standards for TFS and enforced them enterprise wide in coordination with Security team.
• Designing and delivering new database environments for new applications for TFS.
• Configured and managed RAC for high availability.
• Resolved many critical performance issues on the production environments.
• Writing various shell scripts to automate backups, DB health checks, DB growth and alerts thereof.
• Setting up DR solutions with BCV and SRDF in coordination with UNIX and storage teams.
• Established and Configured Grid control at the enterprise level.
• Upgraded many databases from Oracle9i to Oracle10g.
• Patching database whenever required.
• Diagnosing Oracle bugs and thereafter coordinating with Oracle support to resolve them in timely manner.
• Database Performance Tuning, De-fragmentation, Storage Management, Database Monitoring, Security Management. Automated to monitor and manage space in Tablespaces.
• Streamlined database deployment process.
• Active involvement in Management Decisions.

Environment:

• Oracle 10g,Oracle 9i on HPUX and Sun Solaris
• Erwin, Spotlight, Embarcedro DBArtism and Embarcedro Change Manager, BCV, OEM, RMAN, TOAD and StatsPack
• PL/SQL, C, C++, Unix Shell Scripting, Informatica power Center.
• Rational tool for DB versioning.

Front End tools: Siebel, Web Logic, Hyperion 
Database Size : 7 TB

Feb 2004 –Mar 2007 Confidential
Sr. Oracle DBA Orange, CA-92868 
Major Responsibilities Involved:

• Lead role for Designing OLTP database called ASAP for entire Loan processing system for Mortgage Company.
• Capacity Planning and hardware sizing of entire ASAP and its integrated Products.
• Established Non prod and Production environments for ASAP and all integrated environments.
• Time to time Installing & Configuring Oracle 10g, Oracle 9i environments. Applying latest available database patch sets as and when required to stay with latest version and/or to fix critical bugs.
• Established Data Guard for Reporting and Disaster Recovery.
• Configured RAC for high availability and its day to day Administration thereafter.
• 24X7 Production support for OLTP as well as Enterprise Data Warehouse (EDW).
• Resolved many critical performance issues on the production environment.
• Writing various shell scripts to automate backups, DB health checks, DB growth and alerts thereof.
• Planned backup and Recovery strategy for Enterprise wise and established Disaster recovery system (BCV) by co-coordinating with EMC and System Engineering team.
• Automating all RMAN and BCV backups for Non Prod and Production databases.
• Upgraded databases from Oracle9i to Oracle10G.
• Diagnosing Oracle bugs and thereafter coordinating with Oracle support to resolve them in timely manner.
• Database Performance Tuning, De-fragmentation, Storage Management, Database Monitoring, Security Management. Automated to monitor and manage space in Tablespaces.
• Setup Shareplex for real-time reporting database.
• Established production deployment process using Rational Tool to manage various application releases, versions and interim patches.
• Co-coordinating with all onsite Integrating teams to provide feedback on data elements to map with the downstream applications.
• Active involvement in Management Decisions.
• Weekly meetings with Offshore Architect team to sync up DB design requirements.
• Advance level Expertise in Shell Scripting.

Environment:

• Oracle (10g, 9i) on HPUX and Linux
• Erwin, Embarcedro DBArtism and Embarcedro Change Manager, BCV, OEM, RMAN, TOAD, StatsPack, Trace Analyzer, AWR, ADDM.
• PL/SQL, C, C++, Unix Shell Scripting, Informatica power Center.
• Rational tool for DB versioning.
• Front End tools: Web Logic, JBoss

Nov 2002 –Feb 2004 Confidential 
Sr. Oracle DBA Portland, Oregon 
Major Responsibilities involved:

• Data Warehouse and OLTP production database support.
• Regence wise ON-Call support for all Regence-Rewards databases.
• Database designing and Modeling in Erwin.
• Responsible for managing/ monitoring 15 Sub production OLTP and DW databases and also Primary DBA for three productions databases.
• Installing & Configuring Oracle 9i and Oracle 8i environments.
• Refreshing databases on routine bases using physical and export methods. Database Cloning using RMAN.
• Responsible for RMAN backups for production databases.
• Framing Recovery strategies and tests thereon. Recovered many databases using various options based on the various situations.
• Database Performance Tuning, De-fragmentation, Storage Management, Capacity Planning, Database Monitoring, Security Management, I/O Load Balancing and Tuning SQL batch queries. Regular scripts were run to monitor and manage space in Tablespaces.
• Framing, Testing and Implementing of Backup & Recovery strategies for Quality control, Production Databases. Backups are tested and implemented on all Rewards Databases. Recovery strategies were tested based on various occasions.
• Establishing/Configuring Databases for Development, Testing and Staging on Oracle 8I for various kinds of Regence applications.
• Establishing new schema environments in various databases depending upon application requirements.
• Managing BCV (Business Constant Volumes) from EMC for reporting/Clone databases.
• Re-Organizing tablespaces/ data files for I/O load balancing and Managing Row Chaining, re-building of Indexes for better performance.
• Moving application schemas from one database to another using Transportable Tablespaces technique.
• Multiplexing Redo logs and Control files.
• Table Partitioning, Global and Local/Bitmap index partitioning.
• Setting up Cron jobs for scheduling exports, RMAN and TSM backups for all development, testing, Quality Control, User Acceptance, Production databases. Scripts were written to monitor these backups.
• Managing different users, their responsibilities and creating security roles keeping in view business requirements and application usage layers.
• Applying latest available database patch sets after coordinating with management team and technical leads.
• Diagnosing Oracle bugs and thereafter coordinating with Oracle support to resolve them in timely manner.
• Writing UNIX shell scripts for backup, tablespace monitoring, files system monitoring, Database activities etc.
• Giving extensive regular as well as on-call support to development team.

Minor Responsibilities Involved:

• Day to day Support to production development team.
• Troubleshooting day-to-day database issues.
• Active involvement in management decisions.

Database Size: 4TB
Environment:

• Oracle 9i on AIX 5L and Oracle 8I on AIX 4.3
• Erwin, Embarcedro DBArtism and Embarcedro Change Manager, BCV, OEM, RMAN, TOAD, SQL Expert, BMC Petrol and StatsPack, TKPROF
• PL/SQL, C, C++, VB, Delphi, ASP, XML, UML, Coolgen, Interwoven, Unix Shell Scripting.
• Front End tools: Forms 6i.

Aug 2000 – Nov 2002 Confidential 
Senior Oracle DBA 360, 22nd ST, Oakland, CA-94612.
Major Responsibilities involved:

• On-Call Data warehouse support.
• 24X7 production support on OLTP databases.
• Installing & Configuring Oracle (9i, 8I, 8.0.x, 7.x.x).
• Database Security Management, Performance Tuning, De-fragmentation, Space management, Capacity planning, Database monitoring, I/O Load Balancing and tuning SQL batch queries. Regular scripts were run to monitor and manage space in Tablespaces.
• Framing, testing and implementing of Backup & Recovery strategies for production Database.
• Setting up of Standby/ Reporting databases.
• Taking Hot, Cold backups and routine Exports of dynamic tables.
• Configuring Databases for Development, Testing and Staging on Oracle 8i-Sun Solaris and Oracle 7.x-Windows NT platforms. This also includes routine refreshing of these databases from production. Database re-builds/Re-Indexing.
• Routine Syncing of production database with Logical model using Silver Run.
• Creation of primary database storage structure (table-space’s) and primary objects (tables, views, indexes, etc.).
• Re-Organizing Tablespaces and Managing Row Chaining, re-building of Indexes for better performance.
• Multiplexing Redo logs and Control files.
• Working with LOBS, table Partitioning, Index Organized tables, bit map indexes.
• Setting up of Virtual Private Database (VPD) for transaction engine.
• Standby and Reporting Databases were configured, tested and implemented.
• Database Migration from Oracle 7.x to Oracle 8i release 3 and migration from Oracle 8i release 2 to Oracle 8i release3.
• Setting up and management of Oracle Internet Application server.
• Installing and Setting up of Oracle Enterprise Manager.
• Extensive work on writing stored procedures and database Triggers.. Re-written some nightly batch jobs for data warehouse, which performed 50% better than the old way written scripts.
• Designing and implementing replication. This mainly used to synchronize ratings and sales databases with VWeb production data warehouse.
• Encrypting crucial database information (Credit cards, Merchant Identification Numbers and passwords of rating partners).
• Configuring and Managing Oracle 11i Applications Database.
• Managing different users, their responsibilities and roles on Oracle Applications.
• Working on testing, patching and resolving issues pertaining to 11i upgrade.
• Adding and managing concurrent programs, Printers in Oracle Applications.

Minor Responsibilities Involved:

• Encrypting crucial database information (Credit cards, Merchant Identification Numbers and passwords of rating partners).
• Uploading bulk data from external flat files using SQL*LOADER and MS Access.
• Day to day Support to Development team.
• Troubleshooting day-to-day database issues.

Database Size: 2TB
Environment:

• Oracle 9i /oracle 8i Sun Solaris, Oracle 7.x on Windows NT, Oracle Applications 11i on Sun Solaris and Windows NT.
• Erwin, Silver Run, DBArtism, Embarcedro DBArtism, OEM, RMAN, TOAD, SQL Expert, Spotlight and TKPROF.
• PL/SQL, VB, C, C++, XML, UML, Delphi, ASP, Interwoven, Developer/2000, Designer/2000
• Crystal Reports, Goldmine.