CHIRANJIT CHATTERJEE
Kolkata
Summary
In pursuit of challenging assignments that would facilitate the maximum utilization and application of my broad skills and expertise in making a positive difference to the organization
Young, energetic and result oriented GCP Devops Engineer with 9+ years of experience with diverse roles in the IT arena. Persuasive communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management; highly ethical, trustworthy and discrete.
Overview
11
11
years of professional experience
Work History
Sr. Associate - Projects
CTS
06.2023 - Current
GCP Migration support
British Telecommunications plc.
01.2021 - 06.2023
- GCP Acceleration project uses cloud platform projects to migrate traditional Data Warehouse to GCP
- Data from on-prem servers are migrated and stored in BigQuery and presented to business users with a variety of analytics options
- Creation of Service accounts, Buckets, Composers, DF job, Cloud Functions, Datasets, Tables for Dev/Test and Prod using Terraform
- Using CI/CD (Gitlab) for automated build & deployment processes
- Creation and scheduling of DAGs in Airflow
- Daily monitoring of Alerts for PROD
- Managing Users on Google IAM Service and providing them appropriate permissions
- Working knowledge on creating VPC networks, subnets, composer and firewalls rules
Tata Consultancy Services Ltd.
03.2014 - 06.2023
- 7 years of SQL Server database administration, Windows IIS, WebLogic and Linux experience (2014-2021 Aug)
- Worked on Incidents and change requests
- Worked with windows and UNIX team for server issues
- Performance monitoring and troubleshooting
Application support and maintenance
British Telecommunications plc.
01.2014 - 01.2021
- Resolve Corizon is a front-end business Critical Application developed for Technical Help Desk (THD) Advisors
- The application is a part of BT which consists of several direct customer/end user facing applications where L2C and T2R journeys are supported via multiple applications
- Different BT Products - BT Sports, PSTN, Broadband, BT TV are provisioned and diagnosed through these platforms to ensure exceptional product cycles for the customers and provide continuous service
- Application is based on Windows servers where 2 web nodes communicate with the Database and backend system
- High availability as well as zero tolerance in data consistency is the key for the application to minimize any customer impact
- Estimation of the DB capacity along with analysis on the traffic Volumes and resilient DB Architecture
- Configure the SQL agent jobs required for preparing business reports, production activities and ensure no failure of jobs
- Create SSIS/DTS packages for automation, reporting services
- Proper monitoring and health checks for all the databases in the platform
- Create automated monitoring scripts and alert system to provide proactive alert to support team
- Monitoring of application database health and provide suggestions to improve performance
- Trouble shooting for Capacity Issues
- Table index fragmentation analysis and statistics check
- Assist application team to predict impact analysis of any change on the live database and Database performance tuning
- Data analysis and reporting according to Business requirement
Education
B-Tech - Information Technology
WBUT
01.2013
Higher Secondary - Science
ISC
01.2009
Secondary - Science
ICSE
01.2007
Skills
- Scripting Language
- Telecom
- Cloud DevOps
- Unix/Linux shell scripting
- Cloud Technologies
- GCP
- Database
- SQL Server 2008 R2
- Oracle
- MySQL
- Configuration Management
- GITLAB
- Operating System
- Red-hat Linux
- Solaris
- Windows 2008
Personal Information
- Date of Birth: 02/19/91
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Acknowledgment
I hereby affirm that all the information furnished above is accurate and true to the best of my knowledge., Kolkata, 07/05/23
Additional Knowledge
- Basic Java Understanding, Kolkata, IBM, 2009, 2009
- ASP.net Training, Siliguri
- 2011, 2011
- 1Z0-051-Oracle Database 11g: SQL Fundamentals, Kolkata, TCS, 2015, 2015
- 1Z0-052: Oracle Database 11g: Administration, Kolkata, TCS, 2017, 2017
Timeline
Sr. Associate - Projects
CTS
06.2023 - Current
GCP Migration support
British Telecommunications plc.
01.2021 - 06.2023
Tata Consultancy Services Ltd.
03.2014 - 06.2023
Application support and maintenance
British Telecommunications plc.
01.2014 - 01.2021
B-Tech - Information Technology
WBUT
Higher Secondary - Science
ISC
Secondary - Science
ICSE
Similar Profiles
Mohit KumarMohit Kumar
Service Team Leader at CTSService Team Leader at CTS
Brian FairchildBrian Fairchild
Fiber Optic Technician at CTSFiber Optic Technician at CTS
ArulNandhini MoorthyArulNandhini Moorthy
Data Analyst/Developer at CTSData Analyst/Developer at CTS