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

Oracle DBA

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
• 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
• Production support 24/7

Environment: and Tools: Oracle 10gR2, 11gR, 11gR2, 11i/R12, Web logic 10,Oracle Cluster ware, Oracle Apps, 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

Confidential

Oracle DBA

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

Senior Oracle DBA

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 Development, QA environment for new development requirement
• Data migration to other database as per requirement for new systems.
• Change management to all environment
• Managing Microsoft SQL & mysql Instance
• 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
• Installation of Solution Manager 4.0 instance
• 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

Senior Oracle DBA Consultant

Responsibilities:

• Understand Customer Requirement
• Create high and mid-level designs for large, high-impact and strategic database efforts
• Logical Database design
• Table, Column mapping with existing requirement
• 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

Oracle/DB2 ERP DBA

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.
• Monitoring Space and memory requirements
• Importing the Different Dumps for problem Simulation
• Modifying the database structure, as necessary, from information given by application developers
• Creation and maintenance of Database Objects Database, Tablespaces, Tables, Indexes, Views, etc.
• Periodical Backup
• 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 racle/DB2 ERP DBA

Responsibilities:

• Installation of Oracle/UDB DB2 7.1/8.1 in Linux, Aix, Solaris, Win2k and Win NT.
• Configuration of UDB DB2 in EE and EEE environment.
• Monitoring and optimizing the performance of the database
• Creation and maintenance of Database Objects: Database, Tablespaces, Tables, Indexes, Views, Snapshots etc
• 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.
• Backing up and restoring the database
• Handling problems related to use of limited computer resources (disk space, number of process .etc)
• Controlling and monitoring user access to the database
• Providing General Support to users
• Importing the Different Dumps for problem Simulation
• Test Plan design and Regression testing, Explored new features of RAC, Configuration of RAC
• Verifying the fix for various customer bugs
• Reviewed the User guide and Installation guide
• Test Transport for SAP R3 on different instance
• Up gradation 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

Oracle DBA

Responsibilities:

• Involved in Requirement Analysis and design of the project.
• Installation of Oracle 9.0 on Linux, UNIX, Win2k and Win NT.
• Understood the overview from PBSG system (Frito-Lay-US) which was in DB2
• Database Design & Growth Strategy
• 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
• Provide database availability and support
• Various troubleshooting

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

Confidential

Oracle Development DBA

Responsibilities:

• Involved in Requirement Analysis and design of the project.
• 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
• Performance Tuning of VAMAN Server Compare to Oracle, MS-SQL Server
• Backup and Recovery Procedure
• Check that the daily starting, logging, running and stopping of any operations on the database are done properly.
• Obtain the database Performance reports on daily, weekly and monthly basis and track down any performance problems. Inform to the system experts about the problems.
• Transferring Data using Data Transformation Services.

Environment: and Tools: SQL, Oracle 7.2, Vaman.