SUMMARY:

• Over 17 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,12C (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 .
• Supporting production and non-production environments.
• More then 6 years experience as a Sr. Architect and PL/SQL developer on a variety of applications
• Set up streams (10G, 11G) and Advance replication (9i)in multinational organizations.
• Trained staff for streams and Advance replication.
• Superior understanding of logical and physical design.
• Worked as a Principal DBA to resolve Database related issues.
• 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, 11G,12C as well as data migration experience.
• 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.
• Implemented different methods of monitoring Databases pro-actively.
• Implemented policies and procedures for ensuring security of highly sensitive data.
• ITIL Certified
• Working knowledge of HADOOP, HBase, HIVE, PIG, HIVE, Map reducer and SQUOOP.
• Worked with ETL tools such as Informatica.
• AWS cloud migration experience

TECHNICAL SKILLS:

RDBMS: Oracle 12C, 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

GUI Tools: Oracle Enterprise Manager(web version), 12C, 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 scripts.

Operating Systems: UNIX, WINDOWS, Novell, Linux

Hardware: Sun Solaris (E25K)- Veritas file systems(VXFS), HP, Siemens, EMC, HITACHI and HP SAN, AIX,DELL servers

PROFESSIONAL EXPERIENCE:

Confidential

Sr. DBA

• Migrating to AWS cloud, worked on different mission critical applications, Performance tuning expert. Monitoring set up on multiple Databases. Recovery and Backup expert with RMAN. Golden setup for failover capability. Worked on TDE for security. Worked on Wallet. Wrote perl scripts form JSON conversion.

Confidential

Sr. Database Engineer

• AWS is best known for its’ cloud support and capability.
• Working on main front tier cloud applications such as auto scaling and Software load balancing, RDS. Implemented several 11G Databases all across the Data Centers. Established Data Guard for failover capability. Supported production 24x7 . Also supported development teams for auto scaling and SW load balancing. AWS has hundreds of Data Centers all across the world. Maintained SLA of 99.99. Responsibility including performance tuning, creating Databases, upgrading them, test disaster recovery preparation plan, use RMAN to backup Databases. Restore production Databases in test environments. Help Dev. team to tune SQLs. Help new DBAs to come onboard. Used Dataguard for zero downtime. Tuning hibernate queries. Used ETL tools, such as Informatica. Maintain DB scripts. Monitor production Databases.

Confidential

Sr. DBA

• 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 Web logic 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 required. 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 software reviews from Db perspective. This migration involves Data migration and is done using Informatica. Currently upgrading to 11.2.0.3 and golden gate.
• Creating Databases
• Applying security patches
• Upgrading Databases
• Proactively Monitoring Databases using OEM
• Set up thresholds for monitoring
• Data Analysis.
• Performance tuning DB and SQL queries.
• Use streams to replicate Data between Databases
• Help development team to tune SQL queries
• Write scripts for Database RMAN backups.
• Help development team in designing solutions.
• Maintain SLA (Service Level Agreements)
• Support Development, QA / TEST and Production Databases.
• Configure SAN (EMC DMX3) for Database usage.
• Align and assign storage to Databases per requirement with the help from SAN and O.S. support teams.
• Grant and monitor access to users
• Maintain DB architecture.
• 24x7 support.
• Disaster recovery management.
• Participate in technical review meetings.
• Use AWR for performance analysis.
• Flash back Database recovery mechanism used to help testers.
• Lead DBA team

Confidential

Principal DBA

• 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

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

Lead 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
• 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

Confidential

Sr. Oracle Database Administrator

• Confidential 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

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

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

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

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

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

Sr. System analyst and DBA

Responsibilities:

• 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).