Resume: Sanjay Tikku

Follow-Me-Service: 978-720-0994
E-Mail: sanjay.tikku@dtainc.us
Company Website: www.dtainc.us

Experience Summary

Oracle

Oracle DBA with experience in managing 24x7x365 version Oracle 10g / 9i / 8i / 7.x
Oracle DBA with experience on Solaris, Linux, HP-UX, AIX, Windows NT/2000/2003
Expert in Oracle RAC, Standby Database / Data Guard, Advanced Replication
Expert in Oracle Performance Tuning, Trending Using Statspack/AWR and using OEM
Experience With High Volume Websites Hosted On Oracle Databases
Experience With Oracle Application Tuning Including SQL Queries and DMLs

SQL Server

SQL Server DBA with experience in managing 24 x 7 x 365 databases version 2005/2006
SQL Server DBA experience on all current Windows platforms
Expert in SQL Server Standby Database using Mirroring/Log Shipping

Misc

Significant experience in managing a DBA business
Programming Experience Using C, Pro*C, PL/SQL, Unix Shell Scripts, CYGWIN
Experience with Postgres, MySQL, MS-ACCESS databases
UNIX and C Programming Teaching Experience
Experience In Project Management

Employment

Oracle and SQL Server Database Consultant

(02/97 - Present)

Founder - Distributed Technology Associates, Inc.

Client: State Street Bank & Trust (12/07 - Present) http://www.statestreet.com

We have been hired by multiple groups within State Street to assess business critical Oracle databases and performance improvements. The database assessment projects are currently ongoing.

Client: Ellacoya Networks, Inc. (04/04 - Present) http://www.ellacoya.com

Now Arbor Networks (as of Feb 2008) http://www.arbor.net

We have designed their data warehouse to run on Oracle 10gR2 platform. The data warehouse is designed to load data at rates greater than 1 million rows / minute and this data warehouse has been designed to scale to greater than 10TB in size. This data warehouse has been successfully implemented at multiple clients of Ellacoya and is actively being rolled out at the remaining clients. These clients are Tier-1 telecommunications companies worldwide, that generate 10s of millions of rows of network usage daily and sift through that data (in our warehouse) to manage their networks.
Implemented 4 RAC cluster environments (2 nodes in each cluster) with a capacity of 2.2 Terabytes in each cluster, at one of the clients of Ellacoya. This client is one of the largest telecommunication companies in the world. The RAC environment was implemented on Solaris 10 on x86-64 platform using global containers and Oracle version was 10.2.0.3.0. In addition to the RAC systems, we implemented Oracle OEM Grid Control to manage all the database environments we setup. After the initial setup and testing these RAC systems have enabled 100% availability for the application.
We provide total Oracle expertise, on-demand, to Ellacoya and to their clients on 24x7x365 basis. This includes advice on Oracle architecture issues; Operations issues; Performance and Stability issues and High Availability issues.

Client: Computer Asssociates (02/06 - Present)

http://www.ca.com

Currently provide on-going consulting services to Computer Associates on wide ranging matters pertaining to Oracle database for their E-Health application. This application currently runs on Solaris, Red Hat Linux and Windows/2003. My role is to provide guidance on Oracle 10g related performance issues; stability, recoverability and availability issues for the application. We are also recruited on as needed basis to resolve Oracle related issues at CA clients that are using the E-Health application.

Client: LincolnPeak Partners Inc. (07/07 - Present) http://www.lincolnpeak.com

Provide on-going consulting services to LincolnPeak Partners on wide ranging matters pertaining to Oracle and SQL Server databases for their database hosting operations and for their clients. These consulting services are provided on-demand.
Currently optimizing the performance of batch processing at one of LincolnPeak clients. The original elapsed time for processing the batch operations of transactions was 80 minutes which we have now reduced to less than 10 minutes by utilizing various advanced features of Oracle and processing the batch in bulk as opposed to the original implementation of processing the batch row by row.

Client: Investors Bank & Trust (08/04 - 06/07) http://www.ibtco.com

We were hired by the CTO and assessed all the business critical databases of IBT and helped them tune their mission critical databases and applications. Under my guidance the company was able to increase their database activity multi-fold, on the same hardware, as their business grew and IBT was able to meet all of their SLAs to their clients. This being a Financial Services company, the performance of their databases is critical for revenue generation. We continued to advise them on an on-going basis regards their Oracle needs on 8i, 9i and 10g databases across the board.
We created an architecture template for all of their database configurations and standardized all of their database instances to follow best practices for large OLTP and Warehouse databases. This included standardizing the process for installing Oracle; creating databases and configuring them for maximum performance. Currently standardizing their Standby configurations using DataGuard to be followed with standardizing RAC installations.
I have shepherded the company through the successful upgrade of their (25 - 30) mission critical databases from Oracle version 8i / 9i to version 10g. The upgrade process has been on-going for the past year. We continue to provide on-going consulting to the company on all matters related to Oracle Architecture, Tuning, Recoverability and Availability.

