SUMMARY:

• Ten years of experience in software development using Oracle Technologies.
• Excellent Experience in Business Analyst
• 24x7 SaaS production support
• Experience as ORACLE 11g RAC DBA with multi node Cluster in ASM Environment
• Experienced using Explain plan, Tkprof, Sql trace, Sql Tuning Advisor and Sql Access Advisor and identifying the Execution plan and tune queries, using indexes, hints etc. Also used Data Dictionary Views, STATSPACK, AWR, and ADDM for performance monitoring and maintain health of database.
• Extensive experience in Requirement Capturing, System Analysis, Software Design (Data Modeling) and Architecture, Development and Implementation of Software Applications.
• Expertise in ETL data modeling, Data Warehouse Partition table, index, Database development skills like PL/SQL, stored procedures, functions, packages, and triggers.
• Pursue a proactive Analytical approach to troubleshooting and problem solving
• On call support and Applying Patches on off time
• Planning and scheduling regular backups over network storage and testing of recovery
• Customization and automation of regular DBA activities and operating system specific tasks by shell scripts and SQL scripts take preventive actions and troubleshoot the problems proactively
• Experience in Performance Tuning, Capacity Planning, Space Management, Database Upgrades/Migration and Planning Backup & Recovery Strategies
• Extensive experience Real application Clusters(RAC), ASM, RMAN, Data Guard and maintain Standby database
• Excellent experience in oracle upgrade and data migration form Oracle 8i to 9i and 9i to 10G Application Server (OAS);
• Developed PL/SQL programs as Database Triggers, Stored Procedures and Functions
• Experience in Tables, Indexes Creation. Roles, Users Setup and Security.
• Proven expertise in all phases of Software Development Life Cycle (SDLC) of various projects.
• Expert in Database Administration operated by multiple users and multiple Databases
• Experience in Dynamic SQL, Records, Arrays and Exception Handling.
• Exposure in doing Business Process Re - engineering (BPR)

TECHNICAL SKILLS:

GUI Tools:   Developer 2000 6i/9i, Oracle Portal/Web,Designer 2000 V 2.1, Discoverer 6i/9i, Visual Basic 6.0, Power Builder V10.0

ERP:  Oracle Financial Applications 10.7/11i

ETL/OLAP Tools: Oracle Warehouse Builder (OWB), Informatica V 8.5, CRON jobs

Languages:  C, C++,PL/SOL

Databases: Oracle 8i/9i/10g/11g RAC, MS SQL Server 6.5/7.0,Sybase V 11.5

Tools: Oracle Reports 2.5/3.0/6.0/6 i, TOAD,SQL Loader,Pro C, ERwinPL/SQL CrystalReports5/8/8.5. Quest Shareplex Internet HTML, ASP, VBScript, JavaScript, Java, J2EE,. Jdeveloper, JHeadstart, XML, SOAP

Operating Systems:  Windows 2000/NT/95, UNIX C Shell, AIX, Redhat Linux, MS DOS Other Tools Datawarehousing, Oracle Enterprise Manager, SQLNet, Import/Export utilities

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Sr.Database Administrator / Performance Engineer

Responsibilities:

• Design and implement Uni direction data replication to use Golden Gate from SAP, Oracle ERP, Sales force to Oracle’s data warehouse environment.
• Designing and planning to upgrade 11gR2 to 12C.
• Performed extensive Oracle RAC support for node eviction issues and managed them.
• Performed the SQL tuning and recommendations for better performance on Query tools.
• Monitor Database through 12c Enterprise Manager.
• Performed the tuning of Application server to handle large workloads and long running jobs on batch server and Application server.
• Designed Logical and physical database for business transaction functionality
• Review data load processes and suggest enhancements and quality checks
• Creating the database, tables, table spaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Deciding the naming conventions of data file, redo log files, table spaces, segments.
• 24x7 Level four (L4) production support

Environment: Oracle 11gR2(RAC), 12c Enterprise manager, Golden Gate, Active Data Guard, Redhat Linux 5.2 X84 64, Windows XP

