SUMMARY

• Over 8+ years of IT experience in Oracle (11g/10g/9i) as Database Administrator.
• Hands on experience in working on various platforms like Unix AIX, and Windows (NT/98/2000/XP/vista).
• Proficient in SQL, PL/SQL with 3 years of expertise.
• Hands on experience in various stages of System Development Life Cycle (SDLC)..
• Over 6 years of experience working with Data Guard for performing database upgrades, Cross platform migrations and Replications.
• Knowledge of theData Guard installation, configuration, troubleshooting DG issues
• Performed cross - platform migrations(Oracle 9i- 10g - 11g) from multiple databases’s.
• Hands on experience in Oracle Database Administration activities such as production support,Database design, Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup and Recovery,
• Hands on experience in Cloning, Space Management, Database Security, Auditing, Troubleshooting,TAR/SR Support and Documentation. Advanced Queuing.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.
• Hands on experience in implementing security policies at user level and database objects level. Experience in applying oracle patches for DST, Upgradation and migration of databases.
• Experience in configuring Automatic Storage Management (ASM) to administer the oracle related files. Upgrading and Migrating of the Databases.
• Hands on experince in Oracle High Availability features.
• Planned and implemented Disaster Recovery (DR) & high availability solutions using Standby Databases, 9i,10g & 11g Oracle Data Guard.
• Design and implement database backup and recovery procedures using RMAN.
• Strong experience in using SQL developer, SQL*Loader, Exp, Imp, Datapump (Expdp, Impdp), Putty, TOAD, Oracle Enterprise Manager (OEM), SQL*Plus tools.
• Strong Knowledge of creating Tables, Indexes, Views, Materialized views, Synonyms, Delinks, Packages, Procedures, Functions, Cursors, Triggers.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using 10g OEM Grid Monitoring. Involved in Unit Testing, System Testing and supported User Acceptance Testing.
• Extensive performance tuning experience, specializing in SQL Tuning, Database/Instance Tuning, STATSPACK, TKPROF, SQL Trace and Explain Plan.
• Hands on experience in tuning the database objects to resolve the row chaining, row migration and fragmentation.
• Writing scripts to automate the jobs (Backups, exports and imports, archiving old records). Implemented Data Guard for data migration and data transfer
• Scheduling jobs through Oracle Job Scheduler, Crontab (Unix), Scheduled Tasks (Windows)
• Strong ability to handle multiple projects simultaneously through completion and ability to work independently or in a team environment and ability to function successfully in a highly stressful environment.

TECHNICAL SKILLS

Operating Systems: IBM AIX 4.x,5L, and Windows NT/2000/XP/2003/2008.

RDBMS: Oracle 9i, 10g, 11g

Database Servers: HP 700 Series, HP Superdome, Sun 3500, 3800, 6800, Sun Enterprise 450, Oracle Application Server 10g, Sun Fire V1280, Dell PowerEdge T100, Sun fire 4800, and others.

Languages: SQL, PL/SQL, Java, C, C++, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, ETL Sql Developer, Sql Navigator, Toad, DataPump, Data Guard, Oracle Streams, TOAD, Shareplex

Tuning tools: EXPLAIN PLAN, STATSPACK, SQL*TRACE, AWR, ADDM

Others: EMC, NetApp, Veritas NetBackup, IBM Tivoli, HP back up.

PROFESSIONAL EXPERIENCE

Confidential

SR Oracle DBA

Environment: Windows, AIX, SQL, PL/SQL, Oracle 9i/10g/11g, OEM Grid Control, Data-Guard, SQL SERVER, Scripting, TOAD, Dataguard, OEM, Oracle Streams.

