Banner Image

All Services

Programming & Development

SQL Server DBA Architect

$8/hr Starting at $25

A Microsoft Certified SQL Server DBA and Architect with 8.5 years of experience in Production Support and Database Administration using Microsoft SQL Server 2000, 2005, 2008, 2008R2 and 2012 • Hands on Experience in installing, configuring and monitoring SQL Server 2000, 2005, 2008 and 2008R2 • Testing and preparing checklist for SQL Server 2008 on Windows 2008 R2 (Standalone) • Installation of SQL Server 2008 R2. Upgrading SQL Server 2005 to SQL Server 2008 R2 using In-place and side-by-side methods • Installing and configuration of SQL Server 2012 • Setting up and Maintaining of SQL Server failover Cluster Environment (2005,2008 and 2008R2) • Upgrading service packs and hot fixes on SQL Server instances • Upgrade/Migration experience from SQL Server 2000 to SQL Server 2005, 2008 and SQL Server 2005 to SQL Server 2008 and 2008R2 using side by side method. • Upgrading the packages from DTS – SSIS (SQL 2000 – SQL 2005/2008) and SSIS – SSIS (SQL 2000 – SQL 2008/2008R2) • Disaster Recovery Planning & Implementation • Planning and Creating Databases as per Microsoft Recommendations • Expertise in Database Backup, Restoration, and Recovery procedures • Setting up processes for regular backups and restore methods, and ensuring the processes are followed • Database Refresh • Regular Database Administration Activities • Creating logins and users, Provide the required privileges as per business needs. • Experience in using DBCC Commands and DMVs • Experience in implementing and maintenance of different types of Replications like Snapshot, Transactional • Configuring and maintenance of Log shipping and Data Base Mirroring • Performance monitoring • Creating Maintenance Plans for administration tasks

About

$8/hr Ongoing

Download Resume

A Microsoft Certified SQL Server DBA and Architect with 8.5 years of experience in Production Support and Database Administration using Microsoft SQL Server 2000, 2005, 2008, 2008R2 and 2012 • Hands on Experience in installing, configuring and monitoring SQL Server 2000, 2005, 2008 and 2008R2 • Testing and preparing checklist for SQL Server 2008 on Windows 2008 R2 (Standalone) • Installation of SQL Server 2008 R2. Upgrading SQL Server 2005 to SQL Server 2008 R2 using In-place and side-by-side methods • Installing and configuration of SQL Server 2012 • Setting up and Maintaining of SQL Server failover Cluster Environment (2005,2008 and 2008R2) • Upgrading service packs and hot fixes on SQL Server instances • Upgrade/Migration experience from SQL Server 2000 to SQL Server 2005, 2008 and SQL Server 2005 to SQL Server 2008 and 2008R2 using side by side method. • Upgrading the packages from DTS – SSIS (SQL 2000 – SQL 2005/2008) and SSIS – SSIS (SQL 2000 – SQL 2008/2008R2) • Disaster Recovery Planning & Implementation • Planning and Creating Databases as per Microsoft Recommendations • Expertise in Database Backup, Restoration, and Recovery procedures • Setting up processes for regular backups and restore methods, and ensuring the processes are followed • Database Refresh • Regular Database Administration Activities • Creating logins and users, Provide the required privileges as per business needs. • Experience in using DBCC Commands and DMVs • Experience in implementing and maintenance of different types of Replications like Snapshot, Transactional • Configuring and maintenance of Log shipping and Data Base Mirroring • Performance monitoring • Creating Maintenance Plans for administration tasks

Skills & Expertise

Database AdministrationDisaster RecoveryDtsMicrosoftMicrosoft SQL ServerSQLSQL 2008SsisTestingWindows

0 Reviews

This Freelancer has not received any feedback.