SUMMARY

• Around 7 years of professional IT experience as an Oracle DBA in Oracle (11gR2, 10g, 9i, 8i) 11g RAC, 10g RAC, installation, upgrade, designing, backup, recovery, migration, scripting, performance tuning, data guard, golden gate etc. spanning various industries like banking, telecom, pharmaceutical, insurance, financial, retail marketing etc. in variety of environments like UNIX, LINUX, Windows NT 4.0/2000/2003 in production, test as well as development databases.
• Experience in installation, configuration, administration of Oracle 9i, 10g, 11g, 10g RAC, 11g RAC database in Unix/Linux and Windows environments.
• Experience in Real Application Cluster environment (RAC) with ASM and OCFS2 file systems.
• Implemented ASM on RAC and stand alone databases. Managed disk groups using ASM.
• Expertise in troubleshooting Cluster issues in 11g RAC and 10g RAC databases.
• Upgrade/Migration of oracle databases from 8i to 9i and 9i to 10g and 10g to 11g.
• Highly Proficient in applying patch sets to databases and applied patch set 10.2.0.2 to multiple databases.
• Worked on Set up, configuration and maintained Oracle Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.
• High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
• Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Created and managed tablespaces, adding and resizing data files, and performing disk space management.
• Good knowledge in RMAN backups including full, incremental and cumulative.
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning of databases using RMAN.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Excellent knowledge in SQL, PL/SQL, Partitioning, Data modeling with utilities like ER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database Triggers.
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).
• Good co - ordination with UNIX administrators for efficient space management and issues on various servers.
• Implemented automated backup strategy and monitoring of databases using UNIX shell script CRON UTILITY.
• Expertise in overall tuning of Database using Automatic Workload repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) tools and tuning of SQL using STATSPACK, EXPLAIN PLAN and TKPROF.
• Working experience on both OLTP and OLAP environments.
• Experience in using OEM and tools like TOAD and ERWIN.
• Very good knowledge of Oracle Database architecture, SGA, PGA, Background Processes, Listener and TNS Names configuration and Data Dictionary.
• Involved in Disaster recovery planning, execution and testing of production databases.
• Experience as On-Call 24x7 production DBA and application/development DBA and Oracle Support processes for technical requests through ORACLE SUPPORT (Meta link) and other Support Procedures.
• Involved in myriad team meetings and discussions related to Database design, storage requests, software life cycles, implementation, issues, with development teams, other DBA’s as part of strategy and decision making teams.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
• A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS

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

RDBMS: Oracle /11g/11g RAC/10g/10gRAC/9i/8i.

Languages: SQL, PL/SQL, C, C++, XML, UNIX Shell Scripting.

DB Management: TOAD 9.5, Enterprise Manager grid, DBArtisan by embarcadero.

Tools: /Utilities: RMAN, OEM, TOAD, SQL Navigator, Oracle Management Service(OMS), SQL*Loader, ASM, Export/Import, Patch Management, ODBC, Data pump, Data guard, OS Watcher, SQLT VERITAS Net Backup, MS Access.

Tuning Tools: AWR, ADDM, TKPROF, EXPLAIN PLAN, STATSPACK.

Database Modeling: Rational rose, Visio, Erwin.

Networking: TCP/IP, SSH, Oracle Net Services & ODBC.

Hardware Platforms: HP XP256 / XP512, Sun Fire 15K, Sun V480, V240, Sun Fire 6800, Sun Enterprise 6500 / 450, IBM C server p5 model 590, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle Database Administrator

Responsibilities:

• Involved in administering 5 Business critical Production databases and more than 50 development databases of size ranging from 200GB to 2 TB on AIX
• Built 2 Node 11g RAC cluster for production and testing on AIX server Release 6.1.
• Responsible for adding a node to a 4 node Cluster.
• Installed agents on database servers and configured on 11g grid control.
• Setup and configured Oracle 10g/11g Physical Standby database (Data Guard) to ensure high availability, where the standby database was used for disaster recovery as well as to offload the running of huge reports
• Responsible for migrating most of the development 10.2.0.4 standalone Database ranging from 200G to 4TB to 11.2.0.2 and Presented White paper on upgrading 10.2.0.4 databases to 11.2.0.1 to DBA team
• Performed Database Migration from Solaris to AIX using transportable tablespaces.
• Configured Golden Gate for replication of production databases to Reporting Databases.
• Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, constraints, Database Access, Roles and Privileges.
• Extensive use of Data Pump to export and import production data to perform schema refresh and for other testing purposes.
• Based on the oracle recommendation and requests from Chase security division, applied security patches on Business Critical databases. Also applied PSU3 patch sets to fix bugs on the existing systems.
• Reduced production outages by implementing best practices of patch management, purge/archival, code optimization and applied rolling patches such as PSU and CPU on RAC after testing on DEV.
• Cloning of databases using RMAN, DBCA and even manually.
• Recovered data files from block corruption using RMAN.
• Involved in Performance Planning and Tuning by using baselines for AWR and proactive monitoring, bottleneck elimination and the wait event interface to identify issues with respect to performance.
• Very good at analyzing execution plans for queries and making necessary changes to the queries by adding necessary hints to them as suggested to deliver optimum performance.
• Creating user accounts within the database, granting roles and privileges as required in accordance with security compliances.
• Responsible for tuning of long running query’s by creating B-Tree and BITMAP indexes
• Analyzed database performance using AWR, ADDM and query cost using TKPROF, Explain plan.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
• Involved in Database Architecture design and review phase of new applications.
• Follow the Chase policy of process flow in Change Management and other process models.
• Involved in assisting application development team for better optimization of queries.
• Involved in 24x7 production database maintenance and on-call support during the Enterprise Release.

