SQL Data Base Administrator
Company: Collabera Location: Hyderabad Exp: 4-7 Yrs
• Very good communication skills
• Experience with MS SQL Server 2008/2008R2/2012/2014/2016.
• Experience in troubleshooting issues with SQL Installations on the server.
• Experience with Migration from SQL Server 2008 to SQL Server 2012, 2014,2016 and troubleshooting issues.
• Experience and troubleshooting issues in upgrading SQL server software to new versions and applying service packs and patches.
• Proficient with SQL Management Studio, Enterprise Manager, Query Analyser.
• Troubleshooting issues with Maintenance plans, rebuild/reorganize indexes & performing integrity checks.
• Troubleshooting issues with database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.
• Experience and troubleshooting issues with High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering.
• Experience and troubleshooting issues with Always On in SQL Server 2012,2014,2016.
• Experience in Implementing Database Mirroring in SQL Server 2005/2008/2008R2.
• Involved in Installing, Configuring, Maintaining and troubleshooting issues of Cluster in SQL Server 2008, 2008R2, 2012, 2014 and 2016 in Active/Passive.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DVM, Resource Governor, Data collection Reports, crystal reports, DBCC and Custom Script, Built-in performance Report and Activity Monitor.
• SQL Server Performance
• SQL Server Administration (Backup, Restore, Corruption, Deadlock Schedulers, etc.)
• SQL Server Security Issues (SSL, TLS, TDE, Unable to apply security patch )