SUMMARY

• 7 Years of experience in Oracle database administration managing large size databases. Production support DBA for Oracle Real Application cluster databases with Oracle Data Guard and Recovery Manager on Solaris, Linux,HP - U/X and Windows environments.
• Involved in upgrading databases from Oracle 9i/10g to Oracle 11g Release 2 by using Golden gate.
• Involved in upgrading more than 50 databases from Oracle 9i to Oracle 10g Release 2.
• Experience in handling performance issues
• Installed, configured oracle 10g RAC on solaris and linux platforms.
• Configured additional nodes to existing RAC environment.
• Experience on 10g oracle enterprise manager (OEM) and oracle grid control.
• Configured oracle physical and logical standby databases in oracle 10g dataguard Implemented switchover,failover and switchback in dataguard setup.
• Experience on Oracle10g ASM Automatic storage management.
• Restored and recovered lot of databases by using both Rman and Manual backup methods.
• Experience on oracle Database Re-organization and oracle partitioning
• Expertise in cloning database for test and training purposes using Oracle Recovery Manager.
• Experienced with UNIX Shell scripting.
• Cloning/Refreshing databases from production for development, testing purpose
• Installed various Oracle bug fix patches on Sun Solaris and HP UX environments.
• Installed, administered and maintained Oracle software on Sun Solaris and Linux environments.
• Hands on experience with Change, Release, Incident and Problem management processes.
• Experience in working with ticketing tools Manage Now, Maximo & service desk etc
• Experienced with Oracle backup and recovery using both manual and RMAN.
• Experience in working with Oracle product support using metalink to resolve critical issues.
• Oracle SQL*Net Network Configuration, LDAP configuration with OID
• Provided 24x7 Oncall support for production databases in RAC and Non-RAC environment.

TECHNICAL SKILLS

Databases: Oracle11g, Oracle10g/10g RAC, Oracle9i

Operating systems: Sun Solaris, HP-UX, AIX and Windows.

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: Oracle Enterprise Manager, grid control, ASM, Golden Gate, Oracle Data Guard, RMAN Oracle Recovery Manager, LDAP, OID

PROFESSIONAL EXPERIENCE

Confidential, Providence, RI

Oracle Database Administrator

Responsibilities:

• Installed, configured Oracle 11g/10g enterprise edition databases and oracle 10g RAC.
• Installed security pataches using all node down minimum downtime and rolling patching methods
• Adding additional nodes to existing RAC database
• Routine RAC database administration using RAC utilities SRVCTL & CRSCTL
• Installed oracle 11gR2 on sun solaris and created databases
• Upgraded databases from oracle 10g to oracle 11gR2 version
• Configured dataguard using physical and logical standby database.
• Performed switchover and failover using Dataguard configuration
• Performed database point in time recovery using RMAN.
• Working extensively on Golden gate for migration the databases from 10g to 11g RAC
• Tuned the databases to optimal performance
• Worked on oracle 10g grid control.
• Performed daily routine backup checking and other user actives.
• Applied oracle security patches databases every quarter.
• Handled 24x7 On-call support for the databases availability.
• Upgraded databases from 10.2.0.2 version to 10.2.0.4 version.
• Cloned databases using hot backup.
• Written shell scripts to check the backup status
• Implemented RMAN Recovery manager & EXPDP data pump backups for all production databases
• Handled User management and resolving application connectivity issues.
• Managed tablespaces, space related issues.
• Coordinated with server team and backup team for any issues related to their respective track.
• Responsible for migrating Oracle Internet Directory (OID) environment from 10g standalone configuration to high availability cluster configuration, which uses Oracle 11gR2 RAC/ASM technologies.
• Worked with Patch Management on Oracle databases. Updated the database with latest patch updates.
• Refreshed database from production to test and other development environments.
• Written shell script to monitor the databases status and backup status.

Environment: Oracle 10g/11g, Unix, SQL tuning, TOAD, OEM, SQL Developer, SQL Loader, RMAN, Data Guard, Shell Scripts, BAC, Grid Control, Golden Gate

Confidential, Boise, ID

Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle VM Manager on Linux. Creating and managing user for VM Manager.
• Created and Managing Server Pool on Oracle VM environment with oracle VM Manager.
• Created Virtual Machine on Oracle Virtual environment manually as well as with Oracle VM Manager with ISO file and oracle template.
• Monitoring Oracle VM Manager on Linux.
• Created Fully Virtualized and Para virtualized Oracle Virtual Machine with iso file and with use of oracle templates.
• Performed backup of VM Manager.
• Supported Oracle 9i Environments (Tru64, Windows) for SAP R/3 & BW applications
• Oracle databases supported for SAP R/3, SAP BW, SAP APO, GTS and XI applications
• Created and managed ISO pool, running pool to create and manage Oracle VM Machine.
• Manually configuration of vm.cfg files to manage Oracle VM Machine.
• Installation and Configuration of Oracle Linux (OEL-5) on Oracle Virtual Machine.
• Installation and Configuration of CRS, ASM and RAC Database on Oracle Virtual machine manually and with use of template.
• Performed cloning of VM Machine, Created templates from VM Machine.
• Creating and adding shared disk to Oracle Virtual Machine.
• Tuning and Monitoring of Oracle VM machine with Oracle VM Manager.
• Configuration of primary and standby database setup dataguard on Oracle 11.2
• Reconfiguration of OCR and create all CRS service manually on windows.
• Performed Day-to-day Activities database related activities.
• Archive logging is essential for production databases where the loss of a transaction might be fatal created UNIX script to move Archive log.
• Performed Defragment a tablespaces when an object's storage parameters are sized improperly.
• Creating Users and assign roll and privileges.
• Space Management, User management in production environment.
• Database up gradation from 10.2 to 10.3 and 10. 2 to 11.2. by using Golden gate
• Migrated databases by using Golden gate
• Performed datagaurd setup in production environment in Oracle 11.2
• Performed physical standby database setup in oracle 9i.
• Performed database cloning using hot backup technology for production and cold backup in development environment.
• Upgradation of RAC Database from 10.2.0.4 to 11R2 on windows.
• Configured RMAN for the hot backup on production environment. And Incremental backup for the development environment.
• Experience with performance tuning, data extraction, shell scripting - Korn
• Supported a large environment running various versions of Oracle.
• Monitored Alert logs on continuous basis.
• Working with space management adding new data files and managing tablespace, Created new tablespace. Performing defragmentation of tablespace.
• Rebuild new indexes whenever needed.
• Working with internal and external customers to develop new value-added programs and data solutions with existing data structure - Act as liaison with customers - Tests designed applications..

