Siddhartha Datta

Siddhartha Datta

Service Delivery Lead- Database Services

Summary

A Technically adept IT Service Management Professional with an impressive history of leading and managing IT-infrastructure teams. Technology consultant talented at identifying emerging technologies and leveraging the in-house capabilities, having gradually grown into a strong and efficient Technical Service Manager. Business savvy strategist inclined towards improving operating efficiencies through technical improvements.

Education

Education

Bachelors of Commerce

May 2001 - May 2004
Calcutta University

Diploma in Sofware Engineering

Jan 2002 - Feb 2004
APTECH

Work History

Work History

Technical Services Manager-Service Delivery

Nov 2011 - Present
HCL Technologies Limited

Project AIG- EMEA
Currently working as the Technical Services Manager/Delivery Lead for the AIG EMEA Application Database Services, Application Configuration Management and the IT Operations team. As a Overall Lead for the Database services and Configuration Management with a scope of 305 Core Applications.
I manage the Global DBA team. My DBA team is responsible for the Managed database hosting, where we were responsible for creation to administration of customer's production databases hosted in Europe and USA data centers. This gave me the opportunity to work in many different kinds of environments and managing multiple DBAs. 

  • Managing day to day activities of the team, ensuring DBA/CM coverage is there 24/7
  • Formulation of roster management for the team to facilitate proper shift rotation and coverage across all shifts in an ideal 24*7 ongoing project
  • Assigning tasks to the team members and assigning complex projects to the team leads
  • Conflict resolution between team members and with other teams
  • Planning and ensuring DBA/CM team is always uptodate with the latest technologies, e.g. we had 12c inhouse training sessions where every DBA made presentation to the team on one topic.
  • Build the MSSQL/SYABASE/ORACLE/DB2 skillset in the team from scratch along with documentation. We have just started supporting DB2 in the team and now everybody has this skillset.
  • Currently working on building the APP-V skillset in the team in preparation to support new customers.
  • Setup Crisis calls and ensuring outage situation is resolved as soon as possible with coordination with the GCC Service Managers and various other teams.
  • Representing the cases and changes in every Change Management review Meetings and discuss the possibility and areas of approvals with the CAB Team members
  • Perform as primary interface for Global Management with regards to customer escalations
  • Owner for delivering monthly service management report measuring and analyzing actual Database service performance versus client service level agreement, creating service improvement plans when needed to ensure agreed to client service level agreements are met effectively
  • Driving the team to work on more Value-adds to the ongoing projects my sharing ideas for innovation and automation of various processes

 

 

Sr. Database Lead/Analyst

Aug 2009 - Nov 2011
Bank of America

The ITS (Information Technology Services) is an elite segment of the Bank that provides IT services to the Organization. The above-mentioned Applications have been divided according to their respective Engineering as well as organizational Domains. DBA Teams have been formed for each of these Domains for supporting the Applications that are owned by DBAs. Each DBA is the Primary database owner of the Applications mapped to him\her and provides quality SQL Server Support.

As Production DBA/ Application DBA / Application Engineering Support

  • Involved in performance tuning, code optimization, and deployment
  • Designing and implementing SQL Server Security protocols-Identity & Access Control, Secure Deployment & Secure operations
  • Experience of Application Code Review
  • Performed all the Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues as and when occurs, Performance Tuning, monitoring error logs, jobs etc
  • Involved in Logical Data and Index Partitioning using SQL Server 2005
  • Designed, implemented & maintained DTS Packages
  • Involved in Fine Tuning the Procedures After studying the Processing time through SQL Trace
  • Modified & created Indexes, Optimizing Indexes

 

