Abhishek Purohit

Storing huge amount of information generated by Network Sensors(live) and User information (History) across the Globe in HDFS and Hive data warehouse. Then take care of the Bill generation by using Oracle BRM tool, which loads data to RDBMS and is fetched to HDFS by Sqoop and merges up both the data and gives required output which will be then converted to interactive format by Tableau. Skills: Very Good understanding of internal working in Hive, SPARK and Scala with Sequence files, ORC File, AVRO formats.

As a Senior Associate engineer responsible for resolving mission critical database issues whilst enhancing the technical knowledge of engineers and resolving client issues on time. • End to end infrastructure designing and delivery for client. • Requirement gathering from client and creating of technical specification. • Creating Demo model based on the requirement and prepare presentation for the same. • Designing high availability concept according to the client's need.

As a SQL engineers responsible for resolving mission critical database issues whilst enhancing the technical knowledge of engineers and resolving customer issues on time • Research on customer issues, data analysis and provide action plans after data analysis and debugging. • Providing feedback directly to the SQL Server Product Team by filing bugs, Design Changes and high priority Red Zone bugs. Involved in trending of top issues, identifying trends & patterns in feature areas.

• Configuring AlwaysOn feature and patching latest Hotfix for the AlwaysOn servers. • Setting up the Transactional replication for SQL Server. • Created Clustering on SQL Server. • Responsible and Involved in SQL Server Performance Monitoring, Server and Database optimization and Query tuning & used Windows Perform and various 3rd party tools to monitor SQL Server health and gauge the performance. Used SQL Server Dynamic Management Views and functions to monitor & optimize the performance.

Requirements gathering/analysis, designing and developing system database objects and Reports. • Involved in the confidential User Details Testing, Bug Fixing and support. • Periodically DATA VALIDATION & DISCRIPENCY check by creating the scripts to ensure all the data has been correctly updated and provided the deployment reports for the same. • Experience with database performance tuning, Query optimization, client/server connectivity and other network issues.

Responsible and Involved in SQL Server Performance Monitoring, Server and Database optimization and Query tuning & used Windows Perform and various 3rd party tools to monitor SQL Server health and gauge the performance. Used SQL Server Dynamic Management Views and functions to monitor & optimize the performance. • Solving log file issue when log file is full. • Debugging and optimizing Triggers, Views, Functions, T- SQL queries and stored procedures.

Subjects: 1. Programming languages (C,C++,JAVA) 2. Data Structure 3. Industrial Mathematics 4. RDBMS etc.