Professional Summary: 
Technical:

• Over 15 years in IT Industry
• Worked in all stages of the development cycle.
• Over 10 years as Oracle DBA for Oracle 7,8,8i,9i,10G,11G(with ASM and RAC) on different latest platforms such as Solaris-UNIX, HP-UNIX, AIX,Windows-NT, EMC Disk suit and HP-SAN, Hitachi disk array .
• More then 6 years experience as a Sr. Architect and PL/SQL developer on a variety of applications
• Set up streams (10G feature) and Advance replication (9i)in multinational organizations.
• Trained staff for streams and Advance replication.
• Superior understanding of logical and physical design.
• Exceptional experience writing system specifications, system study, analysis and design using various tools
• Experience in corporate multinational environment
• Expert in Disaster recovery planning.
• Currently Using new technologies like Real Application Cluster(RAC), replication with Streams and Data Guard for Disaster recovery solutions.
• Worked and working on VLDB with multi terabyte Databases.
• Full migration experience from 8i to 9i to 10g and 11G,
• Also converted single instances to RAC.
• Expert in backup and recovery and performance tuning.
• Expert in table Partitioning.
• Merger-Integration experience.
• Development and operations both experience.
• Worked on virtualization.
• ITIL Certified

Technical Proficiencies

RDBMS: Oracle 11G R2 (RAC and stand alone Databases), Oracle 10G (10.2.0.4)(including RAC and CRS), 9i, 8i, Oracle 8, Oracle 7. Informix 7, Integra-IV, SQL-Server 2008, 2005. Worked on multi TB Databases. GUI Tools: Oracle Enterprise Manager(web version), 10G and 11G Grid control , 10G and 11G RAC with Automatic Storage Management (ASM), Oracle Performance Manager, Replication Manager, DBA Studio, SQL-Navigator, Designer 2000, Developer 2000, TOAD, Database Configuration ManagerComputer Languages: SQL,PL-SQL,RMAN scripts and unix shell , Perl scripts.Operating Systems: UNIX, WINDOWS, Novell, Linux, Application tier : Worked with JAVA,Weblogic,Websphere,TUXEDO and  Oracle Application Servers. Hardware: Sun Solaris (E25K)- Veritas file systems(VXFS), HP, Simens, EMC ,HITACHI and HP SAN, AIX,DELL servers, Worked with Patabyte storage.
Networking : Worked with TCP/IP, IP and several protocols.Managerial Experties: Motivated team, Building and merging teams (like EMC and SIRI XM), get the things done. Grant bonuses per performance, promoted right talent. Performance appraisals. Bonus assignments. Hiring, Budgeting. License negotiations. Negotiations with vendors. Project and task assignments, Technical guidance to the team. Retaining staff. Remotely managed teams and Databases.

Professional Experience:

Confidential: (Feb 2011-Present)
Platform Lead .
Confidential is well known non-profit organization. Currently we are migrating from old NBCS(National Blood Collecting System) to a new system which will satisfy all FDA requirements. My role is to install and support all QA, Development and to be production Databases. We are using 11GR2 grid infrastructure. Also make sure SAN is worked properly and allocated properly to different Databases and Weblogic instances. I work with backup team to make sure backups are maintained properly and are available when required. I’m working on disaster recover process and make sure application can failover to DR site when reqired. Installed 11 GR2 on IBM and Linux platforms. Using streams technology. Help development team and Data Migration team for all their technical issues. Participated in technical of software reviews fro Db perspective.

