Bhavesh Bhadarka

• Experience in working with High Availability Creation and debugging of Always On, worked on installing FCI and creation of WSFC • Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2005/2008/2012/2014/2016. • Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server. • Experience in Data Migration. • Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users. • Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics. • Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages. • Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification. • Experience in using Performance Monitoring tool (Redgate, DPA), SQL Profiler and optimizing the queries, tracing long running queries and deadlocks. • Experience with SQL Server and T-SQL in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules. Graduated from UT Dallas School of Management MS in IT & Management(ITM/MIS). Good understanding of RDBMS concepts and Experience in querying in Sybase and SQL server, Oracle (SQL/PLSQL). Expose to a wide range of database, reporting, visualization and analytical tools. Specialties: SQL,SSIS, SSRS,Red Gate,DPA