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