SUMMARY:

• 9 years of experience as Oracle Data Base Administrator, providing support for both development and production 11g/10g/9i databases on Various Platforms.
• Proficiency in Oracle database installations 9i, 10g, 11g on UNIX/LINUX, HP-UX, IBM AIX, SUN Solaris, Windows environment with hands-on experience in upgrading the Oracle databases. 10gR1 to 10gR2,9i to 10gR1,10gR2 to 11g .
• Experience on high volume databases with sizes varying from 100GB to 5 TBs of data.
• Experience in installation and configuration of Oracle 10g with RAC using ASM, configured user log on load balancing and failover on RAC database for high availability.
• Installed and Administered Oracle 11g ASM 10g RAC with ASM Oracle Clusterware File system OCFS2 .
• Experience in Real Application Clusters RAC setup, configuration and cluster interconnection with Automatic Storage Management ASM .
• Monitored performance and availability of the VIS application a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN.
• Planned and implemented DR high availability solutions using OEL 10g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Having good knowledge on 11g Grid control and 12C Cloud control and intensively used for Diagnostic tuning activities.
• Experience in applying oracle database patches using opatch utility.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Configured and Maintained Physical Data Guard for High Availability and offline reporting.
• Experienced in using 11g features Data Pump, Mean Time to recover MTTR , AWR, ASM, ADDM, Grid monitoring, and Recycle Bin.
• Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering Terabyte of Oracle Databases on Oracle 10g/9i/8i.
• Performed data replication, transformation and delivery of database transactions using Goldengate replication tool. Supported a large number of Development Databases
• Proficiency with Installation and maintenance of replication tool GoldenGate by creating extract process, extract pump, and replicate.
• Installed, configured, and resolved issues with the Oracle Streams utility, and with the Oracle Change Data Capture CDC utility.
• Engineering of the existing databases and provide both a Physical and Logical/Physical data model to maintain an existing Database.
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Performed backups and crash recoveries using conventional hot/cold backups and RMAN.
• Recovery of Databases Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager TSM .
• Experience in SQL, PL/SQL, Database procedures, Triggers, Packages
• Performing tuning of application with AWR Reports, tkprof, explain plan, Autotrace, Statspack and Oracle Enterprise Manager.
• Experience with designing and data modeling using ERWIN data modeler, converting the logical model to physical model.
• Experienced with installing, configuring and administering SQL server 2000/2005/2008 databases including migration from MS SQL server to oracle
• Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.
• Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools.
• Designing and Building Relational Databases architecture in OLTP, OLAP, client/server.
• Strong learning abilities with keen interest in learning new technologies and best practices with passion to take on challenges to deliver and add value to the clients, good communication and inter-personal skills, accustomed to work in a team environment with tight schedules, and capable of working efficiently under pressure and managing multiple projects.
• Extensive experience on OEM,TOAD Tools for Oracle Application Developers , SQL Plus and SQL Loader as well as traditional UNIX command that requires for Oracle DBA
• Excellent working experience on EMC, NetApp and ASM Storage technologies.

TECHNICAL SKILLS

• Languages: SQL, PL/SQL, UNIX Shell scripting.
• Database: Oracle 11g/10g/9i, SQL Server 2008/2005, MS-Access.
• Application Tools: Oracle Grid control/Oracle Enterprise Manager, TOAD,
• DBCA, TKPROF, RMAN, ASM, RAC, Import/Export, SQL loader,
• SQLNET, Tuning packs, Load runner, VERITAS Netbackup, TSM,
• Commvalut, EXPLAIN PLAN, ERWIN, SQL-Navigator, DBArtisian,
• Data Guard, Data-Pump.
• Development Tools: SQL LOADER, PL/SQL, SQL PLUS, T-SQL.
• ETL Tool: Informatica 8.6, SQL Server Integration Services SSIS
• Operating Systems: UNIX Solaris 9, 10, AIX 5.3, HP-UX11 , Windows 2000/2003
• Windows 2000/XP, Linux Redhat 2.1, 3.x, 4.x, 5.x 32bit, 64bit
• Others: MS Office Suite, SSH, FileZilla

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Provided Oracle database administrative support.
• Oracle 9i,10g,11g grid control OGC , Putty, sql plus, RMAN , Data Pump
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security create and maintain users and roles, assign privileges
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Install, upgrade, and maintain Oracle software products/versions for on Linux, Sun Solaris, and
• HP-UX
• Database migration from NetApp storage to emc storage.
• Database migrations from oracle database 10g to oracle database 11g ASM.
• Database upgrade from oracle 10g to oracle 11g.
• Coordinating with different functional teams about down time.

