Saroj Kumar Das Email & Phone Number

Texas, United States

United States

Dallas, Texas, United States

Dallas/Fort Worth Area

Irving, Texas

New Jersey

* Involved in transition of application databases from NYL to TCS Infrastructure Service. * Managing 1200+ SQL Instances on development, QA and production environments* Involved in Oracle application script execution and responsible for DML changes. * Interacting with Technical Account Managers to understand the requirements and recommending solutions for process improvement. * End-to-End involvement in KT & Service Transition between Newyork Life Insurance to TCS Infrastructure Support.* Perform RCA and Problem management. Work with Engineering and Operation team to optimize robust DBA Automation. * Actively involved with application team for Legacy Management. * Performing database optimizations, troubleshooting & consistency checks regularly for production and testing servers* Repairing the corrupted objects & restoring the data from the known good backup

New York City Area

As a Database Specialist, I plan database upgrades by maintaining, evaluating, and improving a transaction processing model. I also assesses database performance by developing a protocol for measurement of results and identification of problem areas.Moreover I guide a team and mentor other DBAs in L1 & L2 capacity. I also manage 2500+ SQL Instances on development, QA and production environments. I train new Joiners on business specific process and environments of SG market division.Additionally, I interact with onsite Technical Account Managers to understand the requirements and recommending solutions for process improvement. I have End-to-End involvement in KT & Service Transition between Newedge and SocGen database from Singapore DBA. I work with Transversal Engineering team to optimize robust DBA Automation. I am actively involved in Legacy Management. I also perform database optimizations, troubleshooting & consistency checks regularly for production and testing serversSome highlights of my profile include:* Involved in handling multiple technologies, for great initiative & enthusiasm and received Sport Award for same at Society Generally in Aug’14* Successfully completed database transition between Newedge and Societe Generale* Setup script to do Auditing on SQL Server 2005 SE and Completed Storage migration activity* Setup script to check the active cluster node and preferred node if it’s running. Reduced the manual effort of daily check* Successfully completed database migration from Sybase to MS-SQL* Modified all maintenance jobs to use PowerShell* Sybase Server installation: Installed Sybase Server’s Version 15.5 / 15.7* Accountable for software installation of MySQL-Server / Client-5.6. *** Implementing database backups & refreshes for MySQL & Sybase –Manual

At HCL I was working in the capacity of Senior Specialist, I managed 900+ SQL Instances on development, QA and production environments. I have handled many Full-Delegation projects. I also improved/ optimized and streamlined process as part of full delegation transition. I performed RCA’s whenever a problem management is required. For multiple applications, I handled primary DBA roles and responsibility. I also created and maintained all databases required for production usage. I implemented Microsoft Windows Server Failover Clustering and set up DR strategy for different clients. I also handled cognition in replication & log shipping methodologies. I worked on MS-SQL and Sybase Databases. For replicating data from production to test server, I executed replication (Transactional & Snapshot) Some highlights of my profile include:* Recoded achievement in receiving HCL - Appreciation for taking responsibility & multi skilled in Dec’12* Successfully implemented compliance policy & modified Global administration jobs in the project* Set-up transversal data encryption and service broker on SQL Server.* Managed transition for Sybase database for DBI client.* Setup inventory for the DBA team which helps to keep all the information about Application, Server & Database.* Involved with Technology Excellence Group (TEG) to minimize repetitive alerts, Fixing Database related issues. * Worked for Project Transitioning, Offshore KT, Parallel Run & GO LIVE.* Expert in setting up the security in SQL Server.

As a DBA, I installed, configured, administered as well as secured client’s production servers. I managed 500+ SQL Instances on development, QA and production environmentsDuring my engagement I handled basic cognition in clustering, replication and log shipping methodologies. While regulating weekly schedules, I also organized device / drive backups I implemented data retrieval & ran scripting to reload database objects. I coordinated development of SQL Server Security Model & set up the Database / SQL Server standards. I also replaced transaction logs & continuous monitoring of database growth. I also configured maximum number of user connections & the permissions. I applied data transfer method to transfer tables from one server to another & writing code / created jobs to automate repetitive tasksSome highlights of my profile include:* Bagged DBA of the Year at Nuware for contributing in enhancement of customer experience in Sep’09 - 10* Downgrading SQL server 2005 EE to SE to reduce Licensing cost. * Upgrading SQL Server 2000 to SQL Server 2005 or SQL Server 2008.* Job Modification from MKS tool kit to TSQL Script on all database servers. * Build SQL server 2005 Cluster and in managed DR test. * Migrating tables part of Heterogeneous replication from SQL to SYBASE.* Configured Replication, log shipping & Mirroring* Designed Database Security settings based on application / user request* SQL Server Reporting, Integration & Analysis Services installation

Bachelor Of Technology - Btech, Computer Engineering

Education record