Confidential: (March 2010-Jan 2011)
Sr. Technical Manager: 
Confidential merged together to become leading organization in Radio services. After that the MI activities took the speed and my role was to guide DBAs from technical operations perspective needs and to support development and QA staff / developers and testers. We have a Data Center in Washington DC. There are several high visibility projects are going on related to MI. Moving Datacenter from NJ to DC and merging all applications. SMS(Subscriber Management SYSTEM) is the biggest and most complex amongst all the application. With about 30 TB data. I’m leading 12 DBAs from different locations (NY, Rochester, CA, DC). I’ve two teams one for SQL Database support and one for Oracle DB support, Also I work closely with Windows support team , UNIX system administrators and Storage team to make sure storage is allocated properly to the Databases and to the applications. For MS-SQL we are migrated to sql-2008 cluster. For Oracle we migrated to 11GR2 RAC and ASM. Also my responsibility is to make sure backups are running correctly and work with backup team. Designed and supported Sirius and XM application merging project for several applications like Portal and Siebel, Order Management etc.
Technical: 11G RAC technology implemented, Disaster Recovery planning , design and implementation. Set up Golden gate for Databases. Total Database size is 400 TB, with multiple disk arrays. Worked with storage on assigning and defining storage requirements up to several petabytes. We use ASM technology for Database storage. Designed and built DR site. Managed alerts and remedy queues for the team. Worked on reducing monitoring alerts, worked with development team to design and implement solution for the data migration activities. Worked on performance issues faced for development teams. Also defined tools to support development and production support staff. Resolved issues for BCV split mirror and helped storage team to shadow copy databases easily and effectively. Designed solution for refreshing Databases via both split and rman to refresh Databases from production to Development and QA. Supported successfully PCI and SOX audit, supported and passed compliance reviews successfully for Database and system / OS audits. We support SMS (Portal and Siebel) application.

Confidential: May. 2007 June-2010 
DBA Manager
Confidential is well know for it’s storage devices.
Confidential is well known for IT security aspects. RSA is EMC’s security division.

I’ve two teams to manage one in Israel and one in US. Each team has 4 DBAs.
Environment consists of SQL and Oracle Databases.
We support customer facing applications Knowledge based authentication and Token based authentications etc.
As a DBA manager I’ve to manage teams on-call rotation, assign tasks, prepare and manage budget. Manage Oracle licenses. Also decide on the strategies like backup, help Directors in future growth and planning and budgeting for the entire technical operations. Plan disaster recovery operations. Plan and support high availability environments Manage on-call schedule.
Plan release deployments. 
There are multiple applications to support. We have RAC and streams used effectively to achieve 99.9 SLA for the Database. The transfer of data is every 15 seconds between 2 sites.
We have nine data centers distributed across Europe and North America.
Technical:
Streams setup and maintenance. 
Working on different security applications token based and knowledge based.
Create and Maintain RAC with 2-3 nodes in Linux environment, streams replication is used 
for DR purpose and deployment of releases. Monitoring thru Grid control.
Define strategies for database monitoring and implement them.
Currently we are working on the companies to merge with RSA which are taken over ,VERID in USA and Cyota in Isreal and passmark in CA.
Standardizing all technical aspects of the Database across RSA.
Created logical and physical and logical standby Databases.
Created centralized monitoring thru Oracle management servers and defined what and how to monitor within Databases and clusters.
Defined and executed strategy for centralized backups for VTL.(Virtual Tape Library)
Helped Application developers in Performance tuning of SQL statements.
Performance tuning Databases.
Monitor SLAs for the organizations.
Define quarterly goals for the team.
Worked on all kinds of HW including Sun E10K, Sunfire / Dell/HP../ used most OS like Sun , Linux etc.
Disk arrays on worked are EMC, Hitachi, HP.

Confidential
July-2005 – May 2007
Lead 10G Database Administrator
Confidential is the largest in paper industry world wide.

• Lead Oracle 10g DBA consisting of 6 Oracle DBAs and 3 SQL DBAs
• Provided Technical guidance to all DBAs,
• Guide DBAs to/how to resolve all production issues as well as to define direction of monitoring.
• Established monitoring system using 10G grid control
• Support production Databases with on call rotation
• FLEXNET is the first application with over 70 Databases going to be monitored remotely with servers located in field
• Implementing RAC to reduce the cost of hardware
• Implement Streams replication for disaster recovery.
• Trained staff for RMAN backup and recovery, OEM monitoring, streams replication.
• Moved scores of databases from Oracle 9i to 10g. (10.2) RAC environment.
• Using LDAP for scalability
• Centralized procedure and monitoring for backup and recovery thru grid control
• Monitoring SLAs for production, development and QA Databases thru grid control
• Installed, Used and monitored 10g CRS (cluster ready services) to save cost of Veritas cluster.
• Created RAC Databases using ASM(Automatic Storage Management)
• Used HP SAN and EMC for RAC cluster and stand alone Databases.
• Recovered successfully part of production and full production database in time.
• Wrote and monitored SLAs for remote applications and local applications.
• Wrote DR solutions for remote and local applications based upon business needs and SLAs(Used replication , data guard , remote archiving , BCV splits and RAC to achieve the goals)
• Implemented Grid Control solution for monitoring all DBs for the company, also added self healing for some cases.
• Planned and implemented Oracle upgrades to minimize the production outages.
• Saved money by doing consolidations of Oracle Databases on to one server.