Confidential

Lead Oracle DBA

Responsibilities:

• Provided 24x7 supports of Production databases.
• Implemented 10g/11g RAC consisting of 2 to 6 nodes.
• Installed GoldenGate 10.4 on Solaris development tool.
• Implemented 10g/11g Data guard with one physical database
• Extensively worked with DML Triggers.
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Capture, Propagation, Apply using Golden Gate.
• Assist Programmers and Developers with Oracle problems.
• Made use of the REF CURSORS in stored procedures for report generation.
• Designed, configured and maintained backup and recovery policies including RMAN backups. PL/SQL, Performance Tuning, Application Tuning and Monitoring.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
• Extensively worked with ASMCMD for managing ASM environment.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Used Oracle 10g AWR ADDM to monitor database activities and performance tuning.
• Extensively used AWR, ADDM for database performance statistics.
• Migrated all applications and database servers to AIX 5.1 and RedHat AS 3.0 Linux running Oracle 10gRAC with ASM Storage and 10g Application servers. Linux servers running OCFS 2.1. And RedHat Advanced server 2.1 and 3.0.
• Backup of Database Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.
• SQL query tuning using tools like Explain Plan, SQL Trace, TKPROF and Statspack
• Worked with OIDCTL, a command line utility tool for starting and stopping the OID server
• OEM / GRID OGC installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Extensively used Oracle Application Server 10g, in deploying and integrating enterprise's applications
• Planned and performed the database migration from SQL Server to Oracle.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Ensured data is being maintained effectively by monitoring data maintenance.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Able to work effectively with multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.
• Checking database performance on a regular interval, which includes checking various log files.
• Addition of users, objects etc as and when required and granting proper privileges for Database access.
• Taking care of database by checking the size the database and addition of table spaces, data files
• ASM implementation maintenance. Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Created standby database using data guard on testing server.
• Provided Oracle database administrative support.
• Oracle 9i,10g,11g grid control OGC , Putty, sql plus, RMAN , Data Pump
• Maintenance and monitoring of table spaces, data file, control files etc.
• Implement and maintain database security create and maintain users and roles, assign privileges
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Creating table spaces, tables, indexes, users, etc.
• Importing of dumps using impdp/expdp utilities.
• Define Backup Strategies and Implementation.
• Loading bulk data from flat files using sql loader and external tables

Environment: IBM AIX 5.3, Sun Solaris 2.6/7/8, Red Hat Linux 6.0, Oracle 9I/10g/11g, PL/SQL, SQL PLUS, VNC, ORACLE ENTERPRISE MANAGER 9.2.0 , Oracle 10g GRID, QUEST SOFTWARE 5.0 , Oracle RAC, Data guard, Guardium 6.0, Toad 8.6, Oracle Applications 11.5.8, Oracle Application server 10g, APEX 2.0/2.2,Sybase, SQL server

Confidential

Senior Oracle DBA

Responsibilities:

