Site hosted by Angelfire.com: Build your free website today!

Close to 5 years of experience as an ORACLE DBA/Oracle Applications DBA carrying out Database Administrative activities on different platforms (Sun Sparc, HP UX, Windows NT.).

 

Database Administration activities included:

 

Ø                        Installing and maintaining Oracle Applications Versions 11i, 11.0.x, Applying patches, cloning environments from test to production and refresh from production to test.

Ø                        System administration activities (Managing concurrent managers, Creating of users, customizations and printer installs)

Ø                        Involved in setting up and maintaining of Symmetric Replication Server, Disaster Recovery systems and Web Server configuration

Ø                        Installation of Oracle Server, front-end tools like Performance pack, Developer 2000, Discoverer 2000, and Oracle Enterprise manager.

Ø                        Monitoring multiple databases using HP Open View and trouble shooting the alerts thrown by DBSPI.

Ø                        Documenting Installation, maintenance, backup, recovery and other maintenance procedures.

Ø                        Also included setting up of ORACLE user accounts and passwords, Database and Instance Creation, Database Space Management, distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize the data retrieval, Performance tuning & monitoring of the application, database and Unix kernel parameters, installing patches and upgrades and Documentation.

Ø                        Data modeling using ER Win

Ø                        MC Service Guard Implementation to Oracle Applications for Fail Over

Ø                        Recover Manager Configuration with HP OMNIBACK II for Multiple databases and automating the daily, weekly and monthly backups.

Ø                        Backup and Recovery, Database Tuning, Query optimization and establishing Client Server connectivity.

Ø                        Shell scripts for automatic startup and shutdown of databases as well as automated backups.

Ø                        Performance Tuning

 

 

Skills

 

Close to a year of experience as ORACLE Applications 11i DBA, with responsibilities like installation, upgrade, migration, implementation, maintenance, general administration, and performance tuning of ORACLE Applications and other 3rd party tools.

 

Hardware:  Sun Ultra, HP 9000 V, N, & D Class , IBM PC 486, Pentium.

 

RDBMS: ORACLE 7.x/8i, SQL Server 2000/7

 

ERP: ORACLE Applications 11i (11.5.3,11.5.2 & 11.5.1)/ 11.0.x, 10.7

 

DBA Tools: Enterprise Manager 2.x, DBArtirsan, DataJunction, Power Designer, Performance Pack, ORACLE Names Server, and Omni Back Backup Utility.

 

CASE Tools: ERWIN

 

Programming Languages: C, PL/SQL, Pro *C, UNIX Shell Scripts, Java, C++, Java Script

Operating Systems: UNIX, Solaris, HP-UX, AIX, MS-DOS, MS-Windows 3.1/95/98, Windows NT/2000

 

Management/Leadership Skills: Effective in small to large teams, Mentor team members, Take big picture view and Practice leadership principles.

Professional Development: Consulting Skills, Team Based Problem Solving, Systems Analysis and Design, Interpersonal Relations, Communications/Presentation Skills and Project Management.             

 

All projects listed below were accomplished in a team based environment where there was opportunity to be involved both as a team member and a project leader.

 

Professional Experience/Accomplishments

 

Work Experience:

 

1.             ACNielsen                            Database Administrator                     August 2000 to Till Date

 

ACNielsen offer the most comprehensive array of marketing information services available today. By utilizing the most advanced scanning technology, integrated databases and data delivery systems ACNielsen help manufacturers and retailers gain critical insights into their business, their competition and their consumers. ACNielsen enable clients to determine who buys what, how much they buy, where they shop and what influences their shopping decisions.

I worked as a Database Administrator in Total Order Processing System Project.

 

The salient features accomplished as a consultant in ACNielsen are

 

Ø       Installation of Oracle Applications 11.5.4 on Sun Sparc Solaris 2.8

Ø       Implemented Forms Load Balancing in Oracle Applications on Sun Sparc Platform

Ø       Maintenance and regular refresh of development database from the production database.

Ø       Supporting Developers in Application development

Ø       Applying the patches for fixing the problems faced by Developers and Documenting them

Ø       Upgraded Oracle Applications from 11.5.3 to 11.5.4

Ø       Implemented Oracle Enterprise Manager 2.2 for managing Oracle Applications 11.5.4 Database

Ø       Upgraded Oracle Database from 8.1.6.3 to 8.1.7.1

Ø       Applied Oracle Order Management Family Pack E for Applications 11.5.3

Ø       Configured Work Flow Mailer to receive notifications of outstanding work items and respond to those notifications using their E–mail application of choice

Ø       Worked closely with Configurator Developers in resolving bugs and migrating Configuring data from one instance to the other

Ø       Gathered statistics for Application databases for better performance with Cost Based Optimization

Ø       Conducting Sizing/Capacity Planning efforts for the ORACLE Database and Applications

Ø       Informing the Developers about the latest patches available and the fixes for the bugs.

Ø       Maintaining Patches Spread sheet and Documenting the issues logged with Oracle Support

