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: Mar 27, 2015

Mark Varnas

Expert SQL Server Administrator, Architect & Dev
   United States
  |   Alpharetta, GA
  |  8:34 pm Local Time

Overview

Minimum Hourly Rate $85

Microsoft certified. Today I manage 300+ SQL Servers, 5,600+ databases, 22 EB (exabytes) of data spread across 16 data centers. I manage SQL servers ranging across many version up to SQL 2014. I have done database work for 15+ years at numerous jobs and many consulting clients.

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

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 »
Mar 23, 2015|Database Administration|Private|Completed
|
5.0
Mar 18, 2015|Database Administration|Private|Working
Feb 17, 2015|Database Administration|Private|Completed
|
5.0
Jun 24, 2014|Database Administration|Private|Working

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 Remote SQL Server DBA work:
- 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.
- 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, validation, troubleshooting
- Tuning VM hypervisors (VMware and Hyper-V)
- TSQL development (triggers, CTEs, views, stored procedures)
- ETL processing (data load and transformation)
- Security, Auditing
- Compliance: PCI, Healthcare, data masking and anonimizing
- Installations, Upgrades, Service Pack, Cumulative Updates, Migrations, Patching
- SAN: migrations, I/O stress testing
- SQL 2014, SQL 2012, SQL 2008 R2, SQL 2008, SQL 2005, SQL 2000




Read More »

Keywords

SQL Server SQLServer dba remote dba MS SQL MSSQL SQL database administrator TSQL DBA Azure mirroring sql db sql ms sql 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