Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Mark Varnas | Elance
 
176985602337900
Last Sign-in: Feb 26, 2015

Mark Varnas

Expert SQL Server Architect, Admin & Developer
   United States
  |   Alpharetta, GA
  |  10:33 am Local Time

Overview

Minimum Hourly Rate $85

I WILL REFUND 100% OF YOUR PAYMENT if I don't deliver on what I promise. PERIOD.

Today I manage 300+ SQL Servers, 5,600+ databases, 62TB of data spread across 16 data centers. I manage SQL servers ranging from SQL 2000 all the way up to SQL 2014. I have done database work for 15 years at numerous jobs and many consulting clients.

I'd love to talk to you about any questions you may have (even if you don't hire me!) I live in Atlanta, Georgia - so reaching me over the phone will be simple.


Read More »
Feb 17, 2015|Database Administration|Private|Completed
|
5.0
Jun 24, 2014|Database Administration|Private|Working
Jun 19, 2014|Networking & Security|Private|Completed
|
5.0
Jun 18, 2014|Technical Support|Private|Completed
|
5.0

View All »

Portfolio

SQL Server 2008 Implementation and Maintenance Certification 2011 January

Skills (10)

Tested
Microsoft SQL Server Programming
MS SQL Server 2005 Test
My Score
avg
Microsoft SQL Server
My Score
avg
SQL Programming
SQL
My Score
avg
Microsoft SQL Server Administration
Query tuning and optimization
Windows Failover Clustering
Log Shipping
Mirroring
SQL Server Replication
Disaster Recovery (DR)
Microsoft Windows Powershell

Service Description

I specialize in:
- SQL Server Diagnostics and figuring out what is running slow
- SQL Server Health Check - 78+ point check list
- SQL Query Performance Tuning - anything from bad settings to tuning execution plans, indexing, etc.
- Installations / Upgrades / Service Pack installs / Cumulative Updates
- Maintenance plan setup: backup (full, differential, transactional, filegroup, file), statistics maintenance, index maintenance, DBCC CHECKDB, etc.
- Automation using TSQL, Windows PowerShell, C#
- Remote Administration
- High Availability: Log Shipping, Replication, Mirroring, AlwaysOn
- Windows Failover clustering: setup and validation
- Tuning VM hypervisors (VMware and Hyper-V)
- TSQL development
- ETL processing (data load and transformation)
- Security / Auditing
- Compliance: PCI, Healthcare, data masking and anonimizing
- DB Migrations
- SAN migration, SAN/IO stress testing
- SQL 2014, SQL 2012, SQL 2008 R2, SQL 2008, SQL 2005, SQL 2000
- SQL Server: Enterprise, Standard, Web, Express and Developer Editions



Read More »

Keywords

SQL Server SQLServer MS SQL MSSQL SQL database TSQL DBA PowerShell Azure mirroring sql db stored procedure trigger migration Performance Tuning Database Administrator Database Administration query tuning High Availability
Company Snapshot
IT & Programming
9
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
Total
Milestones
Hours
Reviews
5.0
Recommend
Clients
Total
Repeat
Earnings
Private
Private
Total
Per Client
Identity
Username
sqlhouse
Type
Company
Member Since
July 2013
Elance URL
Verifications
Groups
Mark Varnas | Elance

Mark Varnas