Name: – Vivek Johari
Email:- contact@techmixing.com
Professional Experience
Hello, I’m Vivek Johari, a Senior Database Professional with over 18 years of hands-on experience designing, optimizing, and managing large-scale database systems. My technical expertise includes SQL Server, Azure SQL, PostgreSQL, MySQL, SSIS, and Power BI, Data Analysis, Data Science with a proven track record in:
-
Database Architecture & Design – Building scalable, high-performing, and secure database systems.
-
Performance Tuning – Enhancing query execution, indexing strategies, and workload optimization.
-
High Availability & Disaster Recovery – Implementing HA/DR solutions in cloud and on-prem environments.
-
Data Modeling & Analytics – Designing dimensional models, data marts, and BI reports.
-
Cloud Migrations – Planning and executing smooth transitions to Azure SQL and hybrid cloud setups.
In IT industry, I have successfully led database modernization initiatives, implemented data governance frameworks, and developed analytics solutions that drive informed business decisions.
TechMixing.com is my platform to share technical tutorials, deep-dive articles, and real-world case studies covering databases, cloud technologies, data engineering, and business intelligence. My goal is to help professionals, teams, and organizations design better data solutions and optimize their systems for performance and scalability.
Whether you’re a beginner learning SQL or an enterprise architect managing complex data ecosystems, you’ll find resources here that bridge the gap between theory and practice.
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
my name is neeraj i also have done MCA and i am working as a software developer in .net technology,can u suggest me for my bright future…………….because u r settled and in good direction u have DBA is the great post……..
can u provide some interviews to me for DBA
Hi Neeraj,
You can find some good interview questions on this site too]
http://beyondrelational.com/modules/17/interview-questions/238/sql-server-interview-questions.aspx
Also you can refer SQL SERVER Cental and SQL authority sites as well
my email id is…….neerajpokhariyal88@gmail.com
neeraj,
Please visit these website.
1. http://www.planetsourcecode.com
2. http://www.sourcecodehub.com
3. http://www.blog.sqlauthority.com
Hi Vivek,
Im doing bcs.computer science.
i want to be in database field.
im thinking about certifications…
but im confused between Oracle and SQL server.
pls suggest me…
i've search on net…more people told me to go 4 microsoft.
and my teacher suggested oracle..
i'm hell confused…help me :/
Thanks for any other great article. Where else may anyone get that kind of info in such a perfect method of writing? I have a presentation subsequent week, and I’m at the search for such info.
Useful certifications