SQL Database development (5050532)

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

alberico says,

I'm really satisfied of Ke work. First of all, BEFORE to be hired he was very kind and give us some advice to define the origin of a problem. Then he understood very well the task we need to complete and with constant contact with us he performed the ios build we need. Ke is cleaver, gentle and professional. I strongly reccomend him for his skill and empathy

for Issue fixing with ionic+capacitor+auth0 on Aug 03, 2021
Marko Jakic says,

Very pleased to collaborate with.

for Serverless API Integration with AWS on Jul 26, 2021
Mohammed 826 says,

Highly recommended for all your ideas!

for Develop apps using React & Djano on Jul 12, 2021
Mohammed 826 says,

Fantastic developer always helpful and supportive!

for Develop apps using React & Djano on Jul 12, 2021
Marko Jakic says,

Initial infrastructure was proactively done with promising results and on time.

for Serverless API Integration with AWS on Jul 12, 2021

Sign up or Log in to see more.

Ke Chankrisna