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
Azure SQL Server
Azure DevOps
DevOps
Git
Jenkins
Puppet
Chef
Ansible
Docker container
MSSQL SERVER
Python
Basic Knowledge MySQL
Basic Knowledge PostgreSQL
PowerShell Script
Linux
Windows
Basic Knowledge Oracle
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