SUMMARY:

• Over 14 years of experience in System Architecture, Infrastructure Design, Capacity Planning, Database Design, Development and Implementation.
• Experience in Hadoop, Cassandra, Greenplum, Hawq and PostgreSQL
• End­to­End Implementation of Sustainable Multi Cluster, Multi Rack Cassandra, Hawq and Greenplum Database Systems.
• 13years of in­depth experience in database architecture, design and development, administration and maintenance of PostgreSQL 9.2, SQL Server large scale databases
• Highly experienced in database server performance tuning and optimization and troubleshooting and performance tuning for Complex SQL queries

Technical Skills:

Big Data Technologies: Hadoop Administration (HDFS, CDH3, CDH4),Cassandra DSE 4.7, Pivotal HD, Hawq, Greenplum, R, MapR, Tableau

DATABASES: PostgreSQL, SQL Server 2012, 2008 / 2005 / 2000 , SSIS,SSRS 2005/2008

Technologies: Java, ColdFusion MX, JavaScript. DHTML, JQuery

TOOLS: OS Unix (RHEL 6.x), Centos, Ubuntu, OPSCenter 5.2.1, CDH4 Manager, Erwin, NetBeans, SQL LiteSpeed, IDERAAUTOMATION TOOLS Chef, Puppet, Automate BPA Server 8.0 / 7.0

PROFESSIONAL EXPERIENCE:

Senior Hadoop Administrator / Data Architect

Confidential, San Ramon

Responsibilities:

• Solely Responsible for Hadoop Environment Setup having 22 node Clusters including network setup and configuration.
• 11 node cluster to CDH4 from CDH3 and configured CDH4 manager.
• Responsible for managing and administration of multi datacenter Cassandra cluster.
• Responsible for provisioning, managing and administering Greenplum and hawq databases and postgreSQL instances through Chef.
• Created data models in Cassandra and Implemented distributed parallel processing and data migration between Cassandra and hawq, greenplum instances.
• Configured enterprise historian and worked on conversion, pre­ingestion and ingestion of IHA files to hdfs.

Senior Hadoop Administrator

Confidential, Santa Clara, CA

Responsibilities:

• Solely Responsible for Hadoop Environment Setup with 10 node Clusters including network setup and Voltaire switch configuration.
• Working on: Hadoop (HDFS, MapR, CDH3 etc),Hive, MapReduce
• End­to­End Implementation of Sustainable Hadoop echo­System.
• Familiar with Vertica database (community edition)
• Created highly Normalized data model to populate in Data Warehouse Tables.
• Working on data integration and wrote Data Transformation code

Senior SQL Server DBA

Confidential, Alameda, CA

Responsibilities:

• Responsible for Production and staging database servers, including setting up and maintaining production databases in VM / SAN Environment.
• Database administration, schema design / re­engineering, DRS implementation and maintenance.
• Monitoring production servers using IDERA database monitoring tool and taking appropriate measures.
• Design and Implementation of Business process automation with workflows using Automate BPA server
• Designing creative technical solutions for various business process problems related to health care industry involving variety of associated trading partners.
• Responsible for high availability of production database and 24x7 routine maintenance
• Responsible for performance optimization of database and optimization of SQL queries.
• Tuning, Optimization and trouble shooting highly expensive database queries / stored procedures / T­SQL batches.

Environment: SQL Server 2008, 2005. 2000, IDERA, SSIS, Automate BPA Server 6 / 7.0 / 8.0. SQL Litespeed

Confidential

Senior SQL Server DBA

Responsibilities:

• Responsible for 24 Production and staging database servers, including setting up and maintaining few of the critical databases in cluster nodes in SAN Environment.
• Performed all aspects of database administration including data modeling, Log shipping, replication. (MS SQL Replication and TSQL Replication)
• Monitoring production servers using IDERA database monitoring tool and taking appropriate measures.
• Responsible for high availability of production database and 24x7 routine maintenance
• Responsible for performance optimization of database and optimization of SQL queries.
• Tuning, Optimization and trouble shooting highly expensive database queries / stored procedures / T­SQL batches.
• Frequently reviewing, auditing and testing disaster recovery procedure and maintaining related documentation.

Environment: SQL Server 2008, IDERA, SSIS, SQL Litespeed, Visual Source Safe

Senior SQL Server DBA

Confidential

Responsibilities:

• Responsible for 17 Production and staging database servers, performed all aspects of database administration including data modeling, Log shipping, replication and recovery. Created various DTS, SSIS packages and debugging existing packages.
• Developing data mining reports using analysis services, building cubes dimensions and pivot tables
• Responsible for high availability of production database and 24x7 routine maintenance
• Responsible for performance optimization of database and optimization of SQL queries.
• Re­engineered the database schema, writing and trouble shooting database queries / stored procedures / T­SQL code and batch programs

Environment: SQL Server 2005 / 2000, ColdFusion MX, Analysis Services, OLAP, JavaScript

