SUMMARY

• Hadoop Developer with 3+ year experience on Cloudera Hue, HDFS, Spark and HBase.
• Worked on creating Hive tables and transferring data between Hue and HDFS, transferring data between MYSQL HDFS, Hue and HBASE using SQOOP. Database Developer with 6+ years’ experience Worked on design, development and administration of SQL Server (versions: 2000/20 R2/2014) for Financial, Life Science and IT industries.
• Experience with SSIS, SSRS, Database design and SQL queries.
• Solid experience related to performance tuning for OLTP applications, schema design and dimensional data modeling.
• Experience working on JavaScript. Good knowledge of High Availability server solutions including SQL Server Log - shipping, Mirroring, SQL Server cluster and Always On availability Groups.
• Worked collaboratively with offshore team to support the Database environment.
• Experience with database architecture, performance tuning, and query plan analysis, performance monitoring using query profiler, database maintenance and administration on multiple versions of Microsoft SQL Server, MSSQL Server Installs. Worked on data transfers through SQL Server import and export wizard.
• Experience working on migrating trading server.
• Responsible for datacenter migrations and DR test for Prime Brokerage servers.

TECHNICAL SKILLS

Environment: Hadoop, HDFS, Hive, Java, spark(Scala), Github, Python.

Relational Databases: MSSQL 2005/2008R2/2012/2014,MySQL.

Monitoring Tool: Solarwinds, New Relic

Change Management Tool: Zendesk, Jira

Versioning Tool: Github.

OS: Windows 95/98/2000/NT/XP/ 2003/20 .

Others: MS Excel, MS Word, MS PowerPoint,QlikView

PROFESSIONAL EXPERIENCE

Confidential, NJ

Database Engineer

Responsibilities:

• Worked on copying data from HDFS to Hive tables.
• Worked on Cloudera hue for created Hive tables and analyzing the loaded data in the hive tables using hive queries.
• Implemented Partitioning, Dynamic Partitions in HIVE.
• Designed and Implemented Simple to complex Map Reduce jobs to support distributed data processing.
• Knowledge of Map Reduce progamming.
• Worked in import and export data between HDFS, HBase, Hive and Relational Data Management Systems(MySQL) using Sqoop.
• Worked on a Hive Project of analyzing the hive table data using Tableau.
• Load data into Hive partitioned tables.
• Knowledge of Flume Integration.
• Knowledge of Zookeeper.
• Experience writing shell scripts.
• Worked on Spark programming using Scala Language.
• Support application team slowness issues through query tuning.
• Work with application team in supporting them on SQL script modifications and in script execution.
• Work with application team on schema design and data modeling.
• Strong Database Developer skills in the effective way of writing stored procedures, functions and ER design.
• Retrieving MSSQL Database health details using DMVs, DMFs.
• Worked on increasing SQL server performance using windows performance monitor.
• Worked on PowerShell scripts for query executions across multiple servers with output stored in csv format.
• Prepared process documentations.
• Worked on SQL script generation for Database backups and restores.
• Monitor the Replication queue latency during migration to avoid application slowness.
• Worked on Google Scripts to access Zendesk Data for getting the details of Customer Care ticket volume and on Off-boarding the user from Zendesk once a person is not part of the team.
• Worked with application for check outs from database end during application migration.
• Worked on SSIS package for multiple script execution.

Confidential, NY

IT Analyst

Responsibilities:

• Worked on copying data from HDFS to Hive tables.
• Worked on Cloudera hue for created Hive tables and analyzing the loaded data in the hive tables using hive queries.
• Knowledge of Zookeeper.
• Worked on a Hive Project of analyzing the hive table data using Tableau.
• Worked on copying data from HDFS to Hive tables.
• Load data into Hive partitioned tables.
• Provide on-call coverage support for MSSQL and Sybase Servers.
• Support application team slowness issues through query tuning.
• Automated the process to generate space usage report for the MSSQL production environment.
• Strong SQL Server Developer Skills in script writing including writing Stored Procedures, User Defined Functions, Views, Query writing and ER Design.
• Resolve database related issues.
• Worked with global engineering team on always on availability group certification as per nomura standards.
• Worked on MSSQL obsolescence project in migrating MSSQL servers from windows R2, configuration and maintenance.
• SQL Server Cluster Maintenance and builds for trading servers.
• Actively participated in Database Migration project from Pre-Install planning till post migration support for the application teams.
• Worked on scheduling daily database backups as per application team time specifications and transaction log backups.
• Worked on capacity planning and database sizing for all new servers.
• Performed data transfers through SQL Server import and export wizard.
• Implementation of SQL Logins, roles, authentication modes as part of security
• Provide support for Sybase related issues.
• Retrieving MSSQL Database health details using DMVs, DMFs.
• Worked on increasing SQL server performance using windows performance monitor.
• Experience working with Packages, Triggers, stored procedures on oracle platform..
• Retrieve multiple server details using PowerShell Script.
• Worked with storage team in scheduling tape backups for MSSQL servers.
• Participated in storage migration project from EMC to HDS.
• Worked with storage team in scheduling tape backups for MSSQL servers.
• Actively participated in MSSQL disaster recovery test.
• Actively participated in setting up Database Mirroring as DR strategy for MSSQL Servers.
• Monitored and modified Performance using execution plans and Index tuning.
• Worked on shell script to disable monitoring on MSSQL servers during monthly patching.
• Participating in Global Meeting with other regional Database team.
• Installed In-house Database Maintenance tool across MSSQL servers, for MSSQL Database Maintenance.
• Worked on SSRS build for application team.
• Performed basic checks on IQ server.
• Wrote Script for monitoring MSSQL Database backup and Transaction log backup and taking adhoc backup of MSSQL Databases whose previous Database backup failed.
• All the production releases are made once the request is approved by the Change Management team through Service Now.

Confidential

Technical Associate

Responsibilities:

• Work as a SQL Server Database Developer.
• Develop Database design and specification as per the team requirement.
• Ensure Database performance and Integrity.
• Trained junior developers .
• Analyze problems related to Databases reported by the client using customer provided tool.
• Followed Agile Methodology for developing modules.
• Work as a member of development team assisting team lead.
• Write efficient queries and java codes for small applications.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Ensure tables have required indexes to improve query processing.
• Troubleshoot database related issues in a timely fashion. Create complex scripts and stored procedures for Database Maintenance using DMVs.
• Ensure tables have required indexes to improve query efficiency.
• Troubleshoot database related issues in a timely fashion.