SUMMARY

• Over 6 years of IT experience in Oracle (7.x, 8.0.5, 8i, 9i, 10g, 11g) 10g RAC, streams, data guard, installation, migration, designing, backup, recovery, scripting, performance tuning etc. spanning banking and financial industries in variety of environments like UNIX, LINUX, (Solaris, Ubuntu, Red Hat Enterprise), Windows NT 4.0/2000/2003 in production as well as development databases.
• Proficient in Installation, Configuration, Maintenance and Tuning of Oracle 10g/ 9i / 8i and RAC on AIX 5.3, Windows, UNIX, Solaris 8, 9 and 10 platforms.
• Expertise in Implementing of Real Application Cluster (RAC), Automatic Storage Management (ASM) using Oracle 10g R2.
• Implemented Backup & Recovery strategies using RMAN and Hot/Cold backup for Oracle 10g/9i/8i databases in Windows and LINUX environment.
• Configured physical standby database for high availability and disaster recovery. Experience with switchover and failover process for planned/unplanned outages.
• Experience with the Flashback (database, table, and query) features of the oracle databases (10g, 11g).
• Good Knowledge of Autosys, SqlBackTrack and Rman for taking backups and handling recoveries.
• Expert in SQL* Loader, export/import and data pump import to load data in to tables.
• Experience in database reorganization regularly for removing row migrations and fragmentation using export and import utilities. Taking care of tablespace related issues like increasing the storage parameter values, resizing the datafiles, adding new datafiles etc.
• Willingness to participate in a highly productive, team - oriented environment
• Exceptional interpersonal communicator who effectively interacts with clients at all levels of management
• Decisive, energetic focused team leader / player who lead high-performing teams through implementing change and improvements.
• DBA support for multiple production, Staging, development, QA and test environments.

TECHNICAL SKILLS

Database: Oracle 10.2.0, SQL Server

DBA/Dev tools: Import/export, expdp/impdp, iSQL* Plus, DTS, Oracle Enterprise Manager, SQL, RMAN, TOAD, SQL*Loader, SRVCTL, SQL Navigator

Servers: Sun- Solaris (E-250, E-3000), HP -9000 servers

OS: MS DOS, Windows- 95/98/2000/2003, Windows-NT 4.0, HP-UX 10.x, 11.x Sun Solaris-2.5, 2.6, 5.10 AIX 5.1, 5.2, 5.3, Mac OsX

Third Party Tools: Quest Software (Shareplex), BMC SQL-Backtrack, BMC-Patrol, Autosys, QUEST Foglight systems

PROFESSIONAL EXPERIENCE

Confidential, NJ

Senior Oracle DBA

Platform: UNIX, Sun Solaris, AIX

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle 9i, 10g, 11g databases
• Installation, maintenance and tuning of Oracle 10g RAC databases including ASM and CRS.
• Responsible for applying Oracle CPU patches on regularly basis.
• Migrated standalone databases from 9.2.0.8 to 10.2.0.4 with Real Application Cluster (RAC) and ASM in SOLARIS environment
• Planned, coordinated and migrated databases from 9.2.0.8/10.2.0.4 to 11.1.0.7
• Maintaining the Oracle 10g RAC 2 Node cluster
• Configured ASM and Maintaining ASM Disks, Diskgroups, Instances
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile
• Configured RAC Physical standby database for RAC primary using ASM filesystem
• Export / Import, Data pump utility, to refresh the data at table/schema level.
• Having experience of Switchover and Failover, Successfully completed DR (Disaster Recovery) test.
• Configured Dataguard broker to switchover databases from PROD to COB.
• Cloned UAT databases from PROD using Rman Duplicate command.
• Configured/Implemented Flashback database to rollback database during COB TEST.
• Configured/Installed SqlBacktrack 6.6.00, and tested Netbackup restores for all Prod databases as a Proof of Concept.
• Restored Table using Logical extraction from SQLBackTrack backup.
• Handling Partitioning Maintenance activity which involves adding new partitions, backing up old partitions using exp/imp and loading to tape, and dropping same.
• Re-organized the data by moving tables to Direct-IO tablespace to remove fragmentation in the database.
• Worked on import/export, export data pump/import data pump and SQL- loader
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck.

Confidential, NY

Senior Oracle DBA

Databases: 50 databases, Size varying from 3GB-4TB

Responsibilities:

• Installed Oracle Database 10g with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment
• Configured RAC Physical standby database for RAC primary using ASM filesystem.
• Configured multiple standby databases for a single primary using ASM Storage filesystem.
• Implemented Flashback database to rollback database during Disastor Recovery.
• Installed and Configured Oracle OEM Grid for the monitoring of production and development databases
• Having experience of Switchover and Failover, Successfully completed DR (Disaster Recovery) test.
• Data migration between environments using Export/Import, expdp/impdp, Transportable Tablespace, and Oracle Streams
• Configured database services using DBCA.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Worked on creation and deletion of RAC resources like listener/instance and database.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall
• Involved in Data Modeling along with PL/SQL developers to optimize the flow of data.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck.
• Involved in tuning Transaction intensive servers under OLTP situations (I/O bottlenecks, SGA, Pinning objects, Sort space, literal sql, Redo logs)
• Created Shell scripts to monitor tablespace and ASM filesystem usage.

Confidential, NY

Senior Oracle DBA

Databases: 100 databases, Size varying from 3GB-6TB

Responsibilities:

• Installation of (Server/Client) 10.2.0.3 on Solaris, HP-UX
• Installed and configured of Oracle 10g RAC (Real Application Clusters) on Solaris 10.
• Planned, coordinated and migrated databases from 9.2.0.6/9.2.0.8 to 10.2.0.3
• Export / Import, Data pump utility, to refresh the data at table/schema level.
• Data Refresh using Transportable tablespace.
• Having experience of SAN/NAS filesystems, implementing it using soft links.
• Having experience of Switchover and Failover, Successfully completed DR (Disaster Recovery) test.
• Setup, Configured Oracle Data Guard using physical standby database
• Created, maintained, and monitored the Standby Database (contingency site)
• Cloned the instances from production to Test, Development instance using Rman restore, export/import
• Tuned database performance with AWR / V$ views, ADDR reports.
• Involved in Modifying/Creation of Shell scripts to automate the backups of the database using rman.
• Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing oracle processes and increasing SGA overall
• Advised developers confidently using Explain plan, TKprof and identifying the Execution plan in tuning queries, using Indexes, partitioning, hints etc
• Performed daily alert log files, trace files check, and general data consistency & data integrity check. Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) and avoided it
• Involved in Data Modeling along with PL/SQL stored procedures/packages and triggers.

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle on local/Remote Servers.
• Database design, capacity planning.
• Database creation/cloning.
• Creating primary database storage structure, tablespaces, Adding datafile to the tablespace
• Space Management, Users Management, Roles, and Privileges etc.
• Installed, upgraded, trouble-shoot, applied patches of oracle Software and databases from 8.0.5, 8.1.5, 8.1.6 to 8.1.7
• Backup -- Cold/Hot/incremental Backup manually, using utilities, exp/imp.
• Database recovery (complete/incomplete).
• Monitored, tuned database performance, modified db configuration using utlbstat, utlestat, statspack, Instance Monitor
• Setup/maintained standby database as part of fail-over solution, Standby database creation and Maintenance.
• 24 X 7 Production support.
• Writing Shell Scripts for DBA activities.
• Writing PL/SQL stored procedures, functions, packages, and triggers.
• Monitoring and optimizing performance of database.
• Monitoring databases for fragmentation & correcting the same.
• Tuning of databases for consistent performance.
• Interface with Oracle worldwide support.