SUMMARY:

• Over 12 years of IT experience including 8 years as Senior Oracle Database Administration Ver. 11G R1,R2/10G/9i on a variety of UNIX (Solaris, HP - UX, AIX), Windows NT 4.0/2000/2003 with Oracle ( 9i, 10g,11g), Stored Procedures, DB Triggers, Developer 2000, Sql*Plus etc.
• Installed oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX, Exadata and migration of oracle server from 8i to 9i and 9i to 10g, 11g applied oracle patches.
• Installed Oracle 11g RAC software with ASM & OCFS2 File systems.
• Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server
• Installation, maintenance and tuning of RAC Applications.
• Created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts.
• 24*7 production database support with Support to developers & end-users.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Implemented and delivered core edge technologies of Oracle 10g (Streams, EM Grid Control, and RAC).
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Expertise in PL/SQL, SQL and UNIX Scripting (Used to write UNIX Scripts & implemented by Using CRONJOB for Day - to - Day activities.)
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Installation and Configuration of Oracle Grid Control.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Extensive experience with designing and implementing Oracle databases, data warehouse design, implementation and tuning.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Database replication using snapshots, materialized views and advanced replication methods.
• Worked on different types of storage structures (SAN/NAS).
• Good co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

RDBMS: Oracle 11g/10g/9i/8.x/7.x, Oracle 11g & 10g Real Application Clusters (RAC), SQLServer2005.Oracle Streams

LANGUAGES: SQL, PL/SQL, Java, C, XML, UNIX Shell Scripting.

SOFTWARE APPLICATIONS/ TOOLS: ORACLE 8.x/9i/10g, Recovery Manager (RMAN), Real Applications, Cluster (RAC), STATSPACK, ERWIN, Teradata, Clusters, Veritas Backup, Developer 2000, SQL Loader, TOAD 7.6/7.5, Oracle Enterprise Manager, GOLDEN Gate, Exadata

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

• Responsible for all the DBA related jobs for all the instances; performance tuning, backup & recovery using RMAN, managing users, roles & privileges etc.
• Design and develop efficient pl/sql packages/procedures/functions, configuration files, tables and views; implement best practices to maintain optimal performance.
• Provide on call support to production system to resolve any issues.
• Responsible for their day to day issues and processing’s of all databases, taking care of performance tuning of database.
• Major contribution Automatic gathering of all statistics (tables/indexes and application schemas)
• Periodically rebuild indexes, archive and drop old partitions.
• Configuring and administering the Golden Gate replication tool for real-time data replication. Managing the configuration and data changes in between Bothell and Windward data centers.
• Coordinating with the PDBA team for the changes related to Golden Gate replicated tables and making appropriate changes Confidential the target.

Confidential, Atlanta, GA

Sr. ORACLE DBA

Responsibilities:

• Responsible for all the DBA related jobs for all the instances; performance tuning, backup & recovery using RMAN, managing users, roles & privileges etc.
• Design and develop efficient pl/sql packages/procedures/functions, configuration files, tables and views; implement best practices to maintain optimal performance.
• Provide on call support to production system to resolve any issues.
• Responsible for their day to day issues and processing’s of all databases, taking care of performance tuning of database.
• Major contribution: Automatic gathering of all statistics (tables/indexes and application schemas)
• Periodically rebuild indexes, archive and drop old partitions.
• Configuring and administering the Golden Gate replication tool for real-time data replication. Managing the configuration and data changes in between Bothell and Windward data centers.
• Coordinating with the PDBA team for the changes related to Golden Gate replicated tables and making appropriate changes Confidential the target.
• Managing the user control and security management
• Adding users and removing privileges to the user by pre defied industry standards as per the HR systems.

Environment: Oracle 11g R2 &10gR2, HP-UX 11.31, Linux AS 5, AIX 5.3, SQL Server 2005 OEM (Grid Control), RMAN, Solaries, TOAD 10.6.0, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010, ERWIN 6.0, AWR, Explain Plan, Golden Gate, OIM

Confidential, MN

Responsibilities:

• Involved in configuring two node RAC on 11gR1, oracle clusterware on Red hat Linux AS 5.
• Configured server/client side load balancing.
• Added node for the existing two nodes RAC and also configured the services.
• Re design the existing database based on Business rules to overcome the existing issues in the Application and drawn Visio Diagrams to give high level presentation to Manger.
• Involved in designing and creating database objects.
• Created Partitions on large tables for easier manageability.
• Performed day to day activities such as managing user privileges, tablespaces, file system, undo segments, temp segments and indexing.
• Migrated single instance database to multiple instance database (RAC) using export/import, datapump.
• Performed cross-platform migration (AIX to LINUX) using Transportable Tablespace (TTS).
• Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges And user logins
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same
• Created Partitions on large tables for easier manageability
• Extensive UNIX Shell scripting in csh, ksh.
• Importing and exporting files, databases, schemas and tables using SQL* loader and utilities like Import, Export and Data Pump features of Oracle database 10g.
• Involved in designing and creating schema objects like Database tables, indexes, views, materialized views and synonyms
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Max. Extents, coalescing etc kept in CRONJOB.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Deciding the naming conventions of data file, redo log files, table spaces, and segments.
• Generation of the AWR (Automatic Workload Repository), ADDM, ASH Reports and using them for tuning the database.
• Managing the user control and security management
• Adding users and removing privileges to the user by pre defied industry standards as per the HR systems.
• On call support 24/7

Environment: Oracle 11g R1 &10gR2, HP-UX 11.31, Linux AS 5, AIX 5.3, SQL Server 2005 OEM (Grid Control), RMAN, Solaries, TOAD 9.7.2, OIM, RMAN, SQL*Plus, PL/SQL, SQL*Loader, DBArtisian 8.7, MS Visio 2010, ERWIN 6.0, AWR, Explain Plan

Confidential, Boston, MA

Sr. ORACLE DBA

Responsibilities:

• Involved and Configured Oracle 11g database instance running across two oracle RAC nodes on Red Hat Linux AS 4 Server
• Setting up the primary and physical Standby databases for disaster recovery using Oracle Data Guard and successfully conducted switchover operation as part of planned outage
• Creating and defining redo log files and undo tablespaces for RAC environments
• Used start schema for approaching for designing of Data warehouse design
• Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3 on Linux and AIX Boxes.
• Installed and created 10g databases and 10g OEM.
• Designed Star data mart for their clients using Visio and translated business requirements into it and implemented logical design physically into Oracle Database
• Installed Oracle Grid Control and monitored Streams Issues using Grid Control.
• Refresh schema using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges And user logins
• Configuration, maintenance and tuning of Oracle 9iRAC and 10gRAC.
• Configured Failover Database using Datagaurd for Streams Database.
• Performed Network Traffic Tests for Streams.
• Configured Streams setup from HP-UX boxes to SUSE Linux Boxes.
• Installing and configuring Recovery Manager (RMAN).
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Extensive UNIX Shell scripting in csh, ksh.
• Data Modeling, Database Design and Creation.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Extensive Performance Tuning, Memory (SGA) Tuning, etc.
• Expertise in interpreting EXPLAIN PLAN.
• Create database maintenance plans, including updating statistics, re indexing, structure modifications, Capacity plans, and index analysis.
• Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle Database.
• Taking Hot and Cold Backups, Exports etc.
• Assisting customer setup, tune and maintain Oracle database.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication. Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Data Modeling, Database Design and Creation.
• Deciding the naming conventions of data file, redo log files, table spaces, and segments.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.
• Applying patches both Server side and Client side.
• Setting up new environments (Development, Production).

Environment: Oracle 11g &10gR2, Linux AS 4, HP-UX, Solaris, OEM (Grid Control), RMAN, RAC, Data Guard, Oracle Streams, Import/Export, Data Pump, SQL* Plus, SQL * Loader, TOAD, ERWIN 6.0, AWR, VERITAS Net Backup

Confidential

Sr. ORACLE DBA

Responsibilities:

• Responsible for administration and supporting Oracle 9i, 10g and 11g databases.
• Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3 on Intel and HP boxes.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 11g production implementation
• Installation, Upgrade and Configuration of Oracle (8i, 9i, 10g and 11g). Installed and created 10g databases and 10g OEM. Installed RAC on Oracle 11g and worked on ASM.
• Involved in designing of disaster recovery using Data Guard, High Availability using RAC.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings
• Configuration, maintenance and tuning of Oracle 10gRAC and 11gRAC.
• Installing and configuring Recovery Manager (RMAN) and Flash Recovery.
• Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases. Assisted a team of DBAs in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
• Data Modeling, Database Design and Creation using ER-Win.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Performed database tuning using Explain Plan, TOAD, and Enterprise Manager. Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets.
• Oracle replication using streams.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Writing Shell scripts for Alerts for ORA error backup and recovery, Import and export procedure.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Used Active Dataguard makes a read-only replication of a given database.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Tuning Oracle databases and tuning applications (SQL), for tuning SQL working closely with development Team. Extensive familiarity with Tuning Tools like Oracle Enterprise Manager’s (OEM’s), Oracle cost based optimizer, SQL analyzer, top session, top SQL, Performance Manager, Statspack, TOAD. For SQL tuning using “Explain plan”, “TKPROF”, “SQL TRACE”, Optimizer modes, using Optimizer hints, Gathering statistics, Statspack.
• Create database maintenance plans, including updating statistics, rebuilding indexes, structure modifications, Capacity plans, and index analysis.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Used Oracle Internet Directory to leverage the scalability, high availability and security features of the Oracle Database. Taking Hot and Cold Backups, Exports and Applying patches both Server side and Client side.
• Writing scripts for backup and recovery, Import and export procedure.

Environment: Sun Solaris 8.0/9.0/10.0, HP-UX 11, Red Hat Linux, Windows 2000/2003, Oracle 9i/10/11g, Oracle Enterprise Manager, RMAN, ORACLE Warehouse Builder, Reports, 10G RAC, Streams, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2005, 2008, Toad V9.7 and SQL Navigator V6.1.

Confidential

Sr. ORACLE DBA

Responsibilities:

• 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.
• 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.
• Configured Oracle data guard and Streams.
• Oracle streams configuration and performance tuning.
• Data Modeling, Database Design and Creation.
• Design, review and maintenance of database structures.
• Query optimization for reporting and ETL.
• Performance assessment, SQL scripts, stored procedures, functions and transactions analysis
• Oracle Grid Control Management Server Installation
• Database backup and Database tuning for real time and batch systems
• Assisting customer setup, tune and maintain Oracle database.
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Data extraction from various sources, transformation and loading into the target Oracle database using Informatica PowerMart.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• 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 Confidential all levels like 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: HP-UX, AIX and Linux, Windows NT/2000, Oracle 11g, 10g and 9i, Data Guard, Oracle Streams, RMAN, LEGATO, TOAD, OEM Grid Control, AWR, STATSPAK, External Tables, SQL * Plus.