Tirtha Basu Ph: 360-***-**** * ac6fj2@r.postjobfree.com

Career Summary

** + years of experience in Information Technology SQL Server DBA (2005-2016)/ System Administrator experience in Production, Dev and QA environment.

Evaluate the end to end SDLC and implement new technologies that includes Analysis, Design, Development, Testing, Deployment and Support for various Web based applications.

Good in Troubleshooting and Debugging any .NET Web, Windows or Service oriented applications.

Troubleshoot, isolate faults and communication across the infrastructure, applications and business teams.

Configuration/maintenance of High Availability systems like Replication, Log Shipping, Database Mirroring, Always ON. Transaction Log Management.

Configuration/Managing Disaster Recovery (DR) system for SQL Server and Windows Cluster and Application

SQL DML & DDL queries and T-SQL, Debugging and developing SQL queries, Store Procedures, Functions, Triggers.

Auditing and provisioning for database security and access.

Performance Tuning for Databases to optimize queries performance.

Developing and deploying ETL and reports using SSIS, SSRS and Power BI. Tuning SSIS Tasks.

Scaling, configuration, managing of infrastructures for setting up Database Servers and Applications; including OS lifecycle, VM provisioning, Storage and lifecycle operations.

Devise large scale distributed SQL Server Always On clusters with the highest performance and greatest redundancy.

Designing and Automating Yearly and Quarterly runs and tasks.

Deploy upgrades, patches, security features and high availability/Disaster Recovery (DR) for SQL Server.

Manage security by using appropriate Security Solution (Azure Security Center, Operations Management Suite)

Automate monitoring for Servers and Databases Using SCOM and Azure OMS (Operation Management Suite).

Azure Migration from Classic VMs to Latest ARM (Azure Resource Manager) Portal.

Create Azure SQL database in Azure Portal.

Reporting and Monitoring the migration of the on-premise infrastructure to Azure.

Perform code reviews, developing Codes, Identifying inefficient code, provide suggestions for rewriting queries to ensure optimal execution and aiding in resolving production issues.

Responsible for administration, maintenance, performance monitoring and availability of enterprise Production SQL server environments.

Work with Data Architect on long term strategy to ensure integrated database systems. Advise on physical data model and implement changes.

Responsible for capturing various database, server, and application metrics, observing trends that will help longer-term capacity planning and analysis efforts.

Work closely with technical PM’s and other team members to ensure successful project deliveries.

Lead projects and efforts driven by database systems, such as upgrades, database appliance and consolidation.

Have worked on TFS (team foundation server) to version control; for centralized version control and GIT for distributed version control. VSO for deployment.

Implement an appropriate database Backup and Recovery strategy based on data volatility and application availability requirements; using built-in / 3rd party tools (SQL LightSpeed).

Have knowledge of Internet and Web technologies to enable databases to participate in Web-based applications. Examples of this type of technology include XML, CGI, Java, Ruby on Rails, TCP/IP, Web servers, firewalls, SSL, and so on.

Translate a data model or logical Database Design into an actual physical Database Implementation and to Manage that database once it has been implemented.

Design databases so that only accurate and appropriate data is entered and maintained, deploy multiple types of database integrity including entity integrity, referential integrity, check constraints, and database triggers. Ensure the structural integrity of the database.

Well versed with Application Support processes - SLA based services, Incident Management, Problem Management, Change Management, Release Management etc.

Good at multi-tasking and managing changing priorities effectively

Ability to coordinate and facilitate team meetings and one-on-one meetings with project team members and other stakeholders.

Experience of creating and maintaining websites using IIS Server.

Create and manage Azure Resource Manager Virtual Machines

Design a management, monitoring, and business continuity strategy using Log Analytics service in Operations Management Suite (OMS) and Application Insights.

Manage the availability of Windows virtual machines in Azure. Business continuity and disaster recovery (BCDR): Azure Paired Regions

Replicate Hyper-V virtual machines (without VMM) to Azure using Azure Site Recovery with the Azure portal.