Confidential
Jan. 2001 - Sep. 2005
Sr. Oracle Database Administrotor
This company provides and maintains networking services to the worldwide customers.

• Lead team of DBAs and developers
• Create Databases
• Apply patches, Maintain production , QA and Development of all Databases
• Install new application releases
• Migration to Sun E10K from Siemens m/cs and 8.0.5 to 8.1.7 Oracle upgrade
• Migration from 8.1.7.4 to 9.2.0,6 Meta release planning and co-ordination between Canada, France, UK and USA teams
• Replication management, Replication error resolution, reverse engineer replication for all systems and setup and implement replication
• Performance monitoring:
• Check wait events inside DB
• Find out the queries performing poorly
• Analyze and suggest changes
• Monitor the SGA usage and tune the parameters if necessary.
• Backups:
• Used Legato and Reels for backup with RMAN
• Write pre and post scripts for backups
• Coordinate with S.A.s and monitor backups
• Coordination of different teams at different locations worldwide during releases
• Minimize downtime during installations and new releases
• Support QA and UAT phases
• Currently lead for disaster recovery and 7x24 availability for Clarify trouble ticketing system
• Using Streams and Data guard
• Production DBA to maintain OPER (Reston and Frankfurt) databases
• All the systems interact with these two database which are replicated in Reston (USA) and one in Frankfurt(Germany)
• Implement advance replication for 14 groups and to resolve all replication issues
• Database security, Recovery
• Install new releases in QA environment and production (Size 50GB. OS : Simens- reliant UNIX)
• Plan the strategy and choose the best method for migration which will minimize the downtime. Tune the queries.
• Successfully migrated to SUN E10K and Oracle 8.1.7 and the down time was minimal during this
• Migrated to Oracle 10g Database

Confidential 
Sep. 2000 – Jan. 2001
Sr. Oracle Database Administrator
ChamberBiz is a company formed by joint efforts of US chamber of commerce and Telcom Ventures. This was a portal designed for small businesses.

• Oracle 8.i Database running on Sun Solaris 2.6
• Creation of instances, maintaining database, backup strategy, and recovery documentation
• Solely responsible for the performance and health of Database, security, and user maintenance.
• Planned, tested and implemented advance multi master replication
• Planned and tested standby database creation of:
• Production Database support
• Development Database support
• Work with developers and production support personnel to create new database objects and solve database related problems
• Monitor tablespace storage on all instances (production, staging, dev, and prod support)
• Monitor archive logs on production database
• Monitor and maintain Oracle Net8 network environment for all instances
• Move all database changes from dev/test and production support during all new releases
• Maintain and monitor the Listeners on all database instances
• Create and distribute tnsnames ora files for clients and app servers
• Monitor alert logs on all database servers
• Install client side Oracle software on developer machines and application servers
• Install and upgrade Oracle Enterprise Database Server as required
• Modify the Oracle instance initial parameter file as required
• Reboot the Unix servers when required
• Create and run ad hoc queries when requested
• Monitor database performance and make necessary changes
• Backup and Recovery of the Database

Confidential 
Feb. 2000 - Aug. 2000
Sr. Oracle DBA
The project was to combine data of both company companies into Oracle Database of AS400 telephone system.

• Install and tune Oracle database on NT machine
• Design and develop schema common for both systems viz:cable and telephone
• Write procedures for updating the data from cable and telephone systems into new schema
• Transfer this data to other systems, which in turn will talk to automated customer inquiries
• Automate the data updating procedures
• Write procedures for backup and recovery
• Add procedures in automated Window NT's AT jobs
• Tuning the database
• Tune IVR inquiries
• 7x24 production support
• Check for the data consistency
• Maintain multiple databases
• Define and implement backup strategy for the databases

