Mark Varnas Email & Phone Number

Atlanta, Georgia, Us

Atlanta, Georgia, Us

I push SQL Server Performance to the maximum. On days that I am not Tuning, I work as Sr. Database Admin and projects like: db architecture, migrations, upgrades, SQL load testing, automation with PowerShell, AlwaysOn, etc.For the best conversation in your life, ask me about:- Microsoft SQL Server Performance Tuning- Index tuning, T-SQL tuning, stored procedure tuning, Data Warehouse load job tuning- Remote MS SQL Server DBA Services- Performance load testing- SQL Server Health Checks, Database Server Audits- Complex SQL Server Migration and Upgrade projects- Automation (PowerShell and other methods)- New SQL Server setups (if you clicked 20 times Next, Next, Next, during your SQL install - you got db problems!)- Moving to and from the cloud (Microsoft Azure and Amazon AWS EC2 - act little different than on-premise servers. It's NOT one to one match!)- Automated maintenance plans (think of it as oil changes on your car, except they can be automated)- Automated backups (full, differential, transactional, filegroup, file), statistics maintenance, index maintenance, corruption checks- Data Warehousing, SSIS, SSRSToday SQL depends on a ton of surrounding technologies such as - Active Directory- Group Policy- Windows settings- PowerShell- SAN/storage configuration- Virtualization- Networking - Clustering- and if you are in the cloud, then add more items to the list.You want someone that gets them all.I am Enterprise SQL Server Database Administrator, Architect, and Consultant with 20 years of experience with a variety of very complex highly transactional and Data Warehousing environments. With proven track record in performance tuning, architecture, clustering, administration, high-availability, disaster recovery, complex upgrades, monitoring, mirroring, log shipping, replication, hardware selection, capacity planning and security.Testimonials: https://red9.com/testimonials/Reach out to me at: mark@red9.com

Burlington, Ma, Us

- Validated the new clusters that were brought online. Generated 60+ item list of best practices that were broken during current cluster setups. Was a key part in developing SQL Server deployment standards for physical SQL Servers, SQL Failover Clusters and virtualized SQL Servers.- Led and completed disaster recovery (DR) to a remote data center by setting up SQL clusters, load testing SAN (Hitachi HDS HUS-VM fiber channel), log shipping (we could not use AlwaysOn as servers were SQL2008), built and tested disaster recovery (DR) procedure.- Initiated and ran to completion SQL Server Enterprise Monitoring Project. Developed Proof of Concept going through deep evaluation of 3rd party SQL monitoring software, which uncovered a lot of 3rd party tool shortcomings. As part of this, we were able to get a price for all licenses reduced from $350K+ down to $140K and $45K worth of extra software licenses included. Most of the price reduction was because of the list of shortcomings and bugs that I uncovered in the current monitoring product.- Implemented remediation items on SQL Servers that were not up to the standard. Deployed custom monitors. As part of the project, uncovered a many bad instance / DB settings, DBs full backups missing, servers with no maintenance plans, and slew of other issues.- Led and completed disaster recovery (DR) to a remote data center by setting up SQL clusters, load testing SAN (Hitachi HDS HUS-VM fiber channel), log shipping (we could not use AlwaysOn as servers were SQL2008), built and tested disaster recovery (DR) procedure.- Countless DBA team process optimizations. Trained DBA team on PowerShell and how to manage 300+ SQL Servers using PowerShell. Recommended a comprehensive DBA training plan. Helped to develop deployment standards for SQL servers, SQL clusters and virtualized SQL Servers.

Maintained existing SQL environments to ensure maximum uptime. Responsible for about 100 SQL server stability for 4 data centers (on-site, GA, FL, and UK) and 5 environments (Prod, UA, QC, Test and Dev). Managed SQL Server changes by setting up one server to be able to send out PowerShell remoting commands to others. Setup and maintained backup and maintenance jobs. Created and maintain operational documentation. Developed and enforced security measures around data access. Defined and adhered to standards and best practices.

Production DBA

Production DBA

Production DBA

Production DBA

Bs, Bachelor Of Arts And Sciences, Computer Science

Bachelor Of Science (B.S.), Computer Science