Environment: RAC, Golden Gate, Tkprof, Grid, Toad, 11gR2, Data guard, ASM

Confidential, CT

Oracle DBA

Responsibilities:

• Providing production support for 24X7 database availability for Oracle.
• Maintenance and monitoring of oracle 11g/10g database instances hosted on Linux and Sun platform.
• Upgrade and Migration of Databases from 10g R2 to 11g R2 and applying patches as per requirement using datapump.
• DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
• Role on Data Analysis like defining the tables and taking output for database report.
• Simulate a copy of production databases into test databases for application upgrade testing.
• Support and advise the development teams on database related issues.
• Assisted developers in tuning SQL statements in the applications.
• Performance tuning of SQL Server and Query Optimization
• Space Management which includes table space creation, adding new data files.
• Managed Table spaces, Rollback Segments, Redo Logs and database objects.
• Oracle installation, creation of database, which includes physical and logical design.
• Assisted developers in creating stored Procedures, Triggers, Functions, Cursors and Packages.
• Involved in support for 1TB 2 Node production RAC database.
• Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables, Indexes etc,
• Responsible for memory and Application tuning of the databases using Oracle utilities like OEM, SQL Trace, TK Prof and Explain Plan.
• Partitioning of large tables for fine tuning performance.
• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans.
• Taking periodic Backup of the Database and the software using Recovery Manager and VERITAS.
• Generated regular Stats-Pack reports for the performance tuning of the databases.
• Experience with DBUA/Export and Import to migrate the database.
• Responsible for optimizing data access and performance by tuning indexes.
• Performed Replication of the Production database for setting up instances for the QA and Testing teams.
• Hands on experience in writing UNIX Shell Scripts.
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.
• Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection & self tuning purposes.
• Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.

Environment: ORACLE, SQL Server, SQL*Plus, Oracle 11g/10g, Red Hat Linux 4.x, RAC, Solaris 10, Oracle Enterprise Manager, Data Guard, ASM, PL/SQL, RMAN, Toad.

Confidential

Oracle DBA

Responsibilities:

• Responsible for support and maintenance of very critical 24x7 Production and development databases in Oracle 9.2.0.8
• Performed Database migration from Oracle 9.2.0. To 10.1.0.3.
• Worked on designing, creation and administration of databases.
• Technical support to all 63 remote locations for the rectification of problems related with oracle database and Application Server.
• Performed logical and physical tuning, monitored extent growth and fragmentation, audited object creation
• Backup and recovery utilizing RMAN.
• Perform Instance tuning using tools like Stats pack etc.
• Installing patches and upgrades for the database.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
• Worked on export and import utilities.
• Involved onsite-offsite co-ordination as lead.
• Leaded a team of 19 Oracle DBA managing 65 Database running at different locations.
• Responsible to see that database backup and recovery strategies are in place, and to coordinate with Network Services and/or Data Center personnel to keep the integrity of the physical system backups.
• Responsible for optimizing data access and performance by tuning indexes.
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.

Environment: SQL*Loader, SQL*Plus, Oracle 9i/10g, LINUX, HP-UX, Solaris 9,SQL Server 2005, Windows 2000.

Confidential

Jr. Oracle DBA

Responsibilities:

• Handling day-to-day activities.
• Database administration of the Oracle database System.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Involved in the process of tuning and refining queries of various applications.
• Involved in the writing most of the packages, procedures, and functions for the application.
• Involved in the process of exploring new areas of Oracle and its products.
• Worked as Database administrator for the Human Resources database.
• Oracle 9i Database software in Linux, created database according to the requirement of Application Software, monitored and configured databases.
• Oracle Database Administration (logical & Physical database backup, database tuning)
• Daily database backup, table space administration, SQL net configurations and basic database tuning as part of maintenance activities.
• Maintenance of existing system and provided advanced level support.
• Involved in System study, Analysis, Design and Development.
• Developed back-end Stored Procedures, triggers, functions.
• Worked on import/export and SQL- loader.

Environment: Oracle 9i, Informatica, RMAN, Solaris, Erwin, Sql Server 2000, Windows NT