Experience

• 

  Affair, pune

  Jun 2008 - Mar 2011

  Software engineer

  Responsibilities: - Involved in Analysis, Design, and Development and Testing phases. - Analyzed the business requirements from the given specifications. - Writing of Stored Procedures and Functions using SQL Server 2005 and T-SQL. - Maintenance of the various database objects - tables/views/stored procedures - in - SQL Server 2005 Performed the Server optimization, Tuning of the indexes and the queries and Consolidation of SQL Server environment Used the maintenance Plan for - SQL Server databases to recreate indexes and statistics for the performance. - Design and implementation of Security Model, policies and procedures. - Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool. - Database refresh for the Development and Testing Databases across different Servers Show less

• 

  Syntel

  Mar 2011 - Oct 2012

  Analyst

  • Responsible for Monitoring, maintaining, performance tuning SQL Server 2005 / 2008 databases to ensure the high levels of data availability.• Analysis of Space Availability, Backups (transaction log, complete) and Scheduled Jobs• Setting up BACKUP/RESTORE and disaster recovery procedures to ensure minimal downtime and data loss.• Monitoring Transactional Replication and trouble shooting in necessary conditions.• Performance Tuning – Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.• Create and re-evaluate Indexes and made needed modifications for better performance.• Monitoring of server performance by profiler during peak periods of server utilization.• Testing the Data Backup by restoring as test database in a test server.• Backup job for appx. 50 servers use to failed occasionally for one of our client due to shared destination, Analyze and change the scheduled such a way to minimize the failures.• Creating and Reviewing Security features for all the servers.• Documentation of Server Builds specifications and Security features. Participating in process, application and database audits.• Extensive experience in using T-SQL (DDL, DML and DQL) in MSSQL Server 20005/2008 platforms.• Experienced in creating Tables, Stored Procedures, Functions, Views, Indexes, Triggers, Relational Database Models and Data Integrity in observing Business Rules. • Analyzing the clients’ requirements and coming up with optimal database design. Ensuring data integrity and referential integrity by using constraints and/or triggers• Creating stored procedures for custom data access and develops SQL Server code as per requirement. Show less

• 

  Saama

  Oct 2012 - Jun 2016

  Mssql and msbi database administration - aws and azure cloud

  • Installation & Configuration of SQL server 2008 & 2012.• Implementation and Maintenance of Database Mirroring Log shipping and Replication.• Proactive Monitoring of database critical parameters for Database Servers.• Database Administration, Space Management and Change Management.• Database and SSAS Cube Backup & restoration.• Database refresh.• Mirroring configuration and troubleshooting.• Investigating and Troubleshooting Database corruption/Recovery scenarios.• Index Defragmentation and Index Rebuild.• Patches Up gradation for Databases and servers.• Monitoring & Auditing SQL Logs, Jobs, System errors & Security logs.• Troubleshoot system issues monitoring of scheduled jobs and set up maintenance plans to proactively monitoring the performance of SQL Server databases.• Database Performance Tuning using tools like SQL Server Management Studio, Performance Monitor (PerfMon), SQL Server Profiler, DMV’s and Database Engine Tuning Advisor.• Deployed and monitored SSIS packages.• SSAS Cubes and SSIS packer troubleshooting• SSAS - Full Cube processing• SSAS - Cube Sync and troubleshooting.• Used monitoring tool as Centreon UI and Nagios which given critical alerts and warning alerts which are raised from Opswise too.• Implemented tasks on Opswise for SQL Agent jobs, Disk space issues, etc.• Creating and resolving of tickets using Jira.• Created Instances of windows using Amazon console.• Attaching and detaching of volumes, creating snapshots and AMI’s using Amazon console.• Handled Database servers in size of 2, 3+ TB for production.• Maintaining the Proper Documentation, TSG and Reports. Show less

• 

  Ibm

  Jun 2016 - Aug 2021

  Senior sql server database administrator - aws and azure cloud

  Azure Cloud professional with strong experience in migrating resources to Azure, Azure administration, Azure Infrastructure Operations.• Successfully migrated 30+ databases to Azure Cloud using Azure Data Migration Service.• Troubleshoot Azure related issues and engage teams and vendors for quick resolution.• Configuring and monitoring Azure monitor and App insight as per need.• Solid experience in administration of SQL server in Production, QA, testing, and development environments ranging from 2012 to 2019 versions. Installed and configured SQL server 2019 databases in standalone and clustered environment with availability groups.• Configured High Availability solutions, Always-On, and Log Shipping, migration, patching, troubleshooting, optimization, maintenance (modelling, High Availability (HA) and Disaster Recovery (DR).• Produced high-standard databases solutions to meet stability and reliability.• Automated Patching, Backups, Database Refreshes and Maintenance jobs.• Effectively managed and reduced costs by monitoring databases. Configured Azure Site Recovery for DR and Azure back-up on-premises/Azure Environment.• Migrated VM’s, SQL databases from On-Prem to Azure Managed Instance and VM’s.• Upgraded 20+ server from older (End of Life) version to new (N-1) version.• Database Administration, Space Management and Change Management.• Investigating and Troubleshooting Database corruption/Recovery scenarios.• Index Defragmentation and Index Rebuild.• Troubleshoot system issues monitoring of scheduled jobs and set up maintenance plans to proactively monitor the performance of SQL Server databases.• Database Performance Tuning using tools like SQL Server Management Studio, Performance Monitor (PerfMon), SQL Server Profiler, DMV’s, and Database Engine Tuning Advisor.• Handled Database servers in size of 30+ TB for production.• Maintaining the Proper Documentation, TSG, and Reports. Show less

• 

  Kyndryl

  Sept 2021 - now

  Senior sql server database administrator - aws and azure cloud

  I have been working on the same project since 2016, since I joined IBM. IBM has separated the Managed Infrastructure Services business (MIS Business) of its Global Technology Services (GTS) segment into a new public company, Kyndryl Solutions Private Limited ("Kyndryl"), effective September 1, 2021.