SQL Server DBA Resume Upper Marlboro, Maryland - Hire IT People

SUMMARY:

Database Administrator with more than 5 years' experience in the design, implementation and maintenance of SQL Server solutions in an Enterprise environment.
A laser - focused, detail-oriented, reliable, responsible, self-motivated team player and an avid listener.
SQL Server Administration
Performance Tuning and Capacity Monitoring
SQL Server Disaster Recovery
SQL Server Virtualization
SQL Server High Availability
SQL Server Consolidation

TECHNICAL SKILLS:

SQL Server administration - 2005/2008/2012/2014 Performance Tuning
Windows Server EMC storage Vmware

PROFESSIONAL EXPERIENCE:

SQL Server DBA

Confidential, Upper Marlboro, Maryland

Responsibilities:

Provide sole 24x7 global support and troubleshooting for 50+ instances of Microsoft SQL Server version 2005, 2008 R2 and 2012.
Architect, install, configure, optimize and manage enterprise-wide SQL Server 2005, 2008 R2 and 2012 instances.
Experience managing small to large scale SQL implementations. Ranging from small departmental systems to large scale mission critical SAP SQL Server implementations. Including multiple 1.5TB+ databases with high resource and high availability requirements.
Upgraded SQL environment of 50+ instances on multiple occasions. From SQL 2005 to 2008 in 2012 and from SQL 2008 to SQL 2012 R2 in 2014.
Restore database from backup files.
Apply SQL Server Service Packs and Cumulative Updates as required.
Setup and managed Windows and SQL Server clustering for mission critical physical systems and Symantec's Application HA for virtual SQL Servers to ensure high availability.
Implemented and managed SQL Server disaster recovery solutions using native and Quest Litespeed SQL backup and log shipping. Performed point-in-time database restores as needed. Performed successful annual SQL Server disaster recovery test for the past 5 years - failing over mission critical SQL Server databases from Maryland to Syracuse, NY.
Consolidated the corporate SQL environment from 50 SQL instances down to 35 SQL instances. This reduced administrator management overhead and SQL licensing requirements.
Supported SQL Server virtualization project. Resulting in a 60% SQL Server virtualization rate and much greater server resource utilization without noticeable performance degradation. Budget constraints for host resources stopped this project from achieving 100% virtualization.
Perform routine database migrations to support database refreshes from production to test and database consolidation efforts.
Monitor systems and capture performance data to look for tuning opportunities using the following tools - PolyMon, Perfmon data collection sets, PAL, SQL trace, SQL Nexus, Clear Trace, diagnostic DMVs, SQL Sentry's Plan Explorer, Idera's SQL diagnostic Manager for critical systems, homegrown monitoring for systems without budget for a vendor solution.
Setup automation with SQL Agent and Database Mail for maintenance, error alerting and job failures.
Experience setting up and managing transactional replication.
SSIS experience - Developed and managed a SSIS data import/export solution for a data logging application which captured the local Confidential Healthcare telemetry data. Use SSIS for data import/export operations. Help developers troubleshoot SSIS package issues. Upgraded developer SSIS packages from SQL 2005 to 2008 R2 to 2012.
Set up and configured SSRS. Created and deployed reports from BIDs. Provided access to SSRS reports.
EMC storage experience on CX3-80, CX4-80 and VNX 5500: Setup host connectivity to SAN. Designed overall SAN storage with a focus on SQL Server performance. Worked with storage pools, virtual provisioning, FAST and FAST Cache. Created luns and assigned to hosts according to best practices. Monitored overall SAN performance and capacity using Navisphere Analyzer.
Experience with Vmware: Creating virtual machine templates, deploying virtual machines, assigning/editing guest hardware resources, setting guest reservations, v-motion guests, updating Vmware tools, setting host into maintenance and shutting down to perform hardware maintenance, monitoring guest and host utilization. Work with Symantec's Application HA for SQL high availability in a virtual environment.
Provided data center support - hardware vendor support, swapping server and storage hardware, racking servers, cabling, building maintenance management.

ENVIRONMENT: Dell 6850/R710/R180 servers, EMC VNX 5500, Vmware, Windows Standard and Enterprise 2005 to 2008 R2, SQL Server Standard and Enterprise 2005, 2008 R2 and 2012.

We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Upper Marlboro, MarylanD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship