SUMMARY

• Over 16 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.
• 14 years of in-depth experience in database architecture, design and development, administration, maintenance, optimization and performance tuning of PostgreSQL 9.2, SQL Server large scale databases
• Excellent Interpersonal, Management and Communication skills with ability to deliver quality results with minimum supervision

TECHNICAL SKILLS

Big Data Technologies: Hadoop (Pivotal HD, CDH3, CDH4), AWS, Cassandra DSE 4.7, 5.0.2, 5.0 5, Solr, Lucene, Hawq, Greenplum, Tableau

Cloud Technologies: AWS S3, EC2, Glacier, IAM, RDS, Data pipeline

DATABASES: MySQL, PostgreSQL 8.x, 9.x, SQL Server 2012, 2000-2008, SSIS, SSRS 2005/2008

Scripting: Ruby, Shell Script, JavaScript, DHTML, ColdFusion MX

TOOLS: Chef Automation, OPSCenter 5.2.1, CDH4 Manager, Erwin, NetBeans, SQL LiteSpeed, IDERA, Automate Server 8.0 / 7.0

PROFESSIONAL EXPERIENCE

Senior Database Administrator

Confidential, Sunnyvale

Responsibilities:

• Responsible for managing 20 node Cassandra database cluster. Automating deployments and configurations via chef.
• Responsible for administration of postgresql 9.4 instances including but not limited to backup, recovery, troubleshooting, optimization and end user support.

• Responsible for managing Pivotoal Hadoop DCA (30 node cluster) including network setup and configuration.
• Senior administrator for multi datacenter production Cassandra cluster (DSE 5.0.2 / 5.0.5 ), QA and Dev environments running cassandra 2.1 (DSE 5.0.5 and OPSCenter 6.0.7)
• Responsible for setting up disaster recovery plan using snapshots and incremental backups.
• Managing 2 Cassandra instances in AWS for teh Dev and UAT environments. Implementation security using security groups.
• Used Solr indexing with elasticsearch for two different use cases for low latency range queries across terabytes of data..

Senior Hadoop Administrator / Architect

Confidential, Dublin

Responsibilities:

• Responsible for production hadoop cluster running in HDP 2.3.4.
• Principal architect and lead Administrator for production PostgreSQL 9.2, SQL Server environment.

Senior Hadoop Administrator / Data Architect

Confidential, San Ramon

Responsibilities:

• Responsible for managing Hadoop Environment (22 node cluster) including network setup and configuration. Upgraded 11 node cluster to CDH4 from CDH3 and configured CDH4 manager.
• Responsible for managing and administration of multi datacenter production Cassandra cluster (65 node running in DSE 4.7), release and system integration environments running cassandra 2.1 (DSE 4.7 and OPSCenter 5.2.1)
• Responsible for managing and administering Greenplum and hawq databases and postgreSQL instances.
• 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 and meta to PostgreSQL database running in AWS.

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

Senior SQL Server DBA

Confidential

Responsibilities:

• Responsible for 24 Production and staging database servers, including setting up and maintaining few of teh 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