Nainesh Babariya

About Nainesh Babariya

I bring over 16 years of extensive experience in SQL Server database administration, equipped with a detail-oriented, analytical, and troubleshooting mindset. My expertise spans across various Microsoft products, specializing as a SQL Server DBA. Here\'s what sets me apart:Key Highlights:Comprehensive Skill Set: Proficient in SQL Server database administration, data modeling, and analyzing business requirements, along with adeptness in operating systems.Database Management: Demonstrated success in managing large databases, executing backup and recovery operations, configuring and administering HA solutions, and proficiently utilizing SQL Reporting Services (SSRS) for report management.Technical Proficiency: Well-versed in a spectrum of database components including stored procedures, triggers, functions, constraints, and views, ensuring seamless database operations.Cloud Expertise: Experienced in Azure services encompassing both Platform as a Service (PaaS) and Infrastructure as a Service (IaaS). Proven track record in migrating on-premises and legacy databases to Azure, as well as deploying and managing products within Azure environments.Scripting Mastery: Proficient in PowerShell and T-SQL scripting, facilitating the development and maintenance of scripts tailored to diverse DBA tasks, enhancing efficiency and automation.Project Management: Possessing a strong business acumen and technical vision, I excel in managing multiple complex projects. Known for innovative problem-solving, results-driven approach, and the ability to optimize resources with a sense of urgency.I am committed to continual learning and strive to stay updated with the latest advancements in database technologies, ensuring I deliver optimal solutions that align with business objectives. Let\'s connect to discuss how I can contribute to your team\'s success.

Experience

1. Sql Dba

   Investec

   Nov 2019 — Present · Mumbai, IN

   Performance Tuning:• Implemented proactive monitoring solutions resulting in a 20% improvement in overall database performance.• Conducted regular query performance analyses, identifying and optimizing poorly performing queries.Security and Compliance:• Enhanced database security by implementing role-based access controls, reducing the risk of unauthorized access.• Led the implementation of Transparent Data Encryption (TDE) to secure sensitive data at rest.High Availability and Disaster Recovery:• Orchestrated the setup of AlwaysOn Availability Groups, ensuring high availability and minimal downtime.• Developed and tested disaster recovery plans, reducing recovery time objectives by 30%.Automation and Scripting:• Automated routine database maintenance tasks using PowerShell, resulting in a 25% reduction in manual effort.• Developed T-SQL scripts for data migration, backup verification, and performance monitoring.Database Design and Optimization:• Led the redesign of critical database schemas, improving data retrieval efficiency by 15%.• Implemented advanced indexing strategies resulting in a 30% reduction in query execution time.

Education

• Ramrao Adik Institute of Technology

  Bachelors of Engineering (B.E.), Electronics and Telecommunication

  2005 — 2008

• Swami Vivekanand Education Centre

  S.S.C., Science, Maths

  2000 — 2001

• Shri Bhabubhai Mafatlal Polytechnic

  Diploma, Industrial Electronics

  2001 — 2005

Skills

• Ssrs
• T-Sql
• Servers
• Itil
• Windows Server
• Sql Server Reporting Services (Ssrs)
• Ssis
• Replication
• High Availability
• Sql Tuning
• Mirroring
• Dts
• Database Design
• Troubleshooting
• Sql Server Database Administrator
• Data Migration
• Sql Clustering
• Microsoft Sql Server
• Performance Tuning
• Sql Server Integration Services (Ssis)
• Databases
• Transact-Sql (T-Sql)
• Etl
• Database Mirroring
• Cluster
• Sql
• Data Warehousing
• Disaster Recovery
• Log Shipping
• Database Administration