Description
Microsoft Certified Professional and an accomplished SQL Server Database Administrator with more than 7 years of extensive experience. * Extensive experience in database administration, database architecture and configuration, analysis, tuning, data migration, development and support of SQL Server 2016/2014/2012/2008 R2/2008/2005/2000. * Excellent experience in installation, upgrade, configuration, and administration of SQL Servers in both standalone and clustered environments * Installed and configured SQL Server and SSIS, SSRS, and SSAS and service packs. * Performed migration from SQL Server 2014/2012/2008/2005/2000. * Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database * Consistency Checks using DBCC Utilities. * Designed, implemented and managed high availability solutions mainly database mirroring, log shipping, replication, clustering and AlwaysOn. * Solid experience in SQL Server security by controlling permissions and monitoring audit events. * Managed security and database permissions. * Hands-on experience in creating and monitoring proper alerts for system errors, insufficient resources, fatal database errors, hardware errors. * Provided daily administration and performance monitoring of Database related systems. Managed SQL Server Agent. * Created and reviewed databases and database objects including tables, triggers, views, stored procedures, indexes, defaults and rule. * Worked with developers on the most efficient database designs and designed database objects. * Designed and Implemented backup and restore strategy for SQL Server databases. * Experience in writing and tuning T-SQL (Transact-SQL) (DML/DDL/DCL) Queries * Experience in SSIS and SSAS to build three-dimensional cube and present the business intelligent data through SQL Server Reporting Services. * Implemented Table and Index Partitioning to large Databases. * Supported the database environment of SQL Server databases spanning version 2000 to 2012 as database servers are moved from old version to the new version. * Excellent experience in data migration between two environments with SSIS packages, backup/restore, * detach/attach, import/export wizard * Responsible for overseeing service packs and hot-fixes are uniformly applied to all our environments * Experience in providing change management support by reviewing, approving, and implementing changes that affect databases * Supported both production and development databases 24/7/365. * Excellent communication skills, self-managing and teamwork spirits in multicultural environment * Good experience in writing documentation and providing on-call support on a rotation basis
Accomplishments
Highlights:
Keywords