As a Integration and Deployment Leader

  • Closely worked with Solution Architects and sales teams in developing proposals, plans, and communication
  • Designing and implementing Server Hosting as per requirements in a cost effective manner
  • Mentor and Leading Database technologies
  • Estimating tools, models, Process Documentation, and Training Requirements for project deployment
  • Designed complete IT solution for small to mid-segment manufacturing organizations
  • Liaison with Application Teams in weekly meetings for every projects discussing and planning the workflow or actions regarding performance issue, resource bottlenecks, upcoming production changes\releases, long pending issues, etc.

 

As a DBA

  • Disaster Recovery methodologies and high availability techniques and implementations.
  • Up gradation of Database from SQL Server 2000 to 2005 and 2008R2.
  • Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
  • Setting up SQL Server Security.
  • Performed acceptance testing to verify that database changes perform without adverse consequences.
  • Estimated disk storage requirements for database software, database files & database administration needs.
  • Provided optimal database file layout for utilization of storage and performance acceptable to client.
  • Participated in meetings impacting databases physical design.
  • Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will won the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
  • Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
  • Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
  • Implemented & managed database clustering, failover and load balance technologies as per client requirement.
  • Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
  • Conducted root cause and analysis for database incidents and problems.
  • Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
  • Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
  • Conducted research and collaborated with vendor if necessary for additional patches.
  • Provided stopgap solutions if possible and acceptable by business and application team owners.
  • Researched, reviewed and recommended for preventive maintenance.
  • Set up security and access profiles and procedures for database system administrators.
  • Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on mutual agreement.
  • Interfaced with database vendors & client technical support teams to isolate & resolve database related problems.
  • Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
  • Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008.
  • Provided & managed support to Environment of more than 500 Database Servers.
  • Proven ability to handle Database of more than 1 TB in Size.
  • Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
  • Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.

 

Sr Database Administrator

Nov 2008 - Aug 2009
HCL Technologies Limited

Project MICRON Technologies Inc
MICRON-Data Services Operations
Micron has around 500 plus Servers and about 20000 databases including evaluation and Test/development systems. HCL DBAs monitors all these servers. Apart from alerts that come to our email, we use Remedy Console as well as Clear quest Ticketing system to take Database activity requests. In this Project, we predominantly deal with various mechanisms such as Clustering, DB Mirroring and Replication (Transactional\Peer to Peer) to promote the high availability of the system.

  • Perform SQL installations, Service Packs, Creation of new SQL Instances
  • Analyze and troubleshoot the SQL Server processes and jobs
  • Perform project tasks as creation of databases as per MICRON standards, configure OS level parameters, create directory structure layout to place database files, create necessary user accounts, database refreshes from production to Development/Test, Dev/Test to Production, Database Monitoring and Tuning Design, etc
  • Monitor the Disk Space of all the Servers; Set up Replication, DB-Mirroring, and Database maintenance plans
  • Designing, deploying and monitoring SQL Server AUDIT programs.
  • Setting up SQL Server Security.
  • Database auditing, monitoring of various database activities, working proactively on performance issues
  • Write scripts for server and database monitoring; Monitor the Log Space for successful execution of all the specified procedures
  • Troubleshoot SQL issues and escalate issues as appropriate; Cluster management, Replication troubleshooting, DB Mirroring etc
  • Monitor the Server and query performance closely to ensure database productivity
  • Monitor and maintain the SQL jobs running on various boxes
  • Work on with the Development and Test teams in applying bug and hot fixes in both Test\Development and Production environments.
  • Involved in Project reviews, Weekly Operation Meetings, Presentations and all other activities
  • Participate in monthly project reviews and make presentations on the project status
  • Liaison with onsite team and MICRON DBAs and Database Engineering Teams at multiple locations on following up issues

 

Database Adminstrator

Mar 2005 - Oct 2008
Wipro Technologies Limited

Project Microsoft - PSITOPs- Platform Services Informational Technology Operations