Ø       Training System Administrator for setting up security, printer configuration, patch research and maintenance.

Ø       Implemented Oracle Application Management Pack 2.2 for managing Oracle Applications.

 

 

2.             Avasta Inc                             Database Administrator                     June 2000 to June 2001

Avasta Inc offers emerging and expanding ASP companies the opportunity to access a ready-made, highly available, secure, scalable, completely managed, world-class infrastructure previously only available to Fortune 50 companies.

This comprehensive solution is comprised of Infrastructure-on-Tap™ and integrated services including full application management and monitoring services hosted in a world-class Internet Data Center.

 
Worked as consultant from June 2000 to January 2001 and then as employee till June 2001.
Role includes following administrative & development Tasks at my experiences:

 

People PC

Ø       Installation of Oracle Applications 11.5.1 on HP Unix 11.

Ø       Migration of Oracle Applications data from Sun Solaris to HP UX 11

Ø       Upgrading to Oracle Applications 11.5.1 to 11.5.2 on HP UX 11 platform

Ø       Documenting complete installed architecture and all issues logged with Oracle Support.

Ø       Conducting Sizing/Capacity Planning efforts for the ORACLE Database and Applications

Ø       24X7 support for Production & Test Environments

Ø       Cloning Environments from production to Test

Ø       Regular Test Application environment refresh from Production

Ø       Informing the customer with latest patch sets and applying them upon request.

Ø       Troubleshooting concurrent manager problems

Ø       System Administration tasks & troubleshooting the user problems with ADI &other issues

Ø       Configured MC Service Guard ( Fail Over) on Production environment.

Ø       Regular monitoring of invalid objects and compiling them.

 

Pay Map

Ø       Installed Oracle Applications 11.5.3 on Sun Solaris 2.8

Ø       Upgrading to Platinum Environment is to provide a near fully patched environment up to the latest patch level, including all prerequisite patches. Time to install patches is greatly reduced.

Ø       Installed Omni Back agents on Solaris server and integrated with Recovery Manager configuration.

Ø       Trained application developers in setting up Application Desktop Integrator & troubleshooting.

Ø       Regular monitoring of Database and Concurrent managers

Ø       Configured DBSPI agents in all production, test and development environments to monitor through HP Open View.

Ø       Applying patches to development, test and Production environments.

Ø       Refreshing Test Environment regularly from the production environment.

 

Anderson Consulting

Ø       Installed Oracle 8.1.5 and configured for JD Edwards ERP Application

Ø       Configured OMNIBACK & RMAN for Oracle Databases for JD Edwards

Ø       Installation & maintenance of SQL Server 2000 databases

Ø       SQL Server 2000 Database designing, re-engineering databases and data modeling using Erwin and power designer, installing database servers, configuring server on the network, OLAP services includes (working with pivot table services, linked OLAP Servers, multidimensional expressions (MDX) which includes querying and building various kinds of functions), creating and managing stored procedures and triggers, database replication, server tuning, automation of administrative tasks, backup’s, restoring and recovering databases ,user and security management , database optimization ,determining common performance problems

 

Deloitte Consulting

 

Ø      Installation & Maintenance of Oracle Applications 11.5.3 on Windows NT environment for Demonstration.

 

3. CySphere.com Pvt Ltd                    Database Administrator                     December 1999 to May 2000

 

Salient tasks accomplished are

 

Ø       Remote administration of  Oracle 8 web Casino Databases on Sun Solaris 2.7 ( www.luckyland.com, www.megaplay.com, www.bigcat.com, www.planetluck.com, www.zantana.com, www.slcasino.com, www.bigcat.com ).

Ø       Upgraded Casino Database (about 30 GB ) based on Oracle, from 7.3 to 8.0.5 running on Solaris 2.7.

Ø       Developed distributed database environments between different Oracle servers.

Ø       Optimized INIT.ORA parameters to best utilize the new system’s resources.

Ø       Involved in Installation of Oracle Web Application Server 3.0 and writing reports and stored procedures.

Ø       Designed and developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Ø       Performance tuning for history tables which are as big as 1.5 million rows, to access the data faster.

Ø       Used ERWIN tools for ER Diagrams and to implement business rules for table structures and database triggers.

Ø       Implement nightly cron jobs to print DBA reports.

Ø       Implemented nightly backup routines, which include database exports, tape backups

Ø       Database files to the development server for precautionary measures.

Ø       Oracle DBA experience include reorganization of databases, monitoring tablespaces, indexes, extents, performance tuning.

 

Environment:

Oracle Web Application Server 3.0/4.0, ORACLE 7.3.2.3/8.0.5.1/8i, ORACLE Enterprise Manager, Performance Pack, Sun Solaris 2.7, Windows NT/95

 

2. ICFAIN Center for Information Technology, Database Administrator, February 1999 to December 1999

 

Salient tasks accomplished are:

 

Ø       Installation of Oracle Applications Release 11.0.2, upgrading the Applications from 10.7 to 11.0 and maintaining the Applications Databases.

Ø       Automated backup procedures for Production, Test and Development environments

