SUMMARY:

• Over 7 years of experience in IT industry as Oracle database Administrator in various domains.
• Extensively performed database administration tasks: installation, configuration, upgrades, patches, migration, backup and recovery, Space management, database security, Golden Gate, performance tuning and cloning on Oracle 8i, 9i, 10gand 11gR2 on large scale database environments and mission critical large OLTP and OLAP systems.
• Experience in a variety of hardware and software platforms including Unix/Linux, Sun Solaris, HP-UX AIX, MS-Windows 2000,2003 and RHEL
• Outstanding knowledge and hands on experience in Oracle 10g/11g RAC implementation administration Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid installation .
• Hands on experience with RAC Cluster ware configuration, administration and patching, RAC Backup and recovery.
• More than 5 years of experience in migrating and upgrading databases of different versions of Oracle 8i, 9i, 10g, 11g and in different environments.
• Very good experience in doing cross platform migrations using RMAN and Transportable table spaces.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, data guard, cloning and relocation activities.
• Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility Classical Data Pump and Transportable Table spaces.
• Monitoring and optimizing the Database Performances through Database Tuning, System Tuning, and Application/SQL Tuning.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and SQL TRACE.
• Expert in Installing OEM Grid Control, Configuring and Maintaining.
• Extensive experience in Data guard configuration, implementing and maintaining standby databases.
• Experience in installing and troubleshooting Golden Gate issues using command level tools and utilities as well as LOGDUMP utility.
• Setup, Configured and Maintained Oracle Data Guards to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Hands on experience using Oracle Enterprise Manager OEM , SQL PLUS, TOAD and Grid Controlling using OEM
• Co-ordinate with UNIX administrators for space managements on various servers.
• Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Experience in writing Shell scripts to backup, restore database and automate daily activities.
• Specialize in configuring very large Databases up to 10TB and Data Warehouse environments, Backup/Recovery using RMAN and high availability procedures like Hot Standby Databases, Database cloning, and clustered database environments.
• Complete range of Oracle DBA activities including day-to-day production database monitoring includes alert log, trace file, and achieve files, Troubleshooting production issues and Performance Tuning issues.
• Troubleshooting production issues, Performance Tuning, Physical Database design, Table Space Administration and managing Data Dictionary objects. Extensive SQL and PL/SQL skills
• Skilled in reducing the SQL query time by monitoring queries on TOAD and removing deadlocks.
• Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Experienced in providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Role: Senior Oracle DBA

Money Gram International, a leading money transfer company, enables consumers who are not fully served by traditional financial institutions to meet their financial needs. Money Gram offers bill payment services in the United States and money transfer services worldwide through a global network of more than 233,000 agent location.

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Created Databases on SUSE 10 and SUSE 11 servers.
• Oracle 10g, 11g R1 and R2 installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux OUL , and WINDOWS server 2000, and 2003.
• Installed Oracle 10g, 11g RAC database on Red Hat Linux.
• Creating and maintaining the Oracle databases.
• Installation and maintenance of Oracle 11g Data Guard Active .
• Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Coordinate with UNIX administrators for space management on various servers.
• Setting up new environments Development, Production etc. .
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups. .
• Installed and Implemented Backup Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Worked on import/export and SQL- loader.
• Setup backup and recovery procedures using RMAN.
• Experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning with OEM.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.

Environment: Oracle 11g/10g/, Red Hat Linux, TOAD, ERWIN, RMAN, SQL server, Data Guard, OEM, Grid Control, Golden Gate, Data Guard , STATSPACK , AWR, Explain Plan.

Confidential

Role: Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version.
• Implemented Oracle Database 10g Two node Real Application Cluster RAC using Oracle Cluster-ware and responsible for high availability and load balancing.
• Provided production support for the 24x7 Oracle database availability.
• Configured Oracle Data guard for Disaster recovery solutions.
• Achieved High Availability, Data protection and Maximum performance by maintaining physical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup recovery solutions using RMAN.
• Supported and Worked on CURAM for Oracle Databases.
• Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Also migrated data from Oracle to SQL SERVER, Sybase, etc., for testing, reporting and analysis requirements.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases.
• Used oracle configuration assistants like DBCA Database Configuration Assistant for Creating databases, DBUA Database Upgrade Assistant for Upgrading databases and NETCA Network Configuration Assistant for creating a Client-Server environment using Listener, TNS names etc.,
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor ADDM , Automatic Workload Repository AWR for monitoring database performance.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Experienced in performing Point in time recovery using RMAN.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL Loader, NT, Red Hat Enterprise Linux, ASM.

