Banner Image

All Services

Programming & Development Database Design & Administration

SQL Server DBA | SQL Developer | SSIS |

$10/hr Starting at $30

I have 8+ years of experience in Microsoft SQL Server as developer, database administrator, ETL (SSIS) developer and Reporting (SSRS) using SQL Server 2016/2014/2012/2008 and also Completed MCSA( Microsoft Certified Solutions Associated ) Certification * Have good Logical thinking skills and also have very good experience in Analyze and Troubleshooting Performance issue * Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio SSMS. * High-Skilled in Writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expression, Function, sorting the data, Defining Data Source and subtotals for the reports using SSRS 2016/2014/2012 * Rich development experience in creating tables, views, triggers, stored procedures, user defined functions and other T- SQL statements. * Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views. * Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. * Identifying and resolving blocking and deadlock issues by using DMV, Activity Monitor, Sp_Who2, Extended Events and Profiler. * Analyzing Execution plan(hash join, merge join) and re-arrange the query to avoid using hash join * Identifying and resolving fragmentation and performance issues * Design and monitor database maintenance activity. * Strong experience in database installation, Log Shipping, Replication, Mirroring, implementing backup and recovery strategy for applications and databases. * Responsible for securing SQL Server, user management, assigning permission and roles * Have good experience in Database migration activities * Highly experienced in the whole cycle of SQL server integration services SSIS 2012 packages Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing ETL Purposes across different servers. * Strong Experience in SSIS in different transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Slowly change Dimension and etc.

About

$10/hr Ongoing

Download Resume

I have 8+ years of experience in Microsoft SQL Server as developer, database administrator, ETL (SSIS) developer and Reporting (SSRS) using SQL Server 2016/2014/2012/2008 and also Completed MCSA( Microsoft Certified Solutions Associated ) Certification * Have good Logical thinking skills and also have very good experience in Analyze and Troubleshooting Performance issue * Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio SSMS. * High-Skilled in Writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expression, Function, sorting the data, Defining Data Source and subtotals for the reports using SSRS 2016/2014/2012 * Rich development experience in creating tables, views, triggers, stored procedures, user defined functions and other T- SQL statements. * Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views. * Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities. * Identifying and resolving blocking and deadlock issues by using DMV, Activity Monitor, Sp_Who2, Extended Events and Profiler. * Analyzing Execution plan(hash join, merge join) and re-arrange the query to avoid using hash join * Identifying and resolving fragmentation and performance issues * Design and monitor database maintenance activity. * Strong experience in database installation, Log Shipping, Replication, Mirroring, implementing backup and recovery strategy for applications and databases. * Responsible for securing SQL Server, user management, assigning permission and roles * Have good experience in Database migration activities * Highly experienced in the whole cycle of SQL server integration services SSIS 2012 packages Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing ETL Purposes across different servers. * Strong Experience in SSIS in different transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Slowly change Dimension and etc.

Skills & Expertise

Data WarehouseDatabase AdministrationDatabase DesignDatabase DevelopmentMicrosoft SQL ServerQuery OptimizationReportsSQLStored ProceduresTransact SQL

0 Reviews

This Freelancer has not received any feedback.