SUMMARY

• Expertise includes Oracle Applications (e - Business Suite 11i/12), Architecture/Design of custom applications and Databases on Unix/Linux//NT platforms in ensuring Quality, Integrity and Availability of teh Company’s data wifin Oracle Server.
• Experience in setting up an Oracle 9i RAC environment in a cluster file system using VERITAS storage foundation as well as setting up Oracle 10g/11g RAC on Oracle ASM.
• Experience in data modeling using ERWIN and server side application development using SQL, PL-SQL.
• Experience in migrating databases from file systems to ASM.
• Experience in upgrading/migrating teh 9i RAC to 11g/10g RAC and migrating from VERITAS to ASM.
• Experience wif many Installations, Configurations, Up-gradations, Platform Migration, Administration and Patching of Oracle Applications (R12) and Oracle databases.
• Experience in Installations, configurations, Administration and patching of 10gAS, 9iAS and Oracle Web Application Servers.
• Performing routine Oracle Applications maintenance and configuration: Autoconfig, clone, patching, and technology stack upgrade, and gathering statistics for CBO.
• Delivering performance-tuning services for customers wif tkprof, SQL trace 10046, custom scripts and wait interface.
• Knowledge on Oracle SSO / OID configuration wif E-business suite.
• Troubleshooting and resolving critical production issues in complex application environment: SQL*net connectivity issues, locking, latching, database hang issues, OS/network issues, concurrent manager issues.
• Good noledge of RAC (9i /10g/11g) and applications 11i/R12 on Single Instance and RAC environment.
• Developing standard DBA procedures and practices.
• Worked wif version control systems like PVCS and CVS.
• Proficiency includes Engineering and Architecture of Oracle, Resource management, and Security management, Tuning, Clustering, Backup and Recovery. Expert level Knowledge of Relational and object oriented Databases. Good Exposure to Oracle Database Architecture and Optimal Flexible Architecture (OFA).
• Knowledge in administration, management of Operating Systems like Sun Solaris 9/10, AIX 5.2/5.3, HP-Unix, and Windows NT 4.0
• Has strong analytical, administration and problem-solving skills dedicated to maintain teh high quality standards.

TECHNICAL SKILLS

Oracle products: Solid noledge of Oracle technology and products including Oracle database 9i/10g/11g, Oracle Applications R11i /R12, Installation, upgrade and configuration, Oracle SQL*plus, PL/SQL, Oracle Server v7.3.x, v8.x, v8i, v9i, 10g, 11g, RAC, ASM, Stats Pack, SQL Loader, RMAN, Standby Database, Data Guard, Replication, Oracle Internet Directory, Oracle Advanced Security, Oracle Application Server 10gAS, Developer 2000 Suite, OEM (Oracle Enterprise Manager), OAM, Label security, VPD.

OS & Hardware: Solaris 8/9/10, AIX 5.2/5.3, HP-UX 11/11i, Linux (Red hat 4/5), Novell Netware Windows 95/98/NT/XP/2000/2003, Sun T5220/M5000, Confidential P4/P5

Other Products: Shell Programming, UNIX, OEM, Java, C, PVCS, TOAD, .Net, and VB

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Upgraded Oracle 10g to 11g R2.
• Installed GI, created BCP/DR environment
• Tuning SQL Statements, Data load processes and application(s) design.
• Worked on implementing SharePlex
• Leaning/working on Gloden Gate 11g.
• Implemented RAC on Oracle 11g R2 on Solaris 10.
• RAC implementation on Linux.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Helped customers wif server sizing and capacity planning.
• Worked on teh MAA (Maximum Availability Architecture) by combining teh Oracle RAC wif Standby (Data Guard) to get teh maximum availability to avoid single point of failure.
• Used teh SAN (EMC) level backup solution using EMC clone/BCV for data warehouse environments.
• Worked wif Developers in architecting teh Partitioning mechanism for data warehouse databases.
• Worked on migration of some non e-business suite databases from Sun/AIX to Linux environments.
• Worked as a team lead to streamline teh CPU patch analysis and patch management across environments wif teh help of developers/functional support
• Provide day to day database support like executing database related tickets from Remedy.
• Worked on Oracle Enterprise manager to analyze and monitor teh database performance and for DBA activities.
• Provided DBA support in many implementations including customer and item loads.
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Worked wif business to create teh data model, process flow model etc using Data Modeling tool ERWIN
• Worked wif Developers, Analysts to streamline teh processes of Kaiser releases from database perspective
• Worked on RCA (Root Cause Analysis) and give teh guidance on performance tuning both from application side as well as from database side.
• Cloned environments to create patch test, development and QA environments
• Other activities like applying RDBMS patches, security patches (CPUs), proactive monitoring of databases.