Environment: Windows NT Servers. Oracle 8, Sybase Power Designer (for logical and physical Schema design).

Confidential 
Jan. 1999 – Jan. 2000 
Sr. Oracle DBA
Under the production support DBA group there are several systems for telephone billing as well as new order requests. The systems with oracle backend are TSOSRP, TLF, LIFE,BLISS,ECIP-III as a primary DBA.

• 24x7 support
• Replicated servers using RAID technology
• Define standards for database performance to monitor the performance of the database and to improve it.
• Monitor growth of the database and take appropriate action in advance
• Solve any problems related to database and minimize the downtime
• Backup and Recovery
• Create and test reliability of standby database server (Texas Local Factory)
• Install software version releases
• Assist software development team in optimizing the SQL queries
• Write scripts and cron jobs for monitoring the Database
• Upgrade/Install the Oracle versions
• Assign the exact storage clauses to database objects and to distribute them correctly across tablespaces
• Create and maintain users and security to pin the more frequently packages and procedures into memory.

Environment: Oracle 7.3.4,8.0.5.1 HP UX10.2, Sun Solaris 2.6

Confidential 
Jan. 1998 - Jan 1999
Sr. Oracle DBA

• Backup and recovery
• Assure system Y2K compliant
• Maintaining the production and Development Database
• Tuning the production database for optimum performance
• Solving all database related problems as well as programming problems. Write cron jobs to monitor the database
• Writing PL/SQL scripts in triggers and packages
• Assigning the tasks to system analyst and programmers
• Providing technical solutions to programmers and analysts
• Technical coordination between testing, development and configuration management teams
• Planning and coordination of new software releases with government persons

Environment : Oracle 7.3 (UNIX) Designer 2000 ( Windows 95) PVCS ( Program Version Control System)

Confidential 
March 1994 – Nov. 1997 
Sr. DBA and System Coordinator

• Defining standards for the database and system Creating and maintaining tablespaces
• Creating and maintaining schema
• Defining extents sizes of the database objects
• Creating users and assigning the privileges
• Analyzing the tables periodically
• Creating database links
• Perform hot backups
• Recovery from user faults as well as media recovery
• Upload the data from old x-base system into oracle via SQL*Loader

Environment : Oracle 7.3(UNIX), Developer 2000 (Windows 95), Lotus approach (for documentation)

Confidential 
Nov. 1995 - Nov. 1996 
Sr. System analyst and DBA

• Defining standards for the database and system
• Preparing system specification documents
• Creating database and tablespaces
• Responsible for schema of the system (Creation of tables, sequences, views, synonyms, packages and procedures etc)
• Identifying and defining the database triggers
• Imposing the business rules using oracle constraints
• Distributing the load between client(windows 95) and the server (Unix)
• Creating users and assigning privileges
• Giving specifications to programmers and fault finding
• Solving user problems.

Environment: Oracle 7.3(UNIX), Developer 2000 (Windows 95), Lotus approach (for documentation)

Confidential 
Apr. 1995 - Oct. 1995.
Sr. System analyst and DBA.

• Responsible for schema of the system (Creation of tables, sequences, views, synonyms, packages and procedures etc)
• Identifying and defining the database triggers
• Imposing the business rules using oracle constraints
• Creating users and assigning privileges
• Supplied specifications to programmers and fault finding
• Writing the control scripts to load data via SQL*Loader
• Defining and executing the test plan
• Solving user problems

Environment: Oracle 7.3(UNIX), Developer 2000 (Windows 95), Novell NetWare 4.0x, Lotus approach (for documentation)

Confidential
Sep. 1994 - Sep. 1995
Sr. System analyst and DBA.

• Defining standards for the database and systems
• System design
• Schema and scripts of the system
• Writing common procedures
• Distribution of the load between client and server
• Creating users and maintaining users. System specifications and assignment of work to the programmers and fault finding.

Environment: Oracle 7.3(UNIX), Developer 2000 (Windows 95).

Education

• M.S.(Mathematics)
• B.S.(Statistics)
• Post Graduate Diploma in Computer Science
• ORACLE CERTIFIED DBA