We provide IT Staff Augmentation Services!

Sql Server Database Engineer Resume

PROFESSIONAL SUMMARY:

  • 8+ years of Experience in IT industry
  • Experience in Database design and development using MS SQL Server

TECHNICAL SKILLS:

Operating System: Windows NT/98/2000/XP/2003 server

Languages: T - SQL, IBM Netezza Structured Query Language (SQL), Visual Studio 2010/2012/2013/2015

Tools: SQL Server Management Studio, IBM Netezza,Enterprise Manager SSIS, SSRS.

DATABASE: MS Access, MS SQL Server 2008R 2/2012/2012/2016 , IBM Netezza

Software: MS Office, Visio, Adobe Photoshop, Ms Excel, MS-Project 2000, Toad Data Modeller

Reporting Services: Excel, SQL Server Reporting Services

PROFESSIONAL EXPERIENCE:

SQL Server Database Engineer

Confidential

Responsibilities:

  • Developing database objects like tables, views, indexed views, synonyms, stored procedures, user defined functions and writing dynamic SQL, T - SQL, IBM Netezza.
  • Experience in MS SQL Server 2017/2016/2014/2008/2005 suite of products like SSIS and SSRS.
  • Hands on experience with Database development in OLTP and OLAP.
  • Developing database objects like tables, views, indexed views, synonyms, stored procedures, user defined functions and writing dynamic SQL, T-SQL.
  • Creating Clustered and Non-Clustered indexes on tables for faster query retrieval.
  • Traced long running queries , Time out issues and deadlocks using SQL Profiler .

Confidential

MS SQL Developer

Responsibilities:

  • Creating SSIS Packages. Control flow items and data flow tasks.
  • Using property expressions, variables and script tasks to customize data processing.
  • Creating package configuration files.
  • Importing and exporting packages to SQL Server and file system.
  • Moving packages and configuration files across different environments.
  • Creating audits/logging for SSIS packages on task level and package level.
  • Configuring error handling, notifications, restart ability and checkpoints.
  • Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column, look up, merge etc.
  • Improved slow running jobs with the help of redesign and better ETL processes to meet business needs

Confidential

MS SQL Developer

Responsibilities:

  • Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
  • Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
  • Strong knowledge in Performance point server/Excel reporting.

Hire Now