We provide IT Staff Augmentation Services!

Sql Server Consultant Resume

3.00/5 (Submit Your Rating)

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.

  • SQL Server Management - managed and maintained server environments for developing, testing and implementing SQL server based databases to support in-house developed applications and third party applications, set up Maintenance Plans, created SQL Server Agent jobs, configured linked servers, created endpoint, Service Broker, and Event Notification, maintained security, performed troubleshooting of server related issues.
  • Database Management - maintained security, supported QA testing and production releases, reviewed code for creating/modifying database objects (tables, views, stored procedures, functions, and triggers), implemented database object modifications on production servers included Full-Text Search, and CLR integration, supporting ETL tools, Web applications and database applications for sample tracking, data management, reporting and data analysis.
  • Data Management - managed tables, indexes, and data in SQL Server databases.
  • Backup, Restore, and Recovery - set up disaster recovery plans and database backup plans, back up, restored, snapshot and recovery databases.
  • Performance Tuning - used System Monitor, SQL Server Profiler, Query Plans, and Performance Dashboard to monitor servers, removed blocking-deadlock, maintained and tuned indexes, and modified database objects to enhance performance.
  • High-Availability Solutions - configured log shipping to provide standby databases at different locations for disaster recovery.
  • Integration Services (SSIS) - created and managed SSIS packages, deployed SSIS packages to production servers, performed troubleshooting of SSIS packages.
  • Reporting Services (SSRS) - configured data sources, managed security, created and modified reports, deployed reports to production servers.
  • SQL Server Upgrade - designed upgrade strategy, led projects to upgrade servers from SQL Server 2000/2005 to 2005/2008, installed and configured SQL Server, migrated databases, SSIS and SSRS, modified related objects to ensure upgrade smoothly.
  • 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.

  • Information System Management - maintained and developed databases and Access database applications, created reports to meet on user needs.
  • Database Development - designed data models and databases, created/modified database objects (tables, views, stored procedures, functions, and triggers), converted Access databases to SQL Server databases, migrated data to target databases.
  • SQL Server Upgrade - installed and configured SQL Server 2000, migrated databases.
  • Data Management - imported data from a variety of sources into SQL Server databases, updated and cleaned data in SQL Server databases, exported data and generated datasets for data analysis.
  • Education

    Master of Science in Information Sciences

    We'd love your feedback!