Summary

• Oracle DBA Consultant with 11+ years of experience in Analysis, Design, Development and maintenance of database applications primarily Oracle on Solaris, AIX Linux and Windows environment
• Strong Database Management skills including analysis, development, administration and maintenance of database projects in retail and warehousing.
• End to end data design: from conceptual data modeling to implementation for both the OLTP and Data Warehouse environments & SAP systems
• Strong Enterprise Production Oracle DBA, Expert level skills to on different Oracle Versions 7.x/8.x/9.x/10GR2/11gR1
• Hands on experience Designing, tuning and implementing very large databases, 24x7 availability and high transaction volume.
• Experience in database recovery and Oracle disaster planning: Investigate review, apply and test all patched and bug fixes in database environment
• Hands on experience in data setup , Installs upgrades and Patches & Migration
• Configuring monitoring and proactively reviewing statistics for errors, capacity and performance issues
• Solid skills in database performance factors, monitoring tools and tuning procedures
• Hands on daily back-ups, recovery, security, query tuning, and automation and implementation of database related functions.
• Knowledge of fault detection and resolution processes
• Experience and Working Knowledge with various RDBMS. Knowledge of databases, application software as well as their capacity and technical limitations
• Query optimization and tuning skills including cross database and cross server queries, analysis and troubleshooting interactions between databases, operating systems and applications with regard to performance and resources usage. Experience in creating database tables, setting up indexes, data constraints and database views and SQL queries.
• Database Migration Experience from oracle 9i to 10g,11.1.0 to 11.2
• Strong knowledge of Oracle internals, tools including DBMS jobs, RMAN, SQLPlus, export/import, Toad, Oracle Enterprise Manager (OEM)
• Strong in Disaster Recovery (DR) planning and testing & Maintenance, RAC familiarity and configuration, Standby database
• Knowledge of Unix/Linux system administration, Shell Scripting
• Ensure operational efficiency of Database environment meets expected service levels.
• Provide assistance and support to the application development teams on Oracle best practices
• Proven experience in database tuning & optimizing, RMAN backup / restore / recovery, database resizing & de-fragmentation activities
• Producing and updating documentation and Standard Operating Procedures (SOPs).
• Excellent written, communication, presentation and interpersonal skills.
• A very good team player with the ability to work independently.

Technical Skills

Knowledge Domains:

Database and systems administration, design and development

RDBMS:

Oracle 8, 8i/9i/10g/11gR1,11gR2 MS SQL

Technologies:

Oracle 8.1.7, 9i, 10g, 11gR1,11gR2,RAC, DB2/UDB 7.2, 8.1 and 8.2, EEE, federated databases, and UNIX, Linux and Windows, SAP ECC6, NW2004 and NW2004s

Languages:

SQL, PL/SQL

Platforms:

Solaris 8/9/10, AIX 5.X, HP-UX, Linux ES 4, Windows 32/64-bit.

Servers:

Web Logic, Web Sphere, Oracle AS, Apache.

Other tools:

ERWin, Power Designer. Enterprise Management: SmartDBA, SpaceExpert, TOAD, SQL Navigator, RMAN

Professional Experience

Confidential, (May ‘12 to till date)
Role: Oracle DBA, Cleveland, OH
Project:
Confidential,is a global diversified power management company. The company is a leading provider of electrical components and systems for power quality, distribution and control and hydraulics components.

Responsibilities:

• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Database monitoring & support for more than 300 oracle databases using OEM.
• Performance Tuning using AWR, ADDM, ASH reports
• Database backup & Recovery performed using RMAN and Data Pump export and Import.
• Database Space management & Capacity Planning
• Troubleshoot oracle error and work with oracle support to resolve issue
• Support for Oracle 11i Refresh & Database Refresh
• Develop, execute and communicate project plan relating to the database tier projects.

Environment and Tools: Oracle 10gR2, 11gR, 11gR2, 11i/R12, Web logic 10,Oracle Cluster ware, Oracle Apps, Oracle ASM, RHEL 5, Solaris 10,HP Unix , Grid Control (OEM), Oracle Data guard, RMAN, SQL PLUS, Shell Scripts, BMC SDE, shell scripts

Confidential, (Oct ‘11 to Apr ‘12)
Role: Oracle DBA, Stamford, CT
Project:
Confidential,is the leading pharma company for pain-treatment products. They have different manufacturing facilities which using Medical Application i.e. MEDRA, ARGUS, SALEPROD for sales, production and supply chain management.

Responsibilities:

