Jitendra Mhaskar

Experience

• 

  HALDYN GLASS LIMITED

  Feb 1997 - May 1998

  Software Programmer
• 

  Transpek-Silox

  Jun 1998 - Aug 2015

  Manager-IT

  Installed and maintained MS SQL Server 2008r2 on Windows 2003 Server. Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.Configuring, tuning and optimizing SQL Server 2008r2.Involved in complete database design including conceptual, logical and physical models.Performance testing on stored procedures, indexes, and triggers.Creating SSIS Packages for data import/export, scrubbing and scheduled jobs for backups for MSSQL.Creation of reports like Reports by Period, Demographic reports and Comparative Reports.Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.Created Complex reports using SS Reporting services.Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.Understanding and performance of normalization, database creation and indexing.Developed HR Payroll & Employee Management module in C#/SQL 2008 & Crystal Report.Active Involvement in Capex Finalisation for IT Department.Experience in handling the team of 4 employees under me. Show less

• 

  ZeroChaos

  Sept 2015 - May 2017

  Sr. Software Engineer

  Design Development and Support of MS SQL Server 2012/2008R2/2000 db Objects.Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008/2012.Tools used for Performance Tuning and optimization are SQL Sentry plan Explorer / SQL Profiler / SQL Doctor / TOAD & App Dynamics.Index strategies, identifying Unsused / Missed / Duplicate and poor performing Indexes.Creating SSIS packages for Data Uploading/downloading from CSV/Excel File formats.Agent Job Management /Monitoring.Creating Migration script for Business change.Writing automating script for various tasks. Show less

• 

  Civica

  Jun 2017 - Mar 2024

  Lead SQL Database Administrator

  ➢Helping development team in writing efficient T-SQL Code.➢ Writing Highly complex migration scripts for data movement from OnPrem → OnPrem, OnPrem → Cloud & Cloud → OnPrem using BCP & Bulk Insert.➢ Responsible for Index Strategies & Improve performance through Indexing & Statistics.➢ Configuring, Updating & Monitoring Business Continuity & Disaster recovery solutions.➢ Creating cloud compatibility reports for migration through Microsoft Data Migration Assistant.➢ Involved in designing solution for data search management with Elasticsearch & CDC (Change Data Capture).➢ Mentoring team for adhering to using best practices and training them on writing quality performance code.➢ Performance Tuning and optimization through SQL Sentry plan Explorer, SQL Profiler, Extended Events, DMV’s.➢ Handling customer escalations for Performance Improvement.➢ Involved in creating various POC’s for implementing new features available with each version of SQL Server release.➢ Training peers to write optimised code by creating learning from mistake document through Database code review & SQL best practices.➢ Helping business units in resolving performance issues.➢Developing career progression documents for database professional across the organisations.➢ Creating, Maintaining & Implementing SQL Server best practices across the organisation.➢ Training peers on various new features and their uses available in SQL Server product. Show less