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:
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
Bachelors of Engineering in Electronics & Telecommunications From Govt. College of Engineering, Pune, India. Post Graduate Diploma in Computer Studies ( BITS, Bombay, India ).
TRAINING:
SENIOR DATA BASE CONSULTANT WITH OVER 32 YEARS EXPERIENCE
JULY 2000 TO NOVEMBER 2000 - ***************
DB2 DBA
APRIL 2000 TO July 2000 - ***************
Senior DATABASE Consultant
NOVEMBER 1999 TO APRIL 2000 - ***************
Senior IMS/DB2 DBA
AUGUST 2, 1999 TO NOVEMBER - ***************
Lead IMS/DB2 DBA
Februar 1999, to July 1999 - ***************
Senior IMS/DB2 DBA
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:
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
Seeking a challenging position in the area of Database Design / Administration,Data Warehousing or WebDevelopment Environment.
CURRENT EXPERIENCE SUMMARYDB2 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 ANDSKILLSMore 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. |
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:
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. |
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.
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:
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:
Title/Position : Project Leader Cum Analyst
Client : ******************
Aug,92 o Mar,95
Hardware : 486 Server
Software : Foxpro 2.5,LAN
Responsibilities Included.
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:
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:
Presentation of Software for new clients.
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.
Experiencein 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
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
Korn/Bourne Shells, SQL, PL/SQL, ABAP/4, C, Access Basic, Visual Basic.
Skills:
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.
***************** Lead Oracle DBA May 2000 to Sep 2000
Synopsis: Worked as LeadOracle DBA *****************
***************** Lead Oracle DBA / Architect Nov 99 to May 2000
Synopsis: Worked as Lead Oracle DBA Consultant for *****************
***************** Senior Oracle DBA / Architect Oct 98 to Oct 99
Synopsis: Worked as Senior Oracle DBA on Sun Solaris systems for *****************
***************** , Atlanta, GA. Oracle DBA
Jul 98 to Oct 98
Synopsis: Worked as Senior Oracle DBA on Sun Solaris system for *****************
***************** , Atlanta, GA. Oracle DBA
Mar 98 to Jul 98
Synopsis: Worked as Senior Oracle DBA on Sun Solaris system for *****************
***************** , 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.
***************** 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.
***************** , 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.
***************** , Oracle DBA May 91 to Dec 94
***************** . Graduate Research Assistant
Aug 89 to May 1991
***************** , 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.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:
*********** 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:
*********** 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.
Bachelor of Science
Certificate courses in Sybase
Attended many in-house training classes on MS SQL Server, Oracle and Patrol
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 ********************
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.
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.
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.
Computer System
Software
"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.
Obtain part-time, telecommuting, Informix DBA contract work.
Positions Held
***********************
***********************
DBA/ application developer
***********************
July 1995 -Sept 1995
***********************
Aug 1994 - May 1995
- C, Visual Basic 5.0, Java 1.1
Scripting Languages- VB Script, Java Script, Korn shell script, HTML
Operating SystemsDigital Unix 4.0, AIX 4.3, Windows NT 4
DatabaseDBA 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
6/1999 - present *********************
Sr. Oracle DBA/DB+JAVA Architect/DBA Manager
8/1998 - 6/1999 *********************
Sr. Databast Analyst
7/1996 - 8/1998 *********************
Sr. Consultant
responsible of:
6/1993 - 5/1994 *********************
Software Engineer
12/1992 University of Oklahoma Norman/OK Masters Degree in CS GPA 3.8
ADDITIONAL INFORMATIONOver 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
****************
October 99-- Present
Project : Mortel
Role : Database Administrator
Hardware: Sunsparc Server 1000E, Operating System : Solaris 2.5
Software Used : Sybase 11.5
****************
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:
****************
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:
****************
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:
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
*****************
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
*****************
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:
*****************
1/99-4/99
Oracle DBA, MS SQL Server DBA
Consultant (Consulting Firm W2 Contract)
*****************
11/98-12/98
Technical Assessment Expert in Oracle and MS SQL Server
Consultant (Consulting Firm W2 Contract)
*****************
5/98-10/98
Oracle DBA, MS SQL Server DBA
Consultnt (Consulting Firm W2 Contract)
*****************
9/97-4/98
MS SQL Server DBA
Consultant (Consulting Firm W2 Contract)
*****************
1/97-8/97
MS SQL Server DBA, Oracle DBA
Consultant (W2 Contract)
Developed systems for clients of a *************, computer-hardware, electronics company:
*****************
10/95-1/97
Senior Systems Analyst
*****************
8/87-10/95
Systems Development Consultant
***************** Inc. in 1996
which in turn sold its resources in 1997 to ****************
*****************
1/72-8/87
Systems Development Manager
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.
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.
Database Administration 7.X
Oracle Peformance Tuning 7.X
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.
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.
*************
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.
*************
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
*************
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.
*************
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:
*************
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.
*************
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.
LANGUAGES
English - Fluently spoken, read and written.
Spanish - Fluently spoken, read and written.
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 Experience7 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
Name **** ************* *************
Present Address *********************
Permanent Address *******************
Phone Number: ***********************
E-Mail Address **********************
Date of Birth **********************
Passport Number *********, Expires on **** ***** ******.
Known English, Hindi, Marathi.
Marital Status
Married
MS-Project 2000, MS-Team Manager 97
Computer Languages
MS-Office 2000, MS-FoxPro 2.6,DbaseIV, CorelDraw, PageMaker and other utilities.
Internet & Intranet Related Internet Technologies E-commerce, ASP, HTML
Overseas Assignment (2 months)
Organisation ******************
Duration 2 Months (12th Oct. 1998 to 12th Dec. 1998).
Title Web Specialist.
Responsibilities.
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
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
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.
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
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.
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: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
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).
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.
SYNOPSISORACLE 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 SKILLSORACLE, 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 SYSTEMSUNIX (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
UTILITIESUNIX Utilities, UNIX Shell Programming, vi, Perl, make, MOTIF, OPENLOOK, X, X Toolkits, Brief, EDIT, EDT, XEDIT, CMS, All-in-1, ISPF, TSO
HARDWAREHP-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
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
********************* Peoplesoft/Oracle
*********************, Inc. Oracle
********************* Oracle
******************** Oracle/SAP
******************** Oracle/SAP
******************* Oracle
******************** Oracle
******************** Oracle/Oracle Financials
******************** - Concert Oracle
******************** Oracle/SAP
******************** Oracle/Oracle Financials
******************** - PRC Oracle/Peoplesoft
******************** Sybase/Oracle
******************** Oracle
******************** Oracle
******************** Oracle/Informix
From 1981 through March of 1990 worked for several U.S. Government civilian agencies as a Database engineer.
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
**********************
Nov 99 - Present
I am administering production and development instances for Global UAT Division Responsibilities handled as a DBA
**********************
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
**********************
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
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
******************** Consultant (08/2000 A 01/2001).
******************** Consultant (04/2000 A 08/2000).
******************** Consultant. (06/2000 A 07/2000).
******************** Consultant (12/1999 A 04/2000).
******************** IN n Consultant (03/1999 A 11/1999).
******************** Consultant (06/1998 A 03/1999)
******************** Consultant (10/1997 A 05/1998)
******************** Consultant (06/1996 A 09/1997).
******************** Consultant (09/1995 A 05/1996).
OCP, Oracle DBA Oracle 7.3/8 A Oracle Corporation (All 5 Exams, required by ORACLE)