Avishek Rajbanshi
Azure DevOps, DevOps , MSSQL DBA
Kolkata
Summary
Play a responsible role in a DevOps, Azure DevOps, Azure SQL Server, Azure Administrator, and MSSQL Database Administration Professional with more than 9+ years of experience.
Overview
8
8
years of professional experience
9
9
years of post-secondary education
4
4
Certifications
Work History
I.T. Analyst
TATA Consultancy Services Limited
kolkata
04.2021 - Current
- Maintained Git workflows for version control (Source Code Management)
- Developed and maintained automated CI/CD pipelines for code deployment using Jenkins
- Provisioned Servers and deployed features using Puppet/Chef/ Ansible
- Built and deployed Docker container for implementing Microservice Architecture from Monolithic Architecture
- Orchestrated Docker container cluster using Kubernetes
- Responsible for installation and configuration of Azure services
- Translate business requirements to technical
- Assist with all stages of the test,development and maintenance
- Manage Azure subscriptions
- Manage role-based access control
- Implement and manage storage
- Import and export data to Azure
- Implement Azure backup
- Deploy and manage virtual machines ( Create and configure VMs for Windows and Linux)
- Manage VM's backups
- Configure and manage virtual networks
- Monitor and troubleshoot
- Create and configure a Network Security Group
- Implement Azure load balancer
- Integrate on-premises network with Azure virtual network
- Database Design, Programming, Development and Implementation of Client-Server Applications & database systems using MSSQLSERVER 2019/2017/2016/2014/ 2012 /2008[R2]
- Installation, Configuration and Upgradation of Microsoft SQL Server Databases
- Proficient in SQL Server and T-SQL (DDL and DML) in Constructing Tables and Normalization. Troubleshooting all types of database related problem and backup related problem
- Experience in Implementing SQL Server Security and Object permissions like maintaining Database Authentication Modes, Creation of Users, Configuring Permissions, and Assigning Roles to the Users
- Extensive Experience in Backup Plans and implementing various types of Backups using Database Maintenance Plan
- Monitoring of Database size and disk space
- Setup (Log Shipping, Mirroring, Cluster, Always On) high availability solution for the databases.
- SQL Performance Method and SQL server Utilities. Auditing Data and resolving heavy/complex running query.
- Creating various report in SSRS, SSIS Packages as per company need.
Senior System Engineer
Cognizant
kolkata
09.2019 - 04.2021
- Database Design, Programming, Development and Implementation of Client-Server Applications & database systems using MSSQLSERVER 2019/2017/2016/2014/ 2012 /2008[R2]
- Installation, Configuration and Upgradation of Microsoft SQL Server Databases
- Proficient in SQL Server and T-SQL (DDL and DML) in Constructing Tables and Normalization. Troubleshooting all types of database related problem and backup related problem
- Experience in Implementing SQL Server Security and Object permissions like maintaining Database Authentication Modes, Creation of Users, Configuring Permissions, and Assigning Roles to the Users
- Extensive Experience in Backup Plans and implementing various types of Backups using Database Maintenance Plan
- Monitoring of Database size and disk space
- Setup (Log Shipping, Mirroring, Cluster, Always On) high availability solution for the databases.
- SQL Performance Method and SQL server Utilities. Auditing Data and resolving heavy/complex running query.
- Creating various report in SSRS, SSIS Packages as per company need.
Software Application Support L1A
National informatic Center
kolkata
11.2017 - 09.2019
- Database Design, Programming, Development and Implementation of Client-Server Applications & database systems using MSSQLSERVER 2014/ 2012 /2008[R2]
- Installation, Configuration and Upgradation of Microsoft SQL Server Databases
- Proficient in SQL Server and T-SQL (DDL and DML) in Constructing Tables and Normalization. Troubleshooting all types of database related problem and backup related problem
- Experience in Implementing SQL Server Security and Object permissions like maintaining Database Authentication Modes, Creation of Users, Configuring Permissions, and Assigning Roles to the Users
- Extensive Experience in Backup Plans and implementing various types of Backups using Database Maintenance Plan
- Monitoring of Database size and disk space
- SQL Performance Method and SQL server Utilities. Auditing Data and resolving heavy/complex running query.
Technical Analyst
Global Audio Text Solutions Pvt Ltd
Kolkata
11.2014 - 09.2017
- Database Design, Programming, Development and Implementation of Client-Server Applications & database systems using MSSQLSERVER 2014/ 2012 /2008[R2]
- Installation, Configuration and Upgradation of Microsoft SQL Server Databases
- Proficient in SQL Server and T-SQL (DDL and DML) in Constructing Tables and Normalization. Troubleshooting all types of database related problem and backup related problem
- Experience in Implementing SQL Server Security and Object permissions like maintaining Database Authentication Modes, Creation of Users, Configuring Permissions, and Assigning Roles to the Users
- Extensive Experience in Backup Plans and implementing various types of Backups using Database Maintenance Plan
- Monitoring of Database size and disk space
- SQL Performance Method and SQL server Utilities. Auditing Data and resolving heavy/complex running query.
Education
Diploma in Software Engineering And Technology -
NIIT
India , West Bengal , Kolkata 04.2012 - 10.2015
Bachelor of Journalism And IT - Information Technology And Mass Communication
WB State University
India , West Bengal , Kolkata 04.2009 - 03.2012
Higher Secondary -
WBCHSE
India , West Bengal , Kolkata 04.2007 - 03.2009
Madhyamik -
WBSE
India , West Bengal , Kolkata 04.2006 - 03.2007
Skills
Azure Administrator
Certification
AZ-900 From Simplilearn
Timeline
AZ-400 From Simplilearn
08-2022
AZ-204 From Simplilearn
07-2022
AZ-104 From Simplilearn
06-2022
AZ-900 From Simplilearn
03-2022
I.T. Analyst
TATA Consultancy Services Limited
04.2021 - Current
Senior System Engineer
Cognizant
09.2019 - 04.2021
Software Application Support L1A
National informatic Center
11.2017 - 09.2019
Technical Analyst
Global Audio Text Solutions Pvt Ltd
11.2014 - 09.2017
Diploma in Software Engineering And Technology -
NIIT
04.2012 - 10.2015
Bachelor of Journalism And IT - Information Technology And Mass Communication
WB State University
04.2009 - 03.2012
Higher Secondary -
WBCHSE
04.2007 - 03.2009
Madhyamik -
WBSE
04.2006 - 03.2007
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Ramachandran PalaniappanRamachandran Palaniappan
SAP S4 ABAP, OData, CDS , RAP at Tata Consultancy Services LimitedSAP S4 ABAP, OData, CDS , RAP at Tata Consultancy Services Limited
Vinay PathakVinay Pathak
Executive at Tata Consultancy Services LimitedExecutive at Tata Consultancy Services Limited