About Me

Name: – Vivek Johari

Linkedin:-https://www.linkedin.com/in/vivekjohari/

Twitter:-http://twitter.com/VivekJohari
Gmail:- askvivekjohari@gmail.com

Professional Experience

Database profesional with more than 17 years of experience in database designing & programming.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.

Expert in SQL Server database engine, SQL Server integration services and SQL Server Reporting Services development using Microsoft Visual Studio IDE

Good work experience on Space management, Capacity planning for optimum storage utilization, designing data archiving systems.

Implemented High availability solution’s like AlwaysOn, Windows Clustering, Failover Clustering that include Active-Active and Active-Passive Clustering, replication, Database Mirroring, Log Shipping and DR recovery strategies.

Expertise in performance monitoring, query optimization and tuning relational databases for optimum performance under a variety of high volume conditions, high level database design and architect databases.

Experienced in creating and managing SSIS packages to address complex business needs, large volume of data extraction and loading.

Also involved in database designing and apply normalization according to the business requirement.

Installation of new test, production and development database Servers

Good experienced of working on High volume databases under Mission critical environments.

Comfortable creating stored procedures, triggers, functions, T- SQL, etc. SQL versions I have worked SQL Server 2000, 2005, 2008/r2, 2012 & 2014.

Having good experience in working on Azure environment.

Professional Certification

Indian Institute of Technology, Delhi

Post graduation Deploma(PGD) in Data Science and Machine Learning from IIT, Delhi

Microsoft Certifications

 

• MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
• MCTS: Microsoft SQL Server 2008, Implementation and Maintenance
• MCTS: Microsoft .NET Framework 3.5 ASP.NET, Applications
• Microsoft Certified: Power BI Data Analyst Associate
• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified Azure Data Analyst Associate

Oracle Certifications

• Oracle certified profession DBA in ORACLE 10g (OCP)
• Oracle certified profession DBA in ORACLE 9i (OCP)

Data Science & Machine Learning

• AlphaML: Foundations of Machine Learning from 123 of AI
• AI For Everyone from AI For Everyone

Technical Expertise

• Database  designing.
• Database Optimization
• Writing Complex Stored Procedures, Functions, Triggers.
• Designing and developing SSIS & DTS packages.
• Designing SQL Reports using SSRS.
• Database Server Maintenance.

Professional Education

• Master Degree in Computer (MCA)
• BSc.(Hons) Mathematics from Delhi University

Technical Publication

• Contributor at Linkedin.com
• Contributor at sqlserverpedia.com
• Author and blogger at Sqlservercentral.com
• Author, blogger and moderator at beyondrelational.com
• Author and blogger at Codeproject.com
• Member of PASS (Professional Association for SQL Server) community

Other Achievements

Have merit certificate at National mathematics Olympiad

Personal profile

In my free time, I like to spend time with my friends and my parents. I love travelling and always try to plan outing with my friends. I like playing cricket and like to see as many match as possible. Also, I love to watch movies.