dinesh kumar

* Roles and Responsibilities: * Administered Production and Development Databases, Migration of Existing 9i Databases to 10g as well as applying Patches * Implementing and Automating Custom Extraction, Transformation and Loading (ETL) stages for new Data Marts/Enhancements using Shell Scripting, SQL and Pl/Sql * Involved in Performance Tuning of Pl/Sql Applications and Databases * Performed Data Modeling Activities using ERWin. * 24 * 7 on call production support for 4 Banking Applications across 48 Countries. * Feasibility study of Oracle Warehouse Builder as a alternative to the current setup * Environment: * Oracle Database 9i/10g, PL/SQL 9i/10g, Shell Scripting, ERWin R7, Oracle Warehouse Builder (10g) (Feasibility study), RAC, JSP, Sun Solaris 10

* Involved in a migration project in which Banking Applications were migrated from 8i Database (Designer 6, Developer 2k) to 9i Database (Designer 6i/9i, Developer 9i) * Performing daily and weekly monitoring of database, which includes: space usage, data fragmentation, Oracle server performance, Oracle alert logs, object growth, and indexes and tables stored within the database * Evaluating the future growth of the database, estimating disk storage capacity requirements to identify possible I/O bottlenecks, tuning the instance and managing the SGA to improve application CACHE hit ratio. * Monitoring the database by running statspack & RDA set interval to gather statistics information. * Developed 2 Banking Applications using Pl/Sql, Developer and Designer * Received the Best Performance Award for successfully completing this Crisis Project

* Developed a Protocol Analyzer for V5.2 Protocol using Pl/Sql. * This Application dequeues protocol operational messages and these messages are used to validate the packets. * Responsible for rolling up the application into Production as well as Managing the Production Database on which this Application was deployed. * Project was completed within 3/4th of the scheduled duration. * Was involved in Module Integration, User Acceptance Testing, Production Support, Database Administration and Documentation.

* Roles and Responsibilities: * Enhancing and Managing Oracle Designer Applications and Databases * Providing Technical Product Support to Gold/Silver/Oracle Hosted Customers in DBA Activities like SQL, Pl/Sql Issues, Database Utilities (Exp/Imp Utility, Sql * Loader etc), Core DBA Activities, Performance Tuning * Developing and Implementing Tools using Shell Scripting, SQL and Pl/Sql that will assist in DBA Tasks. * Analyzing, Testing and Reviewing New Features and Functionalities in New Releases (9i/10g) of Competency Products (Pl/Sql, SQL, DBA Utils) and Impact Analysis on Client’s Applications * Delivering Tech Talks, Seminars and Trainings both within and outside Oracle. * Posting and Reviewing Technical Articles/Documents on Metalink * Coordinating with team members and identifying Improvement Areas technically * Pro-actively identify Processes to be followed within the team and across teams * Handling Critical Business Loss Situations for Clients

* Handling Database Server Tuning, Application Tuning and Capacity Planning in RAC Environment. * Creating/Automating Crucial Maintenance Tasks using Shell Scripting, SQL and Pl/Sql. * Installing 10g Databases, Migrating Existing 9i Databases to 10g as well as applying Patches. * Performing Data Modeling Activities using ERWin 7.0 * Performing key role in defining Database Change Process for the entire organization. * Supported Reporting Teams and Application Teams in writing complex SQL Queries and Pl/Sql Constructs. * Reorganizing Databases and Database Objects to meet Standards & improve performance by 30%. * Configured RMAN for Backup & Recovery, Oracle Enterprise Manager(OEM) for system monitoring * Generating Critical Management Reports for relevant Application Tasks, Periodic Space Utilization of Database, Users and Objects. * Imparting training and guidance to Dev and Testing teams for better use of database technologies. * RAC, RMAN and Java.