Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

Role: Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support
• Installation, Configuration and Administration of Oracle 11g RAC and Oracle 10g RAC.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database Active Data Guard , Replication.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Migration of all Oracle 9i/10g databases/clients to 11g.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Upgrade and Migration of Database's from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Installation and configuration of Golden Gate
• Implemented backup and recovery procedures Cold/Hot backups, RMAN Incremental backups Import/Export
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR ,ASM ,Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic tuning packs along with AWR ADDM reports.
• Written Shell scripts to Monitor activates like availability of database listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Partitioning of large tables for better performance and manageability..
• Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.
• Logical Physical Database Design
• Capacity Planning and Benchmarking
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, ADDM.
• Applying Quarterly patches and Version change patch bundles.
• Created users, roles and granted privileges according to the business requirements.
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management.
• Provided 24x7support for Production, Development, and test database.

Environment : Oracle 9i/10g RAC/11g RAC, SQL, PL/SQL, SQL PLUS, EXPDP/IMPDP, OEM, RMAN, HP-UX, IBM-AIX, Sun Solaris, RedHat Linux, Windows, Data guard, ERWIN.

Confidential

Role: Oracle DBA

Responsibilities:

• Implemented and configured 10g RAC and 11g RAC.
• Migrated NON ASM databases to ASM databases.
• Maintained Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Created Streams environment in unidirectional and table level for replication of data.
• Configured and used Oracle FlashBack for minor recovery of objects in the database.
• Installed and configured OEM Grid control and intensively used Diagnostic tuning packs along with AWR ADDM reports.
• Implemented Oracle Backup and recovery procedures using RMAN Import/Export.
• Configured RMAN backups for TSM and Commvault and also resolved backup issues.
• Restoring Database's from Backups on testing environments.
• Effectively uses database replication, security and availability solutions.
• Upgrade and Migration of Database's from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Installation and configuration of Golden Gate
• Replication using Golden Gate
• Applying Quarterly patches and CPU, PSU, One-Off Patches to update Oracle version and to fix the bugs using Opatch utility.
• Effectively uses platform-specific, as well as enterprise, monitoring tools to provide fault and pre-fault performance notifications.
• Provides platform-specific performance tuning, installation and configuration.
• Monitors and manages back-up and recovery as well as capacity planning for all Database platforms
• Works with management, peers and vendors to design and implement hardware/software configurations, logical models, operational management models and business continuity plans for systems under management.
• Works with management, peers and vendors to provide ongoing monitoring, performance tuning, implementation and fault root cause analysis.
• Creates design, troubleshooting and operational documentation for all systems under management.
• Authors and peer-reviews knowledgebase articles documenting fault root causes and their respective resolutions.
• Provides and receives cross-discipline training in order to ensure maximum availability of systems under management.
• Carries and responds to off-hours communications device in order to provide 24x7 support.
• Actively pursues opportunities, as an individual and as part of a group, to improve knowledge, tools and processes.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE,TKPROF, ASH, AWR, ADDM
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Performed database Point in Time Recovery and Table Space Point in Time Recovery using Transportable Tablespaces.

Environment : Oracle 10g/11g, SQL,PL/SQL, SQL PLUS, EXPDP/IMPDP, OEM, RMAN, Cygwin X, Linux , Windows, Data guard , Toad 10.1 , Aqua Data Studio 4.7 ,SQL Server Management Studio.

Confidential

Role: Oracle DBA

Responsibilities :

