We provide IT Staff Augmentation Services!

Sql Database Administration Resume Profile

NC

Professional Experience:

  • Over 15 years of experience in SQL Database Administration and Programming
  • Proficient in the following
  • SQL Server and T-SQL.
  • creating and using Stored Procedures, Views, User Defined Functions.
  • creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
  • creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
  • data Extraction, Transforming and Loading ETL using various tools such as SQL Server Integration Services SSIS , Data Transformation Services DTS .
  • creating dynamic packages for Incremental Loads and Data Cleaning in Data WareHouse using SSIS.
  • experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
  • Extracted, transformed and loaded data from various data sources and destinations like Access,Excel,CSV,flat files using connectors, tasks and transformations provided by SSIS.
  • developing Drill Down, Sub reports and Charts using Global variables,Expressions and Functions for the business users.
  • Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.

Technical Proficiency:

  • Operating Systems: Windows XP,7.
  • Languages: Clipper, T-SQL, HTML
  • Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager.
  • Databases: Dbase,MS Access, MS SQL .
  • Reporting Tools: Excel, SQL Server Reporting Services, R R Report Writer, Crystal Reporting.
  • Other Tools: MS Office, Visio, MS Excel,

Skills:

  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
  • Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
  • Bilingual Fluent in English and Spanish
  • Served in the United States Marine Corp. 1978 - 1982

Hire Now