Professional Summary:

• Experienced with over 6 years in Oracle Database Administration in very large Production, test and development environments in a diversified domains, on various versions of UNIX/LINUX and Windows operating systems.
• Oracle DBA proficiency in installation, upgrading, patching, administration of multiple Oracle Enterprise Edition 9i, 10g, 11g databases on RHEL, Sun Solaris, HP-UX, IBM-AIX and Windows.
• Good experience in installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• I've involved in migration of Database and Up gradation from Oracle 10g to 11g.
• Exceptional Knowledge of various states of Software Development Life Cycle SDLC i.e. System Analysis, Applications Design, Development, Integration System Testing Support of Oracle 8i,9i, 10g, 11g in Production, Staging, and Development environments.
• Developed backup and recovery policy and used new features/technologies to optimize system maintenance and extensive knowledge on Partitions and Oracle Streams.
• Proficient in implementation, maintenance of Database Security Users, Roles, Privileges , space management of logical structures i.e. table spaces, rollback segments and auditing of users.
• Proficient in using Oracle utilities like export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Expert in effective troubleshooting of production, development database environments on daily basis with Proactive performance monitoring for better performance in applications database using AWR and Oracle Enterprise Manager OEM .
• Performed backup and recoveries on OLTP database like IBM Informix 7.1, Oracle database.
• Maintaining centralized data from OLTP databases like Informix, Sybase as well as IBM DB2.
• Experienced in performance tuning of various aspects of the database by using oracle utilities like TKPROF, EXPLAIN PLAN, STATS PACK, SQL TRACE, TOAD and Automatic Database Diagnostic Monitor ADDM .
• Expert in Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements
• Data modeling knowledge designing logical, physical and conceptual database schemas.
• Strong ability to script the database models into SQL to create the database objects including tables, views, triggers, indexes, foreign keys and sequence counters.
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN and Knowledge of storage technologies SAN, NAS.
• Ability to restore and recover databases from file system backup in order to bring to the original state as per the business and user requirement.
• Installing and monitoring database security tools like TIVOLI, BMC PATROL. Escalating the issues as per the severity of database and resolving it immediately without any delay.
• Applying latest versions or releases of database patches to minimize the bug issues which caused by the previous versions of patches.

Technical Skills:

Databases : Oracle 11g R2 RAC, 10gR2RAC, 9i

Operating Systems : HP-UX, Sun Solaris, AIX, Linux and Windows, IBM DB2, Informix on IBM.

Languages : SQL, PL/SQL, Java, C, UNIX Shell Scripting.

Tools : RMAN, OEM, SQL Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB Artisan 4.0.

Tuning Tools : TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools : Informatica 5.1, Data pump, Share Plex.

Data Modeling : Erwin, DB Artisan, Rational Rose, SOX

Professional Experience:

Confidential

Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administrations.
• Installed, configured and maintained Oracle Databases and Applications.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Experience using Export/Import and Data pump for migration of databases.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Table Partitioning, Creating Locally managed Tablespaces.
• Applying patches for both Server side and Client side.
• Oracle 11g/10g RAC installation, configuration and support.
• Involved in Upgrading of the oracle databases from 9i to 10g, 9i, 10g to 11g.
• Migrating Oracle databases from windows to Linux
• Refreshing/cloning databases using RMAN
• Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g.
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM
• Experienced in working with Oracle support to resolve the issues quickly as per the business require.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM Grid Control.
• Installed, configured and maintained Oracle Databases and Applications.
• Installing and configuring ASM.
• Using expdp/impdp for export and import
• Working with Oracle 9i and 10g partitioned tables.
• Standby Database Data Guard setup and configuration.
• Creating and maintaining Materialized Views for replication.
• Cloning Oracle databases from Production to Development, Test
• Refreshing/cloning databases using RMAN.
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Metalink
• Working alongside programmers and contributing to the development process
• Defining and Setting backup and recovery procedures.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Partitioning large objects to improve the performance and manageability.
• Proactive monitoring of Oracle Database Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.

Environment : Oracle 11g/10g/9i/8i, OEM Grid Control , Oracle Data guard, ASM, RAC, RMAN, Datapump, SQL Loader, Import Export, AIX, HP-UX, and Red Hat.

Confidential

Oracle DBA

Responsibilities:

• Database Administration support 24x7 for large mission critical production databases
• Database Security Management involving managing Users, Roles and Privileges Expert in troubleshooting problems. Providing necessary privileges or roles to users as per the requirement.
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Performed Data guard switch over to check the standby database is in SYNC with production as per the business requirement and also operated standby database using Data Guard broker.
• Configured Oracle wallet manager on windows file management system or in the user profile area of the Microsoft Windows system registry storing for better access control and easier management.
• Troubleshooting the database performance using Oracle Enterprise Manager, generating the monthly reports on the database to see how much load has been applied on database constantly.
• Working with High transaction databases OLAP using Golden Gate to replicate the data to source.
• Upgraded production databases from 10g to 11g without downtime using Golden Gate replication.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Good knowledge on troubleshooting Golden Gate whenever Extract or Replicate process get abended.
• Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements.
• Space management of logical structures i.e. table spaces, rollback segments and auditing of users
• Participated in doing schema refresh like taking export of one schema and importing it into another schema using different ways of utility tools like REMAP SCHEMA, REMAP TABLESPACE.
• Installing and configuration of Golden Gate Veridata on production, development and testing.
• Analyzing SOX application for validating business inventory for critical ones and risk assessment.
• Responsible for automation of startup, shutdown of database without the involvement of DBA to start the database manually. Effective knowledge of working with System Administrator's.
• Administration, Optimization, Monitoring, Tuning of Oracle Databases.
• Knowledge of storage technologies like SAN, NAS whenever we have a disk outage or mount point issues due to database growth. Raising a request to SAN or NAS to request for additional storage.
• Table Space management, Database Refreshes, and User Administration. Adding additional data file to table space whenever there is required and also involved in shrinking of table space size.
• Involved in scheduling file system backup using Net backup or FDR/Upstream.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM Grid Control.
• Used Data Modeling tools for data message in order to show the output results in different formats using Erwin, Informatica and some other ETL tools.
• Effective implementation of Rational Rose to design schemas and data modeling for business require.
• Ability to restore and recover databases from file system backup in order to bring it to the original state as per the business or user requirement. I have done Point in time Recovery using RMAN.
• Installing and monitoring database using security tools like TIVOLI, BMC PATROL. Escalating the issues as per the severity of database and resolving it immediately without any delay.
• Experienced in working with Oracle support to resolve the issues quickly as per the business require.
• Applying latest versions of database patches to minimize the bug issues which caused by the previous versions of patches.

Environments: Oracle 11g RAC, 10g RAC/9i, IBM AIX, HP-UX , Red Hat Linux, Sun Solaris, Windows XP, SQL Plus, SQL Loader, SQL Developer, Import/Export, Data Pump, TOAD, Oracle Data Guard.

Confidential

Oracle DBA

Responsibilities:

• Database Administration support 24x7 for large mission critical production databases
• Oracle 10g 11g Databases maintenance and troubleshooting.
• Responsible for Creation and maintenance tablespace, datafiles, redo log files and renaming /relocating of data files on servers based on OFA model.
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Upgraded from 9i to 10g, 10g to 11g database and applied critical patches update CPU for latest versions. Good experience in managing Very Large OLTP and Data ware housing databases.
• Good knowledge on replication tools like Golden Gate to extract and replicate Databases.
• Involved in setting up, maintenance of Standby Database with Data Guard for Disaster recovery.
• Working knowledge on NETAPP storage from disk to tape to copy the RMAN Backup Data and mirroring of databases BCV Split backup from one database to another using NETAPP utility.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM
• Designed conceptual schemas using Rational Rose like Entities, Relationships, and Integrity rules.
• Responsible for implementing backup procedures using RMAN. Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database. Implemented strong backup and recovery strategies and monitored backups.
• SOX verification of spreadsheet formulas and macros to identify mechanical and logic errors.
• Extensive Conceptual knowledge on designing Data Modeling like Data Models, Conceptual, Logical, Physical Schemes, Data Modeling Process, Modeling Methodologies, Entity Relationship Diagrams, Generic Data modeling, Semantic Data modeling.
• A batch performance monitor collects application performance data, collates it and produces reports that illustrate application efficiency
• For security administration used oracle Wallet Manager to manage public key security credentials on Oracle clients and servers.
• The GUI is a multi-platform Java client that contains a variety of wizards suitable for novice users.
• Pre-Build checks on UNIX box whether number of LUNS from SAN team allocated perfectly.
• Working with SAN people for additional storage on disk/mount point if having any space issue.
• Maintaining centralized data from OLTP databases like Informix, Sybase as well as IBM DB2.
• Performed backup and recoveries on OLTP database like IBM Informix 7.1, Oracle database.
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• A capacity planning tool outlines how a future application will function and determines whether or not a company will have to upgrade its CPU or add disk storage to keep users happy.

• PL/SQL, Stored Procedures, Packages, Functions, Database Triggers and Shell scripting.

Environments: Oracle 9i, 10g RAC 11g RAC, OEM Grid Control, Sun Solaris, HP-UX, RHEL, Windows 2000/XP, RMAN, TOAD, RATIONAL ROSE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM.

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i 10gRAC database and Performed DBA tasks
• Supporting large mission critical databases in a 24x7 environment.
• Migration of database from Oracle 9i to Oracle 10g.
• Working with database Monitoring and Tuning. Lead efforts to develop and improve procedures for automating monitoring.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and korn shells, Unix shell Scripting.
• Cloning of databases from production to development and test databases
• Used RMAN for Backup Recovery.
• Performance Tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components
• Reviewing performance stats and recommended changes for tuning SQL queries, database, server, and storage configurations.
• Responsible for Upgrading the Database from 9i to 10g, 9i, 10g to 11g.
• Responsible for SQL query tuning, optimization. Performance tuning using tools such as SQLTRACE, TKPROOF, STATSPACK, Explain Plan, AWR and ADDM.
• Automatic Health Monitoring, security, SQL Performance Analyzer.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches and security patches downloaded from Oracle Metalink.
• Working and good experience in diamond relational tables of SQL server 2005 management studio.
• Participating in periodic backup audits, including test restores ensuring all databases and associated logs are being backed-up
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.
• Oracle utilities i.e. export/import Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Submitting Tickets using remedy communicating with other groups like UNIX, Configuration Team.
• Coordinate interaction with vendors in critical database problem situations.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Actively involved in Backup Management of Disaster Crash recovery supporting 24-7 assurance.

Environment: Oracle 10g RAC/9i, Sun Solaris, AIX, PL/SQL, Oracle Streams, DATAGUARD, Import Export, TOAD, OLTP, LDAP, RMAN, Remedy, Shell Script.