Ø       Responsible for development and customization of reports.

Ø       Also performed the duties of Oracle Apps system administrator.

Ø       Designing a high availability 24*7 hour’s databases and hardware infrastructure.

Ø       Working closely with the application development team for the Bug Fixes and Escalation

Ø       Installation and Configuration of ORACLE Enterprise Manger and Performance Pack monitoring tool

Ø       Extensive Tuning of Concurrent managers, database server, Operating System and 3rd Party Software’s. Tools like ORACLE Enterprise Manager (OEM) with Performance Pack were used for getting optimum performance.

Ø       Optimized INIT.ORA parameters to best utilize the new system’s resources.

Ø       Developed distributed database between different Oracle servers.

Ø       Upgraded prod database (about 10 GB in size) based on Oracle, from Oracle 7.3.2 to Oracle 8.0 running on NT server.

Ø       Provided training to developers in writing and tuning PL/SQL stored procedures.

Ø       Analyzed and modified the back-end database and front-end application to maximize productivity.

Ø       Created database links and Snapshots to update corporate database for billing purposes.

Ø       Implemented Oracle’s logical disk striping on SUN server by spreading tablespaces across disk drives.

 

 

Skills:

 

Have knowledge in both Finance and Manufacturing Modules, Oracle DBA, Unix-Internals including shell programming, terminfo, kernel modifications, performance tuning, printer interfacing and SCO’s sysadmin. Re-organization of databases, monitoring tablespaces, indexes, extents, performance tuning.

 

Environment:

 

ORACLE Applications 10.7SC/11, ORACLE 7.3.2.3/8.0.5.1/8i, ORACLE Enterprise Manager, Performance Pack, Omni Back Backup Utility, HP T500/8 CPU’s with OS10.10, Windows NT/95

 

 

4.  Indian Institute of Technology, Kharagpur, India, Systems and Database Administrator, February 1998 to December 1998

 

Tasks accomplished are

Ø       Created database links and Snapshots to update corporate database for billing purposes.

Ø       Designed and developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Ø       Install Oracle 7.2.3 on SCO-Unix server. Establishing SQL*Net V2 between SCO UNIX Box and Windows-NT Workstations using TCP/IP Protocol.

Ø       Automated Backup shell scripts for incremental and full backups on a daily, weekly and fortnight basis and   involved in Media-Recovery Procedures of ORACLE Database

Ø       System maintenance, and performance tuning

Ø       Installation of Solaris 2.X and SCO 5.X, and Windows NT 4.0

Ø       Configuration of DHCP, DNS, MAIL, NFS, NIS+ servers

Ø       Customization user and system environments in the Systems Laboratory               

Ø       Configuration of File Systems and automation of jobs (Cron, at)

Ø       SCO-Unix with WIDE-SCSI-RAID controller with Level-5 option for fault-tolerance and maximum throughput.

 

Responsible for

Installing and creating Oracle 8.0.4 database with context cartridge option, Sizing of different databases Objects, maintenance of Development databases, System/Oracle Performance Tuning (Memory & I/O), Reorganizing of Databases, Oracle Upgrades, Backup & Recovery of test Databases, configuring Oracle ODBC drivers, Configuring Tnsnames, listener and creating Database links.

 

Tools used

   Xvision, VisionFS, Termite, Solstice.

                                                                                                                                                                          

5. Visaka IndustriesLtd.,Hyderabad.      Programmer/DBA                                Jun 1996 to  July 1997

 

Project:                  Dispatch System for Textile Division                             

 

Description:    The dispatch system at Factory site records the Production. Production packing, finished goods movement and carries out dispatch instructions from the Head Office and accordingly generates the delivery Chelan and related reports.

 

                      Designed the logical and physical Models of the database using Erwin tools and also written stored procedures, functions, packages and database triggers. He was also responsible for DBA activities such as application tuning, taking backup, creating new database users and also created the database scripts for the application.

 

Environment:        Novel NetWare 3.12, Oracle 7.X, Developer 2000 (Forms 4.5 & Reports 2.5)

 

 

Project:                 Raw Material System for Textile Division

 

Description: This system supports in various operations of Raw Material Department such as Weight List and Requisition. It also generates reports for management information such as Form – IV. R.G. 23 A Part-I, Bales Stock register and Fiber wise Raw Material status etc.

 

Involved in Oracle database creation, design and implementation of data backup and recovery, capacity planning, performance tuning and data migration and data conversion.. Also involved in analysis, design, development and testing  of the software.  Developed the input screen for entering the details of the pensioners using Forms 4.5 and developed the report modules using Reports 2.5 for generating the above mentioned reports and screens.

 

Education Summary

 

Master of Technology  - from   Indian Institute of Technology, Kharagpur, India,

 

Ø                        Acquired distinction with 76% marks and University Grant Commission scholarship.

 

Bachelor of  Engineering - from Osmania University, Hyderabad, India.

 

Ø                        Accomplished Merit Scholarship for Technical paper presentation.

 

 

References:

Available up on request