PROFILE

Hard-working and enthusiastic with extensive Oracle DBA experience including five years as an Core Oracle DBA at General Electric (GE). Experience included providing support to over 100 Development, Test and Production Databases including critical Production Financial Databases comprising of complex and challenging Unix, Linux, Solaris, Windows environment in Oracle versions 8i, 9i,10g and 11g. Extensive technical knowledge on Database Migrations, Installation, Upgrade, Reorg, Cloning, Patching, Unix and PERL Shell Scripting, RAC, Dataguard, RMAN, Performance Tuning, EMC,Proactive Database monitoring, Performing routine Health Checks, Automating scripts and DBA Tasks, Capacity Planning, Database Backup and Recovery.

EXPERIENCE

Confidential– Albany,NY US
Senior Oracle Core DBA -- 02/2008 – 04/2009
Responsible for providing DBA support for multiple large databases in production, development and test environments. Part of a 16-member DBA team managing 30 production databases and over a 100 development & test databases with databases sizes varying from 50 GB to 550 GB.

• Developed UNIX shell script as part of a LEAN Project to automate the process of Export-Import.
• Automated space estimation based on database growth.
• Installed and Migrated databases to 11g
• Worked on installing Grid Control, configuring email alerts etc
• Developed UNIX Shell Scripts and SQL Scripts to perform database checks.
• Configured scripts to log Backup Information of all databases in to a single database as part of a LEAN Project. Developed Automated generation ofsummary report of these backups to be sent to the team’s distribution list as a HTML report.
• Familiar with Internet Protocols like SMTP, TCP/IP, XML, Proxies, etc
• Implemented RAC on 9i and 10g Databases on Unix,Linux and Solaris environment.
• Developing and Testing Production utilities
• Good knowledge of Dataguard. Worked on configuring Logical and Physical Standby Databases.
• Involved in maintenance tasks like bouncing production databases, services through Veritas.
• Performed regular Database Administration activities which involved - Database Upgrades from 8i to 10g, Installation of Oracle Software, Cloning Databases, Database Reorg and Backup and Recovery.
• Fine tuned Memory, I/O and Database Objects.
• Implemented Disaster-Recovery techniques
• Worked extensively on Autosys in configuring ,deleting, preparing and editing JIL for jobs, moving jobs in Crontab to Autosys.
• Performed SQL tuning by using Explain Plan and Tkprof.
• Mentored in-house DBAs to assume higher levels of responsibility.
• Analyzed Database Performance based on Statspack and AWR report results
• Comfortable using Database tools like Golden, Putty, Toad, Net term

Confidential 
Senior Oracle Core DBA -- 09/2005 – 02/2008
Part of a 8-member DBA team providing DBA support for very large databases in both OLTP and Data warehouse. Managed 40 production databases and development & test databases of varying sizes from 70 GB to 1.8 TB.

• Reclaimed over 30(GB) space in a Database Reorg in one of the most critical databases.
• Handled Disaster Recovery scenarios.
• Upgraded several databases – both release and version upgrades.
• Handled Database Installations (all versions upto 10g).
• Cloned databases with various strategies like Hot, Cold, Logical methods and RMAN.
• Involved in providing technical assistance to developers in all matters concerning performance application related issues.
• Resolving issues faced by Application team by giving resolution details and root cause analysis. (RCCA)
• Responsible for Online/Offline database backups and managing Database recovery with RMAN.
• Worked with Oracle Support during ORA-600 and ORA-7445 issues.
• Responsible for storage management - Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Configured scriptsin Crontab forProduction Environment
• Alert monitoring and resolution.
• Design, Install, Tune and Monitor Oracle databases
• Extensively used Tivoli Storage Manager(TSM) and NetBackup
• Monitor and optimize the Performance of the database

Confidential 
Oracle Core DBA -- 03/2004 – 09/2005
Provided Oracle Core DBA support to GE Oil and Gas databases as part of 3-member team.

• Involved in creating Databases, Tables, Tablespaces, User logins, and Passwords as per SOP
• Involved in Schema refreshes.
• Applied quarterly CPU Patches.
• Resolved listener and tnsnames.ora issues.

Confidential 
Oracle Core DBA -- 08/2003 – 03/2004
Involved in providing Oracle Core DBA support for 6 GE Aviation production databases and 15 development & test databases as part of a 4-member DBA team.

• Responsible for storage management - Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Configured scriptsin Crontab forProduction Environment
• Alert monitoring and resolution.
• Configured several jobs in Autosys

EDUCATION

Confidential University

Bachelor of Engineering, Electrical Engineering and Electronics

AWARDS AND ACHIEVEMENTS

• (2006) - Oracle 9i Certified Associate
• (2008) - Oracle 10g Certified Associate
• (2005-06) – Awarded Best Employee of the Year for GE, India
• (2007) – Awarded Best Mentor of the year for GE Plastics
• Worked on a project to streamline all our backups to log to one single database (Central Repository). This project involved trouble shooting backup related issues and working on centralizing all our backups. This was one of the most efficient LEAN Projects in GE which was later implemented in all other businesses.
• Innovated automated space estimation based on Database growth which served as proactive measure personally appreciated by client and later implemented across various other projects.
• Worked to recover 12 production databases over 3 continuous days during a Disaster Recovery in Cincinnati.