Confidential

Role: Oracle DBA

It is one of world's leading biopharmaceutical company and has a leading portfolio of products and medicines that support wellness and prevention, as well as treatment and cures for diseases across a broad range of therapeutic areas.

Responsibilities:

• Supported Oracle 11g, 10g and 9i databases
• Installed and created 11g databases
• Performed upgrades from Oracle 10g 10.2.0.3 to 11g 11.1.0.1 on Intel and HP boxes
• Successfully migrated databases from Intel boxes Win2000 and Win2003 servers running Oracle 10g over to HP Itanium boxes running Oracle 11g
• Installed Oracle 10g RAC software with ASM OCFS2 file systems
• Configuration, maintenance and tuning of 10g RAC
• Setup of Disaster Recovery databases Data Guard
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Installing and Configuring Recovery Manager RMAN
• Extensive Performance Tuning, Memory SGA Tuning, Net backup, EMC Time finder and SRDF , RAID, RAW Devices
• Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
• Experienced in migrating databases to higher releases including incremental migrations
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Performed Conversion of data from PostGre SQL to Oracle
• Query optimization for reporting and ETL
• Created Managed Jobs using AutoSys Job Scheduler
• Good knowledge in UNIX Shell scripting in csh, Pro C
• Planned version control of production source code using Clear case
• Writing SQL scripts, stored procedures, functions and transactions analysis for performance tuning
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
• Created database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysis
• Storage Management Managing Space, Table Spaces, Segments and Extents, Rollback Segments Data Dictionary
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches
• Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle Database
• Taking Hot and Cold Backups, Exportsetc.
• Data Modeling, Database Design and Creation using ERwin
• Created Triggers for multi-master replication

Environment: HP-UX, Windows 2000/2003, and Linux, Oracle 9i, 10g, and 11g, Oracle RAC 11g, 10g , Data Guard, Oracle Enterprise Manager OEM , RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, Autosys, Clear case, SQL Plus, PL/SQL, PostGre SQL, SQL Loader

Confidential

Role: Oracle Database Administrator

Project Description

GSK Inc. is a British multinational pharmaceutical, biologics, vaccines and consumer healthcare company headquartered in London, United Kingdom. GSK Spread across all Geographical barriers spanning 180 countries, it is in simple terms a behemoth engaged in every aspect of pharmaceutical industries.

CBS IT GSK Core Business Services are an extremely vital component of the IT operations which ensures that the high technology applications ensure the smooth running of all co-related operations on US and UK servers.

Responsibilities:

• Oracle Database 11gR2 Real Application Clusters RAC Installation and Configuration on Linux
• Server release 5
• Upgrading databases from 10.2.0.4 to 10.2.0.5 and Migration of databases between the RHEL AS4 update 8 to SOLARIS 5.10
• Patching, upgrading the database to 10g, 11g
• Creating databases as per client Standard
• Duplicating Database with RMAN from RAC to Single Node
• Duplicating Database with RMAN from RAC to RAC
• Data Guard Rebuild
• 11gR2 DR drill for Data Guard
• Migrated database from non ASM to ASM
• Check the performance of the database and tune as and when requires using tools AWR, EXPLAIN
• PLAN
• Understanding execution plan of top SQL statements by using Explain plan,Auto trace and TKPROF
• Refreshing Test Databases with EXPDP/IMPDP
• Handling database management and change requests in form of import and export.
• Oracle Server and client software installation
• User administration tasks
• Data guard setup and best practices
• Providing connectivity and troubleshooting of connectivity problems

Environment: Oracle 10g, 11g, RAC, LINUX, RMAN, RAC, Data Guard, ASM, AWR, EXPLAIN PLAN, Auto trace, TKPROF, EXPDP/IMPDP.

Confidential

Role: Junior DBA

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system
• Use TOAD tool to access the database.
• Used PL/SQL developer to create PL/SQL Procedures.
• Refresh/Cloning of Database for development, testing.
• Monitoring and Management of database users.
• Testing PL/SQL procedures against the test cases.
• Involved in creating use cases and test cases.

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database Tools/Utilities, Oracle Enterprise Manager.