Banner Image

Skills

  • Business Intelligence
  • Data Management
  • Database Administration
  • Design
  • Microsoft
  • Microsoft SQL Server
  • Programming
  • SAS
  • Server Administration
  • Software Development
  • SQL
  • SQL Server Integration Services (SSIS)

Services

  • SQL Server DBA | SQL Developer (SSIS)

    $12/hr Starting at $25 Ongoing

    Dedicated Resource

    Extensive Experience as a SQL Server DBA (Versions 2000 - 2019) methodically identifying and resolving complex underlying causes of Microsoft SQL Server problems, using a vast variety of techniques and...

    Business IntelligenceData ManagementDatabase AdministrationDesignMicrosoft

About

Expert in Microsoft SQL Server development, SSIS , TSQL, Query Optimization Optimization

Over the past 10 year I have great experience in Microsoft SQL Server development, SSIS , TSQL, Query Optimization . Please see the below my key points:-

Creating run_me.sql scripts having collection of DDL and DML scripts in T-SQL to full fill the requirements.
Used SQL profiler and database engine tuning advisor to optimize queries and enhance the performance of database.
Expertise in writing Complex Store procedure, Functions, Views, and Triggers
Creating views and procedures for listing records in complex summary displays, insertion of data filled in entry forms
Creating user defined functions for the purpose of validations and complex calculations.
Creating different types of SQL Jobs like Monthly Jobs, Weekly Jobs and small periodic jobs for fulfill the needs of all automated processes like Alarm Management, user Email Management, Tracking Management, Reporting Management.
Creating complex procedure to be called in SQL Jobs for periodic creation of tracking records, generating alarms for Tracking Due Dates Passed, Tracking Due Date Approaching,
Creating procedures and functions for Audit Trail system for different displays.
Creating triggers to implement eventual DML statement processing.
Implemented new T-SQL features in SQL Server 2008 like Partitioning, Advanced Error handling, Common Table Expression (CTE)
Made big SSIS project and have done transformations
Extensive experience in C# Development.

Work Terms

Open for any type of work in SQL