Confidential, Chicago, Illinois

Oracle Database Administrator

Responsibilities:

• Built 4 Node 11g RAC cluster for production purpose on Red Hat Enterprise Linux server Release 5.5
• Installed 2 Node 11g RAC for Test environment as well as 4 nodes RAC for physical standby purpose.
• Installed OEM Agents on production as well as on system test hosts.
• Achieved load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.
• Setting up Data guard to ensure the application is highly available, protecting from disaster recovery and for data protection.
• Analyzed log transport services and log apply services in physical/logical databases using data guard.
• Involved in Performance Planning and Tuning by using baselines for AWR and proactive monitoring, bottleneck elimination and the wait event interface to identify issues with respect to performance.
• Very good at analyzing execution plans for queries and making necessary changes to the queries by adding necessary hints to them as suggested to deliver optimum performance.
• Expertise in Performance tuning of RAC and standalone databases, configuring initialization parameters, shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/Logical IO and Memory Usage.
• Practical application of Oracle 11g new features like Database replay, Transaction management with log miner and Flashback data archive, RMAN’s new features as well.
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
• Performed migration activities like Dev to Test and Test to Production for large databases.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
• Designing and implementing of backup strategy for database like when to perform a full backup, incremental / cumulative and deciding upon timings that doesn’t affect normal processing.
• Used shell scripts for monitoring jobs, for startup and shutdown, health check of databases, analyzing stats at different levels, rebuilding indexes and for purging as well.
• Created, scheduled db maintenance tasks, such as tables/indexes analysis, index rebuilds, materialized views refresh, db exports and imports and even maintaining partitions and their purging as and when required and all other day to day janitorial tasks.

Environment: Oracle 11g RAC,11g, 10g RAC, RHEL 5.5, 4.0,DBArtisan, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM, Erwin r8, MS Access.

Confidential, San Francisco, California

Oracle Database Administrator

Responsibilities:

• Installation, Configuration and tuning of Oracle 9i,10g, 11g and 10g RAC databases.
• Implemented and maintained streams for synchronization of data at various test databases in development.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database, also managed undo and redo in the RAC environment.
• Worked on Automatic Storage Management (ASM) instance.
• Migrated data from windows to AIX, Solaris 10.
• Upgradation from Oracle 9.2.0.8 databases to Oracle10.2.0.3.
• Used shell scripting for RMAN and hot backup and recovery.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
• Improved the performance of database by creating and managing database objects such as tables, indexes, partition tables, index organized tables, material views and views.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Worked on export data pump/import data pump, normal import/export and SQL- loader.
• Tuning the databases for optimal performance using AWR and ADDM.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Implemented Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control 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.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).

Environment: Oracle 9i, 10g, 11g, 10gRAC, Red hat Linux 4.x, Solaris 10, SUN V480, HP-UX11, AIX 5L, Windows NT/2000, Toad 8.6, ASM, Oracle Enterprise Manager, ERWIN 4.x.

Confidential, Foster City, California

Oracle Database Administrator

Responsibilities:

• Installation of Oracle 10.1.0.2 on Sun Solaris as well as Windows Servers.
• Install, Upgrade and configure Oracle database for various 32-bit and 64- bit platforms like HP-UX, Solaris - SUN SPARC & Intel, MS Windows 2000.
• Involved in Design and implementation of oracle 10g Data Guard both physical/logical standby databases in high availability mode.
• Used RMAN for backup and recovery of database.
• Create & Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges. Created multiple Raid levels using volume manager.
• Applying Patches 9.2.0.6 on Oracle database.
• Used shell scripting to automate all RMAN jobs.
• Ran the Oracle AWR tool on the Oracle Instances to find out the System Performance Statistics during the peak load times.
• Enabling the Trace files for the sessions which experience a very bad performance and generate the Trace output using TKPROF utility for further analysis.
• Trace the SQL that have poor performance and identify the ways of improving the performance by adding necessary indexes or removing the unwanted indexes.
• Trace the frequently called procedures/packages and pinning them to improve the performance.

Environment: Oracle 10g/ Release2, Sun Solaris, HP-UX, Windows 98/NT/2000, Oracle Enterprise Manager, TKPROF, EXPLAIN PLAN.

Confidential

Oracle Developer/Jr. Oracle DBA

Responsibilities:

• Wrote Stored Procedures according to technical specification documents.
• Ran many batch procedures for loading data from excel or flat files into oracle tables using SQL*Loader.
• Creation of Table spaces, Data files, Indexes.
• Creating schema objects like Database tables, indexes, views, synonyms, sequences and all schema objects in Oracle.
• Wrote extensive Sub Queries, functions, PL/SQL stored procedures, database triggers and packages.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Responsible for migration of all objects into different test instances like Development, Assembly test, Integration test and production.
• Creation of backup scripts using UNIX shell scripting.
• Planning and implementing user grants, roles and profiles for additional security.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Taking logical backups using export and import tools.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.

Environment: Oracle 8i, 9i, TOAD, SQL, PL/SQL, OEM, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000), SQL*PLUS, UNIX Shell Scripting, PL/SQL navigator, SQL* Loader, Mercury ATG tools.