DEEPAK RAJ

Experience

• 

  Serco

  Jul 2013 - Jul 2014

  Database Administrator

  Installation, configuration and maintenance of SQL ServerDatabase backup and disaster recovery MS SQL Server upgrades(from 2000 to 2005 and from 2005 to 2008R2)Used SQL Profiler, Execution Plan, Performance Monitor and DBCC CommandsInstalling, configuring and deploying web-applications across large farms of web servers and troubleshooting runtime errors in IIS 6.0/7.0/7.5Work as part of a team and provide 7×24 supports when required.

• 

  HCL Infosystems Ltd.

  Jul 2014 - Sept 2016

  Senior Database Administrator

  Ministry of Power, Government of India, has launched the Restructured Accelerated Power Development and Reforms Programme (R-APDRP) in July 2008 with focus on establishment of base line data, fixation of accountability, reduction of AT&C losses upto 15% level through strengthening & up-gradation of Sub Transmission and Distribution network and adoption of Information Technology during XI Plan.Installation, configuration and upgrading of Microsoft SQL Server/MySQL/server software and related products.Evaluate MSSQL/MySQL/Oracle features and MSSQL/MySQL/ related products.Establish and maintain sound backup and recovery policies and procedures.Take care of the Database design and implementation.Implement and maintain database security (create and maintain users and roles, assign privileges).Database tuning and performance monitoring.Application tuning and performance monitoring.Setup and maintain documentation and standards.Plan growth and changes (capacity planning).Work as part of a team and provide 7×24 supports when required.Do general technical trouble shooting and give consultation to development teams.Interface with MSSQL/MySQL for technical support.ITIL Skill set requirement (Problem Management/Incident Management/Chain Management etc) Show less

• 

  Sammaan Capital Limited

  Sept 2016 - Mar 2019

  Senior Database Administrator

  Manage SQL database administration assignments for diverse industry clients and maintaining all existing SQL Servers across Enterprise.Develop and implement policies and procedures for ensuring the security and integrity of the company database.Administering and Maintaining of all versions of SQL databasesCreated database objects like tables, views, indexes, stored-procedures, triggers etc.Created Linked servers for retrieving data from other Servers to use in transactional replication.Performance Monitoring with SQL Profiler and Performance monitor. Show less

• 

  Tata Consultancy Services

  Apr 2019 - Mar 2023

  Associate Consultant
• 

  HCLTech

  Mar 2023 - now

  Consultant