Indrajit Mukherjee
Infrastructure Architect at Telmore- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Bengali -
-
Hindi -
Topline Score
Bio
Credentials
-
ITIL
- -
MCITP
- -
MCSA
-
Experience
-
Telmore
-
Denmark
-
Telecommunications
-
100 - 200 Employee
-
Infrastructure Architect
-
Sep 2019 - Present
Architecting infrastructure to Azure cloud, forming a cloud native application and infra. Terraforming infrastructure to Azure cloud. Migrating on-premise infra to cloud following cloud best practice. Automating Infra and application deployment using Ansible, PowerShell, Terraform language. Using Jenkins and writing groovy pipeline definition as CICD tool. Love to make my database faster. Server and infrastructure optimization along with Query optimization is my hobby… Show more Architecting infrastructure to Azure cloud, forming a cloud native application and infra. Terraforming infrastructure to Azure cloud. Migrating on-premise infra to cloud following cloud best practice. Automating Infra and application deployment using Ansible, PowerShell, Terraform language. Using Jenkins and writing groovy pipeline definition as CICD tool. Love to make my database faster. Server and infrastructure optimization along with Query optimization is my hobby now. Working knowledge with various performance tuning tool and mechanism, Database Performance Analyzer, Sentry plan explorer etc working knowledge helping customer to understand and easily find out the pain area in database performance problem, with providing solution for those. Following Glenn Berry, Brent Ozar, Paul Randal's blog is a passion. Experienced in designing HADR solution for business critical database environments in both Physical and Virtual environments, with high OLTP and DW frameworks. With help of customized DBATOOL, my SQL migration method is fully automated and implemented in customer domain. Love data modelling and Visualization using Power BI. Created a lot of in house reporting mechanism in Power BI report server for both enterprise reporting and monitoring etc. Experienced in MongoDB and RavenDB , with three node replication environment for Production. Creating dashboards for real time monitoring, making proper architecture for LOG and Metric monitoring using various leading tools AppDynamics, ELK stack, Azure AppInsight, Grafana etc. Show less Architecting infrastructure to Azure cloud, forming a cloud native application and infra. Terraforming infrastructure to Azure cloud. Migrating on-premise infra to cloud following cloud best practice. Automating Infra and application deployment using Ansible, PowerShell, Terraform language. Using Jenkins and writing groovy pipeline definition as CICD tool. Love to make my database faster. Server and infrastructure optimization along with Query optimization is my hobby… Show more Architecting infrastructure to Azure cloud, forming a cloud native application and infra. Terraforming infrastructure to Azure cloud. Migrating on-premise infra to cloud following cloud best practice. Automating Infra and application deployment using Ansible, PowerShell, Terraform language. Using Jenkins and writing groovy pipeline definition as CICD tool. Love to make my database faster. Server and infrastructure optimization along with Query optimization is my hobby now. Working knowledge with various performance tuning tool and mechanism, Database Performance Analyzer, Sentry plan explorer etc working knowledge helping customer to understand and easily find out the pain area in database performance problem, with providing solution for those. Following Glenn Berry, Brent Ozar, Paul Randal's blog is a passion. Experienced in designing HADR solution for business critical database environments in both Physical and Virtual environments, with high OLTP and DW frameworks. With help of customized DBATOOL, my SQL migration method is fully automated and implemented in customer domain. Love data modelling and Visualization using Power BI. Created a lot of in house reporting mechanism in Power BI report server for both enterprise reporting and monitoring etc. Experienced in MongoDB and RavenDB , with three node replication environment for Production. Creating dashboards for real time monitoring, making proper architecture for LOG and Metric monitoring using various leading tools AppDynamics, ELK stack, Azure AppInsight, Grafana etc. Show less
-
-
-
Tata Consultancy Services
-
India
-
IT Services and IT Consulting
-
700 & Above Employee
-
SQL Database Administrator
-
Aug 2014 - Aug 2019
Infra DBA role: Analyse, rectify and resolve SQL Server-related database incidents and problems within SLAs, Provide RCA for Major Incidents. Working on around 300 PROD/TEST instances including SSAS/SSRS/SSIS and having clustering, mirroring setup with SQL 2005,2008, 2008R2, 2012, 2014. Working on issues for latest HADR Always ON technology with two node cluster. Handling capacity issues with proper file layout management and growth for database log files. Any… Show more Infra DBA role: Analyse, rectify and resolve SQL Server-related database incidents and problems within SLAs, Provide RCA for Major Incidents. Working on around 300 PROD/TEST instances including SSAS/SSRS/SSIS and having clustering, mirroring setup with SQL 2005,2008, 2008R2, 2012, 2014. Working on issues for latest HADR Always ON technology with two node cluster. Handling capacity issues with proper file layout management and growth for database log files. Any kind of access related issues comes from APP/DEV team and user perspective. Having working knowledge on DB Mail. Handling P1/P2 issues with customer calls and SRTs. Handling cluster related issues, recently worked on a unstable cluster issues with two node active-active cluster having unexpected failover occurrences. Performance related issues from server side, and related to SQL server. Working knowledge on profiler, performance dashboard, perfmon etc tools. Build activity: SQL installation (silent method) for SQL 2008R2, 2012, 2014. Keeping all documented for future use. Up gradation with both in-place and side by side method. Pre-checks and Post checks activity while installation. Closely working with Wintel team to manage and build clustered environment to make the cluster disks and other resources ready for the cluster. Closely working with APP team to get the proper requirement for SQL server which makes us decide proper sizing and version of SQL server and database. Working on P2P activity for various standalone and cluster SQL environment having total data size of around 37 TB max Physical HP platform. Building proper migration plans with back out plan as well. Working on CISCO UCS platform database migration where SQL database server migrated to physical rack to CISCO UCS boxes. Building Proper plan with backout plan as well. Working on P2V projects with VMWare platform and clustered datastore environment. Show less Infra DBA role: Analyse, rectify and resolve SQL Server-related database incidents and problems within SLAs, Provide RCA for Major Incidents. Working on around 300 PROD/TEST instances including SSAS/SSRS/SSIS and having clustering, mirroring setup with SQL 2005,2008, 2008R2, 2012, 2014. Working on issues for latest HADR Always ON technology with two node cluster. Handling capacity issues with proper file layout management and growth for database log files. Any… Show more Infra DBA role: Analyse, rectify and resolve SQL Server-related database incidents and problems within SLAs, Provide RCA for Major Incidents. Working on around 300 PROD/TEST instances including SSAS/SSRS/SSIS and having clustering, mirroring setup with SQL 2005,2008, 2008R2, 2012, 2014. Working on issues for latest HADR Always ON technology with two node cluster. Handling capacity issues with proper file layout management and growth for database log files. Any kind of access related issues comes from APP/DEV team and user perspective. Having working knowledge on DB Mail. Handling P1/P2 issues with customer calls and SRTs. Handling cluster related issues, recently worked on a unstable cluster issues with two node active-active cluster having unexpected failover occurrences. Performance related issues from server side, and related to SQL server. Working knowledge on profiler, performance dashboard, perfmon etc tools. Build activity: SQL installation (silent method) for SQL 2008R2, 2012, 2014. Keeping all documented for future use. Up gradation with both in-place and side by side method. Pre-checks and Post checks activity while installation. Closely working with Wintel team to manage and build clustered environment to make the cluster disks and other resources ready for the cluster. Closely working with APP team to get the proper requirement for SQL server which makes us decide proper sizing and version of SQL server and database. Working on P2P activity for various standalone and cluster SQL environment having total data size of around 37 TB max Physical HP platform. Building proper migration plans with back out plan as well. Working on CISCO UCS platform database migration where SQL database server migrated to physical rack to CISCO UCS boxes. Building Proper plan with backout plan as well. Working on P2V projects with VMWare platform and clustered datastore environment. Show less
-
-
-
Capgemini
-
France
-
IT Services and IT Consulting
-
700 & Above Employee
-
Consultant
-
Jun 2013 - Jun 2014
SQL DB transition project and operation support: Working as a MS SQL Server DBA with DBA Support Team that provides 24x5 production supports plus a 2day weekend on-call support for Client. Daily Health check for all PROD servers including Database size, Data file/Log file full, CPU and Memory counters and disk space issues. Checking for any blockings in SQL servers. Worked in a transition project where database server had been migrated within different domain and we… Show more SQL DB transition project and operation support: Working as a MS SQL Server DBA with DBA Support Team that provides 24x5 production supports plus a 2day weekend on-call support for Client. Daily Health check for all PROD servers including Database size, Data file/Log file full, CPU and Memory counters and disk space issues. Checking for any blockings in SQL servers. Worked in a transition project where database server had been migrated within different domain and we had to create exact replica of databases by restoring the backup along with all user migration within different domain providing same access in SQL database. Checking for any failure in maintenance jobs and taking daily/weekly backup as per backup strategy. Monitoring Log shipping and troubleshooting for any kind of issues. Monitoring mirroring failures and real time synchronization issues. Started working on Oracle server’s health checks and working on oracle DBA beginner with having basic knowledge of Oracle server architecture. Show less SQL DB transition project and operation support: Working as a MS SQL Server DBA with DBA Support Team that provides 24x5 production supports plus a 2day weekend on-call support for Client. Daily Health check for all PROD servers including Database size, Data file/Log file full, CPU and Memory counters and disk space issues. Checking for any blockings in SQL servers. Worked in a transition project where database server had been migrated within different domain and we… Show more SQL DB transition project and operation support: Working as a MS SQL Server DBA with DBA Support Team that provides 24x5 production supports plus a 2day weekend on-call support for Client. Daily Health check for all PROD servers including Database size, Data file/Log file full, CPU and Memory counters and disk space issues. Checking for any blockings in SQL servers. Worked in a transition project where database server had been migrated within different domain and we had to create exact replica of databases by restoring the backup along with all user migration within different domain providing same access in SQL database. Checking for any failure in maintenance jobs and taking daily/weekly backup as per backup strategy. Monitoring Log shipping and troubleshooting for any kind of issues. Monitoring mirroring failures and real time synchronization issues. Started working on Oracle server’s health checks and working on oracle DBA beginner with having basic knowledge of Oracle server architecture. Show less
-
-
-
Tech Mahindra
-
IT Services and IT Consulting
-
700 & Above Employee
-
Business Analyst S-2
-
Aug 2012 - May 2013
• Working as a MS SQL Server DBA with DBA Support Team that provides 24x5 production supports plus a 2day weekend on-call support for the Microsoft Corporation application. • Holding 13 applications with different functionality and provide SQL end support also sometimes IIS support confirming application stability. • Ensuring 99.99% server uptime except the scheduled downtime. • Resolving the issues related to database and connectivity of the server in stipulated time… Show more • Working as a MS SQL Server DBA with DBA Support Team that provides 24x5 production supports plus a 2day weekend on-call support for the Microsoft Corporation application. • Holding 13 applications with different functionality and provide SQL end support also sometimes IIS support confirming application stability. • Ensuring 99.99% server uptime except the scheduled downtime. • Resolving the issues related to database and connectivity of the server in stipulated time depending on the priority of the issue. • Monitoring and troubleshooting the DB related issues. • Experience in troubleshooting and resolving database performance issues, blocking and deadlocking issues, • Troubleshooting any kind of log shipping issues, LS jobs failure monitoring and resolving. • Troubleshooting mirroring failures. • Troubleshooting replication issues, latency monitoring, resolving agent failures. • Memory management - Detect and troubleshoot SQL Server related CPU, Memory, I/O, disk space and other resource contention using Dashboard and all. • Monitor Performance with SQL Profiler, Windows Perfmon. • Disk space Planning and Management in all the servers. Also getting SCOM alerts on server health issues and actively working on those. • Closely working with the problem management team and the Engg team to fix the bugs that are reported in the application. Show less • Working as a MS SQL Server DBA with DBA Support Team that provides 24x5 production supports plus a 2day weekend on-call support for the Microsoft Corporation application. • Holding 13 applications with different functionality and provide SQL end support also sometimes IIS support confirming application stability. • Ensuring 99.99% server uptime except the scheduled downtime. • Resolving the issues related to database and connectivity of the server in stipulated time… Show more • Working as a MS SQL Server DBA with DBA Support Team that provides 24x5 production supports plus a 2day weekend on-call support for the Microsoft Corporation application. • Holding 13 applications with different functionality and provide SQL end support also sometimes IIS support confirming application stability. • Ensuring 99.99% server uptime except the scheduled downtime. • Resolving the issues related to database and connectivity of the server in stipulated time depending on the priority of the issue. • Monitoring and troubleshooting the DB related issues. • Experience in troubleshooting and resolving database performance issues, blocking and deadlocking issues, • Troubleshooting any kind of log shipping issues, LS jobs failure monitoring and resolving. • Troubleshooting mirroring failures. • Troubleshooting replication issues, latency monitoring, resolving agent failures. • Memory management - Detect and troubleshoot SQL Server related CPU, Memory, I/O, disk space and other resource contention using Dashboard and all. • Monitor Performance with SQL Profiler, Windows Perfmon. • Disk space Planning and Management in all the servers. Also getting SCOM alerts on server health issues and actively working on those. • Closely working with the problem management team and the Engg team to fix the bugs that are reported in the application. Show less
-
-
-
Infosys
-
India
-
IT Services and IT Consulting
-
700 & Above Employee
-
SQL DBA
-
Mar 2010 - Aug 2012
SQL Server DBA with three years of IT experience, more than two years in Database Administration, Support of MS SQL Server 2008R2,2008,2005,2000 databases in Production, Testing, Development, Replication & Cluster Server Environments. • Experience in Database administration activities like Installation, Configuration, Backup & Recovery, and Performance Tuning, High Availability features Log Shipping, Mirroring, Replication and Clustering. • Experience in providing 24x7 Production… Show more SQL Server DBA with three years of IT experience, more than two years in Database Administration, Support of MS SQL Server 2008R2,2008,2005,2000 databases in Production, Testing, Development, Replication & Cluster Server Environments. • Experience in Database administration activities like Installation, Configuration, Backup & Recovery, and Performance Tuning, High Availability features Log Shipping, Mirroring, Replication and Clustering. • Experience in providing 24x7 Production Support. • Experience in Upgrading MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2005 to MS SQL Server 2008 R2. • Experience in implementing different types of Replication models like Snapshot, Merge and Transactional in SQL Server 2008/2008 R2 • Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005 databases and MS SQL Server 2008 R2 used as DR solution. • Experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster in Windows 2008 R2 Datacenter, Windows 2008 R2 Enterprise, Windows Server 2008 Datacenter, and Windows 2008 Enterprise. • Experience in Performance Tuning, troubleshooting, backup and restore procedures. • Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors. • Monitoring Dashboard Reports for Performance Tuning and finding bottlenecks in database. • Worked with Third Party Backup solutions like SQL Litespeed for MS SQL Server. • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
-
-
Backup Administrator
-
Sep 2009 - Mar 2010
Configuring and Taking Backups of Production Servers using Symantec Backup Exec 11d application and Microsoft Data Protection Manager 2007 and 2010. Managing and monitoring the backup Jobs on daily basis. Responsible for successful completion of Backup jobs of all Production servers on Tapes and disks. Backup Level 2 Troubleshooting, Scheduling backups - Daily, weekly and Monthly Summarizing daily issue and handover to tier-3 team. Prepare technical documentation Preparing… Show more Configuring and Taking Backups of Production Servers using Symantec Backup Exec 11d application and Microsoft Data Protection Manager 2007 and 2010. Managing and monitoring the backup Jobs on daily basis. Responsible for successful completion of Backup jobs of all Production servers on Tapes and disks. Backup Level 2 Troubleshooting, Scheduling backups - Daily, weekly and Monthly Summarizing daily issue and handover to tier-3 team. Prepare technical documentation Preparing weekly and monthly work report Acting as SPOC, handling client's meeting Managing Network/server Infrastructure 2. Project Name: Microsoft Remote Change Management Client: Microsoft Corporation, Redmond (U.S.A) Role: Network/ Windows Administrator DNS (Internal/External), WINS Mapping. Server rebuild with Win2003, 2008 and 2008R2 Installation of Service Pack/Hot fixes as per the user requirements. NLBS Cluster configuration in servers on win2k3 and win2k8. Creating Virtual Machines using SCVMM 2008 and Hyper-V Manager Version: 6.1.7100.0. Promoting and Decommissioning of Virtual Servers and Physical Servers. Renaming and Rehoming Virtual machines.
-
-
Education
-
2004 - 2008
2008 West Bengal University of Technology B.TECH
of Passing Institute, Percentage -
2004 - 2008
2008 West Bengal University of Technology B.TECH
of Passing Institute, Percentage
Community