• Installed, Configured, Upgraded and Applied patches and bug fixes for Prod, Test and Dev Servers.
• Involved in 24 7 support for production RAC database with on-call pager
• Installed and configured OEM Grid Control.
• Install and configure Oracle Golden Gate.
• Installation and creation of 11g and 10g databases for Testing, Development and Production
• Data Refresh from Production to Test and Development environments using RMAN Duplication
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK
• Monitor CPU usage, I/O contention, memory parsing on UNIX server
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g and Sun Solaris to OEL Oracle Enterprise Linux .
• Experience in SQL scripts for session and lock monitoring
• MULTILOAD, TPUMP, SQL, and TASM for workload management.
• Monitored/managed 2 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery.
• Monitored batch performance
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases Data Guard and Replication using Golden Gate.
• Experience in DBA skills of Teradata DBMS Administration, initial Teradata DBMS environment setup, development and production DBA support, use of Teradata Manager, FASTLOAD
• Automated the procedures and interface programs using Oracle Advanced Queuing, Oracle Enterprise Manager.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import move procedures
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM
• Optimal Space utilization in table space by avoiding fragmentation.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions
• Taking periodic Backup of the Database and the software using RMAN and VERITAS NETBACKUP
• Migration of Database from RHEL 4 to Sun Solaris and applying patches whenever required.
• Experience in oracle features Flashback version query, Rollback Monitoring, Tablespace Management, Oracle Datapump, Flashback Table, RMAN and Auditing
• Setting and Installing Oracle Enterprise Manager and Enterprise Backup Utility.
• Scheduling jobs using Oracle Job Scheduler
• Upgradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption
• Installation and configuration of Oracle Client software and Tools
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK
• Monitoring and Optimizing database performance
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
• Created scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration
• SQL scripts to monitor Tablespaces and extent growth

Environment: Oracle 10g RAC, 11g, UNIX, Solaris 10, Informatica, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN, Business Objects XI, Dataguard.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Redhat4
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Created development, testing, staging, production for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Involved in different scenarios of OLTP as well as DSS DATA WAREHOUSE Databases.
• Managed DSS Decision Support System and OLTP On Line Transaction Processing system full life cycle projects with about 10 databases at one time, biggest database around 800 GB supporting both production developments on UNIX and Windows NT/Windows 2000.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Administration, optimization, and maintenance of the Data Warehouse and Data Marts databases.
• Used Informatica Power Center for ETL extraction, transformation and loading data from heterogeneous source systems.
• Managed the migration of SQL Server 2005 databases to Oracle 10g.
• Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index defragmentation.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Worked on Automatic Storage Management ASM for managing data in SAN.
• Performed Bi-Directional Schema Level Streams for Oracle 10g.
• Created scripts and documented the Operational guide for Streams.
• Created and Managed Jobs using AutoSys Job Scheduler.
• Performed Uni-Directional, Bi- Directional Streams from HP-UX Boxes to Suse Linux Boxes.
• Performed Table level Streams.
• Extensive UNIX Shell scripting in csh, Pro C.
• Migrated database from 8i to 9i and 10g supporting various incremental releases.
• Configured RAC 9R2 and 10g from HP-UX boxes to Win 2003 Boxes.
• Configured, migrated and tuned of Oracle 9R2 RAC and 10g RAC.
• Involved in Data Modeling, Database Design and Creation.
• Involved in the Dimensional Data Modeling and populating the business rules using mappings into
• the Repository for Data management.
• Reverse engineering and forward engineering using Erwin.
• Used Informatica as a Data Cleansing tool to correct the data before loading into the staging area.
• Migrated database from Oracle 8i to 10g from Solaris 5 to Win 2003 and configured 10g RAC.
• Maintaining the version control of the source code using Clearcase.
• Design, review and maintenance of database structures.
• Performance assessment, SQL scripts, stored procedures, functions and transactions analysis
• Oracle Grid Control Management Server Installation.
• Provided 24X7 support for production Databases.
• Database backup and Database tuning for real time and batch systems
• Assisting customer setup, tune and maintain Oracle database.
• Proven expertise in object-oriented design and client/server application systems development.
• Performed Performance tuning by using STATSPACK, TKPROF, AWR and ADDM and SQL Trace and TKPROF and Explain plan and Analyze and estimate on object level and schema level.
• Data extraction from various sources, transformation and loading into the target Oracle database using Informatica Power Mart.
• Involved in Data Modeling concepts including Data Vault, and also in Advance security including DB Auditing, Labeling.
• Configured Physical Standby Database for Disaster Recovery using Dataguard.
• Documented the steps of installing and configuring the Crystal Enterprise for the networking department built the servers when we have releases.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD, Foglight and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Perform Oracle replication advanced Queues, materialized views etc
• Devised and Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Backup-using RMAN Recovery Manager as a media management layer.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Trouble shooting of various database performances by proper diagnosis at all levels including SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Windows NT/2003/2008, HP-UX, AIX, Solaris and Linux, Oracle 9i and 10g, SQL Server 2000/2005, Toad , RMAN, PL/SQL,SQL Loader, SQL Plus, Informatica Power Centre 7.2, Erwin, Clearcase, Foglight, Autosys, SQL Backtrack, BMC Patrol, Aqua Data Studio 3.7,Query Analyzer, Oracle Fail Safe, Linux on NFS, blade system from HP.

