Nilkanth
Barot

Database Manager & Solution Architect

Accomplished technology leader with 16+ years of enterprise database administration, cloud architecture, and cross-functional team leadership. Proven track record delivering scalable, high-availability database solutions across Bankruptcy, Healthcare, Advertising, and ERP domains.

Vadodara, Gujarat, India

16+ Years Experience

Team of 15+ Professionals

AWS & Azure Certified

Get In Touch Visit Website

16+

Years Experience

50+

SQL Instances Managed

Team Size Led

Industry Awards

About Me

Professional Summary

Accomplished Database Manager and Solution Architect with 16+ years of progressive experience in enterprise database administration, architecture design, and technology leadership across Bankruptcy, Healthcare, Advertising, ERP, and Engineering domains.

Demonstrated expertise in managing large-scale SQL Server environments, cloud migrations (AWS/Azure), data warehousing, and high-availability solutions. Proven track record of leading cross-functional teams of up to 15 professionals, aligning technology roadmaps with business strategy.

Adept at translating business requirements into scalable, secure, and high-performance database solutions while driving operational excellence and continuous improvement across the full technology stack.

Enterprise Database Management
Managing 50+ SQL Server instances with 99.9% uptime SLA across mission-critical environments.

Cloud Migration Leadership
Successfully led on-premises to AWS/Azure migrations with zero data loss and minimal downtime.

Team Leadership & Mentoring
Leading and mentoring teams of 15+ DBAs, developers, and data engineers with structured career development.

Performance Optimization
Reduced critical query response times by up to 40% through systematic performance baseline analysis.

Core Competencies

Areas of Expertise

Database Management & DBA

Enterprise SQL Server administration, HA/DR architecture, performance tuning, and governance.

Team Leadership & Mentoring

Leading cross-functional teams, defining KPIs, performance reviews, and structured mentoring programs.

Cloud Architecture (AWS/Azure)

Cloud-native database services, migrations, high availability, and cost optimization on AWS and Azure.

Data Warehouse & ETL Design

Star/snowflake schema design, SSIS ETL pipelines, OLTP/OLAP architecture, and BI solutions.

SQL / PL/SQL Optimization

Complex stored procedures, triggers, materialized views, bulk binds, and query execution plan analysis.

Solution Architecture Design

Designing scalable, secure enterprise architecture aligned with business goals and technology strategy.

Disaster Recovery & HA Planning

RTO/RPO planning, Always On Availability Groups, log shipping, replication, and failover testing.

Stakeholder Management

Partnering with C-Level executives to align database and digital roadmaps with organizational objectives.

Technical Skills

Technology Stack

Database Platforms

SQL Server 2005–2022 MySQL PostgreSQL Oracle AWS Aurora DB Cassandra InfluxDB

Cloud & DevOps

Azure SQL Azure Data Factory Azure DevOps AWS RDS AWS Redshift Hadoop on AWS Jenkins Docker

BI & Reporting

SSIS SSRS SSAS Power BI Crystal Reports IBM Cognos

Programming Languages

T-SQL PL/SQL Python C# VB.NET ASP.NET MVC JavaScript jQuery

Tools & Version Control

Visual Studio 2005–2022 TFS GitHub Redgate RabbitMQ Grafana PowerShell

Work Experience

Career Timeline

AIS Info Business Solutions Pvt. Ltd.

APR 2023 – Present

Database Manager — Information Systems Bankruptcy Domain

Lead and manage a high-performing team of 15 technology professionals including DBAs, developers, and data engineers; conduct performance reviews, define KPIs, and drive continuous skill development through structured mentoring programs.
Partner with C-Level executives and business stakeholders to align the enterprise database and digital roadmap with organizational goals, translating business requirements into scalable technical strategies.
Own end-to-end project governance for complex database initiatives — from requirements gathering and architecture design to delivery, QA, and post-deployment support — consistently meeting deadlines and budgets.
Architect and oversee SQL Server high-availability solutions including Always On Availability Groups, log shipping, and database mirroring across 50+ instances, achieving 99.9% uptime SLA.

Drive cloud adoption by designing and executing migration strategies for on-premises SQL environments to Azure SQL Database and AWS Aurora, including schema conversion, data validation, and cut-over planning.
Establish and enforce database governance policies covering data security, access management, CLR-based encryption, audit logging, and compliance with industry regulations.
Design and optimize complex data warehouse schemas (star/snowflake), OLTP/OLAP architectures, ETL pipelines (SSIS), and reporting solutions (SSRS, Power BI) to support business intelligence initiatives.
Lead capacity planning, performance baseline analysis, and proactive tuning using SQL Trace, Execution Plans, and index analysis, reducing critical query response times by up to 40%.
Successfully delivered a Proof of Concept (PoC) for a new enterprise-grade database platform, transitioning it to full production and scaling it to serve organization-wide operations.
Implement automated monitoring and alerting frameworks using PowerShell, Python, Grafana, and InfluxDB for real-time visibility into database health and performance metrics.

Arsons Informatique

OCT 2022 – APR 2023

Senior Database Administrator (Senior DBA) Healthcare Domain

Led the full lifecycle migration of on-premises MySQL databases to AWS RDS, ensuring zero data loss, minimal downtime, and compliance with healthcare data standards (HIPAA considerations).
Managed all DBA operations including performance tuning, automated backup/restore scheduling, failover testing, and proactive server health monitoring across multiple SQL Server and MySQL environments.
Configured and maintained Hadoop clusters on AWS for big data processing, supporting analytics and reporting pipelines for large healthcare datasets.
Authored and maintained comprehensive technical documentation including database architecture diagrams, runbooks, and disaster recovery playbooks.

AIS Info Business Solutions Pvt. Ltd.

APR 2021 – SEP 2022

Senior Database Administrator (Senior DBA) Bankruptcy Domain

Designed and implemented optimized database schemas, tables, views, and indexes to support high-volume transactional systems handling bankruptcy case data across multiple jurisdictions.
Implemented and managed SQL Server Always On Availability Groups and replication across 50+ SQL Server instances, ensuring seamless failover and zero-downtime maintenance windows.
Enforced database security through RBAC, column-level encryption, CLR-based data encryption, TDE (Transparent Data Encryption), and regular security audits.
Developed PowerShell and Python automation scripts for routine DBA tasks including index rebuilds, statistics updates, space monitoring, and health check reporting.

Celtic Systems Pvt. Ltd.

APR 2020 – APR 2021

Senior Database Developer Road Transport, Insurance

Designed and developed complex SQL Server database architectures including normalized schemas, partitioned tables, and optimized indexing strategies for high-volume transactional data.
Engineered and maintained ETL pipelines using SSIS to integrate data from disparate sources (ERP systems, external APIs, flat files) into centralized data marts.
Led database development sprints, coordinating with application developers, system administrators, and QA teams to ensure version-controlled, tested, and stable deployments.

Silver Touch Technologies Ltd.

AUG 2019 – MAR 2020

Senior Database Developer Web Portal

Architected and maintained scalable SQL Server database solutions for large-scale web portal platforms, handling high concurrent user loads with partitioned tables, indexed views, and connection pooling strategies.
Implemented row-level security and data masking techniques to protect sensitive user information and ensure compliance with data privacy standards.

Numerator

MAR 2016 – MAY 2019

Microsoft Business Intelligence (MSBI) Developer / Data Analyst Advertising, Data Analytics

Designed, developed, and deployed end-to-end MSBI solutions including SSIS ETL packages, SSAS multidimensional/tabular cubes, and SSRS reports for operational and executive reporting.
Built interactive Power BI dashboards providing advertising performance analytics, campaign ROI tracking, and media spend analysis for business decision-makers.
Optimized SSAS cube query performance using aggregations, partitioning, and MDX query tuning, reducing report load times by over 30%.

INOX India Pvt. Limited

DEC 2011 – MAR 2016

Application Developer ERP System

Led development of multiple core ERP modules — Sales, Purchase, Inventory, Finance, and HR — designing database schemas, business logic layers, and reporting components for an integrated enterprise platform.
Built predictive analytics and demand-forecasting models using historical product, sales, and financial data to support strategic planning and inventory optimization.
Managed end-to-end project lifecycle including planning, scoping, scheduling, budgeting, risk management, and delivery of ERP module rollouts across multiple business units.

Datatech Computers Pvt. Ltd.

OCT 2009 – DEC 2011

Software Developer Web Development, Microsoft Technologies

Developed dynamic web applications using ASP.NET (Framework 2.0, 3.5) with C#, building data-centric modules with SQL Server 2005 as the back-end database platform.
Developed Crystal Reports for operational and management reporting, integrating report parameters, subreports, and data groupings to deliver structured business insights.

Recognition

Awards & Achievements

AIS Star Performer Award

FY2023 & FY2024

Consecutive recognition for exceptional technical leadership and outstanding project delivery performance.

AIS SPOT Recognition Award

FY2022 & FY2023

Awarded for significant contributions to high-impact database projects and team excellence initiatives.

Enterprise Migration Leader

Key Achievement

Successfully led zero-downtime migration of on-premises databases to AWS RDS/Aurora across multiple organizations.

Credentials

Education & Certifications

Academic Education

Master of Computer Applications (M.C.A.)

Gujarat Vidyapith

Completed SEP 2009

Bachelor of Commerce (B.Com.)

Gujarat University

Completed JUN 2006

Higher Secondary Certificate (H.S.C.)

GHSEB

Completed JUL 2003

Certifications & Training

Microsoft Azure Cloud Architecture

Case Studies & Enterprise Design Patterns — Microsoft

Odoo ERP & Python — Certified Training

Sales, Inventory, Finance & HR Modules — Odoo Company

Key Achievements

Performance Benchmarks

Upgraded all Windows Server and SQL Server instances to current supported versions, eliminating legacy infrastructure risk enterprise-wide.

Implemented CLR-based data encryption across all datacenter databases, achieving full at-rest encryption compliance across the organization.

Led successful migration of on-premises MySQL databases to AWS RDS/Aurora — zero data loss, minimal downtime, and seamless cut-over.

Provisioned and maintained Hadoop clusters on AWS for scalable big data processing supporting BI and analytics workloads.

Managed and maintained database replication topology across 50+ SQL Server instances for high availability and disaster recovery.

Migrated OLTP operational data to OLAP data warehouse using optimized SSIS ETL packages, enabling advanced business analytics and reporting.

NilkanthBarot