Handling Memory configurations for SQL Server 2012 and SQL Server 2008 on Windows 2008.Having Experience on Data center servers and handling more than 1.Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.Troubleshoot performance problems, fine-tuning of databases and index Analysis.Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.Worked on configuring SQL Server with minimum privileged access.Having hands on experience in DR processes including Log shipping and Database Mirroring.Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.Experience in Disaster Recovery Planning and Security Management operations.
Troubleshooting production issues and raising high availability.
Worked extensively on Clustering and server consolidation. Experience in using DMV and dynamic management functions for finding out long running queries. Worked on logical and physical data base modeling with UML and ERWIN tools. Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, contained Databases and, security principals. Expert in data transformation services like SSIS/ETL, DTS, BCP and Bulk Insert. Administering SQL Server High Availability and Disaster Recovery strategies. Expertise in T-SQL writing stored procedures, triggers and functions. Strong technical background along with the ability to perform business analysis and write effective documentation and specifications. Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. 8 years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 20.
0 kommentar(er)
