Kunal Sinha
Senior Database Specialist, Release Management and Infrastructure Lead
Pune
Summary
- 16+ years of Experience as a Senior Microsoft SQL Database Administrator with notable success in Implementing/Directing a broad range of corporate IT initiatives while participating in detailed planning of information-technology initiatives. Focused on "best practices" approach to meet customer specific challenges, in-house business objectives, and support documentation, lam a highly passionate individual who thrives upon seeking new challenges through my career as a Database specialist, release and infrastructure management.
- Currently associated with Barclays Technology Centre of India, Pune, India for almost 8+ years and responsible for critical release, managing team, allocating works within team, and working on Major and high priority incidents and providing robust solutions to customers.
Overview
16
16
years of professional experience
Work History
Primary Database Specialist (IPMDM: Primary DBA)
Barclays Technology Centre of India
10.2016 - Current
- Experienced and highly skilled Database Specialist with over 9 years of expertise in database administration, and more than 2 years in release and infrastructure management.
- Demonstrated ability to ensure high availability, optimize performance, and oversee successful deployments across both cloud-based and on-premises environments.
- Implemented the Rubrik data protection solution for over 50 production databases, resulling in a 60% reduction in backup windows and achieving 100% compliance with recovery SLAS.
- Administered the Rubrik backup and recovery platform, overseeing daily backup operations exceeding 10TB and successfully conducting more than 95 disaster recovery tests without data loss.
- Testing identified vulnerabilities within communication protocols, leading to targeted improvements that strengthened overall resilence against actual threats.
- Knowledgeable in best practices for data security, ensuring compliance with legal and organizational data privacy policies. Well-versed in performance tuning concepts within SQL Server, including indexing, query optimization, wait types, performance counters, and profiler.
- Well-versed in performance tuning concepts within SQL Server, including indexing, query optimization, wait types, performance counters, profiler. and Extended Events.
- Experienced with ITIL concepts including Change, Incident, and Problem Management: participated in major incident calls with cross-functional teams. Planned and executed Disaster Recovery and Production Crossover Operations with application teams.
- Collaborated with cross -functional team (Security, IAM, Compliance team) to provide training on DAP, PAM and PACER so that they will understand its security standard and standard guideline as per User classification.
- Learning Python for infrastructure automation, with hands-on experience creating simple scripts for system monitoring and file managementtasks.
MSSQL Database Administrator (DBA)
Capgemini India Pvt. Ltd.
01.2013 - 08.2016
- In Database Administration for very large and complex databases in SQL Server 2012, SQL Server
2008 R2, 2008 and 2005. - Expertise in Always-On Availability Groups (AAG) and HA/DR configuration and Troubleshooting.
- Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
- Administering SQL Server High Availability and Disaster Recovery strategies.
- Implemented the new SQL Server 2012 mechanisms like data compression, online indexing.
- Contained Databases, security principals and AAG.
Experience in using DMV and dynamic management functions for finding out long running queries. - Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising nigh avallability.
- Experience in Disaster Recovery Planning and Security Management operations.
- Having hands on experience in DR processes including Log Shipping and Database Mirroring.
Worked on configuring SQL Server with minimum privileged access. - Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on
SAN using RAID levels. - Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
- Implemented Always-ON (AG) on SQL Server 2012 SP2 CU5
- Having Experience of Data center servers and handling 1.4 TB databases.
- Strong experience in mentoring team members and writing documentation.
- 24 X 7 Production Database on Call Support
MSSQL Database Administrator (DBA)
Zenith Monitoring Services Private Limited
02.2012 - 12.2012
- Working of DBAs and System Administrators at the Production Development Center in India (Mumbai): • Troubleshooting database and application issues (US) of production, development, and UAT servers. • Experience with DR solutions (e.g.)
- Troubleshooting Database and Application issue (US) of production, Development and UAT Servers
- Experience with DR solutions (eg. log shipping, Replication, mirroring, BCP etc.)
- Ensuring that backup, restore and recovery procedures are implemented and followed Design and implementation of database replication strategies for both internal and Disaster Recovery (DR) requirements.
- Ongoing database performance tuning and upgrades, including monitoring and evaluation of all database patches and service packs.
- Checking and reviewing maintenance plan history at more than 100+ production server.
- Worked on Replication (Transactional), Log Shipping, Clustering
- Worked on SQL Server Hardening closure for SQL Audit to Protect data from outside and inside attackers.
- Also, Knowledge of SSRS JOB Scheduling and emailing reports), SSIS (creating packages for transfer files) and SSAS (Backing up and transfer to the client monthly)
- Apart from SQL DBA handling some tasks of System Administrator including working on Page files.
Active directory and issue related port of SQL, IIS related issues. - Generate script for daily backup as per requirement and manage recovery module of the databases, backup including full, log, DifferentiaL
- Interact with the developers as well as with the clients through mailing and calling to provide 24*7 support.
MSSQL Database Administrator (DBA)
Shams HealthCare Software (Pvt.) Ltd.
01.2010 - 02.2012
- Responsible for leading as part of Implementation Technology System Management (ITSM) Team of DBA's and System Administrators at the development center in india (Nagpur).
- Responsible for running and maintaining in-house and customer SQL Servers and applications (100+
Responsible for assisting customers/ in-house users / developers for any SQL/ Windows issues. - Responsible for Quality testing and deployments of products on in-house and customer sites.
- Build data warehouse systems using Microsoft SQL Server and Microsoft Windows NT/2000/2003. Install, configure, fine-tune, optimize, and monitor SQL Servers on all 100+ customer sites.
- Manage users and security as per company needs (automated). Perform backups and restores (automated).
- Troubleshoot and monitor data and log growth usage for 100+ customers and 20+ terabytes.erform disaster recovery on various critical situations with minimal downtime and capacity
- Provide SQL Server training to customers and internal staff.
Worked on creating, rebuilding and re-organizing of Index. - Worked on some high availability techniques like Database Mirroring, Failover Clustering, Log Shipping and Replication.
Junior Associate MSSQL Database Administrator
Cometsol Infotech Pvt. Ltd.
06.2009 - 01.2010
- Install/ Configure / Fine tune /Optimize and monitor SQL Servers on all customer sites and in-house servers.
- Writing codes in Stored Procedures/Triggers/UDFs
- Using triggers to maintain the consistency of databases.
- Use of DTS to extract data.
- Building Complex Queries in T/SQL to generate reports.
- Optimizing the Stored Procedures using optimization techniques
- Maintain up to date documentation on system specifications and dataflow diagrams for each customer site.
- Automated Messages e-pages review for proactive resolution of issues such as low disk drive space, abnormal memory, and CPU usage.
Education
Master of Science - Computer Application
Visvesvaraya Technological University
Bangalore, India 04.2001 -
Bachelor of Science - Computer Science
GGSIPU
Delhi, India 04.2001 -
Skills
- Database Administrator: SQL Server 2022\2019\2017\2016\2014\2012\2008 R2 \ 2008 so on
MSSQL, PostgreSQL, Oracle (Beginner) - Release Management: Jenkins, GitLab, Docker
Scripting and Automation: Python, Powershell and Bash
Collaboration Tools: Jira (Genjira \ EQJira), Confluence, Teams, SharePoint, Service First - Platforms: Microsoft Windows" operating systems from 9x-2003\2008\2012\2016\2019, Microsoft
SQL Server 65-2022, IIS, AWS
- Networking: TCP/IP, Token Ring, FDDI, VPN, HIPPA, Fiber & ISCSI SANS
- Other Competencies: Network, Systems & Data Security, Healthcare Security Regulatory
Adherence, Data Integrity/Recovery, Disaster Recovery Planning, Contingency Planning, Research & Development, Risk Assessment, Cost Benefits Analysis, Bank Policy ITRS (installation and configuration of monitoring tool - Documentation and Reporting: Technical writing, release notes with RunBook, SOPs, CookBook
Timeline
Primary Database Specialist (IPMDM: Primary DBA)
Barclays Technology Centre of India
10.2016 - Current
MSSQL Database Administrator (DBA)
Capgemini India Pvt. Ltd.
01.2013 - 08.2016
MSSQL Database Administrator (DBA)
Zenith Monitoring Services Private Limited
02.2012 - 12.2012
MSSQL Database Administrator (DBA)
Shams HealthCare Software (Pvt.) Ltd.
01.2010 - 02.2012
Junior Associate MSSQL Database Administrator
Cometsol Infotech Pvt. Ltd.
06.2009 - 01.2010
Master of Science - Computer Application
Visvesvaraya Technological University
04.2001 -
Bachelor of Science - Computer Science
GGSIPU
04.2001 -
Similar Profiles
Reena KolheReena Kolhe
Assistant Vice President (AVP) at BARCLAYS BANK (Barclays Technology Centre India Pvt. Limited)Assistant Vice President (AVP) at BARCLAYS BANK (Barclays Technology Centre India Pvt. Limited)
KESHAB RABIDASKESHAB RABIDAS
App Lead at Barclays Technology Centre IndiaApp Lead at Barclays Technology Centre India
Neeta NayakNeeta Nayak
Assistant Vice President, UAT - Markets Pre-Trade APAC at Barclays Global Technology Centre IndiaAssistant Vice President, UAT - Markets Pre-Trade APAC at Barclays Global Technology Centre India
Niraj DigheNiraj Dighe
Lead Software Engineer at Cloud Software GroupLead Software Engineer at Cloud Software Group
Shubham NayarShubham Nayar
Senior Associate 2 at Acko General InsuranceSenior Associate 2 at Acko General Insurance