Resume 11

• Over 5 Years of experience in database administration and development of application software under ORACLE, SQL server Environment. Thorough knowledge of ORACLE 7.x/8.0/8.1.5/8.1.6/8.1.7, SQL Server 6.5/7/2000, SAS 6.12/8.2 database and development tools.
• Server Administration, system study, analysis, design, development, testing and implementation with expertise in online transaction processing and multi-user systems involving large and distributed databases.
• Thorough knowledge of Normalization, Data Warehousing, Replication, and OLAP 24X7 support, data transfer, documentation, preventive maintenance, archive and purging, database security design and setup, client connectivity, developers support, code review, automation, store procedures and triggers writing, load balancing, remote administration etc.
• Performance tuning, database refresh, and day-to-day database monitoring activities.
• Created roles, Privileges and assigned roles to users. Used Explain Plan to monitor execution path.
• Used utilities like SQL Profiler, SQL Query Analyzer, SVRMGRL, Oracle Database Assistance, Oracle Enterprise Manager, and TKPROF for monitoring database performance.
• Hands on experience in ORADIM, ORACLE Net 8 Assistance, LSNRTC
• Performed database backup and recovery, Mirroring Redo log, Hot, Cold, EXP/IMP.
• Also worked on database creation, modeling, and calculation of object sizes and database sizes.
• Created tables in database with integrity constraints.

RDBMS
ORACLE 7.3/8i/8.1.5/8.1.6/8.1.7, SQL Server 6.5/7.0/2000, SAS6.12/8.2

DATA TOOLS
T-SQL, PL/SQL, SQL*PLUS 3.3/8.0/8.1.5/8.1.6, TKPROF, SVRMGR30, Oracle Net 8 Assistance, Oracle Enterprise Manager, Oracle Replication Server, Oracle Database Assistance, EXP/IMP, SQL Loader, Sql navigator, Business Objects, Performance Tuning by Using TKPROF as well as Clustering and Indexing, Backup/Recovery, OLAP, WEBDB, DTS, Query Analyzer, Oracle OEM, BCP, ISQL, Sql server Enterprise manager

OTHER TOOLS
Database-administration using DB-Artisan, Monitoring tool Spot Light, Data modeling tools like Erwin and Erstudio, Data junction, Toad.

Operating Systems
UNIX Sun Solaris, AIX , Windows NT, Linux, Win95/98, DOS

LANGUAGES
Unix Shell Programming, C and Fortran

INTERNET
XML, XSL, Java1.1/1.2, HTML, MS Access 95/97, Microsoft EXCEL, MS Office 2000, JSP, HTML.

Project: This is a branch of Nova located at Gaisenburg, MD. They mainly deal with genetic and genomic concepts for drug development. Here we get clinical trial data for analysis.

• Oracle production support and Development environment.
• Upgrading Oracle from 8.1.5 to 8.1.7, Installing 8.1.7 on new server.
• Designing new schema form the specks.
• Replication between oracle databases.
• Installing and upgrading oracle.
• Designing new databases for every different Clinical trial.
• All the clinical data is in sas files, which need to be exported to oracle tables. These sas files need to be uncompressed before loading into the oracle database.
• Regular maintenance and fine-tuning the database.
• Creating and managing stored procedures and triggers, distributed data, database replication, server tuning, automation of administrative tasks, backup s, restoring and recovering databases, user and security management, database optimization, determining common performance problems, monitoring, configuring servers, and efficient in handling front-ends activities
• Loading the clinical data from different sas formats to oracle using SQL loader and sas proc dbload.
• Data need to be extracted from different tables in different schemas/databases for analysis. Clinical data comes in different formats so its new scenario for every trial.
• Spreading the table and index data on different table spaces for better performance.

Environment: SUN SOLARIS 8, WINDOWS 2000 and REDHAT Linux, 0, SAS 6.12/8.2, ORACLE 8.1.7, Oracle Net 8Assistance, MS Access 95/97, Microsoft EXCEL, Microsoft Office 2000,DTS, Query Analyzer, Oracle OEM, DB-Artisan, EXPLAIN Plan, JSP, HTML, BCP, ISQL, Oracle Database Assistance, Perl, Backup And Recovery Utility, Exp/Imp, Tape backup, Enterprise Manager, Toad, Erwin.

