Subhashish Chatterjee

Subhashish Chatterjee

Senior Analyst

Followers of Subhashish Chatterjee122 followers
location of Subhashish ChatterjeeSouth Delhi, Delhi, India

Connect with Subhashish Chatterjee to Send Message

Connect

Connect with Subhashish Chatterjee to Send Message

Connect
  • Timeline

  • Skills

    Itil
    Microsoft sql server
    Service delivery
    Active directory
    Bmc remedy
    It operations
    Powershell
    It service management
    Database administration
    Servers
    Sql
    High availability
  • About me

    Working as MS SQL DBA with 5 plus years of experience. Key areas: 1. Backup and Restore 2. High Availability - Log Shipping, Mirroring, Replication, Always On 3. PowerShell Like to work on creating reusable scripts that can make life of DBA bit more easier.

  • Education

    • Bethany Convent School, Allahabad

      1986 - 1998
    • Educational Institution

      2003 - 2006
      MCA Computer
  • Experience

    • Patni Computer Services

      May 2006 - Oct 2007
      Senior Analyst

      • Worked on Oracle based CRM tool CSI used by employees and partners of EMC2 for keeping track of end customers and products installed on each site.• Creating/deactivating account and resetting password for WebEx (an application similar to Microsoft NetMeeting).• Provided support on website named Powerlink used by employees to download software, upload files, etc. Used by end customers to log their complaints.• Provided support on tool named CCA5 used by employees and partners for configuring and installing products of EMC2 and other companies like IBM, Cisco etc.• Before CSI, worked on Clarify (version 10.1) for about 8 months.• Creating accounts for employees of EMC2.• Search and retrieval of data from Clarify.• Creating Orders (RMA) for parts replacement.• Creating and updating records based on the request from EMC2 employees. Show less

    • HCLTech

      Apr 2008 - Mar 2013
      Senior Specialist

      • Availability Management for Databases (using Log Shipping, Mirroring and Replication). • Monitoring and Basic Troubleshooting. • Daily activities based on SOP (Standard Operating Procedures) • Managing Logins/User Accounts. • Diagnosing Backup Failure and starting a failed Backup. • Starting and Stopping a SQL Services.• Identifying job history, starting and Stopping a job.• Check MSSQL Alert log and Windows Logs.• Monitor Daily Backups and do the basic checks on the Database.• Consolidating and sending out health check reports to clients.• Implementing Change Request. Show less

    • Accenture

      Apr 2013 - Sept 2016
      Senior Software Engineer

      • Working as MS SQL Server DBA for more than four years now. • Worked on different versions of SQL Server -2000, 2005, 2008 R2, 2012.• Good exposure on backup and restore. • Account provisioning, • High availability solutions -log shipping, mirroring and replication, Always On.• Performance tuning.• Like working on scripts and create reusable queries for daily tasks, using T-SQL and PowerShell.

    • Aon

      Sept 2016 - Mar 2019
      System Administrator
    • Aon

      Sept 2019 - now
      IND IT Lead - Technology Operations
  • Licenses & Certifications

    • MCTS

      Microsoft
      Jun 2011