Responsibilities:

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Installed High Availability database solution like physical standby databases.
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR) of databases.
• Hands on experience working and managing VLDB’s up to 1TB.
• Performed cross platform migrations from Oracle 10g to Oracle 11g ( AIX/Windows 2008)
• Installed OEM agents and monitored them timely.
• Replicated databases and Data Guard for reporting purposes in OLTP environment with minimum lag.
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR) of databases.
• Hands on experience in shell scripting for dataguard monitoring, purge alert logs, trace files,
• Proficient in migrating data base from 9i/10g to 11g by applying latest patch sets.
• Maintained Production databases.
• Implemented zero downtime migration and upgrade of 10g to 11g database.
• Implemented Oracle advanced security across various database levels.
• SQL*Loader; and Unix scripts to download and manipulate files
• Developed and performed the quality assurance activities and unit testing.
• Proficient in Oracle Materialized view replications.
• Used Data guard for data migration from various database’s.
• Installation and maintenance of Oracle 11g database.
• Implementing 10g Data guard with one physical database
• Developed Hot, cold and logical backup scripts to automate the backup procedures.
• Replicated databases using Oracle Streams for reporting purposes in OLTP environment with minimum lag.
• Involved in team management, team building and lead the DBA team.

Confidential, Los Angeles, CA

SR Oracle DBA

Environment: Windows 2003, SQL, PL/SQL, Oracle 9i/10g/11g.

Responsibilities:

• Implemented Oracle advanced security across various database levels.
• Data migration and data distribution.
• Involved in administration of Oracle 9i/10g R2 instances.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases
• Monitoring database events as part of a Production support and level 1 staff.
• Experienced with RMAN, BACKUP and RECOVERY, POINT-IN-TIME RECOVERY (PITR) of databases.
• Performed cross platform migrations from Oracle 9i to Oracle 10g ( Solaris-Linux)
• Proficient in migrating data base from 9i/10g to 11g by applying latest patch sets.
• Maintained Production, Development, Quality assurance database (QA) and Test databases.
• Managed production and development databases timely.
• Used Data guard for data migration from various database’s.
• Installation and maintenance of Oracle 10g database.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Involved in the process of tuning and refining queries of various applications.
• Implementing 10g Data guard with one physical database
• Converted a single instance database to Oracle RAC 10g.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Extensive usage of ADDM, AWR, ASSM, features of 10g.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Restoration and recovery from backup.
• Cloning of application from production environment to test environment and application of patches.
• Moving data from development to production through transportable tablespace exports.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Implementing standby database and database replication to provide high availability of database.
• Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Monitoring of database performance using STATSPACK
• Experience in SQL*Loader, loading data from text files.
• Involved in team management, team building exercises for the DBA team.

Confidential

Oracle DBA

Environment: IBM AIX,Win NT, 2000, 2003, SQL PL/SQL, Oracle 10g, 9i and Oracle 8i,Oracle Application Server 9i,10g, RMAN, Sybase Adptive Server, MS SQL 2000, 2003,2005.

Responsibilities:

• 24 X 7 Production Oracle database support and administration and on call rotation.
• Installation, Configuration and Administration of Oracle 10g databases includes Database cloning for test environment and applying patches, tuning etc.
• Hands on experience working for replication of databases
• Performed cross platform migrations for Oracle.
• Implemented zero downtime migration and upgrade of 9i to 10g database.
• Backup and Recovery, Setting up and testing the backup and recovery strategies.
• Oracle Database and SQL tuning using STATSPACK, EXPLAIN PLAN, TKPROF etc…
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Diagnose and troubleshoot Database problems and failures
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases
• Involved in administering Oracle database running on Unix and Windows Machines to support Oracle database.
• Involved in the installation of Oracle 10g, on Windows NT and Linux.
• Performed various database refresh’s, patching, upgrading over the databases.
• Storage and space management including table spaces and data files.
• Setting up and maintaining user accounts and profiles
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Oracle database administration on Windows platform.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Setting up and maintaining user accounts and profiles
• Space management and Partitioning of specific tables.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments)
• Coordinating with various QA, development and Win/unix teams periodically in handling multiple projects
• Building disaster recovery solution for the bank from secrach using mainly Physical standby option and Oracle Data Gurad
• Sybase administration on Aix and Migration through Sybase Reengineering tool to Windows server.

Confidential

Database Designer

Environment: Win NT, 2000, SQL PL/SQL, Oracle 9i and Oracle 8i, MS SQL 2000, 2003,2005.

Responsibilities:

• Database administration and designing, and Migration through 3rd party tool on Windows server.