Siddharth Chauhan, Analyst

Siddharth Chauhan

Analyst

NIIT Technologies Pvt. Ltd

Location
India - Delhi
Education
Master's degree, MBA
Experience
14 years, 3 Months

Share My Profile

Block User


Work Experience

Total years of experience :14 years, 3 Months

Analyst at NIIT Technologies Pvt. Ltd
  • India - Delhi
  • My current job since September 2016

NIIT Technologies is India's leading CMMI level 5 IT solutions organization, servicing customers in the America, Europe, Asia and Australia and offers services in Application Development & Maintenance, Infrastructure Management Services, and Digital Services etc. in domains like Banking, Financial and Insurance Services, Travel & Transportation, Manufacturing and Distribution etc.

As active offshore DBA, my key responsibilities are:

 Providing L2/L3 DBA support to all PROD and Non-PROD MS SQL servers for US based client and performing regular DBA tasks.
 Installation, monitoring and maintenance of MS SQL based Servers as per best practices.
 Develop automated solution for repetitive or time consuming DBA tasks.
 Reviewing and resolving server level vulnerabilities to enhance compliance and security.
 Troubleshoot performance and user issues and provide in-time and correct resolution.
 Updating existing documents with newest processes and documenting new activities.
 Provide server and application support for “Robotics Process Automation (UIPATH)"

Associate Process Manager at eClerx Service Limited
  • India - Mumbai
  • January 2014 to August 2016

eClerx is India’s leading knowledge process outsourcing (KPO) company, which is publicly listed in both Bombay & National Stock exchange and serving over 30 of Fortune 500 companies from different domains like Financial services, Broadband, Cable & Telco, e-Commerce and retail, Industrial Manufacturing and distribution etc.

As Associate Process Manager my key responsibilities were as follows:

 Managing and leading team of SQL DBA’s across India.
 Managing and providing support to all PROD and non-PROD SQL instances across all company locations and serving as single point of contact for all escalated DB issues.
 Successfully lead and implemented robust DR solution for all SQL servers in organization.
 Upgrading SQL Server from SQL Server 2000\2005\2008 R1\R2 to 2012\2014.
 Implementing SQL and ITIL best practices for better performance and SLA compliance.
 Installation, support and maintenance of MySQL 5.6 & 5.7 servers.

Senior SQL Developer at Excelsoft Technologies
  • India - Delhi
  • July 2011 to July 2013

Excelsoft offers value added products and services in the e-Learning domain, that serve the interests of educational publishers, universities and schools as well as the government, defense and corporate sector.

As Senior SQL Developer my key responsibilities were:

 Providing support to Non-production federated database system.
 Performance tuning of database queries and providing support to tech team in development of complex logic.
 Review and enhancement of existing automation utilities and replication setup.
 Developed .net based windows application for health monitoring of SQL servers.

Senior Database Engineer at NIIT Technologies Pvt. Ltd
  • India - Delhi
  • September 2009 to July 2011

As Senior Database Engineer and part of offshore DB team, my key responsibilities were:

 Providing L1/L2 database support to all production SQL and Sybase servers for US based client and performing regular DBA tasks like DB restore, patching etc.
 Development and deployment of SSRS reports and SSIS packages for team.
 Migration of SQL 2005 databases to SQL 2008 instances.

Education

Master's degree, MBA
  • at Sikkim Manipal University Directorate of Distance Education
  • April 2012

MBA in Project Management

Specialties & Skills

Performance Tuning
Microsoft SQL Server
Performance Tuning
Windows Server
AUTOMATION
Active Directory
SQL Server Administration
MS SQL Server
VM Ware

Languages

English
Expert
Hindi
Native Speaker

Training and Certifications

MCSA in SQL SERVER 2016 (Certificate)
Date Attended:
March 2018
Valid Until:
March 2021