PSITOPs- Platform Services Informational Technology Operations: The project is focused on core SQL Server production support for more than 1000 production Wipro Technologies servers and many pre-production testing servers. Microsoft monitors all these servers using MOM and all the alerts will be sent to our MSE queue. Apart from these alerts we have customer mails for various issues. This project deals with various mechanisms such as Clustering, Log Shipping, and DB Mirroring to promote the high availability of the system

  • Study, GUI design and Coding for Analysis module
  • Analyze and troubleshoot the SQL Server processes and jobs
  • Monitoring the Disk Space of all the Servers; Database auditing, monitoring of various database activities, working proactively on performance issues.
  • Write scripts for server and database monitoring
  • Monitor the Log Space for successful execution of all the specified procedures
  • Troubleshoot SQL issues and escalating issues as appropriate
  • Cluster management, LS troubleshooting, DB Mirroring etc
  • Monitoring the Server and query performance closely to ensure database productivity
  • Monitor and maintain the SQL jobs running on various boxes
  • Monitor the Log shipping between Productions – Reporting as well as Production –UAT boxes
  • Work on the Development and Test teams in applying bug and hot fixes in both UAT and production environments
  • Team management, training and coordinating with team members on technical issues and other general issues
  • Involved in Project reviews, presentations and all other activities
  • Participate in monthly project reviews and make presentations on the status project
  • Coordinating with onsite team and other offshore teams on following up issues

 

Database Adminstrator

Mar 2005 - May 2006
WiproTechnologies Limited

Project HEWLETT & PACKARD Database Management Services

The project is focused on core SQL Server production support for more than 500 production servers and many pre-production testing servers. The HP DBMS group monitors all these servers using MOM and Remedy incidents and all the alerts will be sent to our L3 queue. Apart from these alerts we have customer mails for various issues. This project deals with various mechanisms such as Clustering, Log Shipping, and DB Mirroring to promote the high availability of the system.

 

  • Disaster Recovery methodologies and high availability techniques and implementations
  • Up gradation of Database from SQL Server 2000 to 2005
  • Installed & configured database software, associated database tools and performance monitoring software
  • Performed acceptance testing to verify that database changes perform without adverse consequences.
  • Estimated disk storage requirements for database software, database files & database administration needs.
  • Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will won the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
  • Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
  • Liaison with Application Teams in weekly meetings for every projects discussing and planning the workflow or actions regarding performance issue, resource bottlenecks, upcoming production changes\releases, long pending issues, etc.
  • Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
  • Implemented & managed database clustering, failover and load balance technologies as per client requirement.
  • Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
  • Requested refreshes pre or post restore activities (e.g. data loads).
  • Database recoveries as per requirements.
  • Conducted root cause and analysis for database incidents and problems.
  • Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
  • Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
  • Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.

 

Software Service Executive

Jan 2004 - Jan 2005
Innerinfosys.com
  • Perform SQL installations, Service Packs, Creation of new SQL Instances
  • Analyze and troubleshoot the SQL Server processes and jobs
  • Write scripts for server and database monitoring; Monitor the Log Space for successful execution of all the specified procedures
  • Monitoring the Disk Space of all the Servers; Database auditing, monitoring of various database activities, working proactively on performance issues
  • Monitoring the Server and query performance closely to ensure database productivity
  • Provide Tier 3\SME support to subordinate hardware specialist\Application Support Teams
  • Troubleshoot software-operating System conflicts; assist users in upgrading the existing software
  • Analyze the most frequent issues and rule out workarounds for timely resolutions for the problems
  • Script of technical resolutions for the usage of Tier 2 application support Teams
  • Monitor and maintain the SQL jobs running on various boxes
  • Requested refreshes pre or post restore activities (e.g. data loads)
  • Database recoveries as per requirements

 

Certifications

Certifications

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS)

Microsoft Corporation

Microsoft Certified Technology Specialists in Microsoft SQL Server 2008 (MCTS)

Microsoft Corporation

Microsoft Certified Solutions Associate 2012

Microsoft Corporation

Microsoft Certified IT Professional 2008

Microsoft Corporation

Microsoft Certified Professional (MCP)

Microsoft Corporation

Portfolio