Subhrangshu Chakraborty
Kolkata
Summary
Top-notch Database Administrator with solid background in designing and implementing data management solutions. Strong knowledge of database security, backup and recovery. Collaborative and dedicated to improving and optimizing database performance.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Database Administrator
Tata Consultancy Services Ltd
06.2021 - Current
- Administered both On-Premise and Cloud based SQL servers, Primarily handling Azure SQL Servers on the cloud side.
- Conducted SQL Server patching activity, troubleshooting issues related to databases and data warehouses as well, performing data refresh for production and non production databases along with increasing experience in writing SQL queries, working on stored procedures, debugging unresolved database object references.
- Performed query tuning by identifying time and resource consuming queries which have caused bottlenecks and led to 90%+ Server CPU usage for a considerable amount of time. Optimized performance by implementing indexing and delaying the services running which caused bottlenecks/deadlocks and creating performance monitors, thereby improving the query performance and reducing the CPU usage by 40% as well.
- Monitored mirroring databases, Always-On application databases, failover clusters with additional experience of setting up CDC services as per client requirements.
- Ensured database security with implementation of role-based access control and regular vulnerability assessments.
- Implemented comprehensive data retention policies that met regulatory requirements while minimizing storage costs.
- Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks. I have also worked on setting up Database email services.
- Increased efficiency in software development processes through effective collaboration with developers to design databases that support application requirements.
- Experienced in working with Azure cloud server and database services like, Automation, Azure Blob Storage, Azure Data Studio, Azure Audit services etc. Automated scale up and scale down jobs for Azure SQL Databases using powershell script and automated the process using Azure Automation Service.
- Conducted regular audits of data quality, identifying inconsistencies and implementing corrective actions as necessary.
- Maintained high levels of customer satisfaction by consistently meeting service level agreements for database performance and availability.
Education
Bachelor of Technology - Electronics And Communication Engineering
University of Engineering And Management
05.2021
Higher Secondary - Science
Techno India Group Academia
Prantik, Birbhum05.2017
Secondary Education - General Studies
Techno India Group Public School
Prantik, Birbhum05.2015
Skills
- Communication
- Core Java
- C Programming
- Python scripting
- Powershell Scripting
- Microsoft Azure
- T-SQL/MySQL
- AWS
- Data Security
- Cloud Database Services
- Query Optimization
- Database Administration
Accomplishments
- Received certification for best performing employee for the time period of April 2022 - April 2023.
Certification
- Certified AWS Cloud Practitioner at Amazon Web Services (Sep 2023 — Sep 2026)
- Qualified in the First round of Codevita season 9 at TCS
- Certified in Java (Basic),Python (Basic), SQL(Basic) and Problem Solving(Basic) at Hackerrank.
- Earned completion certificate of courses “Python for everybody” and “Python Data Structures” from Coursera.
- Earned Course completion certification on Programming Foundation: Object Oriented Design from Linkedin
Hobbies
Football
Singing
Coding
Timeline
Database Administrator
Tata Consultancy Services Ltd
06.2021 - Current
Bachelor of Technology - Electronics And Communication Engineering
University of Engineering And Management
Higher Secondary - Science
Techno India Group Academia
Secondary Education - General Studies
Techno India Group Public School
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
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Ankan BeraAnkan Bera
Application Architect at WiproApplication Architect at Wipro