• Successfully Maintained RAC environments of 3Nodes with ASM file system using cluster ware.
• Involved in Design and implementation of oracle 10g Data Guard both physical/logical standby databases for high availability and disaster recovery.
• Implemented Oracle streams for replication and configured tablespaces for streams administration at database and table level.
• Configuring and using Oracle Log miner and Oracle Flash Back for recovery of the objects.
• Upgrade and Migration of Database's from 10.2.0.4 to 11.1.0.6 and applying patches whenever required.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control
• Monitored Production Database Using O.E.M and Toad DBA Monitor tools.
• Recovering the database from any kind of crash with the minimum data loss.
• Database Recovery both complete and incomplete from different types of failure.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Responsible for maintaining Every Day Backups and also to maintain ASM and Disk Space.
• Performed Database Point in Time Recovery and Table Space Point in Time Recovery with the use of Transportable Table space.
• Applying patches quarterly PSU,CPU,ONE-OFF for security and to fix the bugs.
• Responsible for supporting the Oracle databases and ensuring their Performance, Availability and Security.
• Planning the size of the Database, Creation of Database and location of initial data files, redo log files and multiplexing them, editing database initialization parameter file whenever required.
• Implementation and release of Database changes as submitted by the development team.
• Create Production Support databases for testing every Week for developers using Data pump Impdp from Production Backups.
• Maintaining all database objects including Schemas, Tables, Indexes, Triggers, Sequences, Primary and Foreign keys, Views, and all Constraints.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, ADDM,AWR,EXPLAINPLAN, SQLTRACE and TKPROF.
• Maintaining Erwin for all the new database changes Implemented during each release.
• Responsible for the Database Builds on Test, Development databases and Monitor Production database during builds.
• Worked with cross-functional team of marketing team, engineers, and production planners to understand business process and develop functional specifications.
• Written Shell scripts to Monitor activates like availability of Database Listeners, Space utilization, Gathering statistic for the cost base optimizer, Index rebuilding .
• Good exposure to oracle technologies like AWR, ASM, Flashback and Data Pump Import/Export.
• Worked on External tables for Loading Flat files into Database and also created flat files of existing tables for loading into different environment.
• Provided 24x7support for Production, Development, and test database.

Environment : Oracle 11g/10g, SQL, PL/SQL, SQL PLUS, EXPDP/IMPDP, OEM, Toad 9.0, RMAN,DBCA, Erwin,Linux, Windows.

Confidential

Role: Oracle DBA

Responsibilities:-

• Migration of all Oracle 9i databases/clients to 10g.
• Applying Quarterly patches and Version change patch bundles.
• Implemented backup and recovery procedures using RMAN Import/Export.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE,TKPROF, AWR, ADDM.
• Installation and supporting RAC.
• Worked on Instance Tuning, Memory Tuning and SQL Tuning.
• Written Shell scripts to Monitor activities like availability of database listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding.
• Good exposure to oracle technologies like AWR ,ASM ,Flashback and data pump import/export
• Installed and configured OEM Grid control and intensively used Diagnostic tuning packs along with AWR ADDM reports.
• Written Shell scripts to Monitor activates like availability of database listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Building and Configuring RMAN with Netback up, Legato Backup HP Data Protector.
• Successfully providing 24x7support for production, development, and test database.
• As part of a pilot project to transfer the database administrative activity to overseas, I have documented and coordinated with the people overseas
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, ADDM.
• Created users, roles and granted privileges according to the business requirements.
• Provided 24x7support for Production, Development, and test database.

Environment : Oracle 9i/10g, OEM Grid Control, RMAN, RAC, Imp/Exp, Data Guard, SQL, PL/SQL, SQL PLUS, Perl, Shell Scripting, HP-UX PA RISC

Confidential

Role: Oracle DBA

Responsibilities:-

• Responsible for installing Oracle Database, setup Instance Creation, Database Space Management.
• Installed patches and upgrades for various bugs.
• Implemented traditional Hot and Cold Backups Recovery.
• Distributed the data in different Tablespaces by table partitioning to get the high performance and I/O balancing.
• Performance tuning of Database, SQL queries.
• Performed Export/Import and full database scanning.
• Monitoring and resizing Tablespace, relocating data files for better disk I/O.
• Maintained standby databases for production and staging environments.
• Created roles and users and Managed there privileges.
• Responsible for monitoring resizing Oracle database objects Tablespaces, Tables, Indexes etc.
• Responsible for managing Redo logs, Archive logs, Data files.
• Troubleshooting of the database.
• Documented the problems and solution in the failures of production databases.
• Responsible for extensive use of SQL, PL/SQL, SQL PLUS

Environment : Oracle 10g/9i/8.x, SQL, PL/SQL, SQL PLUS, SQL Loader, Import/Export, OEM, RMAN,Crystal Reports, Developer/2000, Erwin, Shell Scripting, Solaris, HP-Unix, Windows 2000.