Describe/Design Azure business continuity/disaster recovery (BC/DR) strategy.

Design Azure Automation and PowerShell workflows. Deploy resources with Resource Manager templates and Azure portal

Deploy resources with Resource Manager Templates and Azure PowerShell. Deploy resources with Resource Manager templates and Azure CLI.

Experienced in Business Intelligence and Data Warehousing professional skilled in converting data into actionable information using interactive dashboards and data visualizations.

SME for Business Units helping drive proven YoY growth. Help BUs achieve their strategic goals by leading creation of analytical dashboards, influence the business process by providing analytical insights and creation of self service tools for business community.

Experienced in gathering and documenting business requirements, wire frames and mock ups, participating in data modeling & Data Architecture, ETL & dashboard development and performing UAT.

Experienced as team leader coordinating team’s activities, lead communication, work load planning and mentoring. It includes installing SQL Server and the Apps/ Windows Cluster and Setting up Cluster environment for Windows Server, and failover Cluster monitoring.

Automate monitoring for Servers and Databases Using SCOM and Azure OMS (Operation Management Suite).

Perform code reviews, developing Codes, Identifying inefficient code, provide suggestions for rewriting queries to ensure optimal execution and aiding in resolving production issues.

Debugging SQL Server Script issues and Database performance issues.

SQL Server Cube processing for SQL Server Analytical Services.

Setting up Linked servers, Service Broker, Service Routes, which is used for Microsoft Report Analytics tool for accessing reports by Microsoft Partners.

Working in Extraction, Transformation and Loading (ETL) and SSAS and SSRS.

Identifying Root cause for the issues happening in Production environment and logging bugs with Engg team, along with suggesting solution to fix the issues.

Handling Sprint meetings with Engg team for the bugs logged in production environment.

Updating Business stakeholders on deployments happening in Production and Pre-Production environments.

Performing full cycle of testing on bug fixes and new features added up in release in Pre-production environment before deploying the packages and builds in Production environment.

Migration of application from older version of SQL and windows to stay current platform.

Migration of application from older version of SQL and windows to stay current platform.

Managing SCOM monitors for different server, identifying different bottle neck issues like high memory contention, high CPU utilization, high Avg. Disk sec/Transfer and Logical %Disk Free Space.

Adjusting thresholds or overrides for customer requests.

Applying Monthly Patches every month with zero downtime.

Password and service account management, Renew Certificates.s

Monitoring the Performance of the servers from Microsoft Tools.

Serves as the point of escalation (notification) for major incidents

Ensures that any changes to the service under their care follows the current change management work practice

Works with CSI manager and/or service sponsor to identify and prioritize service improvement

Participates in external service review meetings (with the business)

Is responsible for ensuring that the service entry in the Service Portfolio/Catalog is accurate and is maintained

Participates in negotiating Service Level Agreements (SLAs) and Operational Level Agreements (OLAs) for the service

Experienced in developing Automation tools using C#, Powershell, which helps to reduce human activities in application support

Ensures that performance meets the requirements of SLAs and OLAs

Agile/Scrum methodology.

PROFESSIONAL EXPERIENCE

Tech Mahindra Americas INC. Lead DBA, Jan 2015 – Feb 2018

It includes installing SQL Server and the Apps/ Windows Cluster and Setting up Cluster environment for Windows Server, and failover Cluster monitoring.

Debugging SQL Server Script issues and Database performance issues.

SQL Server Cube processing for SQL Server Analytical Services.

Setting up Linked servers, Service Broker, Service Routes, which is used for Microsoft Report Analytics tool for accessing reports by Microsoft Partners.

Working in Extraction, Transformation and Loading (ETL) and SSAS and SSRS

Migration of application from older version of SQL and windows to stay current platform.

Alert Management; performance tuning and Capacity Planning, web application using Powershell script.

Creating Knowledge Base documents for the new features adding up in the system.

Conduct training sessions for L1/L2 and L3 team on application functionalities and new features adding up in the system periodically.

Working with the Agile methodology to test environments