Confidential, NJ

Responsibilities:

• Design, development and complete database administration of the whole system.
• Developing analysis services reports using cubes dimensions and pivot tables.
• Designed the system flow and developed user interface for the whole system.
• Responsible for data extraction for reporting purpose and created and maintained replication to the staging and report database
• Created Store procedures and Transaction Batch programs and SQL Jobs.
• Used heavy JavaScript and DHTML for client validation and user interface enhancements.

Environment: SQL Server 2000, ColdFusion MX on Windows 2000 Server, FuseBox, Crystal Reports 8.0, JavaScript, XML, XSLT, DHTML

Confidential

Responsibilities:

• Project Lead for 4 Member team. Responsible for Development of 3 Modules using pre­defined client use cases.
• Data Modeling & Database Design with ERwin, Performance Tuning and Optimization of Microsoft SQL Server database
• Troubleshooting Coldfusion pages, accessing SQL Server data, Creating and debugging stored procedures.

Environment: SQL Server 2000, ColdFusion 5.0 on Sun­Solaris, Java Script, ERWIN

Confidential, CA

Senior Project consultant

Responsibilities:

• Developed plans to reengineer and consolidate business operations and process into Internet based flexible user interface system.
• Managing 5 member team. Developed focused project development plans and streamlined core IT processes for extranet users (Credit Unions)
• Database Table Designing, Database Design enhancements, Maintenance, Performance Optimization
• Created various User Defined Functions (UDF) for encapsulating common business process.
• Creating and maintaining Replication between production and staging databases, Routine Back up operations of DB and Transaction logs. Event scheduling and other related daily database operations
• Database Maintenance, Restoring databases from backup adding and changing SQL Server logons, users, and groups

Environment: SQL Server 2000, ColdFusion 4.5 with Fusebox, DHTML, Java Script, ERWIN.

Confidential, Irvine, CA

Responsibilities:

• Project Lead for iManager Menu Module (3 member team)
• Database Design for the iManager Menu Module.
• Optimization and enhancement of existing Store procedure for improved performance for High and Low band width users.
• Designed Fuse box architecture and integration with inventory and other modules
• Optimization and enhancement of existing Coldfusion code for improved performance for High and Low bandwidth users.
• Interface design and template coding for iManager express tool.

Environment: SQL Server 2000, ColdFusion 4.5, Fusebox. DHTML, Java Script

Confidential

Responsibilities

• Responsible for SQL Server Database Administration, System Analysis design, Development and Implementation,
• Duties included installation, administration, and maintenance of SQL Server 7.0 databases, creation and maintenance of data models using ERWIN, creation and debugging of stored procedures that interface with Coldfusion web site

Environment: SQL Server 7.0, Windows NT Server 4.0, Macromedia Dreamweawer 3, ERWIN www. Confidential ­ (Client: Confidential Inc, Orange, CA, USA) Feb 2000 - Nov 2000

Confidential

Responsibilities:

• Database Maintenance / Administration. (Development, Test and Production versions)
• Administered two multi­gigabyte SQL Server (Production and backup server), including conducting daily, weekly and monthly maintenance as well as backup and replication.
• Database Transformation Services (DTS) included designing new DTS program and debugging existing program.
• Extensively used CFML, HTML and Java Script for developing the website. Enhancement of client side functionality by using CFSCRIPT, STRUCTURES. Extensively used custom tags for development.
• Re­engineering and Integration of System Architecture for Confidential Vertical market business model to B2B business model.

Environment: SQL Server 7.0, ERWIN, ColdFusion 4.0, Windows NT Server 4.0, Java Script, Macromedia Dreamweawer 3

Confidential, Long Island, NY

Responsibilities:

• Creating and debugging store procedures, Daily maintenance of sql server database and backup, Table designing, schema generation etc.

Environment: SQL Server 7.0, ColdFusion 4.0, Windows NT Server 4.0, Java Script, Macromedia Dreamweawer 3, ERWIN

Confidential, Philadelphia

Responsibilities:

• Developing User Interface. Database was developed in Oracle and linked to ColdFusion.
• Extensively used Custom tags, CFSCRIPT, STRUCTURES, and Java Script for developing the website.
• Generating periodical emails. Schedule Programs, Generating Reports.

Environment: ColdFusion 4.0, Windows NT Server 4.0, Java Script, Oracle SQL *Plus 8.0.4

Confidential, IN

Responsibilities:

• Designing the Database, User Interface. Involved with discussion with Client, regarding business activities.
• Extensively used CFML, HTML and Java Script for developing the website.
• Used CFScript extensively throughout the entire application.
• Created custom tag for routine functionality, Generating Reports.
• Implementing Client and Server side validations using Java Script and Custom tags.

Environment: ColdFusion 4.0, Windows NT Server 4.0, IIS 4.0, Javascript, Oracle SQLPlus 8.0.5