Projects:
Ddtaxi: The ddtaxi service aggregates the largest Internet-enabled reservation booking service in the U.S. for the local point-to-point ground transportation industry. For the first time, corporate travelers, travel planners and consumers have a true reservation and confirmation advocate for taxi, sedan and limousine services. Ddtaxi is a one-stop, value-added solution that is accessible real time anywhere in the nation, plus five major Canadian cities.

Ddradio: The iQradio service is the first national database of radio stations searchable by the content played. You can locate stations playing your favorite artist, talk show, talk show host, sports team affiliate and network programming, wherever you are. By adding a preference profile, Ddradio can quickly find stations in any market that match your interests.

Dd411: Dd411 is the first and only directory information product with definitive directory data, providing the most accurate and findable data available. It s the cornerstone in consolidation of unrelated directory information data sources into a single consistent business process. A quantum leap forward for users of voice directory assistance and Web, the Dd411 platform empowers every business to enhance their competitive position by using definitive directory information that flexibly integrates with existing systems.

• Support for development and production databases.
• There are 2 development and 2 production Oracle servers with Oracle 8.1.5/8.1.6.
• Development of schema changes
• Development of product, quality testing and production database
• Changes are done using scripts from development up the chain to production databases. These changes scripts need to have a rollback script if changes need to be rollback.
• Refreshing the development databases from the production database.
• Remotely administrating the production database through VPN connection. This includes monitoring the database growth, checking for the performance bottlenecks and taking backups for disaster recovery.
• Responsible for installation ODBC Connectivity issues
• Translation of business requirements to an Enterprise Data model
• Planned and implemented various Transact-SQL statements, cursors, stored procedures and triggers
• Responsible for data modeling, creation of database device logical and physical design of the database
• Grant privileges to users to access systems and databases
• Establishing connectivity to databases and monitoring system performance
• Using Enterprise Manager and Query Analyzer to optimize the data flow on call for the production database
• Supporting the development schema design.
• Performance tuning the DML statements before including in the product development

Environment: SUN SOLARIS 2.6,WINDOWS 2000, ORACLE 8.1.6, Oracle Net 8.1.6Assistance, MS Access 95/97, Microsoft EXCEL, Microsoft Office 2000,DTS, Query Analyzer, Oracle OEM, DB-Artisan, EXPLAIN Plan, JSP, HTML, BCP, ISQL, Oracle Database Assistance, Backup And Recovery Utility, Exp/Imp, Net app s snapshot utility, DB-Artisan, Schema Manager, Sport light, Sql Navigator, ERWIN.

Projects: This project deals with selling of books online. Oracle is used as a back end for the application running on SAP system and SQL server handles inventory database. SAP application is used to handle parches orders of the books. The environment is Oracle 8.0 on AIX UNIX and Windows NT 4.0.

• Support the ORACLE production and development databases. There are about 1 production and 2 development databases each about 70Gb.
• Supporting the SQL SERVER production and development databases. There are about 27 production, 45 development servers and 72 databases.
• Designing the recovery plan. Supporting the testing group in running automated bridging applications.
• Analyzing and resizing objects for Production Database.
• Running imports/export utilities, off-line backup, on-line backup various Oracle/SQL server Applications utilities.
• DTS Package for data massage and data conversion from various databases and Flat files.
• Responsible for installation of SQL Server and ODBC Connectivity issues
• Translation of business requirements to an Enterprise Data model
• Worked on DTS, Import and Export utility, BCP Utility and replication tool
• Planned and implemented various Transact-SQL statements, cursors, stored procedures and triggers
• Responsible for data modeling, creation of database device logical and physical design of the database
• Grant privileges to users to access systems and databases
• Establishing connectivity to databases and monitoring system performance
• Using Enterprise Manager and Query Analyzer to optimize the data flow
• Setting up standby server and maintaining it.
• Performance Monitoring, estimate the number of users, CPU and Disk space requirement, identifying bottleneck and rectifying it, fine-tuned store procedures to improve performance, database loads performance improvements, proper setup of database files and file groups to boost performance on SQL Server 7.0.
• On call for the production database.

