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 t 9i t 10g and 11G,
• Als converted single instances t 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 Manager
• Computer Languages: SQL,PL-SQL,RMAN scripts and unix shell , Perl scripts.
• Operating Systems: UNIX, WINDOWS, Novell, Linux,
• Application tier : Worked with JAVA,Weblogic,Websphere,TUXED 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 t the team.
• Retaining staff. Remotely managed teams and Databases.

Professional Experience:

Confidential

Platform Lead .

American Red Cross is well known non-profit organization. Currently we are migrating from old NBCS National Blood Collecting System t a new system which will satisfy all FDA requirements. My role is t install and support all QA, Development and t be production Databases. We are using 11GR2 grid infrastructure. Als make sure SAN is worked properly and allocated properly t different Databases and Weblogic instances. I work with backup team t make sure backups are maintained properly and are available when required. I'm working on disaster recover process and make sure application can failover t 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 fr Db perspective.

Confidential

Sr. Technical Manager

SIRIUS and XM Radios merged together t become leading organization in Radi services. After that the MI activities took the speed and my role was t guide DBAs from technical operations perspective needs and t 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 t MI. Moving Datacenter from NJ t 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 tw teams one for SQL Database support and one for Oracle DB support, Als I work closely with Windows support team , UNIX system administrators and Storage team t make sure storage is allocated properly t the Databases and t the applications. For MS-SQL we are migrated t sql-2008 cluster. For Oracle we migrated t 11GR2 RAC and ASM. Als my responsibility is t 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 t 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 t design and implement solution for the data migration activities. Worked on performance issues faced for development teams. Als defined tools t support development and production support staff. Resolved issues for BCV split mirror and helped storage team t shadow copy databases easily and effectively. Designed solution for refreshing Databases via both split and rman t refresh Databases from production t 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

DBA Manager

• Emc is well know for it's storage devices.
• RSA is well known for IT security aspects. RSA is EMC's security division.
• I've tw teams t 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 t manage teams on-call rotation, assign tasks, prepare and manage budget. Manage Oracle licenses. Als 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 t support. We have RAC and streams used effectively t 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 t 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 t 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

Lead 10G Database Administrator

• International Paper is the largest in paper industry world wide.
• Lead Oracle 10g DBA consisting of 6 Oracle DBAs and 3 SQL DBAs
• Provided Technical guidance t all DBAs,
• Guide DBAs to/how t resolve all production issues as well as t 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 t be monitored remotely with servers located in field
• Implementing RAC t 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 t 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 t 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 t achieve the goals
• Implemented Grid Control solution for monitoring all DBs for the company, als added self healing for some cases.
• Planned and implemented Oracle upgrades t minimize the production outages.
• Saved money by doing consolidations of Oracle Databases on t one server.

Confidential

Sr. Oracle Database Administrotor

• This company provides and maintains networking services t 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 t Sun E10K from Siemens m/cs and 8.0.5 t 8.1.7 Oracle upgrade
• Migration from 8.1.7.4 t 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 Legat 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 t maintain OPER Reston and Frankfurt databases
• All the systems interact with these tw database which are replicated in Reston USA and one in Frankfurt Germany
• Implement advance replication for 14 groups and t 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 t SUN E10K and Oracle 8.1.7 and the down time was minimal during this
• Migrated t Oracle 10g Database

Confidential

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 t 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

Sr. Oracle DBA

• The project was t combine data of both company companies int 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 int new schema
• Transfer this data t other systems, which in turn will talk t 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

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 t monitor the performance of the database and t improve it.
• Monitor growth of the database and take appropriate action in advance
• Solve any problems related t 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 t database objects and t distribute them correctly across tablespaces
• Create and maintain users and security t pin the more frequently packages and procedures int memory.
• Environment: Oracle 7.3.4,8.0.5.1 HP UX10.2, Sun Solaris 2.6