Anurag Dobade Email & Phone Number

Pune, Mh, In

Clover Infotech provides solutions & services across apps, technology, cloud, data management, etc. Provides remote DBA & on-site DBA support in BFSI. Some of the key customers Axis, BALIC, Edelweiss, IndusInd, Kotak Bank, Pidilite, RBL Bank, SBI Bank, Yes Bank etc Technical Expertise:----------------------------------Installation & Configuration of Database Software for Supporting SDLC role in App Development, QA, Staging, Testing & Production Environment.In depth understanding of Database Architecture & Database Best Practices. Good knowledge on SQL Queries, SQL Commands DDL, DML, TCL, DQL, DCL, Keys & Constraints, Data Types, Operators, Normalization, Joins, Subqueries, Stored Procedures, Functions & Parameters, Temporary Table & Table Variables, Common Table Expressions, Views, Triggers, Cursors.Routine tasks like DB Health Checkups, Backup Checkup, HADR Sync, Error Logs, Handling user’s permissions, Database/Server Roles, Monitoring jobs, Mails, Triggers, Alerts, TraceFlags, Blocking, Deadlocks.Securing Database, Backup & Recovery Strategies, Creating Maintenance Jobs, Rebuild/ Reorganize index, Update Statistics & Database Consistency Check (DBCC) to maintain ACID properties & prevent database corruptions. On-Demand supporting database deployments, weekend downtime database patching, migration, upgradation activities.Configuring & Managing Replication, Cluster, Log Shipping, Database Mirroring, Always ON, SSRS Reports Creation & Deployments, Configuring SSIS Catalog, Supporting Deployment, Migration of Packages.Managing & Creating Azure Resource Group, Virtual Networks, Azure Storage Containers, Database Credentials for BLOB Storage.

Provides IT / Technology Services of Software Development, web- designing, Computer Hardware Repair & Services, also offers professional training to Students & support starting up own business.Technical Skills:----------------------------------Installing Windows XP,Vista,Windows7 on DOS desktop/laptops & Updating WindowsXP SP, Migrating Win ME/ WinXP to Windows 7 without user data loss.Fixing missing drivers, Microsoft Office 2000/2003 to 2007 upgrade,Tally, Photoshop, Pager,Antivirus. Sharing Drives,Printer,Scanner in LAN.Improving Performance by Disk Fragmentation & Upgrading RAM, CPU CoresAttaching Phone & Modem Card,Infrared,Bluetooth,Internet,Graphics Card,TvTuner.Assembling or building computer from different parts as per requirements.Resolving OS Startup using Hiren's Boot, BSOD,Auto Restart/Shutdown, Virus corrupt system files, Lost login password, Linux/windows multiple OS bootup etcReplacing RAM,CMOS cell,Floppy Disk,CD/DVD lens, Recovering damaged hard disk.Configuring System for training institutes[School Lab, MS-CIT, Typing, GTA Gaming/Internet Cafe] VGA./HDMI for One CPU Multi-User(Client-Server).

Bachelor Of Engineering - Be, Computer Science & Engineering

Diploma Msbte, Information Technology

Ssc