Blog :- http://www.vivekjohari.blogspot.com/
Database Consultant with more than 11.5 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.
- 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
- Oracle certified profession DBA in ORACLE 10g (OCP)
- Oracle certified profession DBA in ORACLE 9i (OCP)
- Database designing.
- Database Optimization
- Writing Complex Stored Procedures, Functions, Triggers.
- Designing and developing SSIS & DTS packages.
- Designing SQL Reports using SSRS.
- Database Server Maintenance.
- Master Degree in Computer (MCA)
- BSc.(Hons) Mathematics from Delhi University
- 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
Have merit certificate at National mathematics Olympiad
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.