• Support Oracle Databases on 2-Node RAC Cluster with Oracle 11.1, ASM and Oracle Cluster ware.
• Database backup & Recovery performed using RMAN and Data Pump export and Import.
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Database monitoring & support for more than 150 oracle databases using OEM.
• Creating and maintaining the different database throughout the infrastructure Landscape including performance and tuning analysis using AWR & ADDM, capacity planning, systems support & optimization, Database software upgrade/patches
• Apply Oracle-supplied patches to the databases of each OS. Keep all databases with up to date version and patch level.
• Oracle Internet Directory OID Administration and support.
• Worked in FDA Validated system and documentation environment using IQ Scripts.
• Support RMAN catalog for backup and TSM for job scheduling.
• Used Brtools for backup and different codes for performance tuning
• Performing support, maintenance and rollout of SAP environment
• SAP Transport management across multiple landscapes & SAP Performance Tuning
• Periodic refreshes from production to quality and dev Servers
• Exposure of Private cloud on VCE environment, Net App, Data Domain & EMC storage.
• Develop, execute and communicate project plan relating to the database tier projects.
• Trouble-shoots software problem as they apply to design, implementation

Environment and Tools: Oracle 10gR2, 11gR, 11gR2, 11i/R12, Web logic 10,Oracle Cluster ware, Oracle ASM , Linux 2.6, Solaris 10,HP Unix , AIX, Grid Control (OEM), Oracle Data guard, RMAN, SQL PLUS, Shell Scripts, BMC SDE, shell scripts, SAP ECC6,Argus

Confidential, (May ‘11 to Oct ‘11)
Role: Oracle DBA, West Des Moines, IA
Project:
The Secondary Marketing System (SMS) application supports the pooling and delivery of all LIS Government Loans. The application contains conforming and non-conforming loans that have been closed and funded. The primary responsibility of SMS is to create and deliver loan sales to the Agencies and Investors.

Responsibilities:

• Support Oracle Databases on 4-Node RAC Cluster with Oracle 11.1, ASM and Oracle Cluster ware.
• Performed day to day activities: Such as, daily error checks and database health, monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• Performance Tuning and Support for DEV, UAT and SIT, Production RAC Environment using ADDM, AWR Reports.
• Implemented and managed partitioning for very large Tables, created Partitioned based Indexes on Partitioned Tables.
• Data Refresh using Data Pump Utility from Prod to UAT , SIT and DEV
• Implemented change data Capture for newly designed migration system
• Upgrade Oracle Cluster ware, ASM and Oracle Databases from Oracle 10gR2 to Oracle 11gR2.
• Perform RMAN Online backup (Full/ Incremental) of Oracle RAC Databases, setting up and monitor standby database.
• Assisting Application Development Project lifecycle through migration to Production, including SQL optimization and post implementation support.
• Raising TAR/SR with Oracle Support and using Metalink to resolve the bottlenecks in the database environment
• Provide Production DBA support, as needed, on a 24/7 basis.

Environment and Tools: Oracle 10gR2,11gR,11gR2, 11i/R12, Oracle Cluster ware, Oracle Apps, Oracle ASM (Automatic Storage Manager), Linux 2.6, Solaris 10, AIX, Grid Control (OEM), Oracle Data guard, RMAN, SQL PLUS, Shell Scripts, Oracle Golden gate, BMC remedy PAC2000 v7.6,Sybase,shell scripts

Confidential,Role: Senior Oracle DBA, NY (June ‘06 to April ‘11)
Project:

The application requires building Database for current website using vignettes Application which is known content management tool. Website having million of user base in USA.

Responsibilities:

• Participate in conceptual applications design to Understand MSLO Requirement, Communicate with team and management
• Create high and mid-level designs for large, high-impact and strategic database efforts
• Data Modeling and Data Conversions, Logical Database design
• Installations and Configuration 4 node 11gR1 RAC
• Physical database design, Table, Column mapping with existing requirement
• Creating/dropping database, table spaces, and table & database objects
• Performing database administration duties including software installation, patching, backup and recovery, performance tuning, monitoring.
• Query Tuning using ADDM,AWR Reports
• RMAN Backup and Recovery, DB Performance Tuning instance level
• Management of Production, QA & DEV infrastructure
• Change management to all environment
• 24x7 support for production db i.e. performance, backup
• Standby database Maintenance and configuration
• Investigation and diagnostic work on any problems on the database server infrastructure, coordinating efforts with Infrastructure and Operations and Application Support teams
• Ensure operational efficiency of Database environment meets expected service levels
• Provide assistance and support to the application development teams on Oracle best practices
• Communicate with management, executive and technical level staff
• Very large Database Migration from 9.2 to 10.2 oracle i.e Db Size one tera bytes
• Explore New ERP implementation project requirement i.e. SAP ECC to enhance current solution
• Interaction with SAP service marketplace for resolution of issues, keys, downloads
• Experience of operating system-level virtualization using Solaris Containers
• Working knowledge of VERITAS Netback up 6.0,SAN

Environment and Tools: Oracle 11gR1,10g, 9i, SQL, PLSQL, Sun Solaris 10/9, Windows XP/Professional, SQL Loader, TKPROF, SQL*Plus, Toad. DTS, RMAN, VERITAS Volume manager, SAP ERP, Microsoft SQL, Sybase

Confidential,Role: Senior Oracle DBA Consultant UK/Mumbai (June ‘05 to April ‘06)
Project:

The application requires building DW for Call center data for thetrainline.com. It is Virgin Atlantic group client of US. DW application going to measure performance of call center, agents and trends of train booking for London train system. Application having very large data of their online booking system. DW/SAP BW application provides reports for required data from Data mart.

Responsibilities:

• Understand Customer Requirement
• Create high and mid-level designs for large, high-impact and strategic database effort, Logical Database design
• Creating/dropping tablespaces, and table, Create index, views, mviews, synonyms, Procedure, function,
• Create Trigger, Package, DBlinks & ETL Process
• Backup and Recovery, RMAN, Export/Import, Standby database.
• DB Performance Tuning ,Using Hints ,ADDM,AWR Reports
• SOW Designer, Cost Estimation & Project Planning and Management Task
• Worked on infoqube for SAP BW, Worked on TMS, Client Copy ,BRTOOLS
• Interaction with SAP service marketplace for resolution of issues, keys, downloads
• Liaising with the development department for projects and escalation of production issues, assisting with troubleshooting issues, and mentoring junior staff on database management techniques.

Environment and Tools: Oracle 9i/10g, SQL, PLSQL, Business Objects XI, UNIX, Windows XP/Professional, Loader, TKPROF, SQL*Plus, Toad. RMAN

Confidential, Canada/Bangalore (Oct 04 to Jun05)
Role: Oracle/DB2 ERP DBA
Project:
The project involves requirements understanding, technical design and development of Business to Customize Business Objects. To create report it needs database performance tuning for production & Quality database.

Responsibilities:

• Installation, configuration, and tuning of a decision-support environment on Oracle/DB2/MS SQL Server.
• Data base Architecture design and implementation, Logical and Physical Corporate Data Modeling for OLTP and OLAP, 3 tier schema design and implementation, Data management, Data mapping, Design and implementation of Data Extract Transform Load (ETL), Normalized and De-normalized data modeling, forward /Reverse Engineering of data model.
• Creation and maintenance of Database Objects Database, Tablespaces, Tables, Indexes, Views, etc.
• Performed the unit and parallel testing and fixed the reported SQL, PLSQL performance and other issues.
• SAP TMS ,Client Copy, BRTOOLS, System Copy for change management

Environment and Tools: Oracle 9i/10g, SQL, PLSQL, Business Objects XI, UNIX, Windows XP/Professional, Loader, TKPROF, SQL*Plus, Toad, RAC

Confidential,Houston/Pune (Jan ’04 to Oct’04)
Role: Oracle/DB2 ERP DBA
Project: Confidential,is a leading provider of enterprise management solutions that empower corporate to manage IT from a business perspective. Delivering Business Service Management, BMC Software solutions span ERP systems, applications, databases and service management.

Responsibilities:

• Configuration of UDB DB2 in EE and EEE environment.
• Monitoring and optimizing the performance of the database
• Proactive maintenance :index re-builds, index/table re-orgs, partitions, purging data, space management

Install, refresh, upgrade, re-link and maintain all databases in UNIX.

• Test Plan design and Regression testing, Explored new features of RAC, Configuration of RAC
• Test Transport for SAP R3 on different instance, Upgrade of SAP environments (SAP Notes, upgrade of kernel, ABAP stack, plug-ins, system copy, homogeneous / heterogeneous exports and imports, Client Copy
• Interaction with SAP service marketplace for resolution of issues, keys, downloads

Environment and Tools: Oracle 9i, UDB, Loader, TKPROF, SQL*plus, TOAD, Vantive, SAP R3, RAC

Confidential, (Aug ’02 to Dec’03)
Role: Oracle DBA
Project:
Confidential,can be best described as to generate De-normalized version of data Repository from master data which is called Masterfiles. MFI captures data from Customer, Product, Location, Authorization, and Promotion etc.

Responsibilities:

• Involved in Requirement Analysis and design of the project.
• Understood the overview from PBSG system (Frito-Lay-US) which was in DB2
• Performance Tuning at different level for 24/7 database
• Monitoring and optimizing the performance of very large database.
• Importing Different Dumps for Development and testing Environments
• Backup & Recovery & Various troubleshooting

Environment and Tools: Oracle 8i/9.0, SQL, PLSQL, Visual Source Safe, ERWin.

Confidential, (Dec’99 to July ’02)
Role: Oracle Development DBA

Project –RDBMS Development
Symmetric multi processing/ Vaman have created a RDBMS system VAMAN developed in c language.

Responsibilities:

• Major activities included logical and physical database structure design, capacity planning, performance tuning, database security, disaster recovery, installation and ongoing maintenance. Provided routine comprehensive database maintenance and monitoring to optimize database efficiency and minimize downtime.
• Development of different types of Scripts using PL/SQL

Environment and Tools: SQL, Oracle 7.2, Vaman.

Education

• Post-Graduated Diploma in Management
• Bachelor of Science

Awards

• Project Excellence and Implementation Completion award

Professional Trainings

• Oracle DBA Training from Oracle
• UDB EEE training from IBM
• Oracle Backup & Recovery Training from oracle