Sql Server Consultant Resume
Pittsburgh, PA
Profile
Trained and experienced database administrator with strong knowledge base in server configuration and maintenance, database design, development, and administration, integration services, reporting services, and analysis services management, as well as performance tuning in SQL Server.
Core skills/Areas of Knowledge
Database Administration
Performance Tuning
Installation and Configuration
Database Maintenance
Analysis Services
High-Availability Solutions
Logical/Physical DB Design
Integration Services
Disaster Recovery Planning
Database Development
Reporting Services
User Support
Technical Summary
Certifications
MCDBA, MCITP (Database Administrator)
Technical Skills
Databases: SQL Server 2000/2005/2008 R2
Languages: SQL, T-SQL, MDX, VBA, C, C++, Shell Script, HTML, XML
Operating Systems: Windows Server 2000/2003/2008 R2, Windows
Other: ERwin, Visual Studio, Business Intelligence Development Studio, Visual SourceSafe,
Windows Active Directory, Office Suite
Professional Experience
Confidential, Pittsburgh, PA
SQL Server Consultant Nov. 2010 - present
SQL Server systems upgrade and server configuration, database performance optimization, and high-availability (failover clustering, log shipping, replication, and database mirroring); resolved problems with transaction replication to enhance performance; configured database mirroring and replications; provided recommendations on high-availability solutions to support Web applications.
Confidential,San Francisco Pittsburgh, PA
Confidential,SQL Server DBA/Database Architect Aug. 2005 - Sept. 2010
Provided database solutions to meet broad range of objects, including server configuration and maintenance (in clustering, SAN, virtual server, and enterprise environments), database design, development, and implementation, database backup, restore, and performance optimization, data maintenance, reporting services, integration services, analysis services, and SQL Server upgrade as well as user support.
Confidential,) Pittsburgh, PA
Data Coordinator Dec. 2004 - May 2005
Coordinated clinical data collection, data retrieved from different data sources, manipulated large clinical data and generated datasets for statistical analysis.
Confidential, Pittsburgh, PA
SQL Server DBA Feb. 2001 - Feb. 2003
Maintained and developed Center-wide Information System, planned and led system upgrade project, performed data maintenance, backup planning, problem-solving, and system development, trained and supported users.
Education
Master of Science in Information Sciences