Vinayak Utekar

Vinayak utekar

bookmark on deepenrich
location of Vinayak UtekarMumbai, Maharashtra, India
Followers of Vinayak Utekar214 followers
  • Timeline

  • Skills

    Asp.net
    Sql dba
    Oracle sql developer
    Css
    Html
    Bootstrap
    Sql tuning
    Monodb
  • About me

    I Help DBAs Fix SQL Server Performance Tuning Problems. I work every day with multiple customers and on different project, however, I only have a single focus – SQL Server Performance Tuning and Optimization. If you have a performance issue, there are chances that I have seen that issue before and most probably solution is also available in my personal toolbox. Specialties: SQL Server database administration Transact-SQL data analysis, scripting, administrating. SQL Server versions: 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 & 2017. Enterprise administration

  • Education

    • Asm group of institutes

      2014 - 2017
      Master of computer applications - mca a
  • Experience

    • Rafai technologies pvt. ltd

      Mar 2017 - Dec 2018
      Sql server database administrator

      MS SQL & MY SQL Server 2000,2005,2008,2016 Designed Table structure With Windows and Linux Platform. Design And supported High Availability such as clustering, Mirroring, Replication Always on In SQL 2016.Tuning Performance of SQL Server.Core Database Activities like Shrinking database. Attach detach Database, import export database, Database Tuning Ad visor Graphical Execution Plan SQL Profile.Deployment SSRS Reporting Server With encryption KeyCreate views, stored procedure, trigger, Cursor Show less

    • Ibm

      Jan 2019 - Oct 2022
      Sr.pl/mssql - dba

      I specialised in SQL Server Performance Tuning and Optimisation.SQL Replication P - Familiar with unstructured databases such as Cosmos Db.P - Familiar with J SON and XML.P - Familiar with Red gate ToolsE - Familiar with Power shell,Installation, Patching & up-gradation of SQL- SERVER on stand alone as well as on cluster With latest SP, Knowledge of Different GUI tool like SSMS, SSCM, DBTA, SQL-Server Profiler.Good Knowledge of different High Availability option like Database Mirroring, Log Shipping, and Failover clustering.Good knowledge of various DBCC Commands.Creating Jobs and Sending Alerts Using Database Mail and SQL Mail. Tuning SQL Queries and improving the performance of the Database.Good to have Azure SQL DB knowledge and Good to have Azure SQL DB knowledge.Design and modernise clients' mission-critical OLTP and OLAP for performance, availability, latency, and reliability.Performance tuning applications and servers through baselines, DMVS, and traces. Propose fixes including indexes, code re-writes.Scripting and Programming in T-SQL, Power Shell, SQL, PL/SQL, Unix shell, VB, Java, HTML, ASP, VB COM,C#.Special ties:• Database Implementation and Administration• Database Modelling and Design• Performance Tuning• Low concurrency problem resolution• Disaster Recovery• High Availability• Migration• Consolidation• Consulting Show less

    • Tata consultancy services

      Aug 2022 - now
      Sr.software analyst

      Expert in code deployment tools (Puppet, Ansible, and Chef)Possess a strong command of software-automation production systems (Jenkins and Selenium)Knowledge of full SDLC and basic understanding of technologies like Java/J2EE, WAS/Tomcat, Apache/IHS, MQ, TibcoConfiguration tools like GIT, SVN, Wiki, etc.Knowledge in using build tools like Jenkins, Maven, Ansible, Liquibase & NexusKnowledge of packaging & deploying Java/J2EE applications.Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server.Installs, maintains, administers, and tunes MS SQL Server databases. Completes database back-ups and maintains backup procedures.Maintains database high availability and the upkeep and availability of other Database systems as required.integrity, recovery and scalability of the SQL Server, Azure SQL Database and Cosmos DB database environments.Job Responsibilities.Maintain the high availability and disaster recovery (HADR) systems including performing fail over and fail back. Show less

  • Licenses & Certifications

    • Oracle global certification

      Niit computer education
      Jan 2013