Confidential, San Mateo, CA

Sr.Database Administrator

• Experience as ORACLE11g RAC DBA with multi node Cluster in ASM Environment.
• Adding and deleting Cluster Node in existing RAC Cluster
• Performed extensive Oracle RAC support for node eviction issues and managed them.
• 24x7 Software as a Service(SaaS) production support
• Created all SQL Loader control cards and Data pumps scripts to load replicated data.
• Migrate From Sybase database to Oracle database.
• Design and implement Uni direction Data replication to use Golden Gate
• Performed the SQL tuning and recommendations for better performance on Query tools.
• Performed the tuning of Application server to handle large workloads and long running jobs on batch server and Application server.
• Worked extensively with SQL, PL/SQL Stored Procedures performance tuning.
• Performed the Capacity planning and sizing for large Production
• Performed the Oracle's Backup and recoveries in various crash situation.
• Implemented CRON Jobs
• Performed extensive RMAN backup and restoration window tuning on large databases
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Deciding the naming conventions of datafile, redo log files, tablespaces, segments.
• Implementation and maintenance in production database.
• Designed Logical and physical database for business transaction functionality
• Review data load processes and suggest enhancements and quality checks
• Used TOADfor faster application design and developments

Environment: Oracle 11gR1/R2(RAC), Redhat Linux 5.2 X84 64, Windows XP

Confidential, Walnut creek, CA

Sr.Database Administrator / Architect

• Design and implementation of new product databases
• Monitored and fine-tuned the physical database architecture in large Production databases.
• Performed extensive Oracle RAC support for node eviction issues and managed them.
• Support and maintenance Sybase database for customer support
• Monitoring database activities using Oracle10g Grid Control
• Created all SQL Loader control cards and Data pumps scripts to load replicated data.
• Design and implement Uni direction Data replication to use Golden Gate
• Created all SQL Loader control cards and Data pumps scripts to load replicated data.
• Experience as ORACLE 11g RAC DBA with multi node Cluster in ASM Environment.
• Adding Cluster Node in existing RAC Cluster
• Configured and implemented Oracle Grid Control to do day to day activities
• Performed the SQL tuning and recommendations for better performance on Query tools.
• Performed the tuning of Application server to handle large workloads and long running jobs on batch server and Application server.
• Worked extensively with SQL, PL/SQL Stored Procedures performance tuning.
• Performed the Capacity planning and sizing for large Production
• Performed the Oracle's Backup(RMAN and user managed) and recoveries in various crash situation.
• Implemented CRON Jobs
• Performed extensive RMAN backup and restoration window tuning on large databases
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Deciding the naming conventions of datafile, redo log files, tablespaces, segments.
• Implementation and maintenance in production database.
• Designed Logical and physical database for business transaction functionality
• Review data load processes and suggest enhancements and quality checks
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Done the documentation and provided on-site production support

Environment: Oracle 11g(RAC), PL/SQL Stored Packages/Procedures, Sybase V 11.5, Redhat Linux 5.2 X84 64, Windows XP and UNIX Korn Shell Scripts

Confidential, Woodland Hills, CA

Sr. Database Administrator

• Design and implementation of new product databases
• Used Shareplex for replicating databases.
• Initial build script development and maintenance
• Database Backup Configured implemented and using RMAN catalog.
• Expertise in Oracle Cluster Configuration and Implementation in RAC Environment.
• Implemented Data Guard (Standby) for our Protection Application Support.
• Creation and maintenance of development and test Database
• Setup CRON jobs for reprots and data upload
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords (security).
• Worked Data Guard, Cloning using copy from production to Test Supported development and test databases for on going development and testing
• Implemented Data Guard (Standby) for our Protection Application Support.
• Setup RAC environment in development and test database
• Data transfer from SQL SERVER to Oracle using Informatica
• Deciding the naming conventions of datafile, redo log files, tablespaces, segments.
• Implementation and maintenance in production database.
• Designed Logical and physical database for business transaction functionality
• Review data load processes and suggest enhancements and quality checks
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Done the documentation and provided on-site production support

Environment: Oracle 11g(RAC), ErwinV 4.1, PL/SQL Visual Basic 6.0, Informatica V 8.5 Quest Shareplex, SQL Plus, Toad, Windows XP and UNIX Korn Shell Scripts

Confidential, Alhambra, CA

Sr. Database Architect

• Develop, document, implement and maintain data models to revise existing tables and create new tables.
• Designed Logical and physical database for business transaction functionality
• Managed and resolved design issues during development.
• Moved database Schema changes to stage or production
• Database and SQL tuning to improve performance of loads.
• Review data load processes and suggest enhancements and quality checks
• Monitor database performance and modify queries, packages, and stored procedures as required.
• Work with end users and other programmers to identify and translate business reporting requirements
• Load data extracts from legacy to Oracle systems
• Created all SQL Loader control cards and scripts to load replicated data.
• Designed and Developed PL/SQL for interface
• Written the Interface Stored Procedures for Data Transformation
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Done the documentation and provided on-site production support

Environment: Oracle 10g, ErwinV 4.1, Oracle 10g Warehouse Builder, PL/SQL Stored Packages/Procedures, SQL Plus, Toad, Windows XP and UNIX Korn Shell Scripts

Confidential, Los Angeles, CA

Sr. Database Administrator

• Load data extracts from legacy to Oracle systems
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Creation and maintenance of development and test Database
• Implementation and maintenance in production database.
• Designed Logical and physical database for business transaction functionality
• Review data load processes and suggest enhancements and quality checks
• Created all SQL Loader control cards and scripts to load replicated data.
• Designed and Developed PL/SQL for interface
• Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages
• Creating SQL PL/SQL database objects.
• Written the Interface Stored Procedures for Data Transformation
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Done the documentation and provided on-site production support
• Done functional and technical specs

Environment: Oracle 10g, Oracle 10g Warehouse Builder, .Net, Java, J2EE, PL/SQL Stored Packages/Procedures, SQL Plus, Toad, Windows XP, Linux and UNIX Korn Shell Scripts

Confidential, Irvine, CA

Sr. Database Administrator / A rchitect

• Created all SQL Loader control cards and scripts to load replicated data.
• Load data in XML format in oracle database
• Designed and Developed prototype Customer Data Model after review of existing source software packages.
• Designed interface/Conversion mapping, pre production testing, and related documentation and deliveralabs
• Reviewed table design of JDE DB2 tables and Siebel Oracle 8.1.7 Customer tables and index structures to identify pertinent columns
• Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages
• Creating SQL PL/SQL database objects.
• Written the Interface Stored Procedures for Data Transformation
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Done the documentation and provided on-site production support.

Environment: Oracle 10g, PL/SQL Stored Packages/Procedures, SQL Plus, XML, SOAP, TOAD, Windows 2000, Linux and UNIX Korn Shell Scripts

Confidential, Lansing, MI

Database Administrator / A rchitect

• Extensively used of PL/SQL Stored Procedures, Functions, Triggers, Cursors and Packages
• Developed web based front-end screens using Forms 6.0/9.0, generated custom reports using Reports 6.0/9.0 and generated custom graphics using Graphics 6.0/9.0
• Involved in Control File Format in SQL*LOADER
• Creating SQL, Object Views, and PL/SQL database objects.
• Written the Interface Stored Procedures for Data Transformation
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Tuned the SQL’s with the output of Oracle Tools Explain Plan, TKPROOF
• Generated Forms and Reports Using Designer 2000
• Fixing bugs according to the software change requirement
• Involved in Oracle Performance Tuning and Query Optimization
• Developed procedures using Dynamic SQL, UTL FILE.
• Involved in Testing (Both Unit and Integration Level) and Implementation.
• Tested the entire application in testing environment and exported to Production.
• Done the documentation and provided on-site production support.

Environment: Oracle 8i, 9i, Developer Version 6.0, Report Builder Version 6.0 PL/SQL, SQL*LOADER, Designer2000, TOAD, Windows2000, UNIX Shell