Sambit Dhar

Around 12+ years of experience as a SQLDB Administrator Specialized in database solutioning, implementing end-to-end database solutions including scoping/estimation, base lining, and Production Support. Experienced in various SDLC project phases: Requirement/System gathering, Requirement/System Analysis, Functional Specification, Business Logic's, Design, Layered Architecture, Testing, Performance tuning, Documentation, Implementation and Maintenance. Involved in Designing and Implementing high-availability solutions. Experienced working as a Lead SQLDB Administrator on various environments like NPE, UST/CT and PROD. Experienced in database administration, database up-gradation, cluster build/implementation processes. Extensive experience in designing and implementing high-availability solutions. Log shipping, Mirroring Replication & Always on. Configured and managed various AWS services like EC2, EKS, VPC, RDS, S3, Glacier, CloudWatch, cloud front. Worked on On-prem to Azure Migration in SQL server. Managing the technical bridges for troubleshooting of applications and services hosted in AWS environment. Used MongoDB third party tools (ROBO, MONGO, MONGOOWL, MONGOVUE) and Mongo built in binaries to monitor and analyse the performance of MongoDB. worked in the areas of database auditing, performance tuning. Experienced in implementing database security policies in SQL 2005, 2008, 2008 R2 and 2012, SQL2014, SQL2016, SQL2018 and MYSQL. Extensive experience in designing MongoDB multi sharded cluster and monitoring with MNS and Mongo utilities. Highly skilled in Oracle PL/SQL and Oracle server-side programming which includes SQL, PL/SQL Packages. Extensively worked in T-SQL, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views Temporary tables, and Object-Oriented PL/SQL Programming. Experienced in Implementing new designed solutions to build a new database environment. Highly skilled to fine tune the clusters for best performance. Experienced in writing PL/SQL jobs and schedules via oracle scheduler to run daily basis. Experienced in Installing MongoDB on physical machines, virtual machines as well as AWS. Experienced in the Backup and recovery processes, Database optimization, and security maintenance. Experienced in Oracle Database Migration in AWS Cloud. Experienced in MYSQL replication setup and administration on Master-Slave and Master-Master. Experienced in patching, refreshing and migration processes. Implemented/installed/configured SQL Server 2008R2/2008/2005/2012 /2016 on multi node windows cluster. Experienced in Managing the technical bridges for troubleshooting of applications and services hosted in AWS environment. Migrating On-Prem DBs to Azure SQL Databases (Singleton) Having knowledge on Azure Elastic Pool Databases and Elastic Jobs. Experience in working with Point-In-Time restores in Azure. Configured Long Term Retention (LTR) backups for Mission critical databases. Configured On-Premises SQL database backups to Azure using Microsoft Azure Backup tool. TDPSQL Configuration for Online Backup of Databases Knowledge of Third Party tool – Lite speed SQL server Database Migration as per their edition and version to save license cost. Service pack and patch deployment and troubleshoot their issues. Experience to design the logical and physical database design. Strong background in database utility processing and backup/recovery procedures. Familiar with applications performance tuning and access path management through proper indexing. Maintain documentation on system software implementation strategies as new releases of OS and RDBMS become available. Define and enforce adherence to database standards. Experience with replication (transactional, merge, snapshot). Experience installing/maintaining Microsoft Clustering technologies and SQL Server. This includes multi-instance configurations. Knowledge of SQL Server utilities (Query Analyzer, Profiler). Experience in Performance Troubleshooting. Ability to communicate effectively and consistently with all levels of the organization, and to work independently without direct supervision.

Working as SQL Server & Sybase DBA Senior Software Engineer at HCL, specializing in production support, database solutioning, implementing end-to-end database solutions including scoping/estimation and base lining. I'm certified on SQL Server 2008 as MCTS-70-432, SQL Server 2012 – 70-462 and ITIL V3 Certified. I have 12 years of experience in database administration, database up gradation, cluster build/implementation, designing/implementing high-availability solutions, database auditing, performance tuning and defining/implementing database security policies in SQL 2005, 2008, 2008 R2 and 2012, SQL2014, SQL2016, SQL2019.