Description
- Professional Highlights:
- Planning, scheduling and implementing sql server Migrating plans from 2008 & 2008 R2 to SQL 2012 with AlwaysON. Configure BizTalk Logshipping. All version of SQLDBA Production support. SQL Server Performance Tuning. Database Design and development (t-sql).
- Database Mirroring & Log Shipping, AlwaysON ( DR & HA). SQL Version upgrade, migration, monitoring. SQL Profiler, Query Execution plan, Indexing. SQL Server Disaster Recovery Setup.
- SQL Server HADR, AlwaysOn, Replication, Availability Group, Logshipping. SQL Server Clustering, Replication. SQL Server Capacity Planning, Consolidation & Virtualization. SQL DBA Projects Contract, Consulting, Oncall DBA.
- SQL Server Remote DBA support. SQL Server Database Archiving, Testing. SQL Server Backup/Restore.
- SQL Server Installation, Version Upgrade & Architect design. SQL Server Trouble Shooting, Maintenance & Daily production DBA Tasks (24*7*365).
- Implementing changes and migration plans as per the schedule. Good experience in Windows & Linux based operation systems. Working with various teams for the smooth deployment and lead the deployment activities.
- Creating new database and designing, normalize the database as per the business requirement. Good experience telecom, finance, health-care domains
- Primary Skill: Microsoft SQL
- Secondary Skill: Azure & AWS
- Tools: Remedy, Quest Foglight & Spotlight, Litespeed, Red-Gate Backup, Perfmon, profiler, sqlnexus, psdiag, AdeptSQL, SQL Sentry.
- TECHNICAL PROFICIENCY
- SQL Server 2012, 2014, 2008, 2008 R2, SQL server 2005 and SQL Server 7.0, SSIS, SSRS.
- Performance Tuning & Query Optimization,
- Redgate, Litespeed, sqlnexus, Adeptsql, pssdiag, SSM, Activity Monitor, profiler.
- ReplCompare, latencyMonitor, TransRepScripter, Quest.
- Clustering, Migration, Replication, logshipping, DR.
- Ipcenter, Remedy, Magic, Citrix, VPN, Teamviewer, VMware, AdeptSQL, Sql sentry.
- Database Architecture, reviewing existing system and optimize the performance.