Tech Mahindra LTD Senior DBA, Oct 2011 – Jan 2015

Translate a data model or logical Database Design into an actual physical Database Implementation and to Manage that database once it has been implemented.

Documentation of Server Builds specifications and Security features.

Configuration and maintenance of Database Mirroring to provide high availability.

Setting the Always On feature for one of the application which is in stay current platform.

Migration of application from older version of SQL and windows to stay current platform.

Managing SCOM monitors for different server, identifying different bottle neck issues like high memory contention, high CPU utilization, high Avg. Disk sec/Transfer and Logical %Disk Free Space.

Monitoring the Performance of the servers from Microsoft Tools.

Serves as the point of escalation (notification) for major incidents

Ensures that any changes to the service under their care follows the current change management work practice

Works with CSI manager and/or service sponsor to identify and prioritize service improvement

Participates in external service review meetings (with the business)

Is responsible for ensuring that the service entry in the Service Portfolio/Catalog is accurate and is maintained

Participates in negotiating Service Level Agreements (SLAs) and Operational Level Agreements (OLAs) for the service

Ensures that performance meets the requirements of SLAs and OLAs

Artech Infosystems LTD. Sr Software Engineer, Mar 2008 – Sept 2011

In house application used by Genpact, based on Clarify which had backend Database as SQL Server.

Taking Backup of the Database and maintaining Replication and Disaster Recovery.

Setting up of full-proof Disaster Recovery Mechanism

Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.

Testing the Data Backup by restoring as test database in a test server. Code Changes when required done from our end, however only minor code changes.

Setting up Replication between the databases located at two different locations.

Creating a backup link for businesses so that one or the other is always available at a downtime. The backup host is configured in a server which points to a database which are in sync with the main database through replication.

Managing and monitoring the replication; managing, updating, scheduling jobs. Maintaining the database by implementing re-indexing on a bi-weekly basis.

Also, we provide support for Data warehouse, as SQL Server 2000 and SQL Server 2005 are used as a backend database here. Doing DDL, DML and T-SQL changes.

Creating database authentication, granting access and permissions.

Patni Computer Systems. L2 Support Analyst, Dec 2005 – Dec 2007

Provide Administrative level support to EMC database through Clarify & CSI Oracle Application.

Supporting the customer facing applications

The Responsibilities also includes supervising the team of 12 Members as being a senior associate.

Liable of auditing the Work of the Team by given parameters.

Responsible for the Weekly based conference call with the client who deals the Performance level of the Support Team and Process Updates.

Weekly and the Monthly Reports in terms of Performance, Quality and Other attributes as per Client requirement is also created by me.

Involved with the Team who is responsible of creating Process and Training Documentation.

IBM Daksh Business Process Services PVT LTD. TSE, Dec 2004 – Dec 2005

Provide application support for ‘Quick Books’ accounting software from Intuit.

EDUCATION

Masters in Business Administration from Sikkim Manipal University, India

Bachelor of Science from Sambalpur University, India.

GNIIT from NIIT

TECHNICALL SKILLS

Technologies

Experience with SQL Server distributed cluster configuration, maintenance, tuning, backups, restores, disaster recovery

Experience with RDBMS - including SQL, SQL tuning, troubleshooting

Experience building Always On clusters in a multi-datacenter environment.

Automating with Powershell Script; C#, Jscript.

Operating Systems

Windows Server

Tools

Microsoft Visual Studio 2013/2012/2008, VSS, Microsoft TFS and VSO, WebSphere Administration, MS Visio, SQL Developer, IIS 6.0, 7.0, Windows Azure, Powershell, JScripti, C# and .Net; Perl Script, SCOM

Database

SQL Server 2008, SQL Server 2012, SQL Server 2014, 2016

System Development

Requirement Analysis, Business/Functional Process Analysis, Reengineering, Testing, Documentation, Setups and Implementation.

CERTIFICATION

Microsoft Certified Technology Specialist: SQL Server 2008, Database Development

ITIL Certificate: ITIL V3 Foundation Certificate

Contact this candidate