SQL DBA and Test Operations Resume Redmond, Washington - Hire IT People

TECHNICAL SKILLS

Applications: SQL Server 1.1 through 2012, Office 2010, SCOM (System Center Operations Manager), Visual Studio.

Confidential Internal applications: WTT 2.6, Machine imaging (UIP and ASI), Source Depot, Razzle, Build.exe

Languages: CMD.exe batch scripting, TSQL, VB Script, PowerShell

Operating Systems: Confidential DOS, Windows 9x/ME, Windows NT4.0, Windows 2000, Windows XP, Windows 2003, Windows Vista, Windows 7, Windows Server 2008, Windows Server 2008 R2.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, Washington

SQL DBA and Test Operations

Responsibilities:

Supported SQL installation scripts.
Wrote procedure for upgrading all production SQL Servers from SQL 2008 R2 to SQL 2012.
Developed automated scripts for removing the SQL service account from builtin administrators. Used Powershell.
Analyzed SQL blocking storms.

Confidential

SCOM SQL DBA

Responsibilities:

Supported SQL installations within the Monitoring Operations Team.
Wrote a TSQL stored procedure to facilitate the on boarding of new servers into the Perf Counters aggregation system (SPEED).
Recommended and implemented improvements to SQL data file configurations on production servers.
Supported the highly scaled SCOM installation.
Designed and performed SQL disaster recovery drills.
Developed PowerShell script utilities using WMI queries to automatically audit the health of 100 servers.
Supported SCOM 2012 on SQL 2012 using SQL High Availability features of Always On Availability Groups.

Confidential

SharePoint SQL DBA

Responsibilities:

Supported SQL Server High Availability (HA/DR) features using SQL Mirroring and Log Shipping for the largest SharePoint installation in the world.
Performed daily SQL database backups and restores.
Supported an internal application that tracked server security vulnerability for thousands of servers across multiple datacenters of the largest software company in the world.
Defined an operations audit process to be used for all applications managed by the EAD team.
Supported a three tier web application that consolidated the security compliance data on thousands of Confidential servers from multiple databases.
Documented the disaster recovery scenarios using the SQL Server Log Shipping.
Installed and supported failover technologies: SQL Server Log Shipping and SQL Server Database Mirroring.
Automated the installation of SQL Server Database Mirroring to standardize the use of certificates logins instead of Windows authentication logins.
Enabled job configuration back - up by writing a PowerShell script to generate TSQL scripts of all SQL agent jobs on any SQL server instance.

Confidential

Operations Engineer

Responsibilities:

Maintained all machine imaging using Unified Imaging Process (UIP) for the SQL Business Unit
Mass deployment of machine operating systems to enable automated product testing on thousands of computers daily with 98% success rate.
Enhanced robustness of UIP imaging WTT job by creating pre-validation steps to the job automation using CMD.EXE batch with support for WMI queries through on-the-fly generated VBscript.
Supported lab Hyper-V Servers running Windows Server 2008 and Windows Server 2008R2 employing PowerShell library from codeplex.com to automate administration of the VMs.
Fully automated application installations of Visual Studio Dev10 with CMD.EXE batch.
Wrote TSQL queries for managing data in the dynamic imaging database.

We provide IT Staff Augmentation Services!

Sql Dba And Test Operations Resume

Redmond, WashingtoN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship