SQL Server Specialist Resume Profile

Skills:

Technology	NUMBER OF YEARS USED	LAST USED	PROFICIENCY LEVEL
Building and maintaining data mart extraction processes.	5 Years	2012	3 - Expert
Building and maintaining DTS packages	5 Years	2012	3 - Expert
Building and maintaining ETL scripts	5 Years	2012	3 - Expert
Building and maintaining production SQL jobs	5 Years	2012	3 - Expert
Building and maintaining SQL scripts in Microsoft SQL Server	5 Years	2012	3 - Expert
Building maintaining complex SQL queries for data analysis data extract	5 Years	2012	3 - Expert
Clear/excellent communication skills for interface w/ end-users clients	5 Years	2012	3 - Expert
Database design, modelling, installing, upgrading SQL server	5 Years	2012	3 - Expert
Programming w/ SQL Server 2005/2008, SQL stored procedures	5 years	2012	3 - Expert
SQL Server Configuration	8 years	2012	3 - Expert
User Data and Log File Management	5 years	2012	3 - Expert
Experience in the Unemployment Insurance industry Highly desired	5 years	2012	3 - Expert

Work Experience

Employment History:

Confidential

Database Admin

Key Responsibilities:

Executing the day-to-day database operations Modelling, Installing, configuring, patching and administering the database SQL servers.
BCP, Power down Drill exercise every quarter.
Support migration and upgrade of Databases.
Designed the dimensional data mart and developed SSIS packages to validate
Database Performance monitoring and tuning.
Backup and recovery of Databases.
Proactive monitoring of the production servers and minimizing the downtime.
Timely resolution of the production issues.
Implemented BCP/ETL Scripts for data transformation
Resolve SQL Job failures
Design and ensuring the Physical and Logical Model are in synch with every release
Optimize Data and Log management throughput and availability

Environment: SQL Server 2000, 2005, 2008, Windows 2000, 2003, 2008

Confidential

Database Admin

Key Responsibilities:

Executing the day-to-day database operations modelling, Installing, configuring, patching and administering the database SQL servers.
Support migration and upgrade of Databases.
Database Performance monitoring and tuning.
Backup and recovery of Databases.
Proactive monitoring of the production servers and minimizing the downtime.
Timely resolution of the production issues.
Build and maintained Data Mart Extraction, transformation and loading modules.
Building and maintaining datamart extraction process
Implemented BCP/ETL Scripts for data transformation
Development of data extract, transform and load ETL programs using Microsoft SQL Server, including T-SQL, DTS and SSIS
Resolve SQL Job failures
Optimize Data and Log management throughput and availability

Environment: SQL Server 2000, 2005, 2008, Windows 2000, 2003, 2008, DTS Packages

Confidential

SQL Server Specialist

Key Responsibilities and Achievements

Executing the day-to-day database operations modeling,Installing, configuring, patching and administering the database SQL servers.
Involved on Creating and Implementing Disaster Recovery Plan best practices.
Performance Monitoring Log Application, System, Security , Perform on Regular
and Timely Fashion
Advanced Statistics gathering of Memory, CPU, I/0, Hardware Failure, Application Bottleneck.
Setting up and Maintaining Windows Cluster SQL Clusters
Setting up and maintaining Replication Transactional Snapshot
Created SQL Server Integration Services SSIS Packages for Maintenance plans, Optimization Jobs, and custom data extract scripts.
Creating and Running Maintenance Plans during Maintenance Window.
Replication monitoring.
Monitoring Backup/Restore Refresh non production databases with production database
Resolving Drive Space issues

Environment: Windows 2k,2k3,2k8, SQL Server 2005,2008, SSIS Packages, SQL 2005 Reporting Services, DTS Packages

Confidential

Sr. SQL Server Developer/DBA

Key Responsibilities

Executing the day-to-day database operations Modelling, Installing, configuring, patching and administering the database SQL servers.
Responsibilities include Configure, Design , install and upgrade SQL server
Involved on Creating and Implementing Disaster Recovery Plan best practices.
Performance Monitoring Log Application, System, Security , Perform on Regular
and Timely Fashion
Advanced Statistics gathering of Memory, CPU, I/0, Hardware Failure, Application Bottleneck.
Familiar with Log Parser 2.2 and Performance Analysis Log.
Setting up and Maintaining Windows Cluster SQL Clusters
Created packages using SSIS for Data mart extraction from Flat Files, Excel Files
Setting up and maintaining Replication Transactional Snapshot across geographic locations.
Creating and Running Maintenance Plans during Maintenance Window.
Monitor and Resolve Job Failures Debug stored Procedure if required .
Replication monitoring.
Designed SQL SSIS Packages in to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations.
Running DTS/DTSX Packages for Failed Jobs
Monitoring Backup/Restore Refresh non production databases with production database
Resolving Drive Space issues
Monitoring using wide range of Quest tools that includes Spotlight, Performance Analysis,
SQL Watch, Benchmark Factory for Databases, Toad
Development of data extract, transform and load ETL programs using Microsoft SQL Server, including T-SQL, DTS and SSIS
Building and maintaining datamart extraction process
Implemented BCP/ETL Scripts for data transformation
Resolve SQL Job failures
Creates SQL scripts to correct identified data issues that cannot be corrected by the existing applications.
Design and ensuring the Physical and Logical Model are in synch with every release
Optimize Data and Log management throughput and availability

Environment: Windows 2k,2k3,2k8, SQL Server 2005,2008, SSIS Packages, SQL 2005 Reporting Services, SQL Lite Speed, DTS Packages

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship