SQL DBA -8+ Years of Experience

An experienced IT Professional with around 8+years of experience in SQL Server domain as DBA. managing large-scale databases in production support environment.

Profile Summary:

• Installing, configuring and managing SQL Server 2005, 2008\R2, 2012, 2014
• Configuring SQL Server Memory settings, service packs, CU’s, Hotfixes, deploying databases, mapping user accounts to logins and assigning permissions and roles
• Creating & Maintaining logins permisions & fixing orfan users in Migration of Databases.
• Basic knowledge on Oracle DBA.
• Worked on SSAS And SSRS and SSIS.
• Having experience on configuration of URL for reports(SSRS)
• Hands on experience on troubleshooting SSAS services or conection related issues.
• Experience on Backup and restore of SSAS cubes.
• Taking Backups, Restoring Backups, Scheduling backup jobs, Fixing failed jobs on servers.
• Resolving corruption of system databases and user defined databases
• Recovering a database when it is in suspect state
• Importing and Exporting data
• Implementation of database maintenance plans and backup automation
• Hands on experience with Log Shipping & Database Mirroring
• Maintaining and troubleshooting Log-Shipping
• Successfully planned and implemented SQL Server 2005,2008,2008R2, 2012 Database Mirroring
• Worked on cluster environment and configured SQL cluster.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Started working on Azure sql technilogies (AWS)
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Implemented Always-ON (AAG) on SQL

Work Terms

Every Day 4 Hour, Skye for Communication

Attachments (Click to Preview)