Currently provide TOTAL database support to these companies under a Remote DBA agreement with an SLA. The work includes sizing / installing / upgrading Oracle databases for every new install at their clients. Also work with their Tech Support teams to provide total post-install Database Support on a 24X7X365 (or Business Hours) basis, depending on the support agreement their client has signed. We also help with any development effort.
We are the one and only Oracle resource for these companies.

Client: Conservation Services Group Inc. (01/04 - Present)

http://www.csgrp.com

Currently manage (24 x 7 x 365) enterprise databases for Conservation Services Group. All the applications are web based and are running on Oracle database version 9.2.0.4 on Windows 2000 platform. These applications are used worldwide. I assessed their application environment; upgraded all of their databases from Oracle version 8.1.5 to version 9.2.0.4; tuned the database environment and the database configuration. Now our company manages all of their databases being used in this environment around the clock, under an SLA.

Client: Starwood Hotels Inc. (12/00 - Present)

http://www.starwoodhotels.com

Currently manage (24 x 7 x 365) databases for Starwood Hotels Worldwide Intranet. The intranet runs on Oracle Portal and is based on Oracle 9iAS, running on a version 10.1.x of the Oracle databases on Solaris 2.8 platform. I assessed this implementation of Oracle Portal application environment, tuned their database environment, database configuration and schema implementation. I also analyzed their SQL for tuning and those were sent back to Oracle with recommendations for changes in their Portal application.
Now we manage databases in this worldwide intranet around-the-clock, under an SLA.
Currently manage (24x7x365) SQL Server databases for critical enterprise applications at Starwood.
Also provide Backup DBA support to databases within Starwood that are managed by in-house DBA team
Helped Starwood Hotels build a Data Warehouse for data collected on the visits to their reservations website. We used Web Trends application and Oracle database to mine web visit profiles. I led the database effort which included designing and configuring the system, laying out the database and tuning it for loading the web site logs and for data mining queries. It is 100GB+ database growing at the rate of 1-2 GBs per day.
Helped Starwood Hotels with transitioning their stand-alone production databases to a highly available setup (99.999% availability) using Oracle Parallel Server (OPS). Their previous website used a back-end Oracle database which was upgraded to an OPS setup. I architected the entire OPS setup that included application partitioning, physical layout of the database, database configuration, fail over configuration and on-going monitoring of the Oracle databases on as needed basis.

Client: WinterCorp (06/04 - 05/06)

http://www.wintercorp.com

I helped them build a database Benchmark Kit and wrote for them the database API. The benchmark kit is used to test out the scalability of an application against an Oracle database. We recently used the benchmark kit to test scalability of an application wanting to run 150,000 queries per hour against a multi-terabyte database on an IBM 32 CPU (P390), 128GB Memory running AIX 5L on the machine. We plan to do more benchmarks like these for other clients.
I provided ALL Oracle related support to WinterCorp and their clients on as needed basis.

Client: Concord Communications Inc. (Now Computer Associates) (10/01 - 01/06)

http://www.ca.com

Helped Concord Communications migrate their EHealth product to Oracle version 9i (9.2.0.1). EHealth product currently runs on Solaris, Red Hat Linux and Windows/2000. The work involved redesigning their product code and methodology to improve database performance and usability using new features of Oracle 9i. I continue to provide consulting services on as needed basis.
Helped Concord Communications port their EHealth product to Oracle database version 8.1.7 from Ingres. This involved reviewing their entire product code and methodology for database performance and usability with Oracle. I tuned their product SQL, the access to the database and the layout of the database. In addition to tuning for performance I helped with database sizing for disks and memory for all the platforms their product runs on. I also provided consulting with other aspects of the product like backups using RMAN, performance trending using Statspack etc.
Helped Computer Associates with tuning of next generation E-Health Application release. The tuning effort involved query tuning in context of Cognos Reports; database DML tuning for their process of gathering the monitoring data; tuning of the IO sub-system of Solaris platforms to increase the database transaction rate. All of this work was done on Oracle 9.2.0.7.0 platform.

Client: Brooks Automation Inc. (12/00 - 12/04)

http://www.brooks.com

I provided Database Assessment Service to Brooks's clients on as needed basis. Our company's database assessment service is a packaged application to provide a comprehensive evaluation of the Oracle database and the environment. The assessment of the Oracle database environment is performed for stability, performance, recoverability and availability. I designed and built this comprehensive assessment service for Oracle databases, and it is now marketed others to their clients.
Helped define and implement a strategy for offloading the production database for reporting purposes. This involved designing the process of extracting the appropriate data from the production database with the least amount of overhead to the business transaction, transforming and transporting it for reporting purposes to the reporting database. All databases involved are Oracle. This ETL solution is based on PL/SQL and Unix scripts.

Client: Syratech Inc. (10/00 - 12/01)

http://www.syratech.com

Provided complete database support for all Oracle databases (development, test and production environment). The company is running Oracle on Windows/NT platform. We upgraded all the database servers to the latest Oracle 8i version and implemented a standby server in managed recovery mode. All database administration tasks are done through the Enterprise Manager console including automated DBA jobs and management of unsolicited events.

Client: NEBS Inc. (10/98 - 02/99, 03/00 - 08/01)

http://www.nebs.com

Helped NEBS with a Marketing Data Warehouse. I designed all the utilities that load the customer data into the warehouse from the mainframe (transaction system). By using the SQL*Loader, we are able to load into Oracle database tables at the rate of roughly 150 million rows of data per hour. I was the Oracle architect for ALL aspects of the marketing warehouse.
Worked in the central database group to provide DBA support for NEBS Peoplesoft applications running on Oracle databases. In addition to my routine DBA support, my assignments included providing automated high-speed copying of application databases to facilitate the cycle of development through production.

Client: Informio Inc. (08/00 - 02/01)

I helped build from scratch a usage-tracking database for Informio, which has a web site that enables users to sign on and get access to Internet through their phones. I architected and setup this database in which the user access patterns can be analyzed for marketing purposes. This was implemented using Oracle, PL/SQL and CrystalReports, all on Red Hat and Caldera Linux platforms.

Client: SilverBack Technologies (03/00 - 08/00)

I built the data center for the company that is running Oracle on Linux machines. I wrote all utilities that collected data in flat files, on a daily basis, from all the SilverBack clients, loaded them in the data center (using SQL Loader), and then aggregated the raw data based on the reporting requirements of the company. The entire process, end to end, is automated!

Client: Cozone.com (08/99 - 03/00)

Provided Oracle expertise to build and host a new web site using Broadvision and Oracle. This involved sizing the database, creating it, and tuning it for the web site of a retailer. In addition, I designed and wrote all the PL/SQL procedures for Broadvision extensions that were need to support the web site. I was THE Oracle person for building the web site.

Client: CMGI / Myway.com (03/99 - 08/99)

Helped the database team move the hosting of Myway.com's web site from SQL Server database to Oracle database. Responsible for conversion of Transact-SQL to PL/SQL stored procedures and packages. Myway.com uses the IIS web server and needs to move to a more scalable database to handle growth in web site traffic. I also helped translate the SQL Server schema into Oracle schema and used Designer/2000 for all design related purposes.

Client: Fidelity Investments (FESCo) (10/97 - 01/98)

Worked on the Oracle Advanced Benefits application in the Health and Welfare project. We used the Oracle Applications suite consisting of the HR, Payroll and Advanced Benefits applications to build the Benefit Administration business. Also built extensions to the Oracle applications using Oracle Web Forms, Oracle Designer/2000 and Oracle Developer/2000.

Client: InUnity Corp (06/98 - 01/99)

Helped to architect and implement the back-end Oracle database strategy for the company. The Oracle database was to be located on Windows/NT servers and form the back-end for the company's web site. The database was to be replicated to multiple ISP sites to provide continuous availability of data.

Client: Praxis International (02/97 - 12/98)

Analyzed replication and data sharing needs of Praxis International's clients. Praxis sells replication products and I provided technical consulting to help their clients assess their computing environments and choose the appropriate data sharing strategy. I then worked with them to implement replication and other data movement products in their computing environments.

Client: FASTech Integration (02/97 - 12/98)

Helped define and implement a strategy for off-loading the production database for reporting purposes. This involved designing the process of extracting the appropriate data from the production database with the least amount of overhead to the business transaction, transforming and transporting it for reporting purposes to the reporting database. All databases involved are Oracle.
Analyzed the access of the Oracle database by the FACTORYWorks application. This involved SQL query analysis (using RULE based optimizer), index analysis and table analysis. The goal was to analyze all aspects of application's access to the database and provide recommendations to improve the performance by two orders of magnitude. My recommendations were implemented in the subsequent release of FACTORYWorks.

Client: Strategic Interactive Group (10/97 - 04/98)

Provided Oracle DBA services on as needed basis, which included setting-up and maintaining multi-language (English and French) databases. I also analyzed and tuned the web application queries for optimum performance.

Client: Monster Board (02/97 - 12/97)

Designed, setup and tuned Monster Board Oracle database on two DEC Alpha 8400 machines in Tru-Cluster configuration using Oracle Parallel Server. This OLTP database backing the Monster Board web site was taking 1 million hits a day, and was projected to increase to 10 million hits a day. I also provided technical consulting for all aspects of Oracle database/instance/query performance.

Client: Fidelity Investments (Systems) (08/97 - 12/97)

Ran the TPC-C benchmark tests to qualify the SUN PDB 4000 Server for the XTRAC application (high volume workflow application). I also ran the application failover tests to ensure that the application fails over to the surviving node in the cluster when Tuxedo, Oracle, or the machines die.

Client: Fidelity Investments (FIIS) (02/97 - 07/97)

Designed and developed parallel tools (unload, reload, checksum) for very large Oracle database tables. These tools are about two orders of magnitude faster than anything else is in the market. These programs scale extremely well on SMP hardware, especially in Oracle Parallel Server environment. At the time, there were no competing vendor products that provided comparable functionality and the desired performance for large tables in the OLTP environment.

Full-Time Employment

Fidelity Investments, Boston, MA
Project Leader/Manager: Distributed Transaction Architecture Group (Systems Company) (08/94 - 02/97)

Extended Fidelity's client-server architecture to make it distributed over WAN. In the distributed architecture, read-only copies of the corporate database (Oracle) are on the application LANs, master updateable database is at the Data Center, and all sites are synchronized by data replication over WAN in near real-time. Intelligent Transaction Routing, using TUXEDO as the TP monitor, then enables location transparent access to data at any location. The first implementation of this distributed architecture is currently underway at FIIS where a DR site has been created for their customer database.
Architected, designed and led the development of the Oracle based OLTP Replicator for the distributed architecture. The OLTP Replicator additionally includes the capability to resynchronize (and checksum) destination database tables from a LIVE master database. The OLTP Replicator is being put into production for maintaining a hot backup of the FIIS customer database at their DR site. Compared to existing vendor products, this is the fastest Oracle-Oracle Replicator anywhere by at least two orders of magnitude.
Participated in the tuning of the 20GB+ Oracle database on Sun Sparc PDB cluster hardware. This involved optimizing the layout of the database tables, their indexes, application queries, DB configuration etc., in the Oracle Parallel Server environment.

Siemens-Nixdorf, Burlington, MA
Senior Software Engineer/Project Leader: Distributed Computing Group (09/91 - 08/94)

Led the effort to convert all DCE components to comply with POSIX 1003.1 standard. My POSIX conversion guide has now been incorporated into the coding guidelines for all companies providing the DCE technology to OSF.
Implemented and was responsible for all kernel related work in DCE for the SVR4 port on SNI machines.

Samsung Software America, Andover, MA
Senior Software Engineer/Project Leader: UNIX Systems Group (04/89 - 09/91)

Led a team in implementing multiprocessor UNIX, based on SVR4, on the 88K-based Samsung platform.
Worked on the project to implement SVR4 server with Mach 3.0 micro-kernel on the 80x86 based platform. I implemented threads in SVR4 and set it up as a server of the micro-kernel. The project was shelved due to the company's strategic shift to the 88K-based platform.

Wang Labs, Lowell, MA
Senior Software Engineer: VS OS Cluster Group (03/88 - 04/89

Designed and implemented the capability of remote program execution in VS systems' cluster. It was implemented using paging across the network. It was transparent to the user and thereby made the VS cluster look like a single machine.

Concurrent Computer Corp., Orlando, FL
Member Technical Staff: Operating System Group (01/85 - 02/88)

Worked on a team project to develop a layered, architecture-based, multiprocessor operating system for Concurrent's 3280 series computer. Participated in designing the functionality of all sub-systems of the operating system: process management, memory management, and event handling among others.

Teaching Experience

Technology Exchange Company, Reading, MA
Instructor (09/90 - 06/98)

Taught UNIX and C Programming (introduction and advanced level) courses as a contract instructor for TEC's public and on-site courses.

Northeastern University, Boston, MA
Instructor, State-Of-The-Art Program (04/93 - 12/98)

Taught C Programming (introduction and advanced level) courses.

Education

Vanderbilt University, Nashville, TN
MS CS 1984

Indian Institute of Technology, Kanpur, India
B. Tech EE 1982

Publications

Managing the Transition to OSF-DCE Security (Tikku et. al., published in Lecture Notes in Computer Science No. 731, Springer-Verlag, 1993)

Miscellaneous

US Citizen

References

Available on request