Ashish Tripathi

Experience

• 

  Technoways Systems LTD

  Jun 2008 - Mar 2011

  Managing production/test databases, ensuring database integrity and availability.Managing & controlling security, setting up new users, auditing user activity & setting up user profilesResponsible for Database security and Installations of Databases Deadlocking and trouble shooting SQL Related issue.Backup & Recovery, Capacity Planning, Database Exports.Responsible for the availability of the Databases and optimum running of the Business Applications.Taking Database Backups and Restoration of databases, Performing Re-indexing, Defragmentation and Integrity Jobs on the database to optimizing the database performances.Database Performance optimization by finding and diagnosing slow-running queries.Created and managed tables, indexes, Spaces Performance Tuning and Optimization of Databases and Stored procedures. Capable with database Jobs and alerts.Project Summarize:A tool built on Asp.Net (project management tool) which allowed project managers to create a project right from the scratch to the end. All transactions like defining metrics for selected practice for the project adhering to quality norms and activities related to finance approval were defined & done through this tool. It helped the senior management to analyze revenue recovered for each project month wise & helped the user log in the request to the concerned department. It helped the organization to manage resources & generate GPM (Generic Payload Module) for each project & view all reports related to resource utilization.Environment: Key Accountabilities; Common Database Administration (DBA) tasks like performing database backups and recovery, managing database users and security and Database Server Administration.Microsoft SQL Server 2000 installation on Windows 2003. Upgraded application version.Troubleshoot application & database related issues. Supported, troubleshot, monitored, optimized & tuned SQL Server. Show less Managing production/test databases, ensuring database integrity and availability.Managing & controlling security, setting up new users, auditing user activity & setting up user profilesResponsible for Database security and Installations of Databases Deadlocking and trouble shooting SQL Related issue.Backup & Recovery, Capacity Planning, Database Exports.Responsible for the availability of the Databases and optimum running of the Business Applications.Taking Database Backups and Restoration of databases, Performing Re-indexing, Defragmentation and Integrity Jobs on the database to optimizing the database performances.Database Performance optimization by finding and diagnosing slow-running queries.Created and managed tables, indexes, Spaces Performance Tuning and Optimization of Databases and Stored procedures. Managing Job Queues and Disk Capacity.Fair bit idea about migration.Key Accountabilities:Common Database Administration (DBA) tasks like performing database backups and recovery, managing database users and security and Database Server Administration.Microsoft SQL Server 2000 installation on Windows 2003. Upgraded application version.Troubleshoot application & database related issues. Supported, troubleshot, monitored, optimized & tuned SQL Server.Deployed patches & tested them in test as well as production environment. Exported/imported data from/to various formats like delimited raw/text file, MS-Excel, XML, SQL Server, MS-Access. Transferred data between various databasesMonitored MS SQL Server performance and network issues.Set up log shipping on SQL Server 2000/2005 production box.Undertook Indexing, Statistics update Show less

  • Database Administrator

    Jun 2008 - Mar 2011

  • Database Administrator

    Jun 2008 - Mar 2011
• 

  TSL Legacy Page We will be closing this page forever in one month

  Jun 2008 - Mar 2011

  Project Summarize

  Database creation, capacity planning, creating/maintaining users, implementing backup plans.Microsoft SQL Server 2005/2008 installation on Windows 2000/2003. Monitoring MS SQL Server performance and network issues.Setting up mirroring on SQL Server 2005 production boxBreaking mirror & re-enabling mirroring on the event of h/w changes & migrating logins/jobs. Configuring linked servers and administering them. Creating custom stored procedures for monitoring Blocking, Deadlocks, Mirroring and other customer requirements. Deployment of stored procedures in production.Customizing stored procedures to update statistics and reduce index fragmentation on a daily/weekly basis depending on database load. Optimization and tuning of SQL Server.Administering MS SQL Server by creating user logins with appropriate roles, dropping and locking logins, monitoring user accounts, creation of groups, granting privileges to users/groups.Refreshing QA, Development environments with production databases.; A tool built on Asp.Net (project management tool) which allowed project managers to create a project right from the scratch to the end. All transactions like defining metrics for selected practice for the project adhering to quality norms and activities related to finance approval were defined & done through this tool. It helped the senior management to analyze revenue recovered for each project month wise & helped the user log in the request to the concerned department. It helped the organization to manage resources & generate GPM (Generic Payload Module) for each project & view all reports related to resource utilization.Environment: * Citrix * Linux * SharePoint * Exchange * MS SQL Server 2000/2005/2008 * IIS 6.0 * MS Windows 2003 Server; Blackberry Support * Storage support. Show less

• 

  IGATE

  Mar 2011 - Aug 2014

  Have strong Experience in installation of SQL Server in Standalone and In Cluster Servers, Patching them.Backup and restoration of databases. Created custom stored procedures for monitoring Blocking, Deadlocks. Customizing stored procedures to update statistics and reduce index fragmentation on a daily/weekly basis depending on database load.• Optimization and tuning of SQL Server.• Implementing Security for SQL users, Administering MS SQL Server by creating user logins with appropriate roles, dropping and locking logins, monitoring user accounts, creating groups, and granting privileges to users/groups.• Monitoring Activity and performance. Having good Knowledge in Monitoring MS SQL Server performance and network issues regarding database connectivity.• Have good skills in troubleshooting Cluster Failover Issues and mirroring Log shipping, and Replication related issues.• Having experience in Capacity Management for the databases handled. Having experience in activities like DR.Client: Univision September 2013 – August 2014• Actively Involved in the Knowledge transfer process from Offshore.• Handelling Common Database Administration (DBA) tasks like performing database backups and recovery, managing database users and security, and Database Server Administration.• Troubleshoot application & database-related issues. Supported, troubleshot, monitored, optimized & tuned SQL Server. Deployed patches & tested them in the test as well as the production environment.• Undertook Indexing, Statistics update, and Database tuning.• Managing Cluster, Mirroring, Log shipping, and replication related issues and Implementation part also taking care Show less

  • Team Lead

    Mar 2011 - Aug 2014

  • Database Administrator

    Mar 2011 - Aug 2014
• 

  Boston Consulting Group (BCG)

  Aug 2014 - now

  Technology leader with hands-on expertise in building & operating Datacenter, Cloud Database infrastructure, and Cloud computing Databases as well. Having extensive knowledge in orchestrating Database infrastructure and a good understanding of day-to-day challengesCertification from AWS Certified Solutions Architect – Associate, Microsoft Certified Azure Administrator – Associate, ITIL V3, MCITP – Database Administrator, ,Scrum certified.# Experience with Snowflake (cloud computing–based data warehousing).# Rich experiance in managing and maintainging AWS RDS/serverless offerings.# Good understnading of PAAS Services,# Experiance with Postgres Databases.# Cost reduction exercise for Cloud Computing Databases.# Database Performance Tuning key strength.# Exposure to AI/ML took Datarobot.# Hands on experience on AWS , Azure and AliCloud.# IT Service Delivery # Vendor management# Managed larger strategic IT initiatives involving re-engineering of business processes# implementation of DevOps strategy, operations and enterprise applications# Global team managementhonored to translate business needs into technology requirements that support organizational strategy and to successfully manage operations and projects from inception to closure. Demonstrate trusted management skills with agility, vitality, and knowledge across hundreds. Expertise in getting security-related needs included in routine activities. Show less

  • Platform Engineer Manager - GAMMA

    Nov 2022 - now

  • Lead Database Administrator

    Aug 2014 - Nov 2022