Confidential

Oracle DBA

Responsibilities:

• Install, upgrade, and maintain Oracle software products/versions for on Linux, Sun Solaris, and
• HP-UX
• Database monitoring and performance tuning using OEM Oracle Enterprise Manager and STATSPACK.
• Trouble shooting of various database performances by proper diagnosis at all levels including SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Configured Oracle Replication and Dataguard.
• Performed incremental migration from Oracle 8i multi-master to Oracle 9i multi-master replication environment.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
• Migrated database Oracle 8i from Windows NT to Red Hat Linux with minimal downtime.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Implementing Database Security, Management of role-based security.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Used Oracle Advanced Queues feature to set up multi-master replication, dealt with conflict resolution and performance issues
• Database Restore using RMAN, Cold Backup and Export.
• Data Modeling, Database Design and Creation using Erwin.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks including Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle
• Corporation and installation of patches.
• Used Triggers for database activities, including delete, update, and insert triggers for multi-master Replication.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• Production support for Oracle running on UNIX.
• On-Call 24x7 DBA support for production databases.
• OLAP on Oracle platform using Oracle Express OLAP server , Relational Access Administrator RAM ,
• Data Migration as part of enterprise data warehouse project.
• Extensive Performance Tuning, Memory SGA Tuning, RAC tuning, Net backup, EMC Time finder and SRDF , RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of DATA guard.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Environment: Solaris 8.0/9.0/10.0, OAS 10g, Linux Red Hat, Windows 2000/2003/NT Oracle 8i 8.1.6/8.1.7 , Oracle 9i/10gR1, RACF, Oracle Enterprise Manager, Oracle Partitioning, Informatica Power Center 7.1, Oracle Replication, Hot Standby, SQL Plus, PL/SQL, SQL Loader, SQL Server 2000, Toad, Erwin 7.2.

Confidential

Junior Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Performed Database upgrade of Oracle 9i from existing Oracle 8i system.
• Involved in analysis of market risk and claims data.
• Developed new PL/SQL programs Triggers, Functions, Procedures and Packages to manage various business functionalities
• Performing backups and recoveries using RMAN/conventional hot backups.
• Other duties include applying Oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance. Worked with DML SQL statements which were used to modify the client information in the current database tables.
• Worked closely with senior DBA to understand the business and technical requirements.
• Developed entity relationship, data flow and functional diagrams.
• Designed database tables, implementing referential integrity.
• Developed triggers which internally called procedures and functions.
• Performed complex SQL query tuning, index reorganization, and Rollback.
• Developed oracle forms and reports using oracle designer 2000.
• Involved in all phases of the software development life cycle.
• Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database.
• Designed appropriate backup and recovery procedures to meet the business requirements.
• Involved in documenting the entire system architecture and data flow

Environment: Windows 98/NT/ 2000, UNIX, HP-UX, RedHat Linux 4.x, IBM AIX, MIGRATION

Confidential

Junior Oracle DBA / Developer

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Provided support for all the databases as an operational database administrator. Installation, configuration and upgrading of Oracle server software and related products.
• Implemented Standby Database and Database Replication to realize database high availability. Created partitions for large table to improve performance Installed and configured Oracle 8i databases.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting and backup and recoveries.
• Responsible for optimizing the queries and application tuning.
• Created roles, profiles and privileges and assigned roles to users.
• Execute physical database changes required by applications
• Strong Knowledge of Creating Public Synonyms, DBlinks, Ref Cursors, Raise Application Error, Parameterized Cursors.
• Installed and Implemented Backup Recovery procedures.
• Cloning the databases for different environments.
• Maintained archived data on tape.
• Familiarity with the SOX and Hippa.
• Implement Hot, Cold and Logical backup plans.
• Analyze, design and implementation of the Database for e-commerce system.
• Implement Stored Procedures and Triggers based on business plans using PL/SQL.
• Involved in documenting the entire system architecture and data flow

Environment: Windows 98/NT/ 2000, Oracle Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting