SUMMARY

• Over Six years of experience in IT as MS SQL SERVER 2008/2005/2000 Database Administration (DBA) and Development in Windows environment.
• Excellent skills in Database administration activities like Backup & Recovery, Database Security, Data Transformation Services, SSIS, Database designing and Query optimization.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experience in Installation configuration and administration of MS SQL server on Windows NT, 2000, 2003 and 2008 servers in very large environments.
• Excellent Experience in migration Of SQL Server 2000, 2005 to SQL 2008.
• Well hand on experience in Objects creation such as Tables and Views, Table Normalization, User functions, views, user profiles, data dictionaries, Clustered and Non - Clustered Indexes to facilitate efficient data manipulation and data consistency.
• Expertise in creating Reports using SQL Server BIDS like drill down and drill through reports, parameterized reports.
• ETL expertise in using SSIS to Bulk Insert, and creating SSIS Packages.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Monitored and configuration of MS SQL Server and. And Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages and In-depth knowledge of Transact-SQL.
• Experience in developing views, store procedures, and user defined functions to implement business logic and data protection.
• Assisted in implementing different types of replication models like snapshot and transactional.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Worked with third party backup solutions like SQL Light Speed, RedGate ToolBelt, RedGate Backup Pro.
• Experience in Installation, Configuration and Administrations of Business Intelligence solutions including SSIS and SSRS.
• Good interpersonal, analytical and communication skills.

TECHNICAL SKILLS

DBMS: MSSQL Server 2000, 2005 and 2008, MS-Access, MYSQL

Database Utilities: SQL Management Studio, Query Analyzer, SQL Server Profiler, SQL

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

Reporting Tools: MSSQL Server 2005/2008 Reporting Services (SSRS)

Programming Language: T-SQL, HTML

Application Packages: MSOffice suite

Operating Systems: Windows 2000/ XP/7, Windows Server 2003, 2008, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SQL Database Administrator

Responsibilities:

• Installation of the Microsoft SQL Server 2005 and 2008 on New Production and Test servers with latest Security updates involving Service Packs and Security patches.
• Performed Data migration from SQL Server 2005 to SQL Server 2008.
• Provided support for existing Disaster Recovery procedures and Data Modeling.
• Created user logins with appropriate roles, granting the privileges to appropriate users and groups.
• Recovering databases from damaged or suspect conditions.
• Monitored and modified performance using Execution plans and Index tuning.
• Configured Transactional replication between Primary Server and Dedicated servers, with separate Distributor server and troubleshooting replication issues.
• Prepared and documented Backup & Restore Plans.
• Implemented backup process using SQL Lite Speed a Backup solution for MS SQL Server.
• Implemented and successfully tested Log Shipping in SQL Server 2005 and SQL Server 2008.
• Involved in Performance tuning with the help of SQL Server Profiler, Database Engine Tuning advisor & Windows performance monitor.
• Backing up master & system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• Create and maintain database Maintenance plans on various production and development SQL servers.
• Resolved locking (Dead Locks) and blocking issues.
• Partitioning tables to achieve better performance for access and writes.
• Created and deployed SSIS Packages to import and export data from various flat files and Database Replication experience.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Designed various reports using different reporting features such as group by, drilldowns, and drill through.
• Created parameters for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts, images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Created report models for Ad - hoc reporting
• Created weekly and monthly reports as per requirement using SSRS.
• Scheduled Reports to be delivered to User on demand Basis in SSRS report Manager.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, Windows 2003 server/ 2008, SQL Query Analyzer, SQL profiler, SQL Litespeed Backup, RedGate Tool Belt, Visual Studio 2005, SSMS.

Confidential, VT

SQL Server DBA

Responsibilities:

• Installed, Configured and Monitored SQL Server 2005 and 2008.
• Created and used Tables, Views, Indexes, Stored Procedure and Triggers.
• Involved in Performance Tuning of Code using execution plan and SQL profiler. Added Indexes to improve performance on tables.
• On hand experience with Index De-Fragmentation and assigning Page Fill factor for better performance.
• Created Automatic Jobs to reorganize and Rebuild Indexes on Tables to reduce the Internal and External fragmentation.
• Tuned the Slow running queries that were causing Timeouts in the SQL Server using proper Indexes and Joins.
• Developed, monitored and deployed SSIS packages.
• Worked with transferring the data using SSIS (SQL Server Integration Services) packages.
• Extensively worked in sorting the data, defining subtotals for the reports
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures
• Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze .
• Identified and added the report parameters and uploaded reports on to the report manager and organized them in folders.
• Performed Database Backups for Production, Test and Development Servers and Restored Backups onto Test Servers.

Environment: MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005, Windows Server 2003 and 2008, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Database Maintenance Plan Wizard, Data Transformation Services (DTS).

Confidential, Dallas, TX

SQL Database Administrator

Responsibilities:

• Worked closely on SQL Server 2005 and 2008.
• Involved in performing Extraction, Transformation and Loading using SSIS
• Developed all the required Stored Procedures, user defined Functions, Triggers, Views using T-SQL as per business logic.
• Used SQL Server 2005/2008 Reporting Services (SSRS) for generating reports.
• Worked extensively with client gathering requirements to generate customized SQL Reports (Subscriptions Created).
• Development and Implementation of Backup and Recovery strategies.
• Database Backup Compression and Encryption using SQL 2008.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, Normalized Tables, established Joins and created Indexes whenever necessary.
• Used SharePoint Enterprise Portal for hosting Scorecards and SSRS Reports
• Promoted database objects from DEV/TEST to Production. Coordinated and Communicated production schedules within Development and Testing team.
• Worked extensively on all the Environments: Development, Testing and Production
• Worked with front-end application developers to understand their requirements and create Procedures and Reports.
• Automated Database Maintenance tasks by creating Jobs, Alerts and Operators through SQL Server Agent.

Environment: Microsoft SQL Server 2008, SQL Server Reporting Service, SQL Server Integration Service, Visual Studio, Windows XP, MS Office.

Confidential, Dallas, TX

SQL DBA

Responsibilities:

• Responsible to meet the information demands of our business users by delivering timely, accurate, meaningful and standardized data and reporting.
• Excellent experience in developing Stored Procedures, Views and Indexed Views.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2008 Integration Services (SSIS)
• Migrated DTS Packages to SSIS Packages and loaded the data from SQL Server 2000 to SQL Server 2005.
• Involved in ETL framework standards like error processing, reconciliation, validation.
• Worked with package configuration wizard to create configuration file, SQL server table or environment variable to use in further packages.
• Created SQL jobs and scheduled them for nightly loads
• Assisted colleagues in writing VB Script for scripting the task in SSIS packages.
• Experience in designing Database Models for creating tables, indexes, optimizing views using MS Visio.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS)
• Setting and maintaining database logins, users, roles and permissions.
• Retrieve data from cubes using SSIS.
• Consolidated data from OLTP databases in to OLAP using SSIS as ETL.
• Troubleshoot with add and removal of different Data Connections within SQL Server Integration Services.
• Worked with technology features in SQL Server such as Partitioning, File Groups, Replication, Materialized Views, and Options available in executing database statistics.
• Implemented clustered and non-clustered indexes to help performance.

Environment: Microsoft SQL Server, SSIS 2008, SSRS 2008 Visual Studio, Microsoft Office Performance Point Server, Planning, Microsoft Office share point 2007, Windows 2003/XP/vista.

Confidential, Portland, OR

System Administrator

Responsibilities:

• Installed Windows Server 2003/XP/7 and other Operating systems
• Worked with different kinds of Data Discs and Storage Units to store, backup and restore database.
• Worked Extensively with MS Access to create database and maintain it.
• Implementing Disk Backups and Recovery when necessary.
• Assist team on diagnose and resolution of Hardware failure, Software problems and system issues.
• Responsible for providing help, support and assistance in installation of network devices, such as router, modem, switches.
• Very good knowledge on Hardware information such as CPU, Memory, Discs, Network Wiring, BIOS, Network Drives, and their utilization.

Environment: MS Windows XP/2003, MS Access, MS Excel, MS Office Suites, TCP/IP, HTML, DHTML JavaScript, PHP.