Environment: AIX UNIX, WINDOWS NT 4.0, ORACLE 8.0, SQL SERVER 6.5/7, Oracle Net 8.1.6Assistance, AltaVista Search engine, Enterprise manager, ODBC, DTS package, Backup and Recovery Utility, Exp/Imp, Tools, DB-Artisan, ERWIN.

Projects: This project is about medical product catalogs. Client deals with distribution of medical products. To deal with different catalogs we were given project to convert all the data into oracle database for faster access. In order to accomplish this the Medical database is presently being developed. Data is provided by the client in terms of printed Catalogs, used by the client for the selling of products. Database server Oracle and database size is about 10Gb.

• Handled Database size of about 10 GB.
• Data Modeling using Erwin 3.5.2. Creating schema, control file, set database initialization parameters and plan to distribute table spaces across different disks.
• Designed and developed scripts for administrative tasks like backups, tuning and refreshing test databases from production periodically.
• Responsible for fine-tuning production servers.
• Running imports/export utilities, off-line backup, on-line backup various, Oracle Applications, utilities.
• Tuning SQL applications with EXPLAIN PLAN AND TKPROF statistics.
• Pinning of Packages, procedures and functions in SGA Use of recovery strategy when required.
• Updating client s server after data has been QA for error ratification.
• Performance Monitoring, Tuning SQL , determine the size System Global Area SGA , estimate the number of users, CPU and Disk space requirement.
• Handled Database size of about 10 GB Data Modeling using Erwin 3.5.2 Creating schema, control file, set database initialization parameters and plan to distribute table spaces across different disks.
• Designed and developed scripts for administrative tasks like backups, tuning and refreshing test databases from production periodically.

Environment: NT, ORACLE 8.0, Oracle Net 8 Assistance, Oracle Database Assistance, Backup and Recovery Utility, Exp / Imp, Oracle Migration Tools, DB-Artisan.

This is a web base project aims to provide information for the people who need property details. There are two phases:

1. Commercial sales/lease
2. Residential sales/lease

• Designing of database from the specs provided by the client.
• Creating database, control file, set database initialization parameters and plan to distribute table spaces across different disks.
• Designed and developed scripts for administrative tasks like backups, tuning and refreshing test databases from production periodically.
• Analyzing and resizing objects for Production Database. Running imports/export utilities, off-line backup, on-line backup various Oracle Applications utilities Use of recovery strategy when required.
• Performance Monitoring, Tuning SQL , estimate the number of users, CPU and Disk space requirement.

Environment: NT4.0, MS SQL 6.5 /7.0, Visual Basic 5.0.

This is a web project aims to provide information about the food Products which our client would like to sell. This project got many features like registering a user displaying the Information about all food items and kitchen equipment. This is an E-com project where customers can buy through net. This web site provides place for advertisement for food products and kitchen equipment. Database server Oracle and database size about 7Gb.

• Designing of database from the specs provided by the client.
• Creating database, control file, set database initialization parameters and plan to distribute table spaces across different disks. Designed and developed scripts for administrative tasks like backups, tuning and refreshing test databases from production periodically.
• Analyzing and resizing objects for Production Database. Running imports/export utilities, off-line backup, on-line backup various Oracle Applications utilities.
• Use of recovery strategy when required. Performance Monitoring, Tuning SQL , determine the size of System Global Area SGA , estimate the number of users, CPU and Disk space requirement.

This is a web base project, which is made to holding information about the employ and project details. There are many modules like employs profile and project details like status of the project, problems faced while developing the project.

• Designing of database from the specs provided by the client Creating database, control file, set database initialization parameters and plan to distribute table spaces across different disks.
• Designed and developed scripts for administrative tasks like backups, tuning and refreshing test databases from production periodically.
• Analyzing and resizing objects for Production Database.
• Running imports/export utilities, off-line backup, on-line backup various Oracle Applications utilities.
• Use of recovery strategy when required.
• Performance Monitoring, Tuning SQL , determine the size of System Global Area SGA , estimate the number of users, CPU and Disk space requirement.

BS in Electronics & Telecommunications Engineering
Osmania University, Hyderabad, INDIA.
Diploma in Oracle-DBA
Training on MS SQL SERVER 7.0 / 2000.

Microsoft Certified Professional in WINDOWS NT SERVER 4.0