SUMMARY:

• Over 7 years of experience in Oracle Database Administration, Design & Development, Implementation and Testing of Relational Database Management systems for Business solutions. Leading global teams, Extensive experience in database development and production system support. Oracle Database Administration on 24x7 critical production and large databases using Oracle 9i RAC, 10g RAC.
• Implementation of high availability solutions with Oracle 10g RAC.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES 10g OEM Grid Monitoring.
• Expert in configuration and Installation of 9iRAC, 10gRAC, 11g on Linux using ASM.
• Upgrade/Migration of Databases from Oracle 9i to 10g and 10g to 11g as well migrating experience over cross platforms from Linux, windows to Linux.
• Experience in Upgrading databases and applied patch sets to multiple databases.
• Expertise in Database Space Management, Memory Tuning and Application Tuning, Expertise in troubleshooting and performance tuning.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Experience in basic and advanced replication using INFORMATICA, TOAD, Data Migrations using export/import.
• Experienced in using 10g features Data pump, Flash - Back Recovery, AWR, ASM, ADDM, Recycle Bin.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM, ASH.
• Setting up of oracle parallel server 9i RAC/10g RAC Grid control.
• Working experience in both OLTP, OLAP environment.
• Very good knowledge on data guard physical/logical standby databases, working, and managing of partitions and clustering of tables
• Extensive performance tuning experience, specializing in instance tuning, Oracle9i and 10g RAC tuning, Load balancing and SQL optimization.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
• Skilled in dealing with RAIDs on local server (Via RAID card BIOS) in ASM environment such as installation, taking backup, migration from Non - ASM to ASM environment.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager.
• Excellent analytical and problem-solving skills, Sound judgment and use of initiative.
• Worked extensively with configuring database backups in RMAN environments using TSM, Net backup and Commvalut backup utilities.
• Experience in ETL concepts and tools, expertise in performance monitoring and tuning.
• Experience with mid-tier architectures, OEM, TOAD, Oracle grid-control.
• Excellent Written and verbal Communication skills with a customer service oriented attitude.
• Knowledge on Oracle Support processes for technical requests with Metalink.

TECHNICAL SKILLS:

Databases: Oracle 9i/10gRAC/11g

Operating Systems: AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows NT / 2000/ XP

Languages: SQL, PL/SQL, UNIX Shell.

Oracle Tools: RMAN, OEM, TOAD, SQL*Loader, expdp, impdp, EXP, IMP, GRID 10g.

Web Tools: HTML, XML, Java Script

Tuning Tools: TKPROOF,EXPLAIN PLAN,STATSPACK,AWR,ADDM,ASH

Hardware/Storage: Sun E4500, Sun E10K, HP9000, RS6000, EMC, VERITAS Net Backup, Tivoli Storage Manager (TSM).

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle Application Database Administrator

Responsibilities:

• Working with development with all database related issues. Suggests best practices for database implementations.
• Participates in high level and architectural database design for the application.
• Creates and maintains Entity Relationship Diagrams (ERD).
• Interface Design: Assists in the design of interfaces between new and existing applications. Create control tables for Informatica pre and post session process.
• Coordinating with Infrastructure DBA ‘S storage requirement to databases.
• Test case Design: Participates in test data and test case design. Assists in the design and implementation of performance tests. Determines entrance and exit criteria for acceptable database performances.
• Coordinating with Infrastructure DBA in the creation and configuration of development and production databases.
• Creating Tables, Columns as per CNA Business Naming standards.
• Creating master build script for DR and production testing.
• Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Refresh the test and development databases from the source production databases on a regular basis using export/import utility.
• Project and Version management using PVCS Version Manager and Checking DDL,DML’s and Stored procedures in PVCS.
• Database Builds Handling and migrations from CUT (DEV)-ETE (QA)-DR (deployment readiness) and Production .Propagates synchronized database builds to different channels in pre-production and production environments.
• Performance Testing: Proactively monitors development databases for potential performance bottlenecks. Participates in load and performance tests conducted in deployment readiness environments. Assists QA in interpreting database performance results. Tunes and profiles SQL code and stored programs for optimal performance.
• Involved in creating logical and physical data models using Erwin Data Modeler based on business requirements.
• Created and monitored Database maintenance plans (Re-org JOBS) for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Experience in Planning Database, Sizing table space, Create database, scripts, Interact with developers.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users in pre-production. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Extensively used PL/SQL for designingpackages, stored procedures, functionsand databasetriggers.
• Importing data from flat files into database using SQL loader and External Tables. Perform database capacity planning and growth projection by monitoring the tablespaces requirements and ensuring that there is enough disk space available to support the various end-user applications that access to the databases.
• Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA views.
• Migrated data from Sql server to Oracle using change data capture (CDC).Creating tables as per oracle database and changing data types from SQL SERVER to ORACLE.
• Migrated data from DB2 to Oracle using Change Data Capture (CDC).
• Management of schemas, objects partitioning the tables & indexes.
• Developed PL/SQL packages, Oracle tables, stored procedures, functions and triggers.
• Created scripts for data migration for DR and Production.
• Taking periodic backup’s of the databases by using RMAN.
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—helping to transform business requirements into environment specific databases.
• Work within the production support teams and maintain operational consistency and efficiency
• Worked with development team to analyze and support production database.
• Archiving large tables and provides access to business and also increase the performance on archiving tables.
• Worked with both cost based and rule based optimization techniques.
• Partitioned large tables to increase the performance.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Downsizing and defragmenting the Very Large Databases by export / import. Refresh Databases and Schemas with Production Database export / import and datapump. Creating and maintaining Database links.
• Documented the Standard Processes to follow.

Environment: IBM-AIX 5.3 Oracle 9i, 10g, 11g, Data Pump, Diagnostic and Tuning Advisors, DB console, Toad, Sql developer, RMAN, Erwin.

Confidential, St. Louis, MO

Oracle Database Administrator

Responsibilities:

• Installation, Configuration, Designing and Maintaining of Oracle 10g/11g on AIX 5.3,Sun Solaris 10.
• Installed and Configured Oracle 10g, 11g RAC (2 node cluster), CRS using ASM.
• Upgrade/Migration of Databases from Oracle 9i to 10g and 10g to 11g, Cross platform migration from different platforms.
• Experience in Upgrading database 10.1 to 10.2 and applied patch set 10.2.0.2 to multiple databases. Applied CPU patches and worked closely with Oracle.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM
• Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering targetdatabase with the Catalog. Created scripts for automation of jobs.
• Managing Hot and Cold Backups, Exports, Imports and RMAN.
• Refresh the test and development databases from the source production databases on a regular basis using export/import utility.
• Successfully maintained multiple databases. Implemented Grid Control for managing databases.
• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues.
• Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.
• Worked with developers to diagnose database related application problems, provided development Support to maintain application schema and distribution of data.
• Involved in capacity planning and resource planning and datacenter maintenance activities.
• Generated weekly performance reports to identify and solve the problems with performance.
• Implemented PL/SQL stored procedures, triggers to monitor the performance of Oracle databases using TOAD.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Responsible for data integrity, user security, daily monitoring for production and non-production systems. Used standard, value-based and FGA auditing.
• Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuild, materialized views refresh, db exports and janitorial day-to-day tasks.
• Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility. Wrote Shell scripts for Alerts, ORA-errors, backup and recovery, Import and export procedures.
• Provided 24*7 Production Support.

Environment: IBM-AIX 5.3 Oracle 9i, 10g, 11g, SM7, RAC, OEM, Data Pump, Diagnostic and Tuning Advisors, Toad, Sql developer, FGAC, RMAN.

Confidential, Wilmington

Oracle DBA

Responsibilities:

• Responsible for upgrading system from Oracle 10.2.0.1 (10gR2) to Oracle 11.2.0.2 (11gR2).
• Performed the migration and upgradation of Oracle databases by using import/export, oracle datapump.
• Installed and Configured Oracle 11g.
• Created database objects like tables, views, indexes and partitions.
• Used Oracle backup utility RMAN to implement Oracle backup.
• Scheduling meeting with the Application Team in different location to gather the information for migration.
• Performed SQL Tuning and database tuning based on reports generated by Run time SQL execution plans, AWR, ASH Reports, Explain Plan and monitor the database performance
• Estimating the space requirements for database growth for next 12 months and availability of Hardware to support the processes.
• Carried out Performance optimization and Query tuning using Statspack, Tkprof and OEM.
• Installed and Configured Oracle Enterprise Manager Grid Control for monitoring several databases.
• Creating Users and Grant/Revoke roles, privileges on database objects and creating database links (dblink).
• Monitoring the Users, Tablespaces, Memory Structures, Rollback Segments, Redologs, Tables, Archived Redologs and Alerts.
• Performed various database migrations, refreshes as per requirements.
• Applied CPU patches each quarter to keep the databases up to date.
• Worked with developers to tune, optimize code.
• Worked with Oracle support to resolve various issues with the database by opening SR’s.
• As a team member, involved in interacting with business users, gathering business requirement.

Environnent: SQL, Oracle 10g,11g,RMAN,Import/Export,Oracle EnterpriseManager,IBM AIX 5.3

Confidential, New York, NY

Oracle Database Administrator

Responsibilities:

• Installation and Maintenance of Oracle 9i, 10g on IBM-AIX and Windows platforms.
• Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Tuned SQL queries & PL/SQL Applications using AWR, ADDM, Statspack and Execution Plans.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• Used for export and import. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using hot backup and Exp/Imp.
• Involved in Data Warehousing, Data Modeling, Database Design and Creation.
• Implemented Informatica Power Center Connect to provide native connectivity to an array of systems, enabling the oracle applications to easily extract and transform the data.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Managed undo segments, processes, memory, online redo log files, data files.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Supported off-hour on call support for database related issues.
• Created logical and physical design, installed and upgraded databases.
• Documented the Standard Processes to follow.

Environment: IBM-AIX, Windows 2003/NT, Oracle 9i, RAC, TOAD, Informatica, RMAN, Data Pump, Diagnostic and Tuning Advisors, Erwin.

Confidential . Hartford, CT

Oracle Application Database Administrator

Responsibilities:

• Created procedures, functions, packages, and triggers using PL/SQL.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Involved in the Design (Logical & Physical) and maintenance of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Oracle database administration on Solaris platform.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using EXPLAIN PLAN for the Better performance.
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles, Space management
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Environment:Sun Solaris 2.6.8, Oracle 9i, Oracle 8i Oracle Forms 4.5, SQL, PL/SQL, RMAN, External Tables, Export/Import, and TOAD

Confidential

Junior Oracle DBA

Responsibilities:

• Developed data flow diagrams.
• Involved in database Tuning using init parameters, optimizing rollback segments, redo log configuration, and I/O distribution.
• Tuning of I/O, which includes separating data files and redo log files on different locations, separating of data files and index files on different locations, reducing disk contentions.
• Creation of Table spaces, tables, users, roles in Oracle.
• Security administration i.e. managing privileges and roles
• Backups and Recovery i.e. exports/imports, hot backups and cold backups, etc.
• Space Management, which includes table space creation, adding new data files.
• Involved in Analysis of accounts department requirements.
• Creation of tables, indexes, constraints, procedures, functions and packages based on the design.
• Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping for Bank statements transactions data with Bank master.
• Written triggers to enforce integrity constraints.
• Implementation of Cold and Logical backup and recovery procedures.
• Involved in user management by assigning appropriate roles and profiles.
• Managed physical and logical components of database.

Environment: SQL*Plus, Windows-NT, Red hat Linux, Oracle 9i.