Vikrant More Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

• Deliver test plan, strategy for project that should cover the stakeholder's expectations.• Help Align product DB Statistics with Production, includes DMV analysis. Thorough understanding of Production Peaks and DB Analysis of key Production DB’s.• Identify application DB Limitations.• Work to improve performance of product modules, contribute to optimizing SPs, queries, and other DB tuning parameters.• Work with ITOPs to ensure continuous Production data is available for analysis.• Contribute to analysis of LT Reports that are shared with stakeholders.• Help team automating regular manual task related to SQL Server.• Identifying the performance bottleneck and provide suggestions.• Involved in production test conducted during maintenance window, as part of infrastructure testing.• Identifying impact on database during peak load (provide plausible solution), scheduling test with various test plans like DC1/DC2 UP/DOWN respectively.• Continuously monitor SSRS reports and inform stake holders for the possible risks with respect to the database against production server, setting up the automated process to generate Reports based on the defined rules which help in proactive analysis or prepare rule-based model which automatically inform the risk factor if any.• Continuously brainstorming to leverage new feature and concepts in upcoming version.• Implemented High Availability (HA), Transparent Data Encryption (TDE), RML (Replay Markup Language) DReplay (Distributed Replay), Resource Governor, Change Data Capture (CDC), Tempdb contention, Enabling trace flags etc.• Identify database performance issues, using SQL Idera, DMV, and XEvent, providing patches for stored procedure, indexes etc.Nominated for the Employee Of the quater in 2021(Q4)

Pune, Maharashtra, India

• Proactively monitoring DB level of ALL production systems to identify performance bottleneck from aware (inhouse tool which captures all the statistics (IIS Logs, Extended Events, Database Blocking, Deadlocks etc.) from Prod, Pre-Prod, Development & Testing environment) and providing solution to improve the query performance.• Engaged in Hypercare period for performance issues raised by the client after deployment of new release on production and providing performance fixes. • Resolving deadlock/blocking issues identified on production environment.• Identifying performance issues after load test execution and providing modified scripts/suggestions to meet the scenario SLA’s. • Providing Customer support with Level 3 to resolve issues encountered by clients in their self-hosted environments.• Brainstorm new features associated with existing SQL Server versions and providing solution to implement to gain the application performance.

Pune, Maharashtra, India

• Proactively monitoring DB level of ALL production systems, interacting with Enterprise Architect Team (for Performance Tuning), Product Manager, Scrum Manager, Dev. Team, Test Lead and other stakeholders to prioritize performance issues and providing solution to fix.• Partner with application architects to ensure developers are leveraging best features to ensure scalability and performance optimization.• Partner with QA to ensure per-release identification and rectification of performance bottlenecks.• Partner with developers to ensure architectural standards and designs are implemented and ensuring best-practice SQL coding techniques are utilized.• Continuously identify opportunities to improve performance of production systems (o/s, IO, SQL Config, INDEX and SQL optimization).• Understand table indexing and query strategies, database objects maintenance and performance issues.• Analyze problems as assigned and provide solutions to address business needs. Modifying schema design, definition, creation, etc. and programming - stored procedures, functions, complex queries, SQL tuning, performance tuning.• Providing Customer support with Level 3 to resolve issues encountered by clients in their self-hosted environments.Recieved award of Employee of the Quater in 2019(Q4)

Pune Area, India

Pune Area, India

• Deliver test plan, strategy for project that should cover the stakeholder's expectations.• Also help in identifying the performance bottleneck and provide suggestions.• Upgrading SQL servers from current version to the latest -1 in the market, applying patches, hot-fix, service packs & cumulative updates.• Involved in production test conducted during maintenance window, as part of infrastructure testing.• Identifying impact on database during peak load (provide plausible solution), scheduling test with various test plans like DC1/DC2 UP/DOWN respectively.• Continuously monitor SSRS reports and inform stake holders for the possible risks with respect to the database against production server, setting up the automated process to generate Reports based on the defined rules which help in proactive analysis or prepare rule-based model which automatically inform the risk factor if any.• Continuously brainstorming to leverage new feature and concepts in upcoming version.• Performing POC and getting implemented it in database server to gain the performance of an application.• Implemented High Availability (HA), Transparent Data Encryption (TDE), RML (Replay Markup Language) DReplay (Distributed Replay), Resource Governor, Change Data Capture (CDC), TempDB contention, Enabling trace flags etc.• Identify database performance issues, using SQL Idera, DMV and Xevent, providing patches for stored procedure, indexes etc.• Presented on topic "How Do I Boost DB performance" at Global technology Conference held in Boston.• Analyzing Oracle reports like AWR, ASH and ADDM & Setting up process to collect DMV king of statistics using DPV (Dynamic Performance Views to collect DMV kind of data in oracle.• Understand and explore MySQL 5.5 for doing Index Rebuild and Updating Statistics for table, making changes in the configuration files to get the best configuration for the performance of an application.

Pune Area, India

• Working with Onsite Coordinator for gathering requirements and implemented logical Design into Physical Design.• Involved in the all the stages of Software Development Life Cycle (SDLC).• Created and Modified tables, Views, Indexes, User Defined Functions, Stored Procedures in SQL Server 2k8/2k8 R2.• Used the Execution Plan to improve the optimization of the T-SQL code.• Involved in tuning SQL queries using SQL Profiler.• Optimized Stored Procedures and long running queries using query-optimization techniques.• Wrote the complex queries using joints, Sub-queries, common table expressions (CTE) in T-SQL-2008 R2/2008.• Created SQL scripts for various Business Logic of Position, Flow and Ledger and Journal Entries of Transactions in the Database.• Created SSIS package which will import Excel, CSV into Database table.

Master, Computer Application (Management)

Activities and Societies: Awarded as Best Scenior amongest the batch.

Bachelor, Of Computer Science