Confidential

Sr. Oracle DBA

Responsibilities:

• Upgraded Oracle 10g to 11g R2.
• Tuning SQL Statements, Data load processes and application(s) design.
• Implemented RAC on Oracle 11g R2 on Solaris 10.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Helped customers wif server sizing and capacity planning.
• Worked on teh MAA (Maximum Availability Architecture) by combining teh Oracle RAC wif Standby (Data Guard) to get teh maximum availability to avoid single point of failure.
• Used teh SAN (EMC) level backup solution using EMC clone/BCV for data warehouse environments.
• Worked wif Developers in architecting teh Partitioning mechanism for data warehouse databases.
• Worked on migration of some non e-business suite databases from Sun/AIX to Linux environments.
• Worked as a team lead to streamline teh CPU patch analysis and patch management across environments wif teh help of developers/functional support
• Provide day to day database support like executing database related tickets from Remedy.
• Worked on Oracle Enterprise manager to analyze and monitor teh database performance and for DBA activities.
• Provided DBA support in many implementations including customer and item loads.
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x/R12.1.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered teh 11i instance production database as a result of data corruption by successfully applying teh archive redo log files
• Installed Oracle applications 11i E-business suite using multi-node architecture
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Worked wif business to create teh data model, process flow model etc using Data Modeling tool ERWIN
• Worked wif Developers, Analysts to streamline teh processes of Kaiser releases from database perspective
• Worked on RCA (Root Cause Analysis) and give teh guidance on performance tuning both from application side as well as from database side.
• Cloned environments to create patch test, development and QA environments
• Other activities like applying RDBMS patches, security patches (CPUs), proactive monitoring of databases.

Confidential

Sr. Technical Lead

Responsibilities:

• Tuning SQL Statements, Data load processes and application(s) design.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Helped customers wif server sizing and capacity planning.
• Installed R12 on an existing and new hardware and Upgraded Apps R11i to R12. (12.1.2).
• Oracle Apps 11i (11.5.10) and R12 support for day to day activities like Applications Patching, cloning, CPU patch and monitoring teh concurrent manager and jobs etc.
• Worked on teh MAA (Maximum Availability Architecture) by combining teh Oracle RAC wif Standby (Data Guard) to get teh maximum availability to avoid single point of failure.
• Implemented Secured Socket Layer (SSL) in teh 11i E-business applications suite to enable data encryption between teh client and teh middle-tier layer.
• Used teh SAN (EMC) level backup solution using EMC clone/BCV for data warehouse environments.
• Worked wif Developers in architecting teh Partitioning mechanism for data warehouse databases.
• Worked on migration of some non e-business suite databases from Sun/AIX to Linux environments.
• Worked as a team lead to streamline teh CPU patch analysis and patch management across environments wif teh help of developers/functional support
• Monitored and effectively tuned teh Apps 11i database instances by utilizing own scripts, OEM for Oracle and teh StatsPack/AWR utilities.
• Provide day to day database support like executing database related tickets from Remedy.
• Worked on Oracle Enterprise manager to analyze and monitor teh database performance and for DBA activities.
• Provided DBA support in many implementations including customer and item loads.
• Configured Oracle 11i E-business applications suite wif AutoConfig
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x/R12.1.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered teh 11i instance production database as a result of data corruption by successfully applying teh archive redo log files
• Installed Oracle applications 11i E-business suite using multi-node architecture
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Worked wif business to create teh data model, process flow model etc using Data Modeling tool ERWIN
• Worked wif Developers, Analysts to streamline teh processes of Kaiser releases from database perspective
• Worked on RCA (Root Cause Analysis) and give teh guidance on performance tuning both from application side as well as from database side.
• Configured Oracle 11i E-business applications suite wif AutoConfig
• Cloned environments to create patch test, development and QA environments
• Other activities like applying RDBMS patches, security patches (CPUs), proactive monitoring of databases.

