Main page

Resume # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

7. Database Administrator


1

Over 10 years of extensive Oracle experience as a Oracle DBA/ Oracle Financials DBA , Senior Programmer, Designer, Team Leader and Developer in the analysis, design, development and implementation of variety of complex business systems under various platforms. Specializes in Oracle DBMS (Ver 8.1.7 / 8.1.6/8.0.5/7.3.x) and Oracle Database Administration and development tools. Strong experience in supporting multiple production and development databases under Unix and NT environments. Involved in database design, Installations, upgrades, performance Tuning, configuring standby databases, scheduling backups/recovery, migrating databases, UNIX shell scripting. Involved in Documentation, data migration, entity relationship design and database development including stored procedures, database triggers. Have Strong Oracle Development background besides DBA skills of 24X7 environment, ability to work in team and with individuals of different skill levels and trong commitment to get job done under pressure.

Skill Software:

  • Oracle 8.1.7/8.1.6/8.0.X/7.3.X,Oracle Applications 10.7.0 SC 16, Developer / Designer 2000 2.1, Enterprise Manager 2.1 /2.0, Recovery Manager, Oracle Designer/CASE, Enterprise Backup Utility, Forms 4.5 To 2.3, Oracle Report Writer 2.5/2.0/1.1, SQL PLUS 3.3, Ingress,Pro
  • C, ERWin 3.2, DB Artisan, ER Studio. Recovery Manager, Cold Fusion 4.5 .
  • Hardware:

    Sun E4500/E5500/E3500, IBM RS/6000, DEC Alpha 2100, Data General 9600, HP 9000, Pentium and NT/95 Work stations, IBM 7013-j30 , Alpha 800 5/333. O/S: Sun Solaris 2.8/2.7/2.6, Aix Ver 4, Sco Unix System V Rel 3.2, OS/2 Ver 2.1, HP-Unix Ver.A.09.04, OpenVMS VAX 6.1, DG/UX Rel 5.2 Windows NT Ver 4.0

    Professional Experience

    September 2000 to tilldate Oracle DBA/Developer
    Client : **************
    ************** is onlie retailer which permits users to stream professionally programmed music for free, browse information about the artist and title, and listen to audio samples from that CD, as well as the option to purchase CDs and music related merchandise online. Musicplex provides audio streaming in the Windows Media format at 20, 32 and 96 KB per seconds for use with the Windows Media player. The Musicplex streaming player also offers easy-to-navigate user interface and rich artist content.
    Working as a Sole Oracle DBA to support multiple production and development oracle 8.1.X databases running on Sun Solaris E250 and E450. Involved in Database Design, Performance tuning, PL-SQL Coding, database procedures and triggers, Backup/recovery and performance tuning. Setup Production and development databases with MTS configuration. Actively worked with many vendors for schema layout. Installed Coldfusion and Apache web server on Sun E450/250 machines.
    Resolved many oracle performance issues involving disk /o, CPU usage, SQL tuning.
    Worked with developers with Oracle issues and assisted in SQL tuning and PL-SQL coding. Involved in conversion from SQL Server to Oracle.
    Environment: SUN Solaris 2.7, E450/E250, Dell PowerEdge 6450, Windows NT 4.0, Oracle 8.1.7/8.1.6/8.1.5, Oracle Enterprise Manager, SQL Loader, Cold Fusion 4.5, Apache Web Server, Intershop, ERwin Designer 3.2, Tools for Oracle Application Developers, SQL Plus and Oracle Utilities, shell scripting.

    March 2000 to Sep'2000 Oracle 8i Sr. DBA/Developer
    Client: Client : **************
    ************** is an Online Auto Bying service where consumers can research, price, design, order and arrange for delivery of a new vehicle at their home or the office. Nationally launched in May 1999, the company capitalizes on the convergence of e-commerce with the growing "commoditization" of automobiles. Worked as an oracle 8i DBA to support multiple development and productions databases under SUN SPARC E4500, E3500 hrdware. Involved in oracle 8.1.5/8.1.6/8.0.5 installations, upgrades, performance tuning, Developing backup and restore strategies. Involved in setting up Oracle Enterprise manager, Recovery manager, Oracle Partitioning, developing efficient PL-SQL scripts, configuring cold / hot backups. Worked with team of KPMG developers for data loading/SQL Tuning and writing PL-SQL procedures. Involved in developing stategies for efficient oracle performance such as disk i/o, cpu and memory optimization. Configured Standby databases for recovery purposes and developed shell scripts for database monitoring.
    Environment: SUN Solaris 2.7, E4500/E3500/Ultra 450, Windows NT 4.0, Oracle 8.1.6/8.1.5/ 8.0.5, Oracle Enterprise Manager, SQL Loader, DBArtisan, Recovery Manager, ERwin Designer 3.2, Tools for Oracle Application Developers, SQL Plus and Oracle Utilities, shell scripting.

    April-99 to March-2000 Oracle Sr.DBA /Sr. Developer
    Client : **************
    Dscription:
    Worked as an Oracle DBA / DBA-Developer on a Product soley developed by a Relsys International, called Argus Safety, a comprehensive global safety surveillance system for enterprise-wide pharmacovigilance. Argus Safety was developed to meet the needs of the today's global health care concerns. It was oracle-based, Multi-tier, client/server solution. Tools involved were Oracle 7.3.4, Oracle 8.0.5, PL-SQL/SQL Plus and ERWin Designer.
    Argus saftety was implemented on Distributed databases at multiple clients including Novartis, Smithkline Beecham, Proctor and Gamble. Actively involved in writing the compact code for Symetric replication using PL/SQL, database triggers and procedures. Succesfully implemented Replication for Argus Safety for multiple clients at multiple sites (2 sites in Switzerland, one site in UK and US), Involved in Fine tunnig the Replication code to give over 50,000 transactions across the network. Involved in creating and maintaining databases unde Windows NT, Unix enviroenment.
    Succesfully Implemented strategy for backup and recovery of distributed databases under replicated environment. Involved in dba training, day-to-day DBA tasks, documentation, performance tuning, backup/recovery, Oracle 8/8.05/8i installations, upgrades and supporting large relational databases, Logical and physical database design, UNIX shell scripting.
    Environment: IBM RS 6000, Aix 4.2.1, Sun Solaris 2.7, E3500, Windows NT 4.0, Oracle 8.0.5/7.3.3/7.3.4/8i, Oracle Enterprise Manager, SQL Loader, ERwin Designer 3.2, Tools for Oracle Application Developers, SQL Plus.

    June'98 to March ' 99. Oracle DBA
    Client : **************
    Description : Worked as an Oracle DBA on FUNDS application solely developed by Nevada Power Company. Supported 5 other third party oracle applications. Main duties involved mentoring other DBA 's in the process of Implementation , Design, Documentation and Performance Tuning. Involved in Implementation , upgrading and recovery. Implemented new instances for 3rd Party Applications and involved in performance monitoring. Demonstrated Recovery strategies under different failure conditions. Actively Involved in working with development team for efficient SQL/PLSQL development /database triggers/procedures, developed Unix shell scripts, performance tuning scripts , backup strategies and project development documentation. Involved in Database tuning and performance, backup and recovery, and volume management. Developed and implemented strategy for maintaining security roles, privileges, and authentication. Environment: IBM 7013-j30 / IBM RS 6000, Aix Ver 4.2.1, Alpha 800 5/333 Windows NT 4.0, ORACLE 8.0.5/7.3.3. PL /SQL Developer/Designer 2000 Ver 2.1, Oracle Enterprise Manager 1.4.1, SQL Loader, Oracle Utilities. Recovery Manager

    April'98 to May'98 Oracle Applications DBA/Developer
    Client : **************
    Description : Implemented Oracle Applications 10.7 SC 16 on IBM RS 6000,Aix 4 on oracle instance. Developed strategies for Monitoring, tuning and developed SQL/Shell scripts for it. Worked on Oracle Human Resources Module for setting up Oracle Alerts for Changes in Employee details. Assisted in Performance Tuning/Optimization. Involved in applying patches and resolving database issues. Provided assistance in setting up instances, tablespaces, tables, indices, and views at the application level. Installed Oracle rdbms and tools, and helped in system tuning and database conversion/migration. Duties involved were to collect and analyze relevant application performance information using tools, Identify and implement appropriate solutions for database performance problems, Develop and implement strategy for maintaining security roles, privileges, and authentication, Database tuning and performance, backup and recovery, and efficient volume management. Environment : IBM RS 6000,Aix Ver 4.0 , Oracle Applications 10.7 SC16.1. Developer 2000 Ver 1.3.2 , Designer 2000 Ver 1.3.2. PL/SQL, Oracle 7.3.3. Windows NT 4.0/Alpha.

    September'97 - April'98. Oracle Applications DBA
    Client Name : **************
    Description :
    ************** is joint venture of Sega of Japan, Universal studios and DreamWorks SKG which in actively involved in entertainment business with arcades in Vegas, Seattle, Ontario, and Grapewine. Working as a application DBA on 5 databases each with average size of over 15GB ( Oracle Apps ) and 2 KRONOS databases over 10GB for time keeping. Solely involved in routine maintenance, storage management, indexing, optimization , monitoring , fine tuning, Backup and recovery. Involved in applying client/server Application patches, user admin., support , refreshing databases, helping developers with SQL tuning/optimization, writing database triggers/procedures/packages. Involved in trouble shooting and upgrades. Developed Uni shell (Korn) scripts to automate tasks for database monitoring. Worked in converting data from MICROS-8700 which involved data modeling, module design, table design. Used SQL Loader, PL/SQL, Developer 2000 tools like Forms 4.5 and Reports 2.5 along with database triggers/procedures to automate payroll tasks.
    Environment: Sun Spark Enterprise 3000, Sun Solaris 2.5.1, ORACLE 7.3.2.3, Oracle Applications 10.7.0 SC 16,, Developer 2000, Oracle Enterprise Manager 1.2, PL/SQL 3.3. SQL Loader.

    April'97 - Sept'97 DBA/Senior Programmer
    Voyage Accounting System/Vessel Management System,
    Client : **************
    Description :
    ************** owns and operates one of the largest oil company tanker fleets. To support its worldwide operations. It is headquartered in San Francisco, California. The company owns and operates 35 tankers that total more than 5 million deadweight tons. Initially Involved in Performancetuning of domestic calculation Module for response time. This module involved extensive use of Pro c/Report Writer 2.5, Forms 4.5 and PL/SQL along with Optimization techniques. All the modules were thoroughly modified for best response time and response time was brought down to couple of minutes from couple of hours. Successfully tuned database for performance issues , indexing, SGA tuning , de-fragmentation, tablespace re-sizing, tuning SGA and applications. Involved in developing shell scripts, Unix administration.
    Environment: Oracle 7.3, PL/SQL 3.1, Report Writer 2.5, SQL Forms 4.5/3.0, Pro C, Developer 2000, Designer 2000. IBM AIX Ver 3.2 for RS/6000.

    May'96 - Feb'97 DBA/Developer
    Claims Conversion System/ Premium System / Loss Analysis System. Client : **************
    Description :
    Argonaut Insurance mainly deals with Worker's Compensation, General Liability and Commercial Auto/Property Insurance fo businesses. The project is based on distributed databases with Corporate Database on Sequent Server ( HP 9000 ). Involved in writing Pro C Programs to convert data from mainframe to Oracle 7.1 database. Worked individually to write complex Pro c programs which used to read flat files and convert data according to complex business rules.
    Environment: Oracle 7.1, PL/SQL , SQL Forms 4.5/3.0 , Pro C, Hp-Unix, Developer 2000/Designer 2000. SQL Operator, Rumba For Mainframe Ver. 4.0.

    August '95 -Feb'96 Systems Analyst/Developer
    Client : **************
    Description :
    Colonial is a Non-Standard Insurance Company of California involved in Automobile Insurance. Primary responsibilities include gathering of system requirements. Designer 2000 Analysis Tools like Process Modeller, ER Diagrammer, Function Hierarchy Diagrammer and Dataflow Diagrammer , Reverse Engineering , Module LogicNavigator , Generators were used in this Project. Environment: Designer 2000/Developer 2000, Oracle 7.1, PL/SQL , SQL forms Q+E and Impromptu report writer.

    May '95 -August'95 Systems Analyst/Programmer/Asst. DBA Claims Transaction Processing. Client : **************
    Description :
    RxNet Specializes in the management of prescription drug benefit programs. As part of a managed cared network, Rxnet Processes prescription claims selected benefits, then includes drug utilization and review of it's clients. This Includes both processing, payment and analysis of prescription drug claims. Role:
    Involved in developing Automated Report Processes Module (ARP) which automatically executes daily, monthly, weekly, semi-monthly, quarterly, annually depending on execution frequency and parameters specified. Involved in extensive use of Pro C, SQL Forms 3.0/4.0, Report Writer 2.0/1.1, PL SQL 2.0, Database Triggers/Procedures and soe level of shell programming.
    Environment: Oracle 7.0, Sql Forms 4.0/3.0 , Reportwriter 1.1, Sco Unix 4.2, Oracle Case

    December 1994 - April '95 Systems Analyst/Programmer
    Membership Management System.
    Client : **************
    This system has been developed for keeping a track of all small businesses and their dependent businesses and their contacts. Tools like SQL REPORTWRITER 1.1/2.0, SQL MENU 5.0 were used.
    Environment: Oracle 7.1, Forms 4.0/3.0, SQL Reportwriter 2.0/1.1, SQL Menu.

    November 1993 - December 1994 Designer / Programmer / Asst. DBA
    Asset Management System. Client Name : *************
    This project was a conversion of an Asset Management System from ORACLE 6.0, SQL Forms 2.3, And SQL Plus, RPT To Oracle 7.0, Oracle Forms 4.0 And Oracle Report Writer 2.0. Involved in reverse engineering of Actively involed in routine maintenance, storage management, indexing, optimization, monitoring, fine-tuning, and backup/recovery.
    Environment: Oracle 7.0, SQL Forms 3.0, Reportwriter 1.1, Sco Unix 4.2, PL/SQL,

    May 1993 - November 1993 Module Leader / Programmer Analyst / DBA
    Radiology Information Management System.
    Client : **************
    Involved in the technical design and development of various forms including master-detain relationships, data entries having complex triggers, parent-child relationship reports; and testing and integration of forms using SQLMENU. Performed Assistant DBA roles when required. Environment: Oracle 6.0, Oracle Case 5.0, PlSql 2.0, SQLForms 3.0, OracleMenu 5.0, Unix

    June 90 - May 1993 Programmer/Analyst
    Inventory Management System / Payroll System / Financial Accounting System / Commercial Business
    Software' s Environment: Oracle 6.0, Forms 3.0 Menu 5.0,Reportwriter 1.1, Sco Unix 3.2

    EDUCATION

    Bachelors of Engineering in Electronics & Telecommunications From Govt. College of Engineering, Pune, India. Post Graduate Diploma in Computer Studies ( BITS, Bombay, India ).

    TRAINING:
    Advanced Course in Database Administration at University of California, Berkeley.


    2

    SUMMARY

    SENIOR DATA BASE CONSULTANT WITH OVER 32 YEARS EXPERIENCE

  • 20 years experience as an IMS DBA
  • 15 years experience as a DB2 DBA
  • 2 years experience working with ORACLE
  • Expert level knowledge of IMS and DB2
  • Working level knowledge of UDB, SYBASE and ORACLE
  • Team and project management
  • Team and project leadership
  • Data and Process Modeling
  • Data Analysis
  • Data Base Design
  • Data Base Implementation and Support
  • Data Base Monitoring andTuning
  • Expert level knowledge of IBM, BMC and PLATINUM tools and utilities
  • Expert level knowledge of DBRC
  • ENVIRONMENTS
  • IMS DB/DC, IMS DB/CICS
  • DB2/IMS DC, DB2/CICS
  • IBM 3090/308X
  • VSAM
  • IEF/COMPOSER
  • SQL
  • COBOL, COBOL II
  • MVS/XA
  • TSO/ISPF
  • JCL
  • OS/390
  • PROFESSIONAL EXPERIENCE

    JULY 2000 TO NOVEMBER 2000 - ***************
    DB2 DBA

  • Assigned to Vanguard.
  • Did the Physical assessment of several subject areas.
  • Developed criteria for the assessment
  • Developed tools for interogating the DB2 catalogue and Tables
  • Made recommendations for improving the subject areas.
  • Walked thru recommendations with client personnel
  • APRIL 2000 TO July 2000 - ***************
    Senior DATABASE Consultant

  • Coordinate the merging of the European data centers with the US
  • Developed strategies for backup/recovery/reorg for IMS/DB2 databases
  • Resized Data bases fr merging with the US
  • Installed updates to database software
  • Created testing environments for IMS & DB2
  • Supported the Development team by changing DBD's, PSB's, DDL etc
  • NOVEMBER 1999 TO APRIL 2000 - ***************
    Senior IMS/DB2 DBA

  • Support IMS and DB2 applications doing enhancements
  • Did impact analysis of changes to data bases
  • Reviewed Backup/Recovery/Reorg Strategies based on new/added requirements
  • Reviewed space requirements for changing data bases
  • Monitored and tuned data bases
  • Did Impact/performance analysis of mainframe Data bases communicating with distributed client/server applications
  • Did data modeling for UDB application on AIX platform
  • Currently involved in designing UDB data bases for AIX platform
  • AUGUST 2, 1999 TO NOVEMBER - ***************
    Lead IMS/DB2 DBA

  • Supported the Y2K, IMS & DB2 , test environments
  • Monitored and tuned IMS & DB2 Data Bases
  • Made recommendations for improving IMS & DB2 Environments
  • Februar 1999, to July 1999 - ***************
    Senior IMS/DB2 DBA

  • Performed data analysis for new functional requirements for the States' WELFARE, CHILD SUPPORT, & FOOD STAMPS applications
  • Designed new IMS Data Bases, Modified existing IMS and DB2 Data Bases
  • Developed conversion Strategies for implementing DB changes
  • Developed Back up, Reorg, Recovery Strategies for new Data Bases
  • Revised Back up, Reorg, Recovery Strategies for changed databases
  • Monitored and tuned IMS & DB2 Databases
  • Evaluated and implemented IMS Data Base Partitioning software
  • Supervised and tutored other DBAs
  • JANUARY 1979 TO FEBRUARY 1999 - ***************
    Engaged as a Systems Analyst
    Appointed Data Base Administrator 02/1980
    Appointed Senior Data Base Consultant 01/1990
    Responsible for the Data Analysis and Data Modeling of the following applications:

  • Plant Inventory (IMS DB/DC, DB2)
  • Plant Invenory - Data Warehouse (DB2)
  • Plant Assignment (IMS DB/DC, DB2)
  • Plant Assignment - Data Warehouse (DB2)
  • Carrier Access Billing (IMS DB/DC)
  • Trunk Administration (IMS DB/DC)
  • Calling Card Administration (DB2/CICS)
  • Preferred InterExchange Carrier (DB2/CICS)
  • Service Order - Data Services (DB2/CICS, ORACLE)

  • All Mainframe applications utilized an IBM 3090/600 operating under MVS/ESA and are currently running the latest versions of IMS and DD2 Client Server interfaces ran on UNIX and used ORACLE 7&8 Responsible for the DATA BASE DESIGN & IMPLEMENTATION for the following applications:
  • Plant Inventory
  • Calling Card Administration
  • Plant Inventory - Data Warehouse
  • Plant Assignment - Data Warehouse
  • Service Order - Data Services
  • Developed Backup, Recovery & Reorg Strategies for all Data Bases Designed.
  • Performed Access path analysis for all Data Base Accesses
  • Performed Sizing requirements for all Dta Bases

  • Responsible for the Supporting the Data Bases for the following applications:
  • Plant Inventory (IMS DB/DC, DB2)
  • Plant Inventory - Data Warehouse (DB2)
  • Plant Assignment (IMS DB/DC, DB2)
  • Plant Assignment - Data Warehouse (DB2)
  • Carrier Access Billing (Hybrid design using IMS DB/DC &DB2)
  • Trunk Administration (Hybrid design using IMS DB/DC &DB2)
  • Calling Card Administration (DB2/CICS)
  • Preferred InterExchange Carrier (DB2/CICS)
  • Service Order - Data Services (DB2/CICS, ORACLE)
  • For each Data Base Supported the following functions were performed:
  • Monitoring & tuning
  • Conversion Strategy for DB changes
  • Revision of Backup, Recovery & Reorg strategies for DB changes
  • Resizing for DB changes
  • Impact Analysis for DB changes
  • Access Path Analysis for DB changes
  • Other Responsibilities and Achievements
    Was a member of the Company's Tools Evaluation committee for 5 years
    Evaluated Data Base Monitoring & tuning & productivity tools:
  • BMC (IMS &DB2)
  • FILEAID FOR IMS & DB2
  • EXPEDITOR
  • ABENDAID
  • DB2

  • Developed data base conversion strategy, using BMC and user written programs to Convert IMS data bases to Y2K compliant
  • Headed the implementation team responsible for implementing DB2.
  • Developed Standards, Naming Conventions, Design techniques for DB2.
  • Assisted in the development of the DATA BASE MANAGEMENT LIFE CYCLE for the Company, and gave presentations of this methodology to other departments of the company.
  • Gave courses on IMS and DB2.
  • Attended DB2 Users group seminars.
  • Attended SHARE & GUIDE on several occasions.
  • MARCH 1976 TO DECEMBER 1978 - ***************
    Engaged as a Systems Analyst and worked at the following Clients' ites: ***************
    Led a team of programmers & programmer/analysts doing the Analysis, design and Implementation of the Provincial Land Tax Application. This was an IMS DB/DC Application written in COBOL & PL/I. Workmen's Compensation Board Worked as a System Analyst developing the Payment Application Using CICS/IMS/DB, & CICS/VSAM ***************
    Worked as an Analyst on the Human Resources/Payroll application


    3

    Objective

    Seeking a challenging position in the area of Database Design / Administration,Data Warehousing or WebDevelopment Environment.

    CURRENT EXPERIENCE SUMMARY

    DB2 UDB Database Administration. Having over 6 years of experience in Database design and Administration,and Application software design,development and mainteance. Having over 2 years of experience in DB2 UDB (Version 5.2 and 6.1) Database Design,Development and Administration on Windows NT - PC platforms. Proficient and skilled in installation and migration of DB2 & UDB and DB2 Connect, configuring UDB database and instances,configuring DB2 Clients to access DB2 servers and Host Systems using TCP/IP and data replication using IBM Data Propagator. Worked extensively on Database backup and recovery,migrating data using data movement tools A Load,Export/Import and DB2move,dtat replication,performance monitoring using DB2 Performance Monitors. A System Snapshots and event monitors, and explain tools. Experienced in supporting UDB in OLTP/Web Application environment. Worked extensively on AS/400 Administration including Design & Control of Networking with Client Server Technology.

    OTHER EXPERIENCE ANDSKILLS
    SUMMARY

    More than 10 yeas of experience in Information Technology. Experience in software development using DB2,OS/400, POWERBUILDER 5.0,COBOL,RPG/400,BASIC,C,FORXPRO,CLIPPER 5.2 & SUMMER 87 ,UNIFY,UNIX,CP/M,LAN,DOS,WINDOWS 3.1/95

    Software Experience:

    Operating Systems : OS/400,UNIX,LAN,WINDOWS 3.1/95,MSDOS 6.22.
    Databases : DB2,Foxpro,Clipper 5.2 & Summer 87,Unify.
    Language : Cobol,Rpg/400,Basic & C
    Others : Newtorking,Internet - e-mail.

    Education

    Bachelors in Commerce,University of Mumbai,India

    Project Experience:

    Title/Position: DB2 UDB V7.1 DBA Maintenance of UDB Database for Receivable Management System. Nov 00 to Present. Client : ******************
    Hardware: AS/400 50S
    Software: UDB DB2.
    This was a Receivabal Management Systems for various client. Keeping the records of various collection.
    Responsibilities included:

  • To Look after DB2 DBA,Data Flow,Design,Planning for Data Warehousing.
  • User Requirements
  • Query Handling, Reports.
  • To Grant & Revoke rights as per Users need.

  • Software Experience:

    Operating Systems : OS/400,UNIX,LAN,WINDOWS 3.1/95,MSDOS 6.22.
    Databases : DB2,Foxpro,Clipper 5.2 & Summer 87,Unify.
    Language : Cobol,Rpg/400,Basic & C
    Others : Newtorking,Internet - e-mail.

    Education

    Bachelors in Commerce,University of Mumbai,India

    Project Experience:

    Title/Position: DB2 UDB V6.1 DBA,Data Modeler/ Design
    Maintenance of UDB Database Human Resource
    Systems. Data Modeling Management Sytem.
    Sept 00 to Oct.
    Client : ******************
    Hardware: AS/400
    Software: UDB DB2. Ervin.
    This was a Human Resource Systems. Keeping the records of Individuals like, Social Security Number,Benefits to Individual etc.
    Responsibilities included.

  • Data Modeling,Design.
  • To Look after DB2 DBA,Data Flow,Design,Planning for Data Warehousing.
  • Generating Query Handling, Reports.
  • To Grant & Revoke rights as per Users need.
  • Project Experience:

    Title / Position : DB2 UDB V.6.1 Data Modeler / Database
    Administration,Installation,Performance Tuning,Support
    Client : ******************
    April 00 to August
    Hardware : NT,Pentium
    Software : UDB DB2
    This was basically a three tier application called multiplex Electronics systems(MES) for new Generation Vehicles. It was an interanet which provided information to vendors regarding availability of vehicles.
    I was incharge of DB2 UDB Objects & Database Administrator.
    Responsibilities included:

  • Designing the Complete Object DBMS Database for Multiplexed Electronics Systems for New Generation Vehicles.
  • Design and Implementation of Objects to the Database.
  • Using all the new features of DB2 V 6.1.
  • Planning estimation of the size of the database & configuring the database
  • Trouble shooting,Performance Tunning.
  • To ensure the data is available to those user who need it. To GRANT & REVOKE the rights.
  • Project Experience:

    Title/Position:Project Leader(SYSTEMS MANAGER) Mar,1995 to Mar 00
    Client : ******************
    Hardware: IBM AS/400,Pentium.
    Software: DB2,OS/400,PowerBuilder 5.0,RPG/400,Unify,Unix.
    The Following projects were executed by me:

  • Purchase Stores & Production. 2)Financial Accounting.
  • Payroll. 4)Fixed Deposit.
  • Costing. 6)Invoicing.
  • Sales & Statistics. 8)Doctors System.(RPG/400)
  • Payroll System.(RPG/400)

  • Responsibilities included
    Working extensively on very large databases.
  • Redesigning GUI systems & coding standard.
  • Total system study, Design, Development & Implementation, Testing.
  • Trouble shooting, Performance Tuning.
  • Installation of DB2, OS/400, Client Access, PowerBuilder & establishing connectivity of entire system.
  • Planning for Migration, Data mapping & Porting
  • Planning and estimation of the size of the database & configuring the database.
  • Creating f database.
  • Journalling of tables.
  • Backup and Recovery Strategies.
  • Database Security Administration.
  • End user
  • Training.

  • Database Dictionary
  • To ensure the data is available to those user who need it.
  • To ensure that data is not destroyed unless authorised to do so.
  • To GRANT & REVOKE rights as per need.
  • Security of each system, terminal & user wise.
  • To update the latest updated documentation as per changes in each system, keeping the history records.
  • Laision with users at all levels, of the organisation.
  • To look after the database design keeping in mind all aspects of systems, organisation & for group of companies.
  • Data confidentiality.
  • Data Definition Language(DDL)
  • Data Manipulation Language (DML)
  • Data Control Language (DCL)
  • Data Integriy
  • Keeping proper Hierarchy of Authority are as follows:
  • SYSADM - System Administration Authority
  • DBADM - Database Administration Authority
  • (Which include: Alter, Delete, Insert, Index, Select)
  • SYSOPR - System Operator (Which include: Display /Stopall Trace, Recover,Update)
  • DBCTRL - Database Control Authority (Which include: drop / Reorg / Repair/Load/Recoverdb)
  • DBMAINT - Ddtabase Maintenance (Which include: CreateTab /Startdb / Stpdb /Stats / Createts /Displaydb / Imagecopy)
  • Referential Integrity

  • Object Mgt , CL , Message Handling , Entire System Security , Managing Device , Backup, Restore , Problem Determination, Journal Mgt , Disk Mgt etc. Settings of Client Server environment.
    TO HANDLE DAY-TO-DAY OPERATIONS OF AN AS/400 SYSTEM, SPECIFICALLY. AS/40 0 SYSTEM ADMINISTRATION AND CONTROL

    Project Experience:

    Title/Position : Project Leader Cum Analyst
    Client : ******************
    Aug,92 o Mar,95
    Hardware : 486 Server
    Software : Foxpro 2.5,LAN
    Responsibilities Included.

  • Total System Study,Design & Development, Coding,testing & Implementation.
  • Maintaining the above systems.
  • Co-ordination with the user dept & Programmer.
  • Discussion with end user, departmental head for new requirement
  • Networking,training to the Senior Manager & Other staff.
  • Project Experience:

    Title/Position : Senior System Analyst.(EDP Incharge)
    Client : ******************
    Feb92 to July,92.
    Hardware: 386 PC.
    Software: Foxpro 2.5, LAN
    Financial Accounting System.
    Responsibilities included:

  • Looking after IT Dept. for a group of company.
  • Total ystem Study,Design & Development,Coding,testing & Implementation.
  • Project Experience:

    Title/Position: Senior System Analyst (EDP Incharge)
    Client : ******************
    Aug,1990 to Nov,1991
    Worked as a EDP Incharge. This was a software consultancy, Developing above systems for various client as per their requirement.
    Responsibilites included:

  • Discussion with client,Understanding the requirements.
  • Total System Study.
  • Documentation & Manuals.

  • Conducting Training for Senior Manager & Other Staff.

    Demonstration of Software.

    Presentation of Software for new clients.

  • Helping in marketing of software.
  • To look after entire software consultancy.
  • To lead the team of programmer.
  • Trouble Shooting.

  • 4

    Objective:

    Seeking a challenging career as Senior/Lead Oracle DBA on Unix and/or Windows NT platforms.

    Summary:

    Nine years of exceptional experience in database administration of OLTP and Data warehousing applications.

    Experience

    in Database Design, Analysis and Implementation including capacity planning, security administration, scalability, configuration, migration, and Performance/Tuning. Oracle DBA experience on Unix (Sun & HP) platforms based on EMC, Sun and HP storage systems and Windows NT/2000 and proficient in Unix Shell Scripting. Oracle DBA Certified DBA Instructor experience.

    Education:

    Masters in Engineering, University of Alabama, Tuscaloosa, AL. May 1991
    Bachelors in Engineering, Osmania Univrsity, India. July 1984
    Professional Sun Solaris (Unix) System Administration Essentials, NCS Sun Edu. Sun, Atlanta, GA. Apr 1998

    Training:

    ABAP/4 (SAP R/3) Workbench, SAP, Atlanta, GA. Sep 1997
    Vertex Sales Tax Module, Vertex, Philadelphia, PA Jun 1997
    MS SQL Server 6.5 Database Administration, New Horizons, Atlanta, GA Jun 1996
    MS SQL Server 6.0 Database Administration, New Horizons, Atlanta, GA Nov 1996
    Oracle Database Administration, Oracle Corporation, Atlanta, GA. Aug 1994
    Intro to Oracle, SQL, PL/SQL, data modelling, Oracle Corporation, Atlanta, GA. Jul 1992

    Technical Languages:

    Korn/Bourne Shells, SQL, PL/SQL, ABAP/4, C, Access Basic, Visual Basic. Skills:

  • GUI: Oracle Enterprise Manager (NT), Platinum SQL Station, DB Artitian, SQL Analyzer.
  • Tuning Tools: Precise software, Quest software, Shell scripts, SQL scripts.
  • Application Packages: Vertex, Ecel, Access2/97, and Word.
  • Data Modeling Tools: Designer 2000, ERWIN, and S-Designer.
  • Databases: Oracle 7.0, 7.1, 7.2 & 7.3, 8.05, 8(i), MS SQL Server 6.0/6.5, MS Access 2, 95, 97, & 98.
  • Environment: Unix (Sun & HP), Windows NT/2000, MS-DOS, Windows 3.1, 3.11, 95 & 98.
  • Hardware:

    Sun Solaris, HP Unix, EMC, HP Net Server, and Compaq Prolinea/Proliant Servers.

    Experience:

    ***************** Lead Oracle DBA Oct 2000 to Dec 2000
    Synopsis: Worked as Lead Oracle DBA Consultant for Nextel International, Atlanta.

  • Worked as Lead Oracle DBA for mission critical production databases on Oracle 7.3, Oracle 8.0.5 and Oracle 8i. Support for 24x7 databases.
  • DBA tasks include Architectural design, Backup and Recovery, High Availability, Support, Troubleshooting, Performance, and Tuning on Oracle 8i.
  • ***************** Lead Oracle DBA May 2000 to Sep 2000
    Synopsis: Worked as LeadOracle DBA *****************

  • Worked as Lead Oracle DBA for development / scalability databases on Oracle 8i.
  • DBA tasks include Performance and Tuning, Scalability, and database creation on Oracle 8i.
  • Upgraded all Oracle 8.0.5 databases to Oracle 8.1.6 (8i).
  • Developed and supported data warehouse application for decision support systems.

    ***************** Lead Oracle DBA / Architect Nov 99 to May 2000
    Synopsis: Worked as Lead Oracle DBA Consultant for *****************

  • Worked as Lead Oracle DBA on Sun Solaris / HP Unix / NT platforms for 100 mission critical production / pre-production / development / training databases using Sun, HP and EMC storage. Automated Unix and Windows NT scripts for database monitoring and jobs.
  • DBA tasks include Enterprise Wide Oracle DBA Consultant, Performance and Tuning, Backup & Recovery procedure, Net8, Analysis, Tablespace maintenance, Rollback Segments maintenance.
  • Performed Dynamic Hot/Cold Backup procedures on production databases on multiplatform basis.
  • Recommended Oracle DBA tools for Enterprise Wide applications.
  • ***************** Senior Oracle DBA / Architect Oct 98 to Oct 99
    Synopsis: Worked as Senior Oracle DBA on Sun Solaris systems for *****************

  • Worked as Senior Oracle DBA consultant on Sun Solaris and Windows NT platforms for 22 mission critical production and development databases. Oracle 8.05 installation and migration of Oracle 7.3.3.5 databases to Oracle 8.05. Automated Unix and Windows NT scripts for database monitoring and jobs. Created and supported Oracle Standby Architecture database for High Availability.
  • DBA tasks include database cloning, backend job processing, PL/SQL and Platinum SQL Station support, import/export, SQL
  • Loader, SQL
  • Net, Performance an Tuning, Backup & Recovery procedures, Tablespace maintenance, Rollback Segments maintenance, Security Administration. Trained employee for Oracle DBA track. Performed Hot Backups on production databases.
  • Developed Oracle Server Technical Documentation for all production databases.
  • ***************** , Atlanta, GA. Oracle DBA
    Jul 98 to Oct 98
    Synopsis: Worked as Senior Oracle DBA on Sun Solaris system for *****************

  • Worked as Senior Oracle DBA on Sun Solaris platform on a Data Warehouse application for production and development databases.
  • Designed EMC Storage system for the production database on a RAID 0+1.
  • DBA tasks include import/export, SQL
  • Loader for data import, Performance and Tuning, Backup & Recovery procedures, Tablespace maintenance, Rollback Segments maintenance, User maintenance, and SQL
  • Net.
  • Conducted Y2K testing on all Oracle databases. Implemented Standards & Proedures on databases.
  • Performed Unix and Oracle audit for Oracle production database server.
  • Performed monthly data loads using SQL
  • Loader, SQL
  • Plus, Syncsort, FastLoad, FastExport, Bteq.
  • ***************** , Atlanta, GA. Oracle DBA
    Mar 98 to Jul 98
    Synopsis: Worked as Senior Oracle DBA on Sun Solaris system for *****************

  • Worked as Senior Oracle DBA on Sun Solaris platform for production and development databases.
  • DBA tasks include import/export, SQL
  • Loader for data import, Performance and Tuning, Archival Mode, Backup & Recovery procedures creation and implementation, Tablespace maintenance, Rollback Segments maintenance, User maintenance, and SQL
  • Net.
  • Performed Unix administration for Oracle database servers.
  • Converted all databases to Archive Log Mode to enable hot backups and add additional recovery methodology. Created Cold and Hot backu procedures for all Oracle databases. Automated Backup procedures using Unix shell scripting.
  • Performed storage management for tablespaces (defragmentation of tablespaces).
  • Performed weekly data loads using SQL
  • Loader and SQL
  • Plus (using Unix shell scripting).
  • Performed query optimization, triggers, stored procedures using PL/SQL (Oracle).
  • Created Oracle Server Technical Documentation for production and development databases.
  • ***************** , Atlanta, GA. Oracle DBA
    Mar 97 to Mar 98
    Synopsis: Worked as Oracle DBA on Sun Solaris and Windows NT platforms, SAP modules stress testing, and supported other database systems.

  • Designed, developed, and implemented STRESS Test on all SAP R/3 modules using AutoTester. This project helped performance and stress Testing of all SAP modules for SAP implementation.
  • Worked as Oracle DBA on Sun Solaris and Windows NT .0 platforms.
  • DBA tasks include import/export, SQL
  • Loader for data import, Performance and Tuning, Archival Mode, Backup & Recovery procedures implementation, Tablespace maintenance, Rollback Segments maintenance, User maintenance, SQL
  • Net, and ODBC configuration for applications.
  • Installed Oracle 7.3 database and Enterprise Manager. Migrated Oracle 7.1 databases into Oracle 7.3 databases.
  • ***************** Oracle DBA
    Feb 96 to Feb 97
    Synopsis: Worked as Oracle DBA, database application support, application development using SQL and PL/SQL, data migration from legacy systems to Oracle databases, application conversion from mainframe databases to Oracle databases at DOAS, State of Georgia. Other tasks included user support, ODBC configuration and TCP/IP implementation using Client/Server architecture.

  • Worked as Oracle DBA on Sun Solaris and Windows NT platforms.
  • DBAtasks include import/export, SQL
  • Loader for data import, Backup & Recovery, Tablespace maintenance, Rollback Segments maintenance, User maintenance, SQL
  • Net, and ODBC configuration for applications.
  • Designed, developed and implemented Vendor Contract database applications using Oracle. This project included extensive use of SQL and PL/SQL including Stored Procedures & Packages.
  • Designed, developed and tested Food Contract database and application. This project required extensive use of SQL, Dynamic Queries, Oracle RDBMS, Tablespace allocation, Rollback Segment allocation, and security.
  • Converted databases from MS Access to Microsoft SQL Server 6.0 RDBMS.
  • ***************** , Oracle DBA
    Jan 95 to Jan 96
    Synopsis: Worked as Oracle DBA on Unix and Windows NT platforms for various clients in Southeast USA. Other tasks included user support and ODBC configuration.

  • Worked as Oracle DBA on Unix and Window NT platforms at various clients in Southeast USA.
  • Installed Oracle 7.1 on Windows NT and configured Oracle database including SQL
  • Net, ODBC, Tablespace design, Rollback Segment design, Backup procedures, and performance and tuning.
  • Worked as Oracle DBA on Unix platforms for various clients in SouthEast USA.
  • DBA tasks included Oracle server installation on Unix platforms, configuration, capacity planning, security administration, user support, and data loads using SQL
  • Loader and/or Export/Import methodologies.
  • ***************** , Oracle DBA May 91 to Dec 94

  • Worked as Oracle DBA on Unix and Windows NT platforms at various clients in Southeast USA.
  • Traveled to various client locations in Southeast for various projects on Oracle databases.
  • DBA tasks include import/export, SQL Loader, SQL Net, Backup & Recovery procedures, Tablespace mainteance, Rollback Segments maintenance, Security Administration, SQL
  • Net, and ODBC configuration for applications
  • Supported applications on MS Access and MS Visual Basic software.
  • ***************** . Graduate Research Assistant
    Aug 89 to May 1991

  • Designed and developed macros for student record database system using Lotus 213.
  • Designed and developed tables for landfill design using Lotus 123 with table connectivity properties.
  • ***************** , Construction Project Manager Aug 84 to June 89
    Worked as Construction Project Manager with multi-million federal projects and state projects. Traveled to various client locations in Southeast India for various projects on Construction Projects. Project Management tasks include Inventory, Purchases, Project Scheduling, Meetings with personnel and clients, Billing for contracts, estimating and costing, managing 100 personnel projects. Suppored multiple projects at one time.

    Personal:

    Permanent Resident of the United States of America (Green Card). Willing to travel around the world. Enthusiastic & self-motivated hard working male.

    References: Available upon request.

    5

    SUMMARY

    10 years experience in the IT industry renders me as a very well rounded RDBMS specialist excelling both as a Production DBA and a Development DBA. Strong technical background in utilizing NT, UNIX, Sybase, MS SQL Server, Oracle and various database management software tools, and technical leadership on current technologies. I am very well versed in Performance Optimization, Large-scale Production Environments and Troubleshooting. Strong analytical skills provide quick resolution to system issues. Significant background in client/server database design, tuning, management, system analysis, and development Highly proficient in all DBA functions -- including server installation, configuration, security issues, capacity planning, backup & recovery, policy & procedures, and data manipulation across multiple servers. Have excellent knowledge of Database Architecture, distributed Transactions, and Replication. I am adept in backend objects. I have extensive experience as a Project Leader skills for client/server systems development.

    PROFESSIONAL EXPERIENCE:

    *********** DBA Manager/Senior DBA 8/96- Present
    Working for one of the largest financial institution as a Senior DBA/Team Leader, with other DBAs in the team who work under my guidance. Provide Systems support for multiple insurance projects/applications which includes Vantive Help Desk, Image and Workflow, and a financial reporting System which interface with a web base application. Principal job responsibilities are:

  • Provide 24x7 production support for several mission critical financial
  • systems whch utilize multiple Sybase, MS SQL Server and Oracle databases.
  • Develop and implement migration plans, including several successful emergency cutovers (database systems).
  • Develop naming standard and convention for Sybase, MS SQL Servers and directory structure for Oracle databases.
  • Upgrade, configure and tune Sybase, SQL Server and Oracle servers for performance.
  • Provide database design and management for multiple projects. Monitor and recover databases.
  • Develop, implement and maintain of operations procedures and programs, including disaster recovery, system security, replication.
  • Performed multiple development and production upgrades for Sybase from system 11.0.3 to 11.9.2
  • Support in-house and vendor applications that run on SQL Servers
  • Handle large volume database from 10-25GB
  • Support application developers and application implementation groups
  • Performed Upgrade from 8.0.5 to 8i
  • Performed application and data Migration of Oracle, Sybase and MS SQL daabases
  • Prepared Disaster Recovery Planning
  • Configure and Implemented Replication for Sybase & MS SQL Server
  • Set up backup procedures for primary production servers and synchronized them periodically with replicated server
  • Set up of routines and procedures for failure over testing
  • Developed Disaster recovery procedures for Sybase, MS SQL Servers
  • Perform database backups and restores
  • Created thresholds for transaction segments and space monitoring
  • Developed, implemented and automated monitoring tool to check the performance
  • of the Sybase production server which sends an e-mail to primary DBA. Implemented routine on more than 50 servers.
  • Participated and provided Y2K compliance testing process for all the Sybase, Oracle, MS SQL and UDB servers
  • Created multiple technical write-ups for backup/recovery, performance/tuning
  • and query optimization for Sybase, MS SQL servers and Oracle instances
  • Setup and utilize RPC commands to access data & stored procedures back & orth from remote Sybase servers

  • Environment: Sybase 11.0.3 & 11.9.2, MS SQL Server 6.5, Oracle 8.5 & 8i, Windows NT Server/Workstation, Windows 98/95, Sun Microsystems

    *********** Senior DBA 8/95 -7/96
    Functioned as a Production DBA to provide 24x7 production support. Provided support for many insurance applications. Provided technical management for a number of projects including an MS-Access conversion to Sybase. As a DBA performed following tasks:

  • Installed more than 50 MS SQL Server 6.0 and Sybase System 11 on Windows NT
  • Configured system options using Enterprise Manager
  • Migrated application and data using automated scripts
  • Secured user access with integrated, NT standard security
  • Managed storage requirements for databases, devices and system areas Backup & Restore of system and user databases
  • Manipulated data across multiple servers
  • Provided Production Support for more than 160 Sybase and MS SQL servers
  • Monitored Database Logs fr database objects, such as tables, indexes,
  • rules, user-defined data types, defaults, database triggers & stored procedures (to implement complex business rules)
  • Monitored table space allocation; data distribution among segments
  • Created clustered and non-clustered indexes
  • Created thresholds for transaction segments and space monitoring
  • User account/user profile creation/maintenance, group creation/maintenance
  • Granted of Rights & permission
  • Managed and maintained database integrity, consistency and referential integrity
  • Backup and recovery procedures, including implementation of automatic backups Coding scripts for the backup and load procedures
  • Tested, Quality Assurance and Production Server Installation
  • Database performance monitoring, Transaction load analysis, Tuning and Performance enhancement tuned of SQL queries for increased response time by utilizing indexes techniques
  • Database tuning using indexes and stored procedures
  • Diagnosed system problems
  • rovided Technical support for the installation
  • Ensured near - 100% uptime for Database on a 24 hour basis
  • Logical and Physical Database Design; reengineering existing database;
  • data model analysis
  • Wrote procedures for uploading data onto Microsoft SQL Servers from Mainframe and downloading data from Microsoft SQL Server to Mainframe
  • Trouble shooting user related problems

  • Environment: Sybase 10 & 11.0.3, MS SQL Server 6.0 & 6.5, Windows NT Server/Workstation, Windows 95

    *********** System Analyst/DBA 2/89 -7/95
    At a large international bank performed duties as a System analyst and a production DBA. Support included many banking applications such as letter of credit, collection, and foreign exchange system. Provided 24x7 production support for several mission critical trades system, which utilized multiple databases. Upgraded, configured and tuned Sybase server for performance. Developed procedures for implementing and deploying System 10. These projects utilized a PowerBuilder front-end interface, as ¡¥browsed-enabled¡¦ interfaces. Was leader of application development team, also was responsible for query and reporting functions as well as database performance. Participated in the development of a financial application known as transaction & position. Wrote stored procedures, triggers, and update/insert script creation routines. Wrote various scripts, batch processing jobs; database monitoring scripts to monitor Sybase errorlog, space usage, dbcc and others.
    Environment: Sybase 10, Suns Sparc, DEC VAX Series, IBM token ring, Novel, IBM 34 & 36.

    TECHNICAL PROFICIENCY
    Hardware:

  • NT 3.5, 4.0 Server & Workstation Sun Workstations
  • VAX and DEC Workstation IBM System 34, 36 & 38
  • IBM AS400 Novell LANs
  • IBM Token Ring

  • Software:

  • DBArtisan Patrol Change Manager
  • Sybase Open Client 10.0.3 & 10.0.4 Oracle SQL Plus Worksheet
  • Sybase SQL Server Manager Oracle Enterprise Manager
  • SQL Navgator Oracle Instance Manager
  • Sybase and MS SQL Server WISQL Oracle Database Manager
  • SQL Service Manager SQL Performance Manager
  • SQL Security Manager Oracle Name Server
  • Erwin Case Tools Korn Shell Scripts
  • SQL Trace Tool MS SQL Enterprise Manager

  • Communication Software:

  • PC Anywhere NT RAS
  • SMS Telnet
  • MTS DECnet
  • Pathworks
  • RDBMS:
  • Sybase System 10 Sybase System 11
  • Sybase 11.5 Sybase System 11.9.2
  • MS SQL Server v6.0 and 6.5 Sybase Monitor
  • Oracle 8.0.5 Oracle 8i
  • Operating System:
  • Windows 2000 Professional NT 3.5 & 4.0
  • Windows 95 MS Windows v3.1
  • UNIX Solaris Novell NewWare v3.xx
  • OS2
  • EDUCATION

    Bachelor of Science
    Certificate courses in Sybase
    Attended many in-house training classes on MS SQL Server, Oracle and Patrol


    6

    PROFILE

  • Certified Sybase Professional (Oct 1997 A CSPDBA)
  • Certified Sybase Professional (Jan 1999 A CSP-PTS) Performance andTuning Specialist.
  • 14 years industry experience.
  • 7 years Sybase Database Administration.
  • Sybase Replication Server(installation and configuration).
  • Oracle and Sybase experience. Has developed systems in a wide variety of environments.
  • Korn shell scripting, AIX and Solaris experience.
  • Strong Sybase and SQL skills. Sybase database administration since May 1994.
  • Sybase Open Server programming.
  • Sybase Open Client programming.
  • Front-end tools experience include Oracle Forms 4.0.
  • Use of DBArtisan to administer Sybase environments and databases.
  • Logical and Physical data modeling using PowerDesigner.
  • Fully fluent in English and French.
  • EXPERIENCE

    Feb 2000 A Present Senior Database Administrator ********************
    1995 A Feb 2000 Lead Database Administrator ********************
    1987 - 1995 Senior Systems Engineer
    Systems Engineer
    Associate Systems Engineer
    Senior Programmer/Analyst
    Programmer/Analyst ********************
    1986 - 1987 Programmer/Analyst ********************

    EDUCATION

    1984 - 1986 MSc., Computer Science(G.P.A. 4.0) University of Manitoba 1981 - 1984 BSc., Computer Science Bsc., Mathematics Brandon University

    RELEVANT EXPERIENCE

    ********************
    Senior Database Administrator (Feb 2000 A Present)
    Contractor-Telecommute arrangement.
    System Environment:
    Sybase Adaptive Server 11.5, 11.9.2 under Sun hardware and Solaris. Hired as a Sybase performance tuning specialist to analyze, diagnose and fix performance and deadlocking problems with Sybase stored procedures and dynamic SQL statements. Responsibilities also include Sybase Adaptive Server tuning in an environment where databases consist of extremely large tables(250 million rows and more), conducting code reviews and providing help to developers. Delivered dramatic performance improvements and virtually eliminated deadlocks by rewriting stored procedures and reorganizing indexes. Tuned customer reports to execute in seconds instead of hours. Reduced deadlocks from a rate of about 400 per hour to 4 per hour. Brought stability to the sybase environment and increased throughput approximately 10 fold. Tuned several complex stored procedures to execute up to 400 times faster. Involved in architecture discussions for future systems and scaling issues.

    ********************
    NrG Information Services (Database Administrator)
    Lead Database Administrator (******************** Apr 1995 A Feb 2000)
    Senior Systems Engineer (******************** May 1994 - April 1995)
    System Environment:
    Sybase SQLServer 11.0.3, RS6000/AIX 4.3.2, client-server development using Visual Basic 4.0 and "C", Java, Sybase OpenServer, Sybase Replication Server. LeadDatabase Administrator for a joint project between NOVA, TransCanada Pipelines, Westcoast Energy and El Paso Energy (formerly Tenneco). Installed and configured Sybase SQLServer 10.0 and Replication Server 10.0. Responsibilities include data analysis, logical modelling and physical database design, database creation, backups and recovery, implementations of referential integrity, performance tuning and supporting the development team. Manages database security, writes stored procedures and database triggers as well as AIX shell scripts. Planned for and led the upgrade effort to migrate to SQLServer 10.0.1, 10.0.2 and Sybase System 11. Currently manages 10 production databases on 2 production servers supporting approximately 150 concurrent users in a 7X24 environment. Also manages 30 databases across 6 other servers. Provides Quality Assurance for all dynamic SQL statements and stored procedures before implementation in a production environment. Design and implementation of a Sybase Open Server pototype using "C" which acts as a transaction router. Application requests are routed to multiple SQLServers based on the request.

    Skills

    used are "C" and Sybase Open Server/Open
    Client programming.
    Design and implementation of a Sybase Open Client API to facilitate interaction with Sybase SQL Servers and Open Servers.

    Skills

    used are "C" and Sybase Open
    Client programming using CT/Library.
    Involved in all architecture meetings with respect to hardware capacity planning and database configurations.

    ********************
    Sept 1993 - Feb 1994
    System Environment:
    Oracle V7.0, Oracle Forms 3.5, UNIX
    Under contract to ********************, carried out enhancements to oil and gas financial accounting software.

    ********************
    Associate Systems Engineer (Apr 1993 - Sept 1993)
    System Environment:
    Microsoft SQLServer, Powerbuilder 2.0, Windows, client-server development. Design and development of a Powerbuilder/SQLServerclient-server application for an internal Systemhouse project. Responsible for database administration as well as development of Powerbuilder applications.

    ********************
    Senior Systems Analyst (Oct 1992 - Mar 1993)
    System Environment:
    AS/400, RPG banking software, ATMAs.
    The environment consisted of a central AS/400 supporting teller terminals and ATMAs distributed across 45 branches. Banking software was a package written in RPG. Involved in the design and implementation of a purging and archiving system to remove transaction history from disk storage and was solely responsible for the development of a related system to download transaction history to optical disks and to retrieve archived information using FOXPRO on a PC.

    ********************

    Husky Bi-Provincial Upgrader
    Associate System Engineer (Dec 1991 - Apr 1992)
    System Environment:
    Oracle V6.0, Oracle Forms 3.0, ReportWriter, VAX/VMS.
    Enhancements and modifications to laboratory software written in SQLForms 3.0.

    ********************
    System Environment:
    SUN 470/SUNOS, Oracle 6.0, SQLMenu 5.0, SQLForms 3.0.
    Conversion of Honeywell Cobol programs for and inventory tracking system to a SUN 470/SUNOS/Oracle environment using SQLMenu 5.0 and SQLForms 3.0. Responsibilities included estimating development time, form and menu design and coding, testing and implementation.

    ********************
    Associate Systems Engineer (Mar 1991 - May 1991)
    System Environment:
    IBM/MVS, SAS, JCL
    Enhancements and modifications to SAS programs for a payroll system. As part of a SAS upgrade from version 5 to version 6, responsibilities included making modifications to all SAS programs and JCL to ensure compatibility with the new version.

    ********************
    Senior Programmer/Analyst (July 1989 - Mar 1991)
    System Environment:
    IBM 3090/MVS/XA, Adabas/Natural
    Responsible for modifications and enhancements as well as development of new Natural/Adabas progrms mainly in the area of crown royalties.

    Programmer/Analyst (1987 - 1989)
    Installation of an IBM token ring network
    Feb 1989 - Mar 1989
    System Environment:
    PCAs, DOS, token-ring network.
    Responsible for the installation of a token-ring local-area network. Involved in all aspects of the installation including hardware and software. Provided wiring requirements, built printer cables and installed required system software. Also provided training and user and system manuals.

    ********************
    May 1988 - Feb 1989
    System Environment:
    IBM 4680 Point of Sales System.
    Demonstration of the IBM 4680 Point of Sales System. Installed the IBM 4680 Operating System, the IBM-supplied General Sales Application software and configured the cash registers. Customized the application to meet the requirements for the demonstration. Also involved in a study of a larger point of sales system (500 stores) for the Liquor Control Board of Ontario. Responsible for identifying how closey the Ontario system fitted the MLCCAs requirements and to estimate the effort required to implement the Ontario system at the MLCC.

    ********************
    Mar 1988 - May 1988 System Environment:
    IBM/MVX/XA, Cobol
    Conversion of Honeywell Cobol batch programs dealing with commodity trading to IBM cobol.

    ********************
    Dec 1987 - Mar 1988
    System Environment:
    PC/DOS, Postscript
    Developed a lottery production and verification system. Requirements were to generate and print random patterns of winning and losing tickets. Also provided encryption/decryption facilites, documentation and training. Programs were written using Turbo Pascal and Postscript.

    TECHNICAL EXPERIENCE
    Hardware:

    Computer System

    Software

  • IBM RS6000 AIX 4.3.2
  • SUN 470 SUNOS
  • MICROVAX II VAX/VMS
  • VAX 11/750 VAX/VMS
  • Amdahl 580 MVS
  • IBM 3090, 4341 MVS/XA
  • PCAs DOS/Windows 3.1/NT 4
  • AS400/D0 OS/400
  • Languages/Applications/Database

  • "C" Sybase Open Server/Open Client
  • SQL Sybase System 11.x, Oracle 6.x, 7.0
  • Ingres, Rdb/VMS, FoxBase
  • PowerDesigner 6.1.1
  • SQLForms 3.0, 4.0
  • SQLMenu 5.0
  • Powerbuilder 2.0
  • Visual Basic 3.0
  • Natural II Adabas
  • PL/1 IMS
  • Simscript II.5
  • Fortran, Pascal
  • SAS
  • Postscript
  • Courses:

  • Sybase SQLServer 11.x Performance and Tuning (1998)
  • Sybase Open Server Programming ( Feb 1996)
  • Sybase SQLServer 10.0 Administration (Jun 1994)
  • Sybase SQLServer 10.0 Performance and Tuning (July 1994)
  • Oracle SQLPlus, SQLForms 3.0 (1992)
  • Publications:

    "Three-dimensional Representation of Terrain Models from Contour Maps" CONGRESSUS NUMERANTIUM VOL 52. Presentation of the results of this paper at the 15th annual conference on Numerical Mathematics and Computing at the University of Manitoba in October 1985.


    7

    Objective

    Obtain part-time, telecommuting, Informix DBA contract work. Positions Held

    ***********************

  • Support production Peoplesoft HR/Payroll database
  • Support several data warehouses
  • Develop & implement database maintenance korn shell scripts
  • Developed / implemented warehouse load scripts written in korn shell
  • Write / maintain triggers & stored procedures
  • Responsible for Informix software upgrades
  • Responsible for database performance tuning
  • Responsible for refreshing development & test databases
  • Responsible for backup / recovery strategies
  • Document all procedures
  • ***********************
    DBA/ application developer

  • Developed and maintained Informix & SQL Server databases
  • Developed database applications using Visual Basic & Access as front ends
  • Developed reporting system which pulled data from multiple databases, on different platforms, using Java 1.1 with JDBC drivers
  • Developed DB maintenance programs using C
  • Migrated databases from SQL Server platform to Informix
  • Server administrator of DEC Alpha system - Digital UNIX 4.0
  • Developed web application using Active Server Pages Computer Operator, Kodak / IBM Apr 1995 - Dec 1995
  • Utilized MVS mainframe, JCL, SAR Express
  • Maintained SQL Server database which tracked the mainframe documentation
  • Wrote technical documentation
  • ***********************
    July 1995 -Sept 1995

  • Designed MS Access databases for small businesses
  • Developed Visual Basic applications
  • Designed & implemented on-line help systems
  • Dcumented software user manuals
  • ***********************
    Aug 1994 - May 1995

  • Assisted students with hardware and software questions
  • Technical support for PC and network related issues
  • Student tutor for both database and Visual basic courses
  • Professional Certification

  • Informix Certified Professional
  • Professional Organization Memberships
  • Member International Informix Users Group
  • Technical Skills
    Programming Languages

    - C, Visual Basic 5.0, Java 1.1

    Scripting Languages

    - VB Script, Java Script, Korn shell script, HTML

    Operating Systems

    Digital Unix 4.0, AIX 4.3, Windows NT 4

    Database

    DBA for Informix IDS, database modeling

    Education

    Master of Science, Computer Information Systems November 1998 Universiy of Denver, Denver, Colorado
    Bachelor of Science, Business Administration December 1995
    Concentration: Computer Information Systems Colorado State University, Fort Collins, Colorado


    8

    EXPERIENCE

    6/1999 - present *********************
    Sr. Oracle DBA/DB+JAVA Architect/DBA Manager

  • In charge of database group for a startup e-Commerce company.
  • Responsible of iChoose system DB architecture and implementation.
  • Responsible of JAVA middle tier DB access design and implementatin.
  • Responsible of corporate data warehouse design and implementation.
  • Responsible of iChoose system data feed design and implementation.
  • Responsible of iChoose DB fail over and load balance design and implementation.
  • Responsible of maintaining multiple Oracle production instances in two hosting locations.
  • Responsible of setup Oracle DB for KANA system.

    8/1998 - 6/1999 *********************
    Sr. Databast Analyst

  • Designing and implementing data warehouse/data mart on Oracle database (Solaris/OPS).
  • Data modeling, PL/SQL, Shell scripts, Database setup, performance tuning.
  • Extensive contacting with source system engineers, data maintain group and reporting builders to collect and analyze data quality and business requirements.
  • 7/1996 - 8/1998 *********************
    Sr. Consultant
    responsible of:

  • Mainframe/client communication TCP/IP layer implementation;
  • Data collect/exchange modules to handle Mainframe and local system DB synchronize;
  • DB access (Oracle 8) connect to CORBA data broker server;
  • TCP/IP layer between wireless handhold computers and local system in Cargo terminal;
  • Multi-thread gateway for wireless handhold computers accessing local system.
  • Upgraded SABRE group travel booking system. (PC version)
  • Built SABRE gateway setup configurators for NT/Win95.
  • Multiple layers coding and debugging of Open System Gateway for SABRE networking.
  • 5/1994 - 7/1996 *********************
    Software Engineer/Chief System Designer
  • Implemented data warehouse systems for hospital.
  • Developed hospital data mining system to help client tracking and forecasting.
  • Implemented an automatic EDI system for hospital purchasing.
  • Implemented an inventory tracking system with wireless barcode scanning.
  • Built ActiveX object and VBX object for Meditech system accessing.
  • Developed Meditech terminal emulator.
  • Developed scripting tools for automatic data uploading.
  • Designed an automatic Window-based FAX server connecting with Meditech system.
  • Developed a data collection program running in handhold PC on Telxonwireless network.
  • 6/1993 - 5/1994 *********************
    Software Engineer

  • Responsible for design and implementation of a real-time embedded elevator control systems.
  • EDUCATION

    12/1992 University of Oklahoma Norman/OK Masters Degree in CS GPA 3.8

    ADDITIONAL INFORMATION
    Won the 3rd place in the 17th National ACM programming contest. (South Central Region, 1992)


    9

    Summary

    Over 3 years Nine months of industry experience as a Database Administrator, of which 3 years experience exclusively in Sybase 11.9.2/11.5.1/11.0.3/10.x.

    Experience

    includes entire system life cycle including System Analysis, Design, Programming, Testing, debugging and Implementation, User Support and Maintenance of client/server based Sybase applications. Experienced in DBA duties such as backup scheduling, disk management, transaction log management, user administration, activities such as Performance Tuning Query Optimization, Database Consistency Monitoring, Disaster Recovery in Sybase environment. Computer Skills:
    Hardware:

    SUN SPARC SERVER,HP 9000,COMPAQ Proliant Operating systems: Solaris 2.6, 2.5, HP-UX 10.x, Windows 95/ NT / Novel NetWare Programming

    Languages:

    Visual Basic 5.0, C, C++

    RDBMS:

    Sybase system 11.9.2,11.5.1,11.0.3,10.x, Oracle 7.x Tools & Utilities: Crystal Reports 4.6

    Responsibilities
  • Creation of Databases, Tables, Triggers, Stored Procedures, Views, Rules, Defaults, Logins
  • Fine-tuning:

  • Estimating the Size of Tables and Indexes
    Tuning Queries and Stored Procedures
    Monitoring SQL Server Activity
    Restoring the Configuration Variables
  • Trouble shooting
  • Examining Memory usage with DBCC Memory use
  • Tuning Memory use
  • Transaction Log Management - Tuning of Transaction Logging
  • Sizing the Transaction Log
  • Separating Data and Log Segments.
  • Taking Backup of the Server daily and weekly basis
  • System database recovery
  • Disk Monitorig
  • Monitoring the performance of the SQL Server
  • Monitoring the Disk usage
  • Loading Data in and out of Sybase Tables using BCP Utility
  • Work Experience

    **************** October 99-- Present
    Project : Mortel
    Role : Database Administrator
    Hardware: Sunsparc Server 1000E, Operating System : Solaris 2.5
    Software Used : Sybase 11.5

    Team Size : 6
    The system was developed for Ameritech¡¦s In-house application to process Telephone Orders. The system is designed on distributed data processing and client/server environment through ODBC. The system has been designed to take care of the complete Telephone Orders. All Security measures are implemented in this system. The system has successfully handled database size of over 60 GB.
    Responsibilities.
  • Fine-tuning the application
  • Tuning of procedure and triggers
  • Interacting with Ameritech DBA¡¦s
  • Assisting in Sybase Server Upgradation
  • Modifying Data Cache and Named Cache and tuning them
  • ****************
    March 2000 -- Present
    As a Database Administrator, responsible for the Installation, Upgradation, Administration and maintenance of Sybase SQL Server 11.9.2 and 11.0.3 Databases. Upgrading all the Servers from 11.0.3 to 11.9.2. Developed Scripts to perform various automated processes like DBCC, Update Statistics, database dump and log dumps, dropping and recreating indexes and recompile the stored procedures. Scheduling databases backups and log backups. Implemented disaster recovery procedures including regular Dump¡¦s and Load¡¦s. Fine tuning the configuration parameters and monitoring database performance.
    Hardware: Sun Sparcserver 1000E, SunSparc Workstations
    Operating System: Solaris 2.6
    Software Used: Sybase 11.9.2/Sybase 11.0.3
    Team Size: 2

    ****************
    Jan 1997 to Feb 2000 Syase Developer and Database Administrator
    Project: Share Accounting System Client: ****************
    Role: Database Administrator
    Hardware: Sun Sparcserver SS1000, Sun sparc Workstations
    Operating System: Solaris 2.5
    Software User: Sybase 11.5.1
    Team Size: 5
    The system was developed for post issue operation like on-line queries and transfer of shares. The system is designed on distributed data processing and client/server environment through ODBC. The system was designed for one of the leading share transfer agents in the country. The system has been designed and been implemented to take care of the present 6.5 million records and an annual increase of two million records. The system has been designed to take care of the complete process of registration and transfer of shares. The user is required to do only minimal data entry for processing. All security measures are implemented in this system. The systm has successfully handled databases sizes over 20GB. The system has been used for R&D activities of companies such as the Morgan Stanley Growth Fund (MSGF), IDBI, Bank of Baroda, ICICI, BPL Engineering, BIRLA 3M, CRISIL etc.
    Responsibilities:

  • Customization according users specifications.
  • Optimization of SQL queries to improve the speed & performance of the system.
  • Wrote stored procedures
  • Installation and trouble shooting at various branches all over India
  • Built, administered and optimized databases of up to 20GB
  • Installed Sybase & Quick Response system at Branch offices nationwide and monitored the performance and problems of the System
  • ****************
    Project: Mailer
    Role: Database Administrator
    Hardware: Sun Sparcserver SS1000,Sun sparc Workstations
    Operating System: Solaris 2.5
    Software User: Sybase 11.5.1
    Team Size: 4
    This system was developed to streamline ad automate Mail handling and tracking. The incoming mail is tracked till a reply is sent. The system keeps track of the document that is received from the Investor. The Processing Department generates responses that are sent for every Incoming document based on the nature of the complaint. The outgoing mail will be matched against incoming documents enabling the system to find out the pending/ unsolved cases.
    Responsibilities:

  • Installation and deployment of Sybase 10 server on Solaris 2.5
  • Creation of Stored Procedure and Triggers
  • Performance tuning
  • Implemented disaster recovery procedures including regular backups
  • Administration and maintenance of Sybase 10 databases in production, testing and development environments.
  • ****************
    Project: Merging/Amalgamation
    Role: Team member and DBA
    Hardware: Sun Sparcserver SS1000, Sun sparc Workstations
    Operating System: Solaris 2.5
    Software User: Sybase 10.0
    Team Size: 3
    This project facilitates amalgamation any number of companies into a single company. This software enables the allocation of shares in the ratio fixed by the company. In this process, folios and certificates are generated in the amalgamating company. Shares certificates are printed for the newly generated folios. Surrender notices are sent to the investors.
    Responsibilities:

  • Worked as a Programmer/DBA.
  • Played an active part in the design and analysi sof the system.
  • I was responsible for designing, coding, debugging, reportsgeneration and maintenance.
  • Also took part in basic Administration activities like backup and recovery, User administration disc fragmentation.
  • Education

    Graduate from Osmania University in March 1996
    Advance Systems Management (GNIIT) from National Institute of Information Technology (NIIT)
    Diploma in Oracle 7.3 and VB 5 from GEBBS
    Education Center Passed MCPS VB 5 and SQL Server Exam


    10

    WORK EXPERIENCE

    *****************
    MS SQL Server Production DBA & IT Department DBA Instructor
    Consultant (Consulting Firm W2 Contract)
    Specialized in Performance Tuning & Optimization for MS SQL Server 6.5 and 7.0 running on NT 4.0 implemented on Compaq Proliant servers using RAID 1 and RAID 5 in a prodution environment. Achieved a Production Server Performance Gain of 266%. The principal areas addressed were application optimization, checkpoint, CPU bottlenecks, deadlocks, disk bottlenecks, disk i/o parallelism, disk space, fillfactor, index create memory, index optimization, lazy writer, locks, log manager, max async i/o, max server memory, memory bottlenecks, min server memory, open objects, pad_index, paging, query optimization, read-ahead manager, recovery interval, user connections, worker threads and some items from the section "SQL Server Performance" for the Merchant Account Corporation below. Provided over 1,000 pages of documentation including statistical server data/graph volumes, implementation reports and instructional materials. Also, assisted in a version migration from 6.5 to 7.0 as well as a hardware migration from a 2-processor to a 4-processor server.

    *****************
    5/00 - 8/00 MS SQL Server DBA, Oracle DBA
    Conultant (Consulting Firm W2 Contract)
    Addressed maintenance and performance needs (see previous projects) for MS SQL Server 6.5 and 7.0 and Oracle 8i servers running on NT 4.0 and Oracle 8i servers running on UNIX [System V Release 4 (SVR4 and SVR4.2)], implemented on Compaq Proliant and Dell servers, using RAID 1 and RAID 5. Developed plans for server disaster recovery, installation, upgrading and migration. Performed server installations, upgrades from SQL Server 6.5 to 7.0, audits and disaster recovery simulations. Taught classes and provided documentation in SQL Server architecture, storage management, setup, configuration, SQL Agent, SQL Mail and performance tuning and optimization.

    *****************
    1/00 - 4/00 Web Developer Consultant (Independent Contract)
    Designed and implemented a complete ECommerce Solution for a network of websites, utilizing SQL Server Administration and Development skills and Web Programming skills. Considerable time was devoted to improving SQL Server Performance.
    SQL SERVER VERSION
    MS SQL Server 7.0 running on NT 4.0. SQL SERVER MAINTENANCE
    The same as that for the Chicago Board of Trade. See the section "Alphabetical list of tasks and troubleshooting events" for the Chicago Board of Trade below.
    SQL SERVER PERFORMANCE
    Monitored CPU, Memory, I/O Subsystem and Network. The following enhancements were implemented: CPU
    Priority Boost - This option was set to 1 because we were using dedicated SQL Server computers. Max Worker Threads - This was set to a number greater than the number of user connections to avoid thread pooing (which results in user connection wait time). SMP Concurrency - This option was set to -1 (use all processors) since we were using a dedicated, mutiprocessor server. Other CPU Strategies - Moved services and applications to different servers. Started to run services and applications at different times. Stopped using server as a workstation. Took SQL Server off of domain controller. Switched to intelligent controllers for bus mastering and I/O. Upgraded single CPUs to a higher class and clock speed. Upgraded to multiple CPUs.
    Memory
    Free memory in excess of 4 Megabytes was assigned to SQL Server. This number never fell below 4 Megabytes; therefore, Windows NT never issued a request for applications to reduce their working sets. The size of the Windows NT Paging file was increased. Unnecessary applications and services were removed. Unecessary network protocols were removed. The amount of physical memory was increased by 2 GB.
    I/O Subsystem
    Used the Max Async IO and Max Lazywrite I options. Monitored Physical Disk: Avg. disk Queue Length counter. The value was consistently less than Max Async IO. The values for Max Async IO and Max Lazywrite IO were increased by 25%. Used the free buffers option. This was increased by 25% since the SQL Server: I/O - Single-page Writes counter was high. Implemented RAID 5. Switched to high-performance controllers. Removed unnecessary file-server roles from the server. Used hardware-based RAID. Used higher-performing hard disks. Switched to wider-bus motherboards and controllers. Placed tempdb on the fastest possible device.
    After optimizing the data cache, set tempdb to 200 Megabytes to meet demands made on system and since the cache hit ratio was consistently low and no other means could be taken to improve it such as rewriting queries or altering data structures. After increasing the physical memory, the amount of RAM available to the SQL Server was far above what it actually needed to operate effectively as indicated by consistently high cache hit ratio and low physical i/o.
    Network
    Stopped using the encryption feature of the multi-protocol net library since over-the-wire encryption was not needed. Used the packet size option to reduce the packet size. Obtained faster response times. Made certain that Windows NT was set to Maximize throughput for Network applications. Recommended that 16-bit network cards (800 kps) be replaced with 32-bit cards (1200 kps). Suggested that network traffic to the server might be reduced through routing changes. Recommended that switched hubs be used to reduce overall bandwidth usage. Recommended installation of multiple network cards on the server, and that each card be configured to send to a different part of the network.
    Other Strategies

  • User Connections - Monitored the number of connected users during normal usage sessions to determine this number.
  • Procedure cache - Decreased the percentage of free RAM to reserve for procedure headers and execution trees to 20% sine RAM was considerable.
  • Open Databases - Set the maximum number of databases that can be open simultaneously to 50.
  • Open Objects - Set the maximum number of database objects that can be open simultaneously to 1000.
  • Locks - Set the number of available locks to 10,000 since SQL Server
  • displayed messages that the number of available locks was exceeded and based on number of connected users.
  • Logwrite sleep - Increased to 200 since RAM was considerable.

  • WEBSITES
    The websites submit online transactions to SQL Server. The submission pages submit customer information to SQL Server using the http "POST" function. Some custom, HTML tags were created:
    website_id This tag identifies the website owner.
    website_number This is a unique number which identifies the website.
    order_sequence This tag determines the order in which customer information is requested.
    territory This tag determines the countries which can be selected from a country select list.
    country_selectin This tag determines which country will be displayed first in the country select list.
    language_territory This tag selects the customer's language.
    card_transaction This tag specifies credit card transaction and the amount of the transaction.

    *****************
    5/99-12/99
    MS SQL Server DBA
    Consultant (Consulting Firm W2 Contract)
    Description of work environment:
    Information Systems is responsible for the effective use of technology and computer resources to achieve exchange operational and strategic objectives. Trading floor support systems, such as the Market Price Reporting System (MPRIS) including quotation distribution; the Market Information Data Inquiry Systems (MIDIS and MIDIS-Touch); and the electronic order entry and order delivery system are maintained and operated by the department. The electronic trading sysems, Project A and Chicago Board Brokerage, are also being developed and supported by the department. Staff computer system support is provided to all staff departments for office automation and specific computer systems used by the Accounting, Member Services, Office of Investigations and Audits, and Telecommunications departments. The technical development and maintenance of the CBOT's Corporate Internet Web Site is also the responsibility of this department.
    MS SQL Server 6.5 and 7.0 running on NT 4.0.
    Alphabetical list of tasks and troubleshooting events:

  • Architecture and Planning,
  • Assist Application Developers in Applying RDBMS Technology,
  • Backup Device Creation,
  • Capacity Planning for Database Servers,
  • Corrupt Application Database,
  • Corrupt Master Database,
  • Corrupt Table,
  • Data Destruction or Loss,
  • Database Backups,
  • Database Changes,
  • Database Creation,
  • Database Data Only Transfer,
  • Database Deletion (Drop),
  • Database Disaster
  • Recovery Planning Inluding Testing Scenarios and Documentation,
  • Data Integrity,
  • Database Maintenance Schedule,
  • Database Object Missing (No Data),
  • Database Object Updates,
  • Database Recovery,
  • Database Restore,
  • Deadlocks (or Blocking),
  • Development Database Planning,
  • Logical and Physical Database Design,
  • Nightly Batch Process,
  • NT Server,
  • Out of Disk Space Event,
  • Performance Monitor Alert Setup,
  • Problem Tracking/Resolution Event Report,
  • Production Database Planning,
  • QA and Architecture Review,
  • QA'ing a Server,
  • Replication (Publishing, Distributing, Subscribing),
  • Security Requirements,
  • Service Pack/Maintenance Updates,
  • SQL Server Alert and Task Creation,
  • SQL Server Performance Issues,
  • Task Scheduler Not Working,
  • Test Database Planning,
  • Transaction Log Dump with INIT,
  • Transaction Log Dumping at 50% Full,
  • ransaction Log Fails to Dump,
  • Transaction Log Filled Due to Open Tran,
  • Unkillable Process,
  • Understanding of 24 x 7 Database Support,
  • User Connections Exceed Threshold

  • This project required he signing of a confidentiality agreement. However, participation in the project is authenticated by several hundred pages of records and affidavits in the public domain.

    *****************
    1/99-4/99
    Oracle DBA, MS SQL Server DBA
    Consultant (Consulting Firm W2 Contract)

  • Oracle DBA, Oracle Developer.
  • MS SQL Server DBA, MS SQL Server Developer.
  • Oracle 8 running on NT 4.0 and UNIX [System V Release 4 (SVR4.2)].
  • Microsoft SQL Server 6.5 and 7.0 running on NT 4.0.
  • Administered, developed and consolidated Oracle databases.
  • Administered and migrated Microsoft SQL Server databases to Oracle.
  • Migrated Access databases to Microsoft SQL Server.
  • Handled database design, tuning, backup, recovery, export, import, application tuning.
  • Developed and administere the Oracle database back end of a web site which was integrated with a series of ongoing, national, television commercials.
  • This project required the signing of a confidentiality agreement.

  • However, participation in the project is authenticated by several hundred pages of records and affidavits in the public domain.

    *****************
    11/98-12/98
    Technical Assessment Expert in Oracle and MS SQL Server
    Consultant (Consulting Firm W2 Contract)

  • Oracle DBA, MS SQL Server DBA.
  • Oracle 7 running on NT 4.0 and UNIX (AIX 4.3.2).
  • Microsoft SQL Server 6.5 and 7.0 running on NT 4.0.
  • Prepared a Technical Assessment of the Paradox/Oracle Database
  • *****************
    5/98-10/98
    Oracle DBA, MS SQL Server DBA
    Consultnt (Consulting Firm W2 Contract)

  • Developed the Customer Subsystem for Amoco's Terminal Automation System.
  • Oracle DBA, MS SQL Server DBA, Visual C++ Developer.
  • Oracle 7 running on NT 4.0, UNIX (AIX 4.1.5) and UNIX [System V Release 4 (SVR4)].
  • Microsoft SQL Server 6.5 running on NT 4.0.
  • Administered and migrated MS SQL Server databases.

    *****************
    9/97-4/98
    MS SQL Server DBA
    Consultant (Consulting Firm W2 Contract)

  • MS SQL Server DBA, MS SQL Server Developer.
  • Microsoft SQL Server 6.5 running on NT 4.0.
  • Developed SQL procedures for a variety of reports.
  • Developed the Reports segment of Kraft's KAPS System.
  • Developed reports in Crystal Reports 6.0.

    *****************
    1/97-8/97
    MS SQL Server DBA, Oracle DBA
    Consultant (W2 Contract)
    Developed systems for clients of a *************, computer-hardware, electronics company:

  • *************: Planned Maintenance System, Oracle DBA, Oracle 7 running on NT 4.0.
  • *************, Oracle DBA, Oracle 7 running on NT 4.0, Visual Basic Developer.
  • *************: Purchase Order System, Oracle DBA, Oracle 7 running on NT 4.0, MS SQL Server DBA, Microsoft SQL Server 6.5 running on NT 4.0, Administered and migrated MS SQL Server databases, Visual C++ Developer.
  • *****************
    10/95-1/97
    Senior Systems Analyst

  • Oracle DBA and MS SQL Server DBA.
  • Oracle 7 running on NT 4.0 and UNI X [System V Release 4 (SVR4)].
  • Microsoft SQL Server 6.5 running on NT 4.0.
  • Developed Technical Database in Oracle, and its Visual Basic front end, for the Technical Support Department.
  • Developed Radio Frequency Data Collection (RFDC) Program in C, specialized 'LXE' C and Visual C++ for use on RFDC units.
  • The RFDC program included Bar Code reading capabilities.
  • Developed Bar Code Maker Database in MS SQL Server, and Zebra code.
  • Integrated RFDC program functionality with the Technical Database.
  • Migrated MS SQL Server databases to Oracle.
  • Created Dispatch Database in Oracle, and its Visual Basic front end.
  • Developed Material Requirements Planning Database in Oracle, and its Visual Basic front end.

  • Was a significant factor in obtaining ISO Certification for U.S.
    ***************** through the development of a Planned Maintenance System
    Database recognized as 'Best of Industry' by the ISO Committee.
    Developed the irst efficient Purchase Order System for the Manufacturing Department, consisting of an Oracle Database and its Visual Basic front end.
    Developed the Manufacturing Systems Main Menu System in Access which is used company-wide.
    Involved in every phase of the Development Lifecycle including Strategy, Analysis, Design, Documentation, Construction, Testing, Implementation, User Acceptance, Training and Support.
    Functioned as Team Leader for a Programming Group consisting of 10 technicians and 10 programmers and within that group as Lead Programmer for the Programming Team. The development process unfolded as follows: Initial, user requirements were obtained from the 10 technicians and a conceptual, project plan involving an application plan consisting of several, individual modules was developed. A practical, week-by-week, project plan was then created in which one or more individual modules were assigned to a given programmerto be completed by a given time. The project plan was presented to the 10-member, Programming Team. Feedback was obtained from the programmers. The project plan was revised. Work was begun on the project. Over the next year, weekly status reports were required from the individual programmers and individual, module developments were visited by me at least twice a week. New, user requirements from the technicians were allowed until the 2nd month of the project. At that point, all changes were locked in and new requirements deferred until the first revision of the project two years later. Completed the project ahead of schedule.

    *****************
    8/87-10/95
    Systems Development Consultant
    ***************** Inc. in 1996
    which in turn sold its resources in 1997 to ****************

  • Developed systems at several major corporations including Kraft Foods, Rand McNally and The National Safety Council.
  • Created a Customer Database at Rand McNally for their Public Relations Department in Dbase IV.
  • Created a Product Database at Kraft Foods in Access, Excel and Visual Basic for their National Sales Department.
  • Created a Membership Database in Paradox and Quattro Pro at the National Safety Council for their C&A Department.
  • Developed an Automated Proposal Generation System in Access and Visual Basic for the National Safety Council.
  • Developed a Quarterly Accountability MultiSpreadsheet Database in Access for invoice tracking at Oce.
  • Developed a specialized, invoicing application in Visual Basic for Chicago Health Industries.
  • Served as acting Network Administrator at Peoples Choice Cable TV. Programmed new workstations nd performed hardware installation and configuration. Handled the LAN end of a LAN-to-WAN conversion.
  • Handled daily responsibilities for batch processing of tax data under OS/VS1 and IDMS on an IBM 4341 mainframe for Computax.
  • Handled electronic accounting functions at AGA on a WANG 2200 minicomputer.
  • *****************
    1/72-8/87
    Systems Development Manager

  • Hired, evaluated and supervised new data processing professionals.
  • Served as Project Manager, Team Leader and Lead Programmer.
  • Reorganized the Data Processing Department to meet the new, competitive requirements of the microcomputer age.
  • Developed automated graphics systems in several languages.
  • Developed GUIs for mass production of printed material.

  • 11

    OBJECTIE:

    Seeking a challenging position that requires a dedicated Senior Oracle DBA for Internet, OLTP and Datawarehouse applications for a Production environment, that best utilizes over 10+ years of my progressive experience.

    EDUCATION:

    BS in Computer Science

    EXPERIENCE:

    6 Years of experience as ORACLE DBA, Enterprise wide Backup solutions, Disaster Recovery solutions, High Availability through Shareplex and 6+ years of experience in Configuration, design, development, testing and implementation of system and application software. Subsequent to the design and development of software, provided maintenance and customer support after implementation. Ability to execute tasks independently or as part of a team.

    SKILLS:

    ORACLE 8i DBA, Backup and Recovery solutions, Replication using Shareplex, Disaster Recovery solutions, Design and Development skills indatabase applications, system applications like Financial, Order Processing etc., using ORACLE RDBMS and SYBASE. Expert in RMAN, OEM 2.1, Legato Networker, High Availability Systems, C, Visual C++, PL/SQL, VISUAL BASIC, ACCESS, Shell programming, PERL and WINDOWS Graphical User Interface programming skills.
    SOFTWARE: ORACLE8i, 7.3.4, VISUAL BASIC, MICROSOFT ACCESS 7.0, JAM 7.34, Power Builder 3.0, Oracle Power Objects, C, MFC Visual C++, "C++" Language, WINDOWS SDK and other GUI based tools.
    OPERATING SYSTEM: Solaris 2.7, Windows NT, LINUX, DEC Unix OSF1 4.0, NT 4.0, AT&T SVR 4 MP-RAS UNIX, MS-DOS, Windows 3.1, Windows 95, OS/2, AIX 3.2.4,AIX 4.1.2, HP-UX 9.01,9.00,10.01 and Sun OS 5.5.1, Open VMS 4.0
    TOOLS/UTILITIES: Oracle Enterprise Manager (OEM 2.1), Oracle Management Pack, Oracle Tuning Pack, Apache Web Server, ERwin, Lex, Yacc, sdb, svrmgrl (Oracle 8i), EBU, Exp, Imp, Sql Loader, ODBC, Crystal Reports, EXCEL Macros, Crystal Reports, Microsoft.
    HARDWARE: 80x86, MOTOOLA 68040, 6085 Xerox Workstation, IBM 3270, AT&T System 3550,3600, Globalyst S40, SUN SPARC Center 1000, 2000E, HP-UX -9000, HP-UX Apollo Series 700,715/80, SUN SPARC Server 20, Sun Micro System, IBM 8507, IBM RISC System/6000 and Sun SPARC station IPX and IPC.

    WORK EXPERIENCE

    COMPANY : **********
    CLIENT: Priceline, Stamford CT.
    NAME OF THE PROJECT: Production ORACLE DBA
    FROM: Sep 2000 to Current
    Description : Working as Production DBA.. Leading the Production DBA team for UK Priceline. Involved with designing the hardware requirement for priceline products, installation of oracle 8.0.5.2, building the database for different products like AIRLINE, HOTEL, RENTAL CAR and TELECOM database in solaris environment for Production, QA, Development and training boxes for PRICELINE UK. Crrently managing around 40 databases in Production, QA, Development and training environment by giving 24/7 support.
    1. Used Shareplex and replicated the database forHigh Availability. Installed the shareplex, configured and maintained it.
    2. Using Netbackup and RMAN configured the database backup for production databases.
    3. Populated the database from Development, Quality Assurance, Test and Production environment using EXP and Imports.
    Configuration of High Availability System using Veritas ClusterSoftware.
    4. Configured many Standby Databases for High Availability.
    5. Configured BMC Patrol to monitor the database for maintenance.
    6. Wrote shell scripts to monitor Standby database, maintain standby database, monitory shareplex, Hot backups, exports, storage manangement etc.

    COMPANY : HCL America
    CLIENT: **********
    NAME OF THE PROJECT: ORACLE DBA - Enterprise Wide Backup Solutions for E-Business.
    FROM: Nov 1999 to Aug 2000
    Description : Provided Enterprise Wide Backup Solutions using RMAN from Oracle 8i and Legato Networker. Their application includes Web Servers for Netmarket.com, Finncial Systems and Datwarehouse applications.
    1. Using Legato Networker coded RMAN scripts to use the different POOLS for different retention and browsing policy. As the different applications and business requirements requires various retention policy, configured the Legato Networker to use the same. Optimized the tape usage by running different incremental backups To optimize the tape usage in the library configured the RMAM backup and recovery with incremental HOT backups.
    2. Using Oracle Enterprise Manager, RMAN, Oracle management Server, Oracle Agent configured Backup and Recovery for their production, staging and development environment. To give single point of Management control used the OEM Management Console to schedule the backup jobs with incremental backups.
    3. Documented the Backup and Recovery procedures and gave training to the DBA's to perform the same.
    4. Configuration of High Availability System using Veritas Cluster Software and poviding backup and recovery solutions using RMAN without duplicating backup during failover.
    5. Configuration of Standby Databases for High Availability and for offline Report generation.

    COMPANY : **********
    TITLE/CLIENT: /**********
    NAME OF THE PROJECT: Product development
    FROM: 08/1998 to 10/1999
    Description : Design and development of a lottery game. This is currently being developed in Open VMS environment for backend application, Sybase 11 for backend database, JAM 7.35 for Front End application. Involved in offline application development, backend database development using Sybase Stored Procedures, Client development using JAM software and Sybase Application DBA.

    COMPANY : **********
    TITLE/CLIENT: Oracle Database Administrator/**********
    NAME OF THE PROJECT: PRIMARY ORACLE DBA
    FROM: 06/1998 to 08/1998
    Description : Worked as a Primary Oracle DBA for Peoplesoft application.

    COMPANY : **********
    TITLE/CLIENT: rimary Oracle Database Administrator/ **********
    NAME OF THE PROJECT: PRIMARY ORACLE DBA
    FROM: 08/1996 to 06/1998
    Description : Worked as a Primary Oracle DBA for a Data Warehouse and Financial Application System. Environment includes 8 production and 25 development/test databases. Supported Oracle 7.3.4 server in the production environment and testing Oracle 8.0.4 server in the test environment. Duties and responsibilities include perform Oracle Server Installations, Oracle Client installations through SQL Net 2.3, Oracle Enterprise Manager installations, S/W upgrades, Patch Installations and configuration. Responsible for VLDB physical database creation, tablespace management, and loading of data and maintenance for a database of size around 300GB. Providing production support Finnancial application users who is using PeopleSoft 6.0 and Datawarehouse application users. Using Oracle Enterprise Manager 2.0, Monitor and optimize the performance of the atabases. Maintain system security, enroll users, audit and monitor users access to the databases. Install, creation of catalog database and support of Backup software like Legato Networker V4.2A, Legato Juke Box, DMO 2.1 drivers for automated HOT and COLD database backup and recovery using Oracle Enterprise Backup utility (EBU). These Legato Networker stores data to the tune of 1.5 Terabytes. Developed and supporting manual backup software for small databases. Responsible for database kernel tuning, Database server level init parameters tuning and SQL query tuning for the Datawarehouse/FS system using EXPLAIN PLAN, compute/estimate statistics SQL TRACE, cost/rule based optimization techniques. Developed SQL scripts to monitor the space usage using a command center. Developed unix shell script to monitor alert log files. Integrated Tivoli TME 10 Ver 3.1.2 with oracle database to monitor unusual system event. Interact with Oracle Customer Support for the oracle errors that occurs frequently and aply the patch release on a regular basis.

    Peoplesoft Project :
    TITLE/CLIENT: Peoplesoft Application DBA/ **********
    FROM: 02/1998 to 06/1998
    Description : DBA for a Peoplesoft 6.0 HR and Financial System. Involved in installation of Peopesoft 6.0, Manage Test and Acceptance database. Used Application upgrader, Data Mover, Export, Import and performed SQL tuning.

    COMPANY : **********
    TITLE/CLIENT: Senior Software Consultant/ **********
    NAME OF THE PROJECT: Data-verification Module for ORACLE DBA Monitor
    FROM: 10/1995 to 08/1996
    Description : Involved in writing the Data-verification scripts using SQL PLUS with system tables and views of ORACLE 6.0,7.0,7.1 and 7.2, for DBA Monitor Application called TMON for ORACLE. Writing this SQL script programs for around 600 fields of the SYSTEM tables. Also using PL/SQL Stored Procedures. These SQL scripts are responsible for tuning the ORACLE server, Displaying Oracle Configuraion report, Checking of Log and Trace files, Location of Archive Log Files, Space Utilization, Security Information and many other tasks. The above project was done using the following software SQL PLUS 3.0, PL/SQL,MICROSOFT ACCESS 2.0. and tested in AIX 4.1.3, HP-UX, SUN OS and Solaris machines. Working as a Team Leader for this project.

    TITLE/CLIENT: Senior Software Consultant/ **********
    NAME OF THE PROJECT: Role of Part-time DBA for ORACLE.
    FROM: 10/1995 to Current
    JOB DESCRIPTION: Responsibility includes Installation for ORACLE 7.0,7.1 and 7.2 in the environments mentioned below. Also performed many roles like creation of Tablespaces, Datafiles, Log files and regular Backups. Wrote my own shell scripts which automates the functionality of Cold backups at regular interval using CRONTAB and many UNIX shell command. Wrote many shell scripts which basically adds users, assigns system privileges, perform database checkup t find whether Oracle instance is alive, and spool the response and mail it back to ORACLE DBA, also generates report which prints the security privileges for everyone. Routine checks of log and trace files to see whether there are any problems requiring action, routinely clearing out old entries from the log file. Was responsible to make the system use Multi threaded System(MTS) and Parallel Query Option concepts by changing appropriate configuration parameters. I am performing the above role using the following products Oracle Server Manager 2.1 Ver and SQL DBA, SQL Plus and in the following O.S environment AIX 4.1.2 and above, Solaris 2.3 and 2.4, HP-UX 9.0,10.0 and SunOS 4.x.

    TITLE/CLIENT: Senior Software Consultant/ **********
    NAME OF THE PROJECT: QA for DBA Monitor Application called TMON for ORACLE
    FROM: 10/1995 to current
    JOB DESCRIPTION :Performed a structured QA testing for The MONITOR for ORACLE prodct on all the platforms mentioned below. Performed Regression test, Conditional Logging test, Stress test, GUI interface testing and also by running the Data-Verification module explained in the above project (Data-Verification Module for ORACLE DBA Monitor). The above QA was done on the following software products ORACLE 6.0,7.0,7.1, and 7.2. and in the following Operating System environment AIX 4.1.2 and above, Solaris 2.3 and 2.4, HP-UX 9.0,10.0 and SunOS 4.x. Working as a Team Leader for this project.

    TITLE/CLIENT: Senior Software Consultant/ **********
    NAME OF THE PROJECT :QA for DBA Monitor product TVIEW for SYBASE
    FROM: 10/1995 to 1/1996
    JOB DESCRIPTION: Performed a Structured QA testing for The MONITOR for SYBASE product on all the platforms mentioned below. Performed Regression test, Conditional Logging test, Stress test, GUI interface testing and also by running the Data-Verification procedures. The above QA was done on the folowing software products SYBASE 4.9.2 and 10.0.2 and in following O.S AIX 3.2.4,AIX 4.1.2, Solaris 2.3 and 2.4, HP-UX 9.01,9.00, 10.01 and SunOS 4.1.4,4.1.3_ul. Worked as team leader for this project.

    COMPANY : **********
    TITLE/CLIENT: Software Consultant/ **********
    NAME OF THE PROJECT: Package Information retrieval system
    FROM: 8/1995 to 10/1995
    JOB DESCRIPTION : This project is to retrieve the package information, and decide what media to build and duplicate of the entire AT&T SVR4 Operating System. Developed this using Microsoft ACCESS 2.0 and Microsoft EXCEL 5.0. I completely designed and developed this product. It will automatically import the data from the EXCEL spreadsheet and flood the database table. Then based on the customer input it will retrieve the information for any particular product. The packaging information was stored in the Excel spreadsheet. I used the OLE object control to manage the diplay by transferring data. I used around 10 different forms, many Queries, Tables and Reports. Also used many database object controls.
    TITLE/CLIENT: Software Consultant/ **********
    NAME OF THE PROJECT: CD-ROM, Tape and Flex Duplication Application:
    FROM: 4/1995 to 8/1995
    JOB DESCRIPTION : Developed this program to automate the duplication process of the media generation for various products. It packages all the 1200 individual product component of UNIX SVR4 MP-RAS operating system by compression into a single unit. It also bundles the different components into different components to create Client Server Operating Environment, Network File System Operating Environment Product etc. It was developed using curses and UNIX C Shell script language. It will reset the tape drive and duplicates the media and reports the result of the process in the log file.

    TITLE/CLIENT:
    Software Consultant/ **********
    NAME OF THE PROJECT: SMDP(Software Media Distribution Process System):
    FROM: 7/1994 to 6/1995
    JOB DESCRIPTION: This Application is to process the Software media distribution and storing various product information and generate report for the dependency definition of the MP-RAS SVR4 OS and other products. This report will be used by the Duplicating centers to decide what components constitute the product. Developed this product using ORACLE 7.0 and MICROSOFT VISUAL BASIC. Used ODBC connectivity for connection with Oracle. Used around 25 screens, more than fifty Queries, 20 reports using Crystal reports,. I designed this system, prototype developed and implemented this whole system. I was the project leader and team size was totally 3 people.

    TITLE/CLIENT:
    Software Consultant/ **********
    NAME OF THE PROJECT: Order Entry System:
    FROM: 4/1994 to 11/1994
    JOB DESCRIPTION : Developed Order Entry system in ORACLE. Involved in design and implementation of the system, using Oracle 7.0, Forms 4.0, Oracle Report Writer, SQL Plus, and codes were written using PL/SQL and Pro C. I was mainly responsible in forms design and report writing. This application involved many screen forms and reports for different category of users. All the security measures were taken into consideration for the different types of users. This is to be used by the Sales people for order processing to the customer.

    TITLE/CLIENT:
    Software Consultant/ **********
    NAME OF THE PROJECT: P-I-P-E (Pipe Information Productivity Enabler):
    FROM: 1/1994 to 4/1994
    JOB DESCRIPTION: PIPE is an application enabler product, enabling the movement of information between relational databases and DDE aware applications. The purpose of this PIPE is to gather data from the PLC (Program Logic Control) Machines through Net DDE Protocol and then apply the filters and fittings to the data gathered and then generate the SQL statements. Then using ODBC for Oracle Server execute the SQL Statement. My role is to develop the PIPE - ODBC Engine application and Error Logger application independently. This was developed using MFC C++, ODBC Complaint PC Database, DDE, SQL DBA, SPXSRV, ORACLE 7.0, Net DDE, SQL Server, SPX/IPX Protocol, TCP/IP Protocol and using 80486 IBM Machine. It was developed in MS-WINDOWS Operating system.

    TITLE/CLIENT:
    Software Consultant/ **********
    NAME OF THE PROJECT: Global View - System Administration Module (SAM):
    FROM: 9/1993 to 12/1993
    JOB DESCRIPTION: Developed the System Administration for the Product, Global View for Windows. This product is a MESA Emulator for XNS system for Windows. This actually simplifies the TTY mode in UNIX o GUI interface with windows. This administration module actually connects to the Global View of XNS system and makes connection. Once connection is made it allows to execute a script language for various administration work like running error recovery module, Booting operations and many other operations. This was basically done by creating a Virtual Disk space in the DOS machine, and load different Xerox applications. Involved in complete GUI design, development of the module. Supported them in memory related bugs. This was developed using WINDOWS SDK 3.1, C700 and debugging utility like CodeView and SoftICE, and used Source Code Controller. The Operating System used in this project was MS-WINDOWS and XNS using 6085 Machine.

    TITLE/CLIENT:
    Software Engineer/ **********
    NAME OF THE PROJECT: WP for Mailmerge Utility in Database Manager :
    FROM: 10/1993 to 8/1993
    JOB DESCRIPTION: Developed a Word Processor object with th help of "ACEdit" library for basic editing functionality which was developed earlier. This design basically involved developing two major classes, one class for User Interface and another class for managing information coming from the User Interface. This WP was developed to be integrated in Mail Merge editor and finally to be integrated in a Database Manager Product. This WP took care of Paragraph, Character, File I/O, Indentation, Justification, Spacing, OLE for Picture Importing, Page Preview, On Line Help, Header /Footer, Ruler's and finally printing options. Provide another CRuler class which has various preference like inches, centimeter and Pica scales. Developed the action module as DLL. All the common dialog box were used for different interface options. This project was done using MFC C++, WINDOWS 3.1 SDK, Debugging utility CODEVIEW and SoftICE and TOOL BOX, Charting for Windows.

    Oracle Certification

    Database Administration 7.X
    Oracle Peformance Tuning 7.X

    Technical Training

    Oracle 8 Features and Administration
    Oracle Enterprise Manager 1.5
    Oracle Recovery Manager
    CBT for Oracle DBA I and DBA II
    CBT for Oracle Tuning, Architecture.


    12

    PERSONAL QUALIFICATIONS
    Over 8 years of solid Information Technology experience.
    Committed to complete tasks on time, while maintaining specifications.
    Willing and able to learn quickly.
    Creative problem solver.
    Productive in an independent or a team environment.
    PROFESSIONAL QUALIFICATIONS
    BrainBench Certified Informix Database Administrator A Transcript ID number 19391. To verify, go to BrainBench website at http://www.brainbench.com and enter the transcript ID number.

    TECHNICAL SKILLS

    RELATIONAL DATABASES
    INFORMIX Dynamic Server 7.3x, INFORMIX Dynamic Server 7.2x, INFORMIX Dynamic Server 7.1x, FoxPro,MS Access.
    OPERATING SYSTEMS
    Sun Solaris 5.6 (Korn Shell), IBM AIX 4.x (Korn Shell), DEC UNIX 4.0 (Korn Shell), DEC UNIX 3.2 (Korn Shell), SCO UNIX Ware 7.0 (Korn Shell), HP-UNIX 9.0(Korn Shell), Windows NT (workstation), Windows 95/98, Windows 3.11, DOS, Novell NetWare 3.11. PROGRAMMING LANGUAGES
    Informix 4GL 7.2x, Informix SQL 7.2x, Informix 4GL 6.0x, Informix SQL 6.0x, Korn shell scripting, AWK scripting, HTML, C, MicroFocus COBOL, CICS, Quick BASIC, Clipper.
    BACKUP AND MIGRATION TOOLS
    Legato NetWorker client, Informix ON-BAR, Informix ON-Archive, Informix High Performance Loader.
    CASE TOOLS
    EmbarcaderoAs DB/Studio, PlatinumAs ER/win.
    OTHER TOOLS
    Hewlett Packard OpenView IT/Operations (now VantagePoint Operations) A Informix plug-in.

    PROFESSIONAL EXPERIENCE

    *************
    March 2000 A Present
    Contractor
    Operations Database Administrator assigned to HIP (Healtheon Integrated Platform), a service integration platfom for Healtheon | WebMD. Healtheon | WebMD is the first end-to-end Internet healthcare company, connecting physicians and consumers to the entire healthcare industry, by using the Internet to facilitate a new system for the delivery of healthcare, resulting in a single, secure environment for all communications and transactions that will enable a more efficient and cost effective healthcare system.

  • Installed Informix Dynamic Server in several development, test and production servers.
  • Migrated data from the production server and tape backups into test servers, by unloading large dynamic tables with HPL (High Performance Loader), and restoring small static tables from tape.
  • Setup ON-BAR and scheduled Legato for database server and logical log backups on production servers.
  • Recommended and developed maintenance utilities for the production and test databases (ran by CRON), which included update statistics to improve the query optimizer decision paths, dbspace disk availability, and exten number monitoring.
  • Tested disk arrays (IBM (Shark) and MTI) for the new Enterprise Storage Solution project, by setting and timing series of serial and random reads and writes from HPL jobs and SQL statements that were run from Korn shell scripts.
  • Helped to setup HPAs OpenView IT/Operations Informix plug-in to monitor the database, by providing database monitoring thresholds.
  • Purged and archived data out of large critical tables by using existing scripts and/or HPL.
  • Worked closely with the projectAs System Administrator in hardware changes, hardware requirements for new servers (production and test) and disk layout rearrangements.
  • Created and modified several new and existing Korn shell scripts for monitoring and data extraction.
  • Delimited the work scope of the DBA and the involvement of the user in it.
  • Calculated actual and projected table size and growth on key, fast growing tables.
  • Monitored daily DB server and logical log backups.
  • Created, designed and deployed an intrnal web site to document all DBA activities, documentation, utilities, processes and standards for current and future DBAs.
  • *************
    January 1999 A November 1999
    Client: First American CREDCO A Project: Data Migration and DB Replication Database Administration Consultant for First American CREDCO, the largest provider of specialty credit-reporting and information management products. First American Credco has a strong track record of technological solutions and diverse product offerings which include Automotive, Mortgage, Merged and Personal credit reporting as well as Credit Scoring, Employment and Income Verification, Tax Return Verification, Tenant Screening, Management Reporting and Market Research Tools

  • Implemented Informix Enterprise Replication (CDR) between the production server, an IBM R40 running AIX 4.1.3.0 OS using Informix Dynamic Server 7.24.UC7, and the new production server an IBM RS/6000SP running the IX 4.3.2.0 OS using Informix Dynamic Server 7.30.UC8. The implementation included:
  • Tested HPL and CDR on/between both machines.
  • Performed HPL and network file transfer benchmarking.
  • Recommended upgrades to the old server Informix engine, to make CDR between the two machines possible.
  • Automated tasks, through the use of Korn shell scripts.
  • Migrated data from the old production server to the new one using a combination of SQL unload/load and HPL. The SQL unload and load statements were generated and ran using a Korn shell script of my design, and HPL, was used to load/unload the larger tables (2.5+ million rows and 100+ bytes wide).
  • Created Korn Shell scripts to monitor CDR, given that the Informix monitoring tools do not work in the AIX environment.
  • Monitored and troubleshot CDR
  • Analyzed and documented a credit report application to increase performance:
  • Analyzed SQL statements within the application to determine if they are optimized to use indexed searches.
  • Adde new indexes to tables in the applicationAs database, where needed, based on the SQL statement analysis mentioned above.
  • Recommended Data Modeling tool to be used on this project.
  • Reverse engineered the applicationAs database, using a data-modeling tool (EmbarcaderoAs ER/Studio), to get a base for the documentation of the databaseAs data model.
  • Assisted resident DBAs with various day-to-day DBA tasks.
  • *************
    June 1998 A January 1999
    Database Administrator for PrePass, a project of Lockheed Martin Information Management Services, Commercial Vehicle Operations, Transportation Systems and Services, dedicated to allow heavy commercial vehicles to bypass weight stations in several states, using advanced technology to weight the vehicles at highway speed, and fast speed communication relays to verify credentials, registration, safety records, and related data.

  • Developed a maintenance schedule for the production database, which included updatestatistics to improve the query optimizer decision paths, dbexports / dbimports to decrease extent dissemination across the dbspaces, and database tape backups.
  • Improved the performance of reporting and invoicing/billing by 50%, by providing regular maintenance to the database, and tuning the engineAs configuration file.
  • Recommended the purchase of additional hardware (more memory and an additional processor) for the new server, to handle projected growth of the database.
  • Recommended a new hard disk layout on the new server, pointing out the necessity of several spindles, to improve performance and data availability by allowing parallel scans to retrieve data, and by fragmenting tables in the database.
  • Created a schedule to migrate the production database from an Informix OnLine 7.10 engine for DEC UNIX 3.2 on a single-processor DEC Workstation to an Informix OnLine 7.23 for DEC UNIX 4.0 on a dual-processor DEC 2300 Server.
  • Configured and tuned the database engine already installed onthe new server, according to the available hardware resources
  • Worked with the developers to create a series of SQL scripts to measure performance on both the current platform, as well as on the future platform.
  • Reviewed SQL scripts and stored procedures, improved filter selectivity where necessary and recommended a better indexing strategy, all to improve performance on data retrieval.
  • Recommended data modeling software to be used on the overall projected re-design of the application, the database and the business process.
  • *************
    December 1997 A June 1998
    Software developer and Appointed DBA for *************** (now ***************),
    a direct hardware, software, and subscription services retailer for large software and hardware corporations.
    A As Software Developer:

  • Developed a custom generic data loader to handle data sent by new clients, capable of fie handling (through AWK scripts) duplicate row checking, auto generation of new customer codes, automatic restart in case of failure and precise error logging.
  • Maintained various customized systems (Contact Management, Quoting / Ordering, and Accounting), using Informix 4GL and Informix SQL.
  • Served as a liaison between the Development Team and the users.
  • As Appointed Database Administrator:
  • Proposed, specified, developed and implemented a new procedure to upgrade statistics based on the current indexing strategy.
  • Specified and developed new processes and procedures to update the data warehouse with data from the production database on line, using triggers and stored procedures, as opposed to a batch process at the end of the day.
  • Proposed and specified a table fragmentation strategy, to solve availability issues.
  • Performed dbexports and dbimports to solve extents dissemination through out the dbspace.
  • Created and loaded a testing environment based on a previous dbexpot of the production database.
  • Created utilities to check for locks on tables, showing the owners UID, table locked, server from where the application was invoked.
  • *************
    July 1995 A December 1997
    Client: *************
    Plug-in Asset Control Environment Member of a team that provided 24 by 7 support to a critical inventory tracking system (Plug-in Asset Control Environment - PACE) for Pacific Bell. Using this system, ************* saved 120 million dollars between 1995 and 1997.
    In 1997, ************* PACE team won the RIT/USA Today Quality Award.

  • Enhanced and modified the PACE application using SQL, Informix-4GL, Korn shell scripting and AWK scripting on a HP-UNIX platform. Reduced data corruption by fixing bugs and enhancing the application.
  • In charge of the API between PACE and six other legacy systems. Developed a brand new API with an existing legacy system to provide data for a critical report requested by the client.
  • Lnk between the Application Support Team and other members of the ClientAs team. Gained new business relations for the team with teams PACE is directly interacting with, but did not have a personal relationship in the past.
  • In charge of legacy systemsA data, API jobs scheduling and API data error.
  • Analysis of the mentioned led to improvement on the job scheduling to release stress on the 24 by 7 pager carrier at late night hours and recommended a course of action to reduce occurrences of API data errors.
    In charge of database administration tasks. My obligations included:
  • Dbexports, database reorganizations and database index checking to increase data integrity and performance.
  • Creation and alteration of tables and indexes as requested by the application support team.
  • Data analyses to provide optimum table fragmentation and space usage, when needed.
  • Monitoring the databaseAs performance and sanity.
  • *************
    May 1994 - July 1995
    Trainee A Developed and implemented batch and on-line programs in COBOL.
    A Designed and developed screen maps in CICS.
    A Performed quality analysis tests.

    *************
    October 1994 - December 1994
    Contractor
    ************* is the largest publisher of legal matter books. They also are the official legal publisher for the State of California. A Coded data item definitions in C like macros to be included in a Legal Form Generator and Database.

    *************
    September 1990 - January 1993
    Programmer/Analyst (and part time teacher) for the largest, most prestigious and most advanced Advertisement and Graphic Design school in Peru.
    A Designed, developed and maintained statistical systems for upper management. Improved statistical reporting time by 80%. A Designed, developed and maintained payroll system. Reduced the payroll processing and printing time by 85%.
    A Reviewed and investigated new hardware and software poducts for the Computer Assisted Graphic Design Master program. A Troubleshot PC hardware and software.

    EDUCATION
    Informix Software, Inc. - Education Services
    September 1995 / April - June 1997
    Brisbane, California
    Courses: Structured Query Language (SQL)
  • Developing Applications Using Informix-4GL
  • Managing and Optimizing INFORMIX-OnLine Dynamic Server Databases
  • INFORMIX-OnLine Dynamic Server System Administration
  • Relational Databases Design

  • Computer Learning Center
    May 1994 - July 1995
    San Jose, California
    Major: Computer Programming
    Instituto de Alta Tecnologia Cibertec
    March 1989 - December 1991
    Lima, Peru
    Major: Computer Science
    Universidad de Lima
    March 1987 - December 1987
    Lima, Peru
    Major: General

    Education

    LANGUAGES
    English - Fluently spoken, read and written.
    Spanish - Fluently spoken, read and written.


    13

    Career Objective

    To work with gigabytes of MS-SQL databases giving optimum performance, 0% downtime and 100% efficiency with 100s of users and to provide maximum security to the databases.

    Overall Experience

    7 years of experience out of which 10 months as Technical Director, 3 years as a Project Leader, 1 year as a Senior Programmer, 2 years as Junior Programmer with 2 months of overseas experience and some teaching experience. Over all 3 years as MS-SQL Server DBA.

    Experience Summary

  • Working with M/S. Mahati Technologies Pvt. Ltd. as Technical Director since Feb' 2000.
  • Worked with Info Needs India Ltd. from May 1999 to January 2000 as a Project Leader
  • Web Specialist for British elecom - Amsterdam for 2 months (Oct.'98 - Dec.'98)
  • Worked with Askey Soft for 2 years as a Project Leader (Aug.'96 - April.'99)
  • Worked with Askey Soft for 1 year as a Senior Programmer (Aug.'95 - Aug.'96)
  • Worked with Askey Soft for 1 year as a Junior Programmer (Aug.'94 - Aug.'95)
  • Worked with Gajanan Enterprises for 1 year as a Programmer (Aug.'93 - Aug.'94)
  • Major Strengths

  • Excellent team leader and team player
  • Excellent communication and inter personnel skills
  • Excellent Project Planning skills
  • Excellent Database design and database maintenance Skills
  • Excellent knowledge of e-commerce and web sites and portals
  • Excellent Knowledge of current technologies and ActiveX, COM, DCOM
  • Working knowledge of networks
  • Working knowledge of Web Server administration and securities Field of Interest
  • MS-SQL Server DBA
  • Database designing and maintenance
  • Web site planning and designing.
  • Intranet planning and designing.
  • Software Development
  • Software Testing.
  • Personal Information

    Name **** ************* *************
    Present Address *********************
    Permanent Address *******************
    Phone Number: ***********************
    E-Mail Address **********************
    Date of Birth **********************
    Passport Number *********, Expires on **** ***** ******.

    Languages

    Known English, Hindi, Marathi.

    Marital Status
    Married

    Educational Qualification
    BE (Computers) from University of Pune.

    Computer Proficiency
  • Platforms worked on S-DOS (All Versions till 6.0),
  • Windows NT 4.0, Windows 2000
  • Unix AT&T Rel. V System 3,
  • SCO Unix V/386 Rel. 3.2,
  • Novell Netware 3.2, Windows 3.11,
  • Windows 95, Sun Solaris Unix.
  • Project Management

    MS-Project 2000, MS-Team Manager 97

    Computer Languages

  • Known Visual Basic (ActiveX, COM, DCOM), C, Pascal, Fortran, COBOL, Basic
  • RDBMS Oracle 8 with Developer 2000.
  • MS-SQL Server 7.0 DBA
  • MS-Access 7.0
  • MS-SQL Server 7.0
  • Installing and configuring SQL server, Registering Servers, Creating devices, databases and table.
  • Managing with Enterprise manager
  • Uploading to web server
  • Backup and recovery policies
  • Performance and tuning
  • Security
  • Computer Software

    MS-Office 2000, MS-FoxPro 2.6,DbaseIV, CorelDraw, PageMaker and other utilities.
    Internet & Intranet Related Internet Technologies E-commerce, ASP, HTML

  • E-Commerce
  • Shopping Cart
  • Credit Card Validations
  • Secured Socket Layers (SS)
  • Active Server Pages (ASP)
  • Ad Rotator components, Mailing Components, Content Rotator Components
  • Connecting to any Backend, Sessions, Cookies, Applications
  • Professional Experience

    Overseas Assignment (2 months)
    Organisation ******************
    Duration 2 Months (12th Oct. 1998 to 12th Dec. 1998).
    Title Web Specialist.
    Responsibilities.

  • Web Sites Design and Development
  • Maintaining the overall working of Sun Solaris System.
  • Contact Person Mr. Hans Koolen
  • Projects Done
    1. Web Site Design and Development
    Planning, Design and development of British Telecom site. Designed 5 pages with HTML with some Perl scripting.
    2. Jel Secure Server.
    Installation of the Java Development Kit (JDK), Omnibus and various patches on Sun Solaris systems. Developed Web Pages for the same and provided security through Security Dynamics Ace Secure ID Cards.
    3. Remote Annex Terminal Server.
    Installation, Connecting various UnixSystems to the Remote Annex Terminal from Bay Networks and configuring them for access from outside world.

    Working with ****************** as a Technical Director.
    Organisation ******************
    Duration Since Feb 2000
    Title Technical Director
    Responsibilities
    MS-SQL Server 7.0 DBA, Client Interaction, Planning, Designing, Scheduling, Testing.
    Contact Person *****************
    Contact Number *****************
    Projects Done
    The below mentioned projects have been successfully carried out as a Technical Director with a team of 10 people with varying duration of time. The team comprised of 2 Project Leader, 6 software engineers and 2 Graphic Designers. Also maintained the MS-SQL Server 7.0, which housed the databases for the projects done. 21 data entry operators keyed in data for the portals developed with an approximate database size of 1.3 GB..
    The responsibilities carried out were as follows
    1) MS-SQL Server 7.0 DBA

  • Performance Tuning
  • Security
  • Backup
  • Creating and Maintaining tables, roles, users etc.

  • 2) Analysis & Designing
    3) Documentation
    4) Code Reviews
    5) Testing
    6) Contents
    Sites Handled
    1) www.*******.com web site
    This is ******* Ltd. In-house portal, which consists of the following modules. The modules, which were designed and developed under my guidance, are mentioned here
  • Matrimonial
  • Jobs (www.*******.com)
  • Rental
  • Site Search
  • Dating Zone (www.*******.com)
  • Students Zone (www.*******.com)
  • Cash Cards
  • Common Entrance Exams Platform
  • 2) www.*********.com
    3) www.*********.com
    4) ....
    ....
    9) www.*********.com
    [I]URL' ÅÊ ÂÙÌÏ 9 ÛÔÕË, ÚÁÍÅÎÁ ÐÒÏÉÚ×ÅÄÅÎÁ ÍÎÏÊ (àÓÔÁÓ)[/I]

    Working with ******************
    Organisation ******************
    Responsibilities MS-SQL Server 6.5 DBA, Planning, Designing, Scheduling.
    Contact Person *****************
    Contact Number *****************
    Projects Done
    The below mentioned projects have been successfully carried out as a project leader with a team of 22 people with varying duration of time.
    Sites Handled
    1) www.***********.com
    2) www.***********.com
    3) www.***********.com
    4) www.***********.com

    Software Development

  • 1) Developed a postproduction studio software for M/S. Visual Needs a media division of Info Needs India Ltd. (VB)
  • 2) Developed a students analysis system for a client in UK (VB/MS-SQL 6.5)
  • 3) Developed a society software for a client in UK (VB/Oracle 8)
  • Intranet Projects

    1) Info Needs India Ltd. Intranet design and implementation
    In house development of Intranet of Info Needs India Ltd. The intranet had the following modules
    1. Marketing
    2. Human Resources
    3. Front Office
    4. Library & CD-Rom automation
    5. Purchase
    6. Sales
    7. Accounts
    8. Work Flow

    Worked with ************* from August 1994 to September 1998.
    Organisation *************
    Duration August 1994 to September 1998. ( 4 years )
    Title. Project Leader for 2 years,
    Senior Programmer for 1 Year
    Junior Programmer for 1 Year
    Responsibilities Project Leader: MS-SQL Server DBA, Planning, Designing and Scheduling.
    Sr. Programmer: Designing front ends, Coding & Testing
    Jr. Programmer: Coding, testing and maintenance
    Contact Person *****************
    Contact Number *****************
    Projects Done
    The following projects were done for various clients with Visual Basic as front end, MS-Access, Oracle 7.3 and MS-SQL as backend, Windows NT and Windows 95 clients with varing time duration and a team size ranging from 2 to 10 people.
    The responsibilities included MS-SQL Server DBA, Requirement Analysis, Planning, Interface nd Database Designing, Scheduling.

  • 1. Address Book & Mailing Labels Software.
  • 2. Software for Office Automation.
  • 3. Fee Reconciliation for SNDT Juhu.
  • 4. Software Enhancement of Junior College Results Program (In House Development).
  • 5. Software for College Time Table Generation (In House Development)
  • 6. Invoicing Programs for M/S Saki Auto Products Pvt. Ltd.
  • 7. Sales & After Sales Follow up Package for M/S. Excel Tutor's Bureau.
  • 8. Maintenance & Printing of Students Final Results, Leaving Certificates etc. for M/S SNDT Senior College of Home Science, Juhu.
  • 9. Inventory Maintenance for M/S Enterprise Systems & Services.
  • 10. Payroll Package for M/S. Gajanan Enterprises.
  • 11. Payroll System for M/S. J. S. Multimedia Systems Pvt. Ltd.
  • 12. Program for Maintenance & Printing of Students Final Results, Leaving Certificate etc. for M/S SNDT Junior College of Home Science Juhu.
  • 13. Question/Answer Database for M/S Excel Tutor's Bureau.
  • 14. Student's Performance Reporting for M/S Excel Tutor's Bureau.
  • 15. Customer Database for M/S Excel Tutor's Bureau.
  • 16. Payroll Package for M/S Kalimata Plastic Industries.
  • 17. Inventory Maintenance Package for M/S Kalimata Plastic Industries.
  • Worked with ************* during August 1993 to August 1994.
    Organisation *************
    Duration August 1993 to August 1994. (1 year )
    Title. Programmer for 1 Year
    Responsibilities Programmer: Coding, testing and maintenance
    Contact Person *************
    Contact Number *************
    Projects Done

  • Payroll Package
  • Material handling System
  • Teaching Experience

  • Visiting Faculty for M/S SNDT Junior College of Home Science, Juhu. Conducted Courses in Computer Fundamentals, MS DOS, Windows, MS Office, Page Maker & Crel Draw for a group of 10 students of TYBHSc.
  • Educational.

    1) Passed Secondary School
    Certificate (SSC) with First Class in Year 1985-86.
    From Maharashtra State Board of Secondary Education (Mumbai).
    2) Passed Higher Secondary School
    Certificate (HSC) with First Class in Year
    1987-88. From Maharashtra State Board of Higher Secondary Education (Mumbai).
    3) Passed Bachelor of Engineering (BE - Computers) with Higher Second Class
    in the Year 1993-94 from University of Pune.
    BE SEMINAR TOPIC "Machine Learning".
    BE PROJECT TOPIC "VIRUS VACCINE".
    PROJECT RESULT Developed an Anti-Virus Toolkit
    The Toolkit Scanned for commonly known Boot Sector & File Virus. A module also cleaned Boot Sector Virus. The software was Menu Driven. Also it had the facility to add new signatures. Project done in Turbo C.


    14

    Senior Oracle DBA
    Professional Profile:
    Senior-level Oracle DBA/Information Architect, with exceptional skill in Unix development and administration. Highly motivated results-oriented individual with a positive attitude. A team player with the ability to recognize and utilize all team members' skills. Communicates well with clients, management and team members.

    Objective:

    I am seeking a contract position within an established company to act as Senior Oracle DBA. I am looking for challenging work on a project that requires my unique expertise and extensive Oracle/Unix background. I am willing to lead or work within a group or alone on a smaller highly specialized project.

    Relevant Skills:
    Operating Systems:

    AIX v4.X, Sun Solaris 2.6, Windows 98/95

    Languages:

    SQL, Oracle Procedural Programming Language, Perl, Korn Shell, Bourne Shell, C Shell, Microsoft Development Tools
    Databases: Oracle v7.3, Sybase v10, MS Access

    Relevant Experience:

    Jan 2000 - Feb 2000
    Senior Oracle DBA (Contract) - **********************
    Six-week contract providing Oracle support for 30 production, test, and development Oracle databases running on IBM R6000/S70, Sun Enterprise 450 and 3500.
    Converted an Access Point-Of-Sales database to Oracle. Created the database, all tablespaces, users and import the data. This was accomplished by creating the database, importing the Access database, extracting the table definitions, modifying the table's location and size; then recreating the tables and re-importing the data.
    Provide backup support as System Administrator for both AIX and Sun Solaris.

    1982-1999
    Senior Technical Specialist - **********************
    Positios Held: Oracle DBA, UNIX Administrator, Senior Systems Analyst, Systems Analyst, Senior Programmer Analyst, Programmer
    1998 - 1999
    Senior Oracle DBA
    Responsible for maintaining three production and two test Oracle 7.3 Database server environments. Responsibilities included monitoring, tuning, backup and recovery of each database. These databases are a critical part of Tivoli enterprise monitoring software. Co-designed and developed a Guaranteed Software Distribution sub-system. Performed as Data Architect, creating all Database Schema, Oracle procedures, Korn Shell and Perl scripts. The system was designed to guarantee delivery and successful installation of any software package pushed to a clients desktop, reducing IS labor requirements, and automating a difficult task across the enterprise.

    1993-1998 Oracle DBA
    Maintain two Oracle and one Sybase databases residing on two RS 6000s. Responsibilities include backups, recovery, tunng, maintaining transaction logs and tablespaces. Developed purging programs using SQL and C Shell to meet the needs of this unique production environment. Developed systems to incorporate mainframe data with Oracle tables to produce reports for warehouse operations and their customers (i.e. manifest, operation statistics, packing slips, and storms reports).

    Relevant Education:

  • 1999 - Data Modeling, Southern California Edison
  • 1997 -Certificate, UN IX Systems Administration, California State University at Fullerton
  • 1997 - Oracle Administration, Oracle
  • 1997 - Oracle Performance Tuning, Oracle
  • 1997 - Oracle Backup and Recovery, Oracle

  • 15

    CAREER GOAL:

    To obtain a management position, managing some aspect of IT within a companyAs internal information technology department. Manaing Database Development and/or Administration, for example.

    SYNOPSIS

    ORACLE DBA/DATA MODELER/Technical LEAD/PROJECT MANAGER. Perform Senior/Lead Oracle DBA functions and Project Management on Production and Development Projects. Work as a database architect doing data modeling and DBA functions on project. Integrate third party or custom Oracle applications into SAP, Oracle Financials and Peoplesoft. Work with company management in selecting products implemented under Oracle database. Work closely with Unix/NT administrators, Network administrators and Front End programmers in configuring the environment for Oracle and developing/configuring the application. Work as site technical manager for SAP or specialty Oracle development. Work as companyAs representative to non-technical and third party/vendor staff ensuring that engagement is proceeding smoothly. Also, perform pre-sales and marketing functions for IT sales.

    COMPUTER SKILLS

    DATABASES/LANGUAGES

    ORACLE, SYBASE, SAPDBA, INFORMIX, MS SQL SERVER, PEOPLESOFT, SQR, C , C++, Visual C++, SQL, Visual Basic, Powerbuilder, Erwin, EasyCase, System Architect ORACLE 6.0/7./8: PL/SQL, ProC, SQLForms3/4, SQLPLUS, Reportwriter, Menu, Financials, Manufacturing, Designer 2000, Enterprise Manager SYBASE SQLServer 4.9/10: Transact-SQL, SQR, Embedded SQL/C, APT Workbench, APT Library, DB-Library and Data Workbench PEOPLESOFT: Financials 7/7.5 , HR 7/7.5

    OPERATING SYSTEMS

    UNIX (HP, SUN, DEC, SILICON GRAPHICS, IBM, AT&T), HP-UX, SUN-OS, SUN-SOLARIS, Ultrix, IBM-AIX, UNIXWARE, SCO, DEC VMS, NOVELL, DOS, OS/2, WINDOWS, WINDOWS95, SYSTEM 7, NT (3.5/4.0), VM, MVS

    UTILITIES

    UNIX Utilities, UNIX Shell Programming, vi, Perl, make, MOTIF, OPENLOOK, X, X Toolkits, Brief, EDIT, EDT, XEDIT, CMS, All-in-1, ISPF, TSO

    HARDWARE

    HP-9000, SUN, DEC, SILICON GRAPHICS, IBM-RS/6000, AT&T, DEC-VAX, IBM PC COMPATIBLES, MACINTOSH, IBM Mainframes/Minis

    EDUCATION

    University of Maryland, University College (College Park, MD)
    B.S.: Computer Science 8/81
    B.S.: Accounting 5/80
    University of Maryland, University College Graduate School 9/85 - 5/87
    Computer Systems Management - 18 hours, no degree, 3.5 GPA

    EXPERIENCE

    Development/Production DBA/Analyst and Project Manager 3/90-Present In March of 1990 I left the U.S. Department of Treasury, I formed my own company called ***********************. Leaving government employment allowed me to do much more challenging and rewarding work in the private sector. The company As primary focus was database design, development, tuning, upgrades and monitoring using Oracle, Sybase and Informix. From the start my work tended to be mostly Oracle consulting and today is almost exclusively Oracle database consulting work. The following chronological list highlights the significant projects I have worked on during this time period. 2000 Contracts

    ********************* Firm A DSS Oracle

  • A Worked as a Database Architect
  • A Database was Oracle 8i
  • A Used Erwin for the data modeling
  • A Project consisted of creating a data model for clientAs new web site
  • ********************* Peoplesoft/Oracle

  • A Worked as an Oracle DBA for their Peoplesoft HR and Finance application
  • A Upgraded Peoplesoft from 7.0 to 7.5 and tools from 7.53 to 7.58
  • A Platform was HP-UX 11.0
  • A Upgraded Oracle from Oracle 8.0.5.0.0 to 8.1.6.0.0 (8i release 2)
  • A System was comprised of 19 Oracle Instances on two servers
  • A Supported over 200 developers
  • *********************, Inc. Oracle

  • A Worked with a large systems integrator in setting up an IT practice.
  • A Purpose of assignment was to help educate sales staff about how to market IT software engineering skills to potential clients
  • A Advised several offices and helped write proposals for potential software development and production projects.
  • A Advised nix and NT networking engineers on installing, configuring and tuning Oracle 8 databases.
  • A Worked on Project for client involving Administering and modifying Oracle Financials
  • 1999 Contracts

    ********************* Oracle

  • A Worked with large international bank on several Web based database systems implemented under Oracle 7 and 8.
  • A Primary function was to perform Lead Oracle DBA duties and help to maintain several large Oracle databases.
  • A Worked with business and technical staff in tuning and reconfiguring Oracle Databases to better meet business needs. Major ERP Vendor A Peoplesoft
  • Training

  • A Took several months of training in Peoplesoft Applications at PeoplesoftAs headquarters in Pleasanton, California.
  • A Went to several customerAs sites to help them install/upgrade/tune Peoplesoft Applications implemented under Oracle Databases.
  • A Became very expert at upgrading, configuring and tuning Peoplesoft applications.
  • 1998 Contracts

    ******************** Oracle/SAP

  • A Purpose of assignment was to provide Oracle expertise in configuring environment to evaluate two add-on products to SAP running under Oracle.
  • A Analyzed products and helped write report to management to aid in products acceptance/certification
  • A Did SAPDBA SAP administration
  • A Did Oracle tuning work
  • A Platforms were Unix (IBM AIX 4.2) and NT (4.0)
  • A Used SAP R3 and Oracle 7.3.4/8
  • ******************** Oracle/SAP

  • A Purpose of assignment was to install and configure a sales/marketing application implemented under Oracle that interfaced with the SAP environment
  • A Was DBA and lead for project
  • A Used Oracle 7.3
  • A Platforms were Unix 4.1 on IBM AIX and NT 4.0
  • A At end of assignment, helped to write up management report outlining deficiencies within product
  • 1997 Contracts

    ******************* Oracle

  • A Installed and maintained Oracle databases for various bank applications
  • A Was one of everal production/development DBAs at site
  • A Used Oracle 7.1 - 7.3 with procedural and replication options
  • A Platforms were NT, Unix (on various vendors equipment)
  • ******************** Oracle

  • A Created Test administration and reporting system
  • A Was Development DBA and lead for project
  • A Used Oracle 7.3, Oracle Designer 2000 and ERWIN 2.6
  • A Created PL/SQL 2.3 routines
  • A Platform was NT 3.51
  • 1996 Contracts

    ******************** Oracle/Oracle Financials

  • A Was an Oracle Production/Development DBA for several projects
  • A Monitored several very large databases and corrected problems
  • A Worked on a large full-life cycle application development
  • A Platforms worked on included Sun Solaris and IBM Aix (UNIX)
  • A Wrote/maintained several large C applications and Korn Shell scripts
  • A Did analysis on many issues including: Data modeling tools, Oracle Upgrade issues and Parallel Query Option
  • ******************** - Concert Oracle

  • Helpd create a large data warehouse working with Price Waterhouse
  • Was Oracle DBA for project
  • Platform was HP-UX 10.
  • Used Oracle 7.2.
  • Used Oracle Utilities, UNIX Utilities and Erwin 2.
  • Wrote many PL/SQL routines, stored procedures, triggers, etc.
  • Tuned database and front end applications
  • 1995 Contracts

    ******************** Oracle/SAP

  • Ported Ingres Database running on a VAX under VMS to Oracle running under UNIX on an IBM RS-6000 to integrate with SAP system.
  • Wrote UNIX routines in Korn shell and Perl.
  • Converted embedded SQL/C routines running under Ingres/VAX VMS to ORACLE PRO C running under UNIX.
  • Was production/development DBA for project.
  • Platform was UNIX on an IBM RS-6000 running AIX.
  • Used Oracle 7.2.2, Pro C 2.1 and SQL FORMS 4.0.
  • ******************** Oracle/Oracle Financials

  • One of several production Oracle DBAs.
  • Ugraded Oracle databases and utilities to new releases.
  • Did initial design work for large data warehouse project
  • .
  • Used: Oracle 7.1/7.2, Oracle Manufacturing, Oracle Financials, perl, UNIX shell scripts, C/C++, Powerbuilder.
  • Platform was UNIX on Sun.
  • 1994 Contracts

    ******************** - PRC Oracle/Peoplesoft

  • Created large billing system for use by government contractor to supplement Peoplesoft system.
  • Was a development DBA for project.
  • Used Oracle 7.
  • Oracle tools, Powerbuilder, System Architect, C/C++, SQR, UNIX shell scripts.
  • Platform was UNIX on HP 9000 machine.
  • ******************** Sybase/Oracle

  • Created trouble ticket reporting and tracking system.
  • Was production DBA for all Sybase and Oracle systems.
  • Used Oracle 6/7, Oracle tools, UNIX shell scripts and utilities, Sybase 4.9/10 and Sybase tools/utilities, C++, Visual Basic, Powerbuilder.
  • Used several case tools including IEF and ADW.
  • 1993 Contracts

    ******************** Oracle

  • Made major enhancements and migrated a database used for drug manufacturer licensing.
  • Was development DBA for project.
  • Used Oracle 6, Pro C, C++, UNIX utilities, UNIX shell scripts, Oracle Forms 3.0, Oracle Menu, Oracle Reports.
  • Platform was UNIX on Dec.
  • 1992 Contracts

    ******************** Oracle

  • Made major enhancements/fixes to a database used for telephone billing and verification for all U.S. Government non-defense agencies.
  • Was one of several DBAs on project.
  • Used Oracle 6, Pro C, UNIX utilities, UNIX shell scripts, Oracle Forms 3.0, Oracle Menu, Oracle Reports.
  • Platform was UNIX on DEC, Bull and HP machines.
  • 1990 - 1991 Contracts

    ******************** Oracle/Informix

  • Created large Oracle database for use in billing verification between corporate and departmental billing systems.
  • Was DBA for projects.
  • Project was a full life-cycle development.
  • Used Oacle 5/6, Oracle tools including Oracle Forms 2.3, C, UNIX utilities and UNIX shell scripts.
  • Worked with several UNIX platforms including AT&T and Sun.
  • Created Informix database for use in awarding merit pay, holding employee evaluations and EEO related information.
  • From 1981 through March of 1990 worked for several U.S. Government civilian agencies as a Database engineer.


    16

    I am an Oracle Database Administrator with six years of experience in IT Industry, Extensive experience as a DBA in both Unix (Sun Solaris, HP-UX and NCR) and Windows NT environments.

    SKILLS

    Operating System : HP-UX 10.20,Windows NT 4.0,Novell NetWare 3.1, Sun Solaris 2.51, NCR 4.0,VMS
    Databases : Oracle 6.x/7.x/8.x
    RDBMS/Front ends : FORMS 3.x/4.x,SQL DBA, Utilities (EXP, IMP, SQL LOADER),SERVER MANAGER, ENTERPRISE MANAGER.
    GUI : Visua Basic 5.0,Power Builder 5.0
    Intranet : HTML, Netscape Navigator
    Languages: C, Java, COBOL, Pro C, PL / SQL

    Responsibilities Handled as a DBA

  • Overall database design and development.
  • Complete database planning - include future storage requirement for database, modifying database structure as per the needs of the development team.
  • Implement and maintain database security.
  • Database tuning in levels of memory, application, structure.
  • General technical trouble shooting and give consultation to development teams.
  • Database re-organization to avoid fragmentation of tablespaces.
  • Managing on-line redo log files.
  • Archive log files and Rollback Segments.
  • Creation of database triggers and procedures for data integrity.
  • Planning and implementation for backup and recovery of the Oracle database.
  • Administration of all database objects, including tables, clusters, indexes,views, sequences, packages and procedures.
  • Implemented backup/recovery in a production systems.
  • Implemented, tested re-evaluated backup/recovery scenario.
  • Implemented BCP (Standby database) in a production system.
  • Installed / Upgraded Oracle 7.x/8.x in different platforms.
  • Installed / tuned Sql Net in different platforms.
  • PROJECT HISTORY

    **********************
    Nov 99 - Present
    I am administering production and development instances for Global UAT Division Responsibilities handled as a DBA

  • Administering production/development database instances.
  • Set up replication between different oracle databases.
  • Implemented Backup strategy using Back Exe.
  • Implemented standby database.
  • Done application and database tuning using Quest software.
  • Re-organized databases to eliminate fragmentation.
  • Set up new user accounts at system and dtabase level also done data loading.
  • Trouble shoot database / connectivity problems.
  • Taking care of migration from Oracle 7.3 to 8.1(8i)
  • Manage sizing and creation of all the database tables/indexes.
  • Take care of Windows NT administration for development team.

  • ENVIORNMENT : HP-UX,HP 9000 Series, Windows NT 4.0 Oracle 7.3/8.1,Developer 2000 /Java/JDBC

    **********************
    Nov 98 to Nov 99
    I administered both production and development instances of AT&T's sales telecommunication Web databases, a part of of AT&T's Information Technology Services division (production support).
    Responsibilities handled as a DBA

  • Reconfiguring existing physical database layout to increase performance and better utilize hard disk space.
  • Design, Implement, and Document automated Backup/Restore, database maintenance, and Disaster Recovery Procedures.
  • Duties include monitoring monthly import processing, Oracl installations and upgrades, SQL
  • Net configuration (client and server) server tuning, and capacity planning.
  • Additional responsibilities include customer assistance with query development, and assisting other DBAs

  • ENVIORNMENT : Solaris2.5.1,Sun3000,HP-UX,HP9000Series, Windows NT 4.0, NCR 10.20 Oracle 7.3/8.1

    **********************
    Aug 98 to Nov 98
    ************* is the world's leading provider of speech and language technology products, solutions,and services to businesses and individuals worldwide.L&H wants to the DBMS data to Oracle rdbms 8.0.4 on a Sun Solaris System.
    Responsibilities handled as a DBA

  • Installation of Oracle 8.0.4 binary on Sun Solaris 2.5.,Windows NT 4.0
  • Creation of new database instances for the new data.
  • Creating new schemas, tablespaces and tables for the migration.
  • Migrating DBMS data to Oracle 8.0.4 using Sqlloader.
  • Setting up of Net8 o the server and client sites ( Windows NT & Windows95).
  • Populated Oracle Database among Unix and NT Server using export and import utility.
  • Analyze database performance and tune appropriately.
  • Creating new user accounts, setting up of security.
  • Setting up backup/recovery procedures and setting up daily exports on the system.
  • Setting up of cron jobs.

  • ENVIORNMENT : Solaris 2.5.1,Sun 3000,WindowsNT 4.0 Oracle 8.0.4

    EDUCATION

    Master of science (Math) Post Graduate Diploma in computer Applications

    CAREER

    Organization Duration Title
    1. ****************** Feb 1995 to June 1998 DBA (Oracle)
    2. ****************** Solutions July 1994 to Feb. 1995 Analyst Programmer STP, Govt: of India


    17

  • Over seven years of exerience in Information Systems and Database Administration.
  • Experience in supporting VLDBs.
  • Oracle Certified 7.3/8i
  • Experience in Parallel and Replication servers and performance tuning.
  • Good communication skills and business interaction skills.
  • Availability: August 14th.

  • Hardware
    HP-9000/Netserver IBM RS/6000 Sun SPARC/Ultra Dell PowerEdge
    Operating Systems
  • HP-UX 10.20 IBM AIX 4.x
  • Sun Solaris 2.x/7 SCO UNIX 4.0
  • Windows NT /98 Red hat Linux

  • Databases
    Oracle 8.0.5/8i Oracle 7.x
    Languages
  • C Pro C 2.0 PL/SQL

  • Tools
  • Developer/2000 Designer/2000

  • Forms 4.5 SQL
  • Forms 3.0 SQL
  • Plus 3.3 SQL
  • Loader SQL
  • Net Import/Export SQL
  • Trace Explain Plan
  • Tkprof Enterprise Manager
  • Transparent Gateway APPC Gateway PVCS, RCS, SCCS, Visual Source Safe
  • Oracle Web/Application Server (OAS) Oracle Failsafe
  • Oracle Developer Server Internet Information Server (IIS)
  • Oracle Applications 11, 10.7C
  • Manufacturing & Financials PROFESSIONAL EXPERIENCE

    ******************** Consultant (08/2000 A 01/2001).

  • On-Publishing Company with Oracle 8/NT. Involved in Database Modeling (Logical and Physical), Database and objects creation.
  • ******************** Consultant (04/2000 A 08/2000).

  • Online health care system is designed using the three-tier architecture with the thin client concept, the apache server with perl, which are the middle layer and the database as the third layer.
  • As a the Oracle DBA, responsible for configuring development and test databases with multi-master replication for high-availability and scalability, also automated the replication set up to the maximum extent, designed the back up and recovery strategy
  • Responsible for database and application performace tuning as well as backup and recovery of database.
  • Dell PowerEdge, Redhat Linux 6.1, Oracle 8.0.5 with Multi-Master replication.
  • ******************** Consultant. (06/2000 A 07/2000).

  • Installation and configuration process of Oracle applications (financials) and also web enabling the application for Cybersoft an Application Service Provider.
  • Dell PowerEdge, Windows NT 4.0 Service Pack 4, Oracle 8.1.6, Oracle Financials 11.0.3, Oracle Application Server 3.0.1, Oracle Forms Server, Oracle Jinitiator 18
  • ******************** Consultant (12/1999 A 04/2000).

  • Online bond trading system is designed using the three-tier architecture with the thin client concept, the Oracle Developer server with Oracle Web application server, which are the middle layer and the database as the third layer.
  • As a Senior DBA, responsible for administering production, test and development databases, configuring Oracle Application Server (OAS), Internet Information Srver (IIS)
  • Responsible for database and application performance tuning as well as backup and recovery of database.
  • Sun Ultra 250, HP LXr/LP, Solaris 7, Windows NT 4.0, Oracle 8.0.5, Oracle Application Server 2.1, 4.0.7, Internet Information Server (IIS) 2.0, Oracle Failsafe, MSCS Cluster, Oracle Developer Server and Oracle Jinitiator 27
  • ******************** IN n Consultant (03/1999 A 11/1999).

  • As Senior DBA, Oracle Applications, responsible for administering production, test and development databases for Oracle Applications Financials and Manufacturing 10.7C.
  • Managed Oracle Applications and database for various plants located in the US and Canada. Migrated database and applications to new RS/6000 S7A. Managed RAID 5 configuration.
  • Responsible for database and application performance tuning as well as backup and recovery of Oracle.
  • IBM RS/6000 S7A, H50 & J50; AIX 4.x, Oracle 7.3.4, Oracle Applications Financials and Manufacturing 10.7C and Oracle Enterprise Manager.
  • ******************** Consultant (06/1998 A 03/1999)

  • Senior DBA responsible for the Enterprise Services Management System, which handles networking information pertinent to various enterprise services, including a T1 connection.
  • Administered Oracle Parallel Server, production, test, development and standby databases. Performed data conversion from Unify to Oracle.
  • Redesigned logical and physical data model for new release. Responsible for backup and recovery, and performance tuning.
  • Managed RAID 0+1 configuration.
  • Sun SPARC 1000, Sun OS 2.x, Oracle 7.x and Oracle Enterprise Manager.
  • ******************** Consultant (10/1997 A 05/1998)

  • Involved in development and maintenance of the CMSS product, which supports lifecycle of SIM cards from procuring white/SIM cards, personalizing white cards, issuing SIM cards to dealers and performing support inventory functions like transfers, write-offs, etc.
  • Responsible for database creation, maitenance, backup and recovery (hot, cold, export); created Unix cron jobs.
  • Involved in data migration.
  • Took part in unit, integration and user acceptance testing; fixed bugs.
  • Created different environments for development and testing using Import/Export.
  • Tuned application and server.
  • Implemented the system.
  • Worked with users during requirements analysis and for acceptance testing.
  • Consulted with Oracle Corp. support during bug fixing.
  • HP-9000, HP-UX 10.2, Oracle 7.3, Developer/2000, X-Windows.
  • ******************** Consultant (06/1996 A 09/1997).

  • DBA for the Cabs Automated Front End System (CAFE).
  • client-server order entry system, CAFE processes requests from access carriers for access providers to get access services (telecommunications).
  • Responsible for database creation and maintenance.
  • Created various testing and development environments.
  • Designed logical and physical structure of Oracle database.
  • Setup three-tier architecture. Responsible for replication, hot/cold backup ad recovery.
  • Tuned application and server. Coded an interface between Oracle/IBM DB2 and Oracle/IBM IMS.
  • RS/6000, AIX 4.1, Oracle 7.2, Developer/2000, IBM DB2 & IMS, Oracle Transparent Gateway for IBM DB2, Oracle APPC Gateway for LU6.2.
  • ******************** Consultant (09/1995 A 05/1996).

  • HuRIS, Human Resource Information System, a HR, payroll, benefits and training system consisting of many screens with complex validations, and functional/data security enforced at every level.
  • As a DBA, responsible for the day-to-day maintenance activities including backup and recovery of the database.
  • Wrote program specifications for Forms 4.5 development and developed screens. Involved in unit testing.
  • SCO UNIX 4.0, Oracle 7.1, CDE Tools 2 (Forms 4.5).
  • EDUCATION/TRAINING

  • Master of Science in Computer Science (1st Class with Distinction).
  • Bachelor of Science in Computer Science (1st Class).
  • Courses: Lotus Notes Domino Server Admin.
  • CERTIFICATION

    OCP, Oracle DBA Oracle 7.3/8 A Oracle Corporation (All 5 Exams, required by ORACLE)




    Main page


    1