Enterprise Architect

JIGAR PATEL

****, ********* **, ******* *******, IL - 60192.

PHONE. DAY: 630-***-**** EVENING: 312-***-****.

• E-MAIL: *********@*******.***

VISION

To obtain a challenging position in the field of database systems as a SQL server database Architect/DBA Lead in a professional environment in preferably Finance, Insurance, Trading, Banking or healthcare industry where I can explore my inherent talent & past experience to serve earnestly, increase profitability, reducing the down time and grow with an organization.

MISSION

To increase the organizational profit by providing highly available and efficient database environment. Delivering rich customer experience by providing fastest database access and hence system access for 365 days a year, 24x7. Providing business critical information to the top management to help them in making better business decisions.

SUMMARY

13 plus years of IT experience & Microsoft certified database administrator (MCDBA) with experience in SQL Server 2008/2005. Exceptional leadership skills and experienced in leading team of 20+ team members

Expert in recommending, evaluating and implementing Solid State Drive (SSD) or NAND flash based storage solution for SQL Server database servers. Well versed with key products in market and best compatible hardware. Developed close relationship with IBM and HP. Identified key issues with IBM X3850 M2 server architecture and worked with IBM to get them fixed.

Thorough knowledge and experience in OLTP & OLAP database modeling, design (logical and physical OLTP and OLAP), architecture, development, implementation and administration, used ERWIN, ER Studio, Sybase power designed and Visio.

Expert in Database Architecture, Storage Architecture, SAN implementation and configuration, Storage Consolidation, Server Consolidation, Migration to 64 bit and SQL Server 2008/2005, I18N (Internationalization), Capacity Planning, management and allocation, RAID.

Expert in High availability configuration and Disaster Recovery setup, Server clustering, log shipping, Replication, Database Mirroring (SQL 2008/2005)

Expert in installing, configuring, and performance tuning SQL Server 2008/2005

Mastered the art of performance tuning SQL server. Used various tools like SQL profiler, & perfmon. Strong background in query optimization and query analysis.

Transact SQL (T-SQL) coding, writing queries, stored procedures, cursors & triggers.

Address and resolve technical issues related to databases and provide 24*7 supports.

Experienced in detailed Database Documentation using ER Studio and meta data management, Caching Technologies, Data ware housing, BI and ETL

Maintain development, test and production databases in clustered environment.

Good understanding of SQL server security and transaction management.

Experienced in VLDB operations with databases of 2 TB size.

Familiar with SEI CMM Level 5 and ISO 9001 quality standards.

TRAININGS, SEMINAR AND MEMBERSHIPS

Active SQL Server PASS member

Windows and SQL Server Connections

Active member of SearchStorage and SearchSQL- Storage Decisions conference

Active member of SearchDataCenter – Attended Data Center Decisions

Microsoft Certified Courses 2733 – upgrading DBA Skills to SQL Server 2005

Microsoft Certified Course 2734 – Upgrading Development Skills to SQL Server 2005

PROFESSIONAL EXPERIENCE

July 2007 – Till Date ThomsonReuters Financials

http://www.thomson.com/solutions/financial/ Chicago, IL, USA

Designation : Enterprise Database Architect

I am working as an Enterprise Database Architect in Thomson Reuter’s WebQA product line. WebQA is a financial database integration and analysis product for financial and investment firms as well as related financial researchers. The core database is used by many internal and external applications for financial research. WebQA product integrates data feeds from many diversified data vendors as well as ThomsonReuters internal data feeds. Its high transaction OLTP system which gets market data updates from all the markets in world. On average 100 million transactions per day with highest around300 million transactions per day per server. These feeds include vendors like I/B/E/S, World scope, Compustat, Barra, Reuters, First call and DataStream. The content set include Equities, Fixed Income & Equity Indexes, company fundamentals, Estimates, Broker Research, Ownership, Fixed Income Pricing and much more. The product also consists of daily data ingestion to manage the daily data update.

Key Achievement

Implemented Solid State Storage Solution at massive scale and achieved >10X performance improvement and lowered Storage cost by more than 10 Million USD.

Saved company close to 4 Million Dollar by negotiating better pricing with vendors FusionIO, IBM and HP.

Saved company 3 Million dollar by changing license models used for licensing SQL Server, Windows OS and other enterprise software.

Saved company 4 million dollar by doing server consolidation and cluster consolidation.

Designed, Architected and overseen implementation of SNMP monitoring of hardware in multiple data center for proactive hardware monitoring and reduce unplanned downtime.

