Commtouch Software - Creation and Administration of Sales Management tool at Commtouch Software. A web-based tool designed to help the sales managers to target potential customers and start sales campaigns. We were responsible for installing the databases, configuring them and making distributed connections to multiple databases. I was also responsible for the database administration tasks like security, tuning and other exercises. A web interface was built using ASP, Visual Basic components and Crystal Reports.

Tasks: Design and Development of all Database Related Objects like tables, view, db links, Procedures Database Administration Tasks- Security, Space, Tuning, Access Issues, etc. Design of Advance Solutions like Distributed Database Systems.

Software Oracle 8.0, Net8, Oracle Enterprise Manager, Windows NT, Oracle Call Interface, OEM Performance Pak, PL/SQL, SQL*Plus

Providian Financial Corporation - A database intensive application based on Oracle 8 and Oracle 8i. We were responsible for designing the database from the user interactions, creating and administering the database pertaining to the company's product, providing support to the developers on database access, troubleshooting oracle related problems, enhancing applications by tuning database access and designing alternative solutions. We were also responsible for the creation and maintenance of the XML DTD and the XML documents used to communicate with the partner companies. The special aspect of this project was the direct impact of the tuning on the bottom line of the company.

Tasks Design, Development And Maintenance Of All Database Related Objects Like Tables, Views, DB Links, Procedures and Packages in Development, Test and Production Databases. DBA Tasks - Access Issues, Security, Space, Tuning, Alternative Solutions Like Distributed Databases, Database Objects, Etc. Creation of XML Docs and DTD.

Software Oracle 8 and 8i, Net8, Enterprise Manager and DBA Studio, PL/SQL, XML, SQL*Plus, Solaris 2.6, Windows NT 4.0 Server and Workstation.

Aureal Semiconductor - Design, Development and Administration of Customer and Inventory Data Warehouse At Aureal Semiconductor. The project involved construction and maintenance of several large databases for storing data related to the inventory sold to the vendors. The system handles online as well as summarized and intensive search oriented for many users and size hovering around 80 Gigabytes. The special tasks noteworthy in this project were the tuning based on the heavy online and batch access, the coexistence of several types of front end tools like Unix, X-windows, PowerBuilder, Visual Basic, Developer/2000 and Web. The high point in this project was the introduction of an online client server design to make a distributed database system out of several heterogeneous systems.

Tasks: Design and Development of all Database related objects like tables, views, db links, procedures, etc. in Development, Test and Production Databases. Production Database Administration Tasks - Security, Space, Tuning, Access Issues, etc. Design of Advance Solutions like Distributed Database Systems

Software Oracle 7.1, 7.2, 7.3, 8.0, 8.1, Developer 2000, SQL*Net, Net8, Oracle Enterprise Manager, OEM Performance Pak, PL/SQL, Pro*C, SQL*Plus, Solaris 2.5, Windows NT, BMC Patrol, Platinum Server Manager, Sablime.

Golden Gate University - Design, Development and Administration of a Data Warehouse for Financial Data at Golden Gate University. The project involved the design and development of a Database of size around 100GB of financial related data.We were involved in the design of tables, view, and optimized queries; development of the database related procedures, objects and methodologies. As DBA we were responsible for performance tuning, space management and security administration. The advanced tuning methodologies utilized are Parallel Query Servers, Disk Striping, etc.

Tasks: Design and Development of all Oracle related programs like Forms, PL/SQL, etc. Database Administration Tasks - tuning, space, security management, etc.

Software Oracle7.3, Developer/2000 suite: Oracle*Forms 4.5, Oracle*Reports 2.5, PL/SQL 2, Pro*C 2, SQL*Net2, SQL*Plus, AIX on IBM RS/6000