Confidential

Sr. Oracle DBA

Responsibilities:

• Tuning SQL Statements, Data load processes and application(s) design.
• Helped customers wif server sizing and capacity planning.
• Worked on DR/BCP databases setup
• Worked on analyzing AWR reports on a weekly basis.
• Worked to streamline teh CPU patch analysis and patch management across environment.
• Provide day to day database support like executing database related tickets from Remedy.
• Worked on Oracle Enterprise manager to analyze and monitor teh database performance and for DBA activities.
• Provided DBA support in many implementations including customer and item loads.
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Worked wif Developers, Analysts to streamline teh processes of Kaiser releases from database perspective
• Worked on RCA (Root Cause Analysis) and give teh guidance on performance tuning both from application side as well as from database side.
• Cloned environments to create patch test, development and QA environments

Confidential

Sr. Technical Lead

Responsibilities:

• Tuning SQL Statements, Dataload processes and application(s) design.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Helped customers wif server sizing and capacity planning.
• Installed R12 on an existing and new hardware and Upgraded Apps R11i to R12. (12.1.2).
• Oracle Apps 11i (11.5.10) and R12 support for day to day activities like Applications Patching, cloning, CPU patch and monitoring teh concurrent manager and jobs etc.
• Migrate/upgrade teh Oracle 9i RAC infrastructure to Oracle 10g/11g RAC on Oracle ASM.
• Worked on teh fresh installation/setup of 10g/11g RAC in ASM and set teh guidelines for other DBA.
• Worked on teh MAA (Maximum Availability Architecture) by combining teh Oracle RAC wif Standby (Data Guard) to get teh maximum availability to avoid single point of failure.
• Implemented Secured Socket Layer (SSL) in teh 11i E-business applications suite to enable data encryption between teh client and teh middle-tier layer.
• Some experience on SQL*Server; example: Created databases on SQL-Server using enterprise manager.
• SQL-Serer, database cloning using enterprise manager
• Worked on developing procedures using T-SQL
• Worked on setting up backups on SQL-Server
• Used teh SAN (EMC) level backup solution using EMC clone/BCV for data warehouse environments.
• Worked wif Developers in architecting teh Partitioning mechanism for data warehouse databases.
• Worked on migration of some non e-business suite databases from Sun/AIX to Linux environments.
• Worked as a team lead to streamline teh CPU patch analysis and patch management across environments wif teh help of developers/functional support
• Monitored and effectively tuned teh Apps 11i database instances by utilizing own scripts, OEM for Oracle and teh StatsPack/AWR utilities.
• Provide day to day database support like executing database related tickets from Remedy.
• Worked on Oracle Enterprise manager to analyze and monitor teh database performance and for DBA activities.
• Provided DBA support in many implementations including customer and item loads.
• Configured Oracle 11i E-business applications suite wif AutoConfig
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered teh 11i instance production database as a result of data corruption by successfully applying teh archive redo log files
• Installed Oracle applications 11i E-business suite using multi-node architecture
• Installed third party components in Kaiser Environment like Clear Quest, Requisite Pro etc.
• Upgraded some production databases from 8i to 10g R2.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Worked wif business to create teh data model, process flow model etc using Data Modeling tool ERWIN
• Worked wif Developers, Analysts to streamline teh processes of Kaiser releases from database perspective
• Worked on RCA (Root Cause Analysis) and give teh guidance on performance tuning both from application side as well as from database side.
• Worked wif customer/business to understand teh business needs and presented teh solution diagram/Process flow/Data flow etc using data modeling tool ERWIN.
• Researched and applied teh DST patches on Oracle RDBMS.
• Configured Oracle 11i E-business applications suite wif AutoConfig
• Cloned environments to create patch test, development and QA environments
• Other activities like applying RDBMS patches, security patches (CPUs), proactive monitoring of databases.
• Helped customers wif server sizing and capacity planning.

Confidential

Sr. Principal Consultant

Responsibilities:

• Implemented multiple servers in teh middle-tier layer of teh Oracle 11i E-business applications suite. Teh middle-tier layer was then load-balanced by leveraging Cisco’s Content Services Switch (CSS) technology. This was done to provide both teh scalability and high availability where multiple servers were used to provide redundancy/availability to avoid a single point of failure and load-balancing was used to scale up teh middle-tier layer for large number of concurrent user connections.
• Worked in a team environment to implement SSO/OID wif E-business suite.
• Configured Oracle Portal and integrated it wif E-business suite.
• Worked on Oracle Enterprise manager to analyze and monitor teh database performance and for DBA activities.
• Tune SQL Statements, Data load processes and application design.
• Monitored and effectively tuned teh 11i database instances by utilizing own scripts, Precise In-depth for Oracle and teh Stats Pack/AWR utilities.
• Implemented Secured Socket Layer (SSL) in teh 11i E-business applications suite to enable data encryption between teh client and teh middle-tier layer. This was first implemented and tested in teh lab and then promoted to production.
• Configured teh Apache server of teh Oracle 11i E-business suite to take advantage of multiple Java Virtual Machines (JVM) to avoid overloading of TEMPfewer JVMs
• Involved in Applications 11i administration including 11i Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Design and tested high availability architecture for Oracle 11i application wif RAC on OCFS.
• Upgraded teh 11i Oracle RDBMS instance to 64-bit on Solaris 2.8. This was done so dat teh System Global Area (SGA) could be scaled up beyond teh 3.2 GB boundary limit imposed by teh 32-bit RDBMS. This was also implemented as a pre-requisite task to implementing Quick me/O, ODM (Oracle Disk Manager) or RAW devices to allow these technologies to take advantage of teh larger Oracle cache while providing efficient me/O. This was first implemented and tested in teh lab and then promoted to production
• Configured Oracle 11i E-business applications suite wif AutoConfig
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered teh 11i instance production database as a result of data corruption by successfully applying teh archive redo log files
• Installed Oracle applications 11i E-business suite using multi-node architecture
• Upgraded Oracle’s 11i E-business suite from 11.5.6 to 11.5.9. Followed teh promote-to-production methodology where all supporting environments were first successfully upgraded prior to production
• Upgraded production database to 9i2.
• Implemented database auditing, data security and Remediate high-risk violations in production environment, calculators as per SARBOX policy requirements.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Provided DBA support in many implementations including customer and item loads.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.
• Helped customers wif server sizing and capacity planning.
• Involved in implementing sound backup/recovery strategy using RMAN.

Confidential

Principal Consultant Oracle DBA

Responsibilities:

• Upgraded multiple Oracles 9i to Oracle 11g R1.
• Besides in-place upgrade we also did platform migration for some small database from HP to Linux and Windows to Solaris.
• Supported production databases after teh migration and upgrades before handling operations to in-house DBAs.
• Developed and streamlined Backup, restore processes.
• Development cloning scripts.
• Tune SQL Statements, Data load processes and application design.
• Monitored and effectively tuned teh 11i database instances by utilizing own scripts, Precise In-depth for Oracle and teh Stats Pack/AWR utilities.
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered teh 11i instance production database as a result of data corruption by successfully applying teh archive redo log files
• Installed Oracle applications 11i E-business suite using multi-node architecture
• Upgraded Oracle’s 11i E-business suite from 11.5.6 to 11.5.9. Followed teh promote-to-production methodology where all supporting environments were first successfully upgraded prior to production
• Upgraded production database to 9i2.
• Implemented database auditing, data security and Remediate high-risk violations in production environment, calculators as per SARBOX policy requirements.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Provided DBA support in many implementations including customer and item loads.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.
• Helped customers wif server sizing and capacity planning.

Confidential

Principal Consultant

Responsibilities:

• Implemented multiple servers in teh middle-tier layer of teh Oracle 11i E-business applications suite. Teh middle-tier layer was then load-balanced by leveraging Cisco’s Content Services Switch (CSS) technology. This was done to provide both teh scalability and high availability where multiple servers were used to provide redundancy/availability to avoid a single point of failure and load-balancing was used to scale up teh middle-tier layer for large number of concurrent user connections.
• Worked in a team environment to implement SSO/OID wif E-business suite.
• Configured Oracle Portal and integrated it wif E-business suite.
• Worked on Oracle Enterprise manager to analyze and monitor teh database performance and for DBA activities.
• Tune SQL Statements, Dataload processes and application design.
• Monitored and effectively tuned teh 11i database instances by utilizing own scripts, Precise Indepth for Oracle and teh StatsPack/AWR utilities.
• Implemented Secured Socket Layer (SSL) in teh 11i E-business applications suite to enable data encryption between teh client and teh middle-tier layer. This was first implemented and tested in teh lab and then promoted to production.
• Configured teh Apache server of teh Oracle 11i E-business suite to take advantage of multiple Java Virtual Machines (JVM) to avoid overloading of TEMPfewer JVMs
• Involved in Applications 11i administration including 11i Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Design and tested high availability architecture for Oracle 11i application wif RAC on OCFS.
• Upgraded teh 11i Oracle RDBMS instance to 64-bit on Solaris 2.8. This was done so dat teh System Global Area (SGA) could be scaled up beyond teh 3.2 GB boundary limit imposed by teh 32-bit RDBMS. This was also implemented as a pre-requisite task to implementing Quick me/O, ODM (Oracle Disk Manager) or RAW devices to allow these technologies to take advantage of teh larger Oracle cache while providing efficient me/O. This was first implemented and tested in teh lab and then promoted to production
• Configured Oracle 11i E-business applications suite wif AutoConfig
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered teh 11i instance production database as a result of data corruption by successfully applying teh archive redo log files
• Installed Oracle applications 11i E-business suite using multi-node architecture
• Upgraded Oracle’s 11i E-business suite from 11.5.6 to 11.5.9. Followed teh promote-to-production methodology where all supporting environments were first successfully upgraded prior to production
• Upgraded production database to 9i2.
• Implemented database auditing, data security and Remediate high-risk voilation in production environment, calculators as per SARBOX policy requirements.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Provided DBA support in many implementations including customer and item loads.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Helped customers wif server sizing and capacity planning.
• Involved in implementing sound backup/recovery strategy using RMAN.

Confidential

Senior Information Specialist (Sr. Oracle DBA)

Responsibilities:

• Involved in Oracle Applications R11i installation/upgrade and system configuration.
• Worked wif development team for proactive tuning at application design stage and tuning data loading processes.
• Monitore application/database performance wif OEM, Statspack and Precise Indepth.
• Monitored and effectively tuned teh 11i database instances by utilizing own scripts, Precise Indepth for Oracle and teh StatsPack utilities.
• Tune application/SQL statements using tkprof and explain plan, oracle profiler and using wait interfaces.
• Write standard DBA procedures and practices.
• Evaluated different Oracle and Internet technologies and solutions.
• Design and tested high availability architecture for Oracle 11i application wif RAC on OCFS.
• Diagnosed and troubleshoot different aspects of Oracle Application system.
• Configured teh Apache server of teh Oracle 11i E-business suite to take advantage of multiple Java Virtual Machines (JVM) to avoid overloading of TEMPfewer JVMs
• Involved in Applications 11i administration including 11i Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Configured Oracle 11i E-business applications suite wif AutoConfig
• Cloned environments to create patch test, development and QA environments
• Designed, tested and documented a process to clone 11.5.x environments. This process was designed at a time when no other supported cloning process was available from Oracle
• Recovered teh 11i instance production database as a result of data corruption by successfully applying teh archive redo log files
• Provided DBA support in many implementations including customer and item loads.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Involved in implementing sound backup/recovery strategy using RMAN.

Confidential

Sr. Oracle DBA

Responsibilities:

• Involved in Oracle Applications R11i installation/upgrade and system configuration.
• Worked wif development team for proactive tuning at application design stage and tuning data loading processes.
• Create SQL scripts Excel spreadsheet to estimate and capture data growth.
• Monitore application/database performance wif OEM, Statspack and Precise Indepth.
• Monitored and effectively tuned teh 11i database instances by utilizing own scripts, Precise Indepth for Oracle and teh StatsPack utilities.
• Demonstrated Oracle 9iAS architecture and use of OID for centralized user management.
• Incorporated new features of Oracle 9i like Spfile, Locally managed tablespaces and bulk data load operations like INSERT ALL, MERGE and BULK INSERT etc.
• Demonstrated LDAP based user management and Fine Grained Access Control (VPD) and Auditing.
• Demonstrated use of advanced security options like Lable security.
• Tune application/SQL statements using tkprof and explain plan, oracle profiler and using wait interfaces.
• Write standard DBA procedures and practices.
• Evaluated different Oracle and Internet technologies and solutions.
• Involved in Applications 11i administration including 11i Database/Applications cloning, tuning, patching and monitoring concurrent manager processing etc.
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.
• Involved in implementing sound backup/recovery strategy using RMAN.

