Banner Image

All Services

Programming & Development Database Design & Administration

SQL Database development

$40/hr Starting at $1K

  • IT industry performing Database Administration, Design and Development using SQL Server 2005/2008 R2/2012.
  • Expertise working with SQL Server 2005/2008 R2/2012 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS and SSRS.
  • Experience in data Normalization and Data Modeling using Erwin and generating mapping documents.
  • Extract Transform Load ETL development using SQL Server 2005, SQL server 2008R2 Integration Services SSIS and SQL Server 2008R2 Reporting Services SSRS .
  • Experience with Ad-hoc reporting, parameterized, custom reporting using SSRS for daily Ad-Hoc reports.
  • Configured and administer BPA Business Process Automation for designing ETL work flow and including multiple packages within the work flow
  • Documenting all ETL projects and work flows by using Bi Documenter and also including supporting documents for troubleshoot for each project.
  • Developing Test Plans, Test scripts and Executing Test Cases using HP ALM- quality center 11.
  • Working with new data quality services DQS in SQL 2012 as part of creating rules for data mapping and data cleansing.
  • Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
  • Experience in Data Migration by using side-by-side upgrade process Management.

About

$40/hr Ongoing

Download Resume

  • IT industry performing Database Administration, Design and Development using SQL Server 2005/2008 R2/2012.
  • Expertise working with SQL Server 2005/2008 R2/2012 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS and SSRS.
  • Experience in data Normalization and Data Modeling using Erwin and generating mapping documents.
  • Extract Transform Load ETL development using SQL Server 2005, SQL server 2008R2 Integration Services SSIS and SQL Server 2008R2 Reporting Services SSRS .
  • Experience with Ad-hoc reporting, parameterized, custom reporting using SSRS for daily Ad-Hoc reports.
  • Configured and administer BPA Business Process Automation for designing ETL work flow and including multiple packages within the work flow
  • Documenting all ETL projects and work flows by using Bi Documenter and also including supporting documents for troubleshoot for each project.
  • Developing Test Plans, Test scripts and Executing Test Cases using HP ALM- quality center 11.
  • Working with new data quality services DQS in SQL 2012 as part of creating rules for data mapping and data cleansing.
  • Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
  • Experience in Data Migration by using side-by-side upgrade process Management.

Skills & Expertise

Data ManagementDatabase AdministrationDatabase DesignDatabase DevelopmentDB2Microsoft AccessMicrosoft SQL ServerMySQLOraclePL/SQLPostgreSQLSQLTransact SQL

24 Reviews

Sign up or Log in to see more.