Designed, Architected and overseen implementation of GMI and PAWZ monitoring across multiple data center and infrastructure monitoring using HP Openview and IBM Tivoli.

Designed, Architected and implemented 10GigE network database and web servers.

Tested various new servers including HP DL 580 G7, 585 G7, 370 G6, 380 G7.

Received TOPS (Thomson Outstanding Performer award)

As an Enterprise Database Architect my responsibilities include

Key Responsibilities

Designed and Implemented SSD storage solutions for Database Servers to get high performance and replaced EMC DMX. Implemented more than 500 TB of SSD Storage in production running since 3.5 years.

Implemented, Designed and executed 10GigE networking infrastructure for the product. First product in ThomsonReuters to implement and use 10GigE at this scale.

Create, Plan, manage and execute CAPEX of 25-40 Million USD for my product line.

Logical and Physical Database Design for OLTP & OLAP systems, Database Architecture, storage and network architecture.

Evaluate, Test and validate new technologies, server models and prepare organization wide guidelines and standards for database and web servers and storage.

Pioneered usage of NAND flash based drives. Evaluated and implemented NAND flash for first time in Production environment in company and first major client implementation for vendor.

Suggest cost saving options, consolidation strategy and streamline and optimize key organization processes and infrastructure.

Prepare technology and infrastructure roadmap.

Database development – coding procedures, function, triggers

Database deployment, administration , performance monitoring & tuning

Development, design and architect the new data feed ingestion

Working with SQL Server 2008 R2/ 2005 running on Windows Server 2008 R2 / 2008 64 Bit Intel Nehalem based Systems with 512 GB RAM and EMC DMX/ VMax and FusionIO SSD.

Provided 24x7 365 days Database Administration and Production Support for more than 75 Servers across more than 12 environments and two product lines for close to 3 years.

Plan, manage and support product deployments and upgrade.

Leading offshore team of developers / DBA.

Involved with more than 100 SQL Server 2008/2005 Database servers with more than 5 TB data on each across 15 different environments including production, DR, QA and Development for 2 product lines WEBQA and Outpost.

Design, implement and monitor Replication, Storage systems and high availability of Servers.

Experienced in Capacity Monitoring using tools like PAWZ, Perfmon

Experienced in Infrastructure monitoring using HP OpenView, IBM Tivoli, SNMP Monitoring.

Experienced in High Availability and disaster recovery planning, design and implementation.

Vendor management, price negotiation HP / IBM/ FusionIO/ Arista/ OCZ/ Nimbus /Pure / SolidFire/Kaminario/Adaptec/XIO.

Excellent negotiation skills.

May 2007 – June 2007 Marketing Analytics

Marketing Analytics is a recognized leader in market response modeling. Marketing Analytics helps their clients to quantify what drives sales and help them use the results to increase market share, revenue, and profit.

(http://www.m-a.com) Evanston, IL, USA

Designation: Database Manager.

As a Manager Database Systems, my responsibilities include designing and creating architecturally sound web based BI systems. Optimizing existing database infrastructure and improve scalability of the systems to support double digit growth of the organization.

May 2004 – April 2007 Ticketsnow.com

Ticketsnow.com owned by Ticketmaster and known as LiveNation is world’s biggest online ticket selling company. Ticketsnow.com is a high transactional (OLTP) ecommerce web site selling Tickets with seasonal load variance.

(http://www.Ticketsnow.com/) Ticketsnow.com Crystal Lake, IL, USA

Designation : Enterprise Database Architect (October 2006 – Till Date)

As an Enterprise Database Architect my responsibilities include shaping highly efficient, highly available, highly scalable and high performance ecommerce (OLTP) website. Identifying opportunities to improve the organizational profitability by doing cost optimization using new technologies.

Project Work

Server consolidation – In this initiative, I lead a project to optimize the hardware allocation by server consolidation. This was achieved by using 64 Bit Architecture, New multi core (Dual and Quad) processors, Server Virtualization. The overall goal of the project was to reduce the number of servers by 50% or more. The net savings expected was around 1 million dollars which includes cost saving in hardware, support, maintenance, power and cooling, Software Licensing and other over heads like Disaster Recovery. Usage of third party product like CiRBA or IBM NDAT for identifying consolidation candidates.

Storage Consolidation – In this initiative, I lead a project to optimize the storage system by better provisioning techniques like Thin provisioning or better capacity planning and forecasting. This should help to consolidate lots of direct attached storages or on board disks to a NAS (for file systems) or SAN (for high performance Databases) to allow easy and centralized management. Achieving cost optimization by identifying the best combination of RAID levels, SATA or SCSI drives and Tiered storage configuration and Fiber Channel (FC) Vs iSCSI SAN systems.

64 Bit system Architecture – In this initiative, I presented a detailed report which includes the market study of 64 bit processors available in market for windows based system and present the best possible options for various architectures. For ex: Itanium (EPIC) systems for Scale up Vs AMD optron/ Intel Xeon systems for scale out architectures. This initiative should bring organization on 64 bit system architecture for improved hardware utilization, linear scalability and performance. Defining guide lines for the best utilization of multicore technology which includes guide lines around multi threading and thread optimization. Increased RAM will help in other organizational initiatives like centralized dynamic data caching.

Migration to SQL Server 2005 – In this initiative, I lead a project to upgrade existing SQL Server 2000 systems to SQL Server 2005 for cost saving, better hardware utilization, scalability and high availability. This will than be used for better application data caching using dynamic caching technologies provided by SQL Server 2005 notification services and ASP Dot Net 2.0 SQL Cache dependencies. Usage of third party caching appliances like Gear6.

Enterprise Data warehousing (EDW) and BI – In this initiative I designed and implemented EDW system to provide improved data analysis and support smart decision making based on real data. The EDW will help organization grow to the next level by providing business critical information from hidden data. SQL Server 2005, SQL Server Integration Services (SSIS), Microsoft BI Stack (Pro-clarity), MS Office 2007, Share Point server 2007 and SQL Server Reporting services will be used to provide integrated real time reporting and controlled centralized web based data access.

Designation : Manager Database Systems ( May 2005 – October 2006)

Project work

Actively involved in development of three mission critical projects in Web, Client Server and Data ware housing using SQL Server 2005.

SQL Server 2005 deployment on HP MSA 1500 and HP EVA 6000 SAN.

T-SQL Development, Database Design and Architecture in SQL Server 2005

Development of Sales Fact in Data ware house using SQL Server 2005

Development of SSIS packages for ETL and ODS.

Actively involved in defining, designing and implementing SOA based Web Service Architecture.

Performance monitoring and improvement of Web Services and all web sites.

Planning and designing Enterprise Database Integration with ER Studio.

Working with Windows Server 2003 64 Bit AMD Systems with 32 GB RAM.

Evaluating cutting edge technologies like Texas Memory Systems’ RAM SAN, Cast IRON’s Application Route and Zazat’s Z-box (In memory SQL Server Database).

As a Manager Database Systems my main responsibility include

Overall management of company’s database environment with the help of team of 7 team members which includes 3 DBA and 4 database developers.

Overall responsibilities include hiring of team members for database. Actively involved in hiring and setting best QA team.

Driving the company’s EIBOXOFFICE Point of Sale product’s development efforts by providing fastest, low cost and high quality data storage options using SQL Server and SQL Server Express.

Achieving 99.99% high availability for company’s mission critical OLTP ecommerce website backend production servers with various proactive measures. This includes proactive system monitoring, on-going performance tuning, automated notification for critical system events using several tools like perfmon, sysmon, logmon, SQL Server Profiler and third party tools.

Knowledge of most of the Third Party Tools available for SQL Server in market and constantly involved in piloting them to determine the case where they can be used.

Utilizing best available third party tools to achieve desired results. This includes piloting various software for backup from companies like Idera, Veritas, CA, RedGate and Quest. Presently using SQL LiteSpeed for fast, encrypted and compressed backup for high availability and security and Lumigent Log Explorer for in depth log analysis.

Driving and designing next generation database server environment with use of latest technology and break through architecture for better system performance.

Managing and executing various database related tasks like Database Design, Database programming, Deployment in several ongoing development projects.

Setting best practices and coding standards for Database team. Versioning of the database code and change management. Ensuring the quality and performance of new and existing database code.

Implementing HP MSA 1500 and HP EVA 6000 SAN for SQL Servers. Defining and designing SAN, configuring RAID levels depending application nature for optimum performance. Implementing HP OpenView for Pro-active monitoring of server environment.

Designation : Database Architect / DBA (May 2004 – May 2005)

Hardware, Database & Application Performance tuning of SQL server 2000 clusters running on windows server 2003 enterprise edition.

Increasing the site uptime. The company had a problem of frequent database downtime which in-turn brings the website down. Average 100K loss in revenue per hour of down time.

Performance tuning of the present environment and re-architecting bad applications.

Overall environment management. The overall environment is very complex which includes around 50 servers. The Cluster hardware consists of Compaq DL 750 running 16 CPU with hyper threading, NetApp Raid Array and iSCSI running windows 2003 EE and SQL Server 2000 in Active/Passive mode and HP MSA 1500 SAN.

In 1 month of duration with the company the database server availability is increased by 15 hr/Week downtime to 11 Minutes/week.

Fine tuning of the cluster disk subsystem. Setting effective backup strategy.

Writing lot of OSQL utilities for the product support group.

Providing 24X7 support for the database issues related to product and web sites.

Troubleshooting and solving the complex end user issues related to data, integrity, transactions and product bugs in database.

Training the developers of the company in writing efficient database code.

October 2003 – April 2004 ASAP Software INC. Designation: Data Center DBA.

1. ASAP eSmart Buffalo Grove, IL, USA

ASAP Software is leading seller of license software products. ASAP esmart is a leading asset management service offered by ASAP to the end client. As a data center DBA my responsibilities include

Installation and management of SQL server 2000 clusters running on windows server 2003 enterprise edition.

Backup and restore of databases. Database size ranges from 63 GB to 470 GB

Replication for reporting database and log shipping for warm standby server.

DTS programming to load and archive history data from OLTP database to OLAP database

Routine database maintenance.

Performance tuning of SQL server 2000.

Database auditing and security management.

Use third party backup software of Varitas (shadow copy) and sql-litespeed.

Managing development, qa and production database environment.

24*7 customer support.

Hardware capacity planning and fine tuning.

Use of new generation technologies for better results. Implemented SQL server reporting service for reporting purpose on pilot basis.

June 2003 – August 2003 FreeMarkets INC. Designation: Sr. Database Architect / DBA.

FreeMarkets is NASDAQ Listed Company (FMKT) and world leader in GSM (Global Supply Management) and e-sourcing solutions. For more information click the link below.

(http://www.freemarkets.com/)

2. FREEMARKETS ES. Pittsburgh, PA, USA

Platform : SQL Server 2000, Windows 2000, C#, ASP.net, XML, Sybase Power Designer, Visio

Team size: 25 Members.

The project was to develop and maintain databases for the various products of the freemarkets INC in which I did database design, coordinating various activities related to product development lifecycle, coordinating work of several database developers and administering various SQL server databases in clustered environment for high availability.

Requirement study and information gathering.

System analysis and design, flow diagrams and ER model, database design

Lead team of database and front-end programmer successfully.

Designed internationalized database systems.

Leading the database team which included 3 Jr. DBA and 5 data warehouse developers.

Product support and problem solving.

Setting up snap shot and merge replication between various databases, programming DTS.

Communicating with the offshore team for the day-to-day work

Nov 2002 – May 2003 Infosys Technologies Limited (http://www.infosys.com/)

Database Architect / DBA

Infosys is World’s Second most profitable Software Company after Microsoft. Infosys Technologies Ltd. (NASDAQ: INFY) has over 17000 employees worldwide.

SONY ICH EAI. JAPAN Duration: Feb 25 2003 – May 2003

Platform : SQL Server 2000, MS Access, Oracle 8i, Windows 2000, UNIX, Pro c, C, Erwin

Role : Sr. Database Architect.

Team size: 15 Members.

The project was to develop and maintain an information clearinghouse ICH. The ICH is SONY Tokyo’s technology, which enables smooth data interchange in the heterogeneous system environment.

Understandings the very complex existing systems and define requirements.

Database design, logical and physical database modeling and database development.

Defining data transfer strategy and designing DTS packages to transfer data from various sources like Text Files, XML Files, SQL server, Excel, and Access to SQL server.

Programming SQL jobs for nightly tasks to do bulk copy of data using BCP.

Problem solving and technical support for the existing database systems.

Maintaining development and production database and security management.

Communication with offshore team member on daily basis.

FUJITSU JAPAN Duration: Nov 18 2002 – Feb 24 2003

Platform : SQL Server 2000, Oracle 8i, Windows 2000, UNIX, Linux 6.0 & 2.1, C, Visio

Role : Sr. Database Architect

The project was to port a data warehouse product from Linux environment to UNIX and Windows environment along with some product enhancement. The product named Symfoware Navigator is a market leading product of FUJITSU for data ware housing and MIS reporting. I designed and developed the SQL server database for the product. The other activities included managing security of the database, back- up and restore operation and data transformation using DTS.

Apart from this, it included having back end coding and UNIX shell scripting.

Excellent communication and project handling capability displayed with Japanese clients.

Worked with diverse systems and professionals.

Customer support and problem solving for the existing system.

Communication with offshore team for daily project status and co-ordination.

June 1998 – Nov 2002 Patni Computer Systems Limited (http://www.patni.com/)

NewMarket International (NI) NH, USA. Duration: June 1998 – Nov 2002

Platform : SQL Server 7.0& 2000, Windows 2000, Access, VB6.0, Crystal Reports 8.0, Erwin

Role : Sr. Database Architect / SQL Server DBA

This was time & material project for the product development company. Newmarket International is a leading provider of hospitality software in US, Europe and has around 80% of market share.

We were maintaining development, test and production SQL server 2000 databases running on Windows 2000 server in clustered environment. Data transfer from other sources to SQL server database using DTS and BCP. Various other activities included were DTS, scheduling jobs, database back up and recovery, replication, security management, transaction management, replication and performance testing. Some of the very important task performed are listed below

• Setting up replication to consolidate data from various booking server from across US to one server. This included setting up snapshot, merge and transactional replication to keep room nights booking information up to date and real-time.

• Database size varied from several hundred GBS to Max 1 TB depending upon the client.

• Provided 24*7 supports to several critical hotel clients like Hilton, Crown and Washington Resort.

• Successfully lead team of 3 Jr DBA and 2 application testers.

• Debugging stored procedures and triggers to find the problems, Used SQL profiles as well to identify performance bottlenecks.

• Excellent trouble shooting skills and customer friendly attitude rewarded by Award of “Excellence in Engineering by Client”.

• Extensive T-SQL programming & expert in writing stored procedures, triggers and queries.

• Communication with the offshore team members for the daily project status and developments.

Sales Automation for the Hospitality Industry NH, USA. Duration: July 2001 – Jan 2002

Platform : SQL Server 2000, Windows NT 4 & 2000, VB.Net, C#, ASP.Net, Crystal Reports 8.0

Role : Database Architect / SQL Server DBA

The project was prepared for an existing hospitality client using ASP.NET, C#, Mobile Web SDK, JSCRIPT.NET, COM+, XML, Active-x, ADO.Net and SQL server 2000. The key task was to migrate from mixture of Microsoft and non-Microsoft technologies to new generation Microsoft.Net technology. I was responsible to workout the strategy, training of the team members on .net and project documentation. I also carried out the responsibility of complete database design, development and administration.

Product Performance Tuning.

Client : NewMarket International (NI) NH, USA. Duration : June 2002 – Oct 2002

Platform: MS SQL Server 2000, Windows 2000, C#. Net, Erwin

Role : Database Architect/Group Leader

The scope of the project was to do performance tuning of the various products. It also included performance tuning of the database. My responsibilities included

• Identifying bottlenecks in performance using SQL server profiler and various other mechanisms

• Redesigning flow of several functionalities, keeping performance in mind

• Query tuning & index tuning of database & rewriting several stored procedure or breaking them

ACCOMPLISHMENT

Got TOPS (Thomson Outstanding Performers) award.

Got the team award for the NI Project

Got Excellence in Engineering Award from New Market Internationals.

Pioneering the usage of .Net technology in the company and trained other members.

Improved the product performance by 150%.

EDUCATION

YSM (Young software manager) Globsyn Tech. Limited.

First rank in University

Aptech computer education

HDSE (Higher diploma in software engineering)

First rank

1994 – 1998 S.S.Engineering college

Bachelor in Engineer - Instrumentation and control

Second rank in University

PROFESSIONAL QUALIFICATION, TRAINING AND SEMINAR

MCDBA (Microsoft Certified Database Administrator)

Exams passed are listed below

070-215 – Installing configuring and administrating Windows 2000 server

070-210 – Installing configuring and administrating Windows 2000 professional

070-228 – Installing, configuring and administrating Microsoft SQL server 2000 EE

070-229 – Designing and implementing databases with SQL server 2000 EE.

070-175 – Designing and implementing distributed applications with Visual Basic 6.0

MS2733 – Updating Your Database Administration Skills to Microsoft SQL Server 2005

MS2744 – Updating Your Database Development Skills to Microsoft SQL Server 2005

INTERPERSONAL SKILLS

Excellent Self-learning skills, Team Player, Exceptional leader, Tough Negotiator, Strong in conceptualization, Ability to handle Complexities, Proactive, Assertive, Good in Time Management, Focus on Quality, Prioritization, Customer oriented, Can work under pressure & dedicated.

WORK STATUS

Permanent resident. Authorized to work for any employer in USA.

REFERENCES

Available upon request

Contact this candidate