Confidential

Senior Information Specialist (Oracle DBA/Developer)

Responsibilities:

• Involved in custome development activities including system analysis, design and building system using Oracle Desiggner/2000, Oracle Developer/2000 and Oracle Database.
• Worked wif development team for proactive tuning at application design stage and tuning data loading processes.
• Created detail plan for installation, upgrade and migration of Oracle database and Oracle Applications.
• Performed system performance tuning.
• Monitore application/database performance wif OEM, Statspack and Precise Indepth.
• Monitored and effectively tuned teh Oralce database instances by utilizing own scripts, Precise Indepth for Oracle and teh StatsPack and ESTAT/BSTAT utilities.
• Run SQL scripts for AP, OE update and PO import from teh interface tables to Financials
• Applied OM patches downloaded from Metalink
• Tune application/SQL statements using tkprof and explain plan, oracle profiler and using wait interfaces.
• Write standard DBA procedures and practices.
• Run Autoupgrade
• Applied Mini Packs
• Applied High priority patches downloaded from Metalink
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.

Confidential

Information Specialist (Oracle DBA/Developer)

Responsibilities:

• Involved in custome development activities including system analysis, design and building system using Oracle Desiggner/2000, Oracle Developer/2000 and Oracle Database.
• Worked wif development team for proactive tuning at application design stage and tuning data loading processes.
• Created detail plan for installation, upgrade and migration of Oracle database and Oracle Applications.
• Performed system performance tuning.
• Monitore application/database performance wif OEM, Statspack and Precise Indepth.
• Monitored and effectively tuned teh Oralce database instances by utilizing own scripts, Precise Indepth for Oracle and teh StatsPack and ESTAT/BSTAT utilities.
• Run SQL scripts for AP, OE update and PO import from teh interface tables to Financials
• Applied OM patches downloaded from Metalink
• Tune application/SQL statements using tkprof and explain plan, oracle profiler and using wait interfaces.
• Write standard DBA procedures and practices.
• Run Autoupgrade
• Applied Mini Packs
• Applied High priority patches downloaded from Metalink
• Other activities like applying rdbms patches, security patches, proactive monitoring of databases.

Confidential

Information Specialist (Oracle DBA/Developer)

Responsibilities:

• Involved in custome development activities including system analysis, design and building system using Oracle Desiggner/2000, Oracle Developer/2000 and Oracle Database.
• Worked wif development team for proactive tuning at application design stage and tuning data loading processes.
• Worked on many custom applications like Financial, Order management, Confidential and used Oracle’s Developer/2000 (Forms 5.0/6.0) and SQL, PL/SQL to do develop database-stored procedures.
• Created detail plan for installation, upgrade and migration of Oracle database and Oracle Applications.
• Performed system performance tuning.
• Monitore application/database performance wif OEM, Statspack.
• Monitored and effectively tuned teh Oralce database instances by utilizing own scripts and teh Oracle ‘s ESTAT/BSTAT utilities.
• Creation, Configuration and maintaining database for IMN, Peterson Publishing.
• Developed scripts for creating databases, tablespaces, rollback segments and users as per teh specifications given by customers.
• Performed cold & hot (Physical) backups, logical backups of teh database.
• Created and managed users, roles and database access. Creating primary database objects (tables, views, indexes) once application developers has designed an application.
• Developed Database triggers and Stored Procedures for populating and updating data into different tables on ORACLE 7.3/8.0 Database Management Systems. Developed scripts for exporting and importing database.
• Installation of ORACLE Web Application Server on Sun Solaris 2.5, Windows NT 4.0.
• Deployed forms on web application server for Peterson project.
• Developed scripts for exporting and importing database.