SUMMARY

• Around 8 years of experience in various phases of SDLC with various versions of MS SQL Server Database.
• Extensive experience as an SQL Server DBA (2012/2008R 2/2008/2005/2000 /7.0 ) in Production, Development and Test Environments.
• Administered the Installations, Configurations and patch management of MS SQL Server 2012/2008R 2/2008/2005/2000 /7.0
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Proficient in requirement analysis, system design, and Object Oriented Design (UML).
• Equipped with the broad experience of Financial, Banking & Telecom applications testing UNIX, Client/Server and Web based Applications
• Extensively worked in OLTP & OLAP environment that includes production (24x7), QA and development databases in SQL Server.
• Experience in Query optimization & Performance tuning. Used SQL Profiler, Execution Plan, Performance monitor, DBCC commands and troubleshooting.
• Proficient in logical and physical data modeling, forward and Reverse engineering using Erwin data modeling tool.
• Well - experienced in application software development in Microsoft Access/Excel/Word/Outlook SQL, PL SQL, UNIX.
• Experience in creating databases, transactions, tables, indexes, constraints, writing and debugging stored procedures, triggers, views, functions and cursors using SSMS & SQLCMD.
• Maintaining SQL Script for creation of Database Objects and generating scripts using Erwin tool.
• Expert in maintenance of SQL Server through DBCC Utilities, and maintenance plans to update statistics and rebuild indexes.
• Extensively worked in highly available SAN & Active, Passive Clustering environment with Very Large Databases (VLDB) with change control (Visual Source Safe) and (Team Foundation Server).
• Extract, Transform and Load (ETL) data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various DTS & SSIS packages.
• Highly skilled in Data migration of data from Excel, Flat File, Sybase, Oracle to MS SQL Server using tools like DTS, SQL Server Integration Services (SSIS), BULK INSERT, BCP and Replication between SQL Server (heterogeneous/homogenous).
• Extensive experience in the development of Reports using SQL Server 2005 Reporting services (SSRS).
• Working Experience in designing, implementing, maintaining, and documenting complex database applications, data warehouse (OLAP, Star Schemas, Snowflake Schemas, Cube, Fact Tables, and Dimension tables
• Experience in creating cubes by using SSAS and populating facts and dimension tables.
• Strong Communication and Time Management skills and excellent team player and ability to adapt quickly to changing environments.

TECHNICAL SKILLS

Operating Systems: Windows NT 2000/2003 Server, Windows XP, UNIX, Linux.

Languages: C, C++, Confidential -SQL, Oracle PL/SQL, MYSQL, MS DOS, VB.Net, C#, ASP.NET, ADO.NET

RDBMS: Microsoft SQL Server 2012/2008R 2/2008/2005/2000 /7.0 , MS Access 2003/2007, Oracle 9i.

SQL Server Tools: SQL Server Management Studio, Configuration Manager, Enterprise Manager, Query Analyzer, SQL Profiler, DTS, SSIS,SSRS, SSAS, Database Tuning Advisor, DTS, BCP, ODBC,SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio.

Web Servers: IIS 5.0/6.0, Apache.

Web Technologies: HTML, JavaScript, PHP, ASP.NET, XML, XHTML

Other Tools: Microsoft Visual Studio 2003/2005, Erwin 4.0, Crystal Reports, Source Control, MS Office suite, MS Visio, Windows System Monitor.

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

SQL Server DBA/Developer/SSIS/SSRS

Responsibilities:

• Create and maintain various databases for Development and Testing Environment using SQL Server 2012/2008R 2/2008/2005/2000 and involve in actual Relational Database Design for high OLTP environment.
• Worked with Client/Server tools like SQL Server Enterprise Manager and Query analyzer to administer SQL Server.
• Created a database model by using Erwin 4.0 and also designed automated scripts in Confidential -SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Created scripts for tables, stored procedures, and DTS and SSIS, (SQL 2K5) tasks.
• Physical Implementation and application of Schema changes to SQL Server database using Power Designer View.
• Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language.
• Good experience on working with Extract, Transform and Load (ETL) tool.
• Develop/customize UNIX shell scripts to automate routine DBA tasks of exports, space usage monitoring and others
• Exposed to data conversion from different data sources to SQL server 2008 using SSIS.
• Using Import/Export wizard to move data from flat files and Excel sheets to SQL Server using SSIS.
• Developed a Database Maintenance Planner for the Performance of SQL Server, which includes Re-indexing, Database Integrity Checks and Update Database Statistics.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Created stored procedures to create dynamic SQL Queries to adopt dynamic environment.
• Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions
• Executed UNIX shell scripts to test the nightly batch jobs.
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication.
• Experience with third party tools like Embarcadero, AR Remedy system to access the SQL Server.

Environment: SQL Server 2012/2008R 2/2008/2005/2000 , SSIS, SSRS, Windows Server 2003, Visual Source Safe 6.0,ASP.Net 3.0, C#, Vb.Net, Visual Studio 2008,Visual Basic, UNIX.

Confidential, Houston, TX

SQL Server DBA/Developer/SSIS/SSRS

Responsibilities:

• Working with various business groups while developing their applications, creating E-R diagrams.
• Modified current database by adding tables, altering referential integrity and relationships to support the control system.
• Generated and debugged complex stored procedures and functions for better performance and flexibility in SQL server and oracle databases.
• Used Triggers to generate customized error messages.
• Created CTE’s to reduce the complexity of the recursive queries.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2008/2005/2000.
• Migrated DTS 2000 Packages to SSIS using DTS Migration Wizard.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources using the concept of OLE DB.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy /exact lookups in SSIS.
• Developed Web pages using ASP and C# which is used by collection department for accessing reports.
• Optimized SQL queries for efficiency and assisted the front end developers with their queries and procedures.
• Created non-clustered indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.

Environment: MS SQL Server 2008/2005, Windows Server 2003/2000, Sybase Central V 4.3, SSIS, SSRS, Erwin 7.2, BIDS.

Confidential, Plymouth, MN

SQL DBA/Developer/SSIS/SSRS

Responsibilities:

• Migrated Data using BCP and SSIS packages.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Created packages using Error handling mechanism and used variables to handle package dynamically.
• Developed data files of Premium Earned, Incurred Claims and compensations using SSIS packages.
• Performed data conversions from flat files to a normalized database structure using ETL Methodologies.
• Retrieved data from multi-dimensional databases (OLAP) using MDX.
• Designed and developed the entire business intelligence reports using SQL Server Reporting Services 2005 and integrating it to the front end application.
• Maintenance of Clustered and Non- clustered indexes in SQL Server 2005.
• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications.
• Extensively used Joins, Functions and Correlated Sub-Queries to simplify complex queries involving multiple tables.
• Optimized indexes using the Index Tuning Wizard and Rebuild indexes. Used SQL Server Profiler to trace the slow running queries and the server activity.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping, data cleansing and conversion and data load.
• Extracted logs from the UNIX for the defects by retrieving the log files from the server and reported to the developers for better tracking the defect.
• Periodic checking databases with DBCC commands for maintaining data consistency and integrity.
• Defining and creating indexes for query optimization and revising scripts for optimal performance.
• Developed the end-user documentation and performed periodic updates of the design documents.

Environment: SQL Server 2005, SSIS, SSRS, Windows Server 2003, Visual Studio .NET,UNIX, Visual Source Safe 6.0

Confidential, Dallas TX

SQL Developer/DBA/SSRS/SSAS

Responsibilities:

• Installing and configuring SQL Server 2000 and 2005.
• Designing Cubes and Data models for Data Warehousing Applications.
• Created and scheduled jobs to setup log shipping between production servers.
• Created databases and logins with permissions in SQL Server 2005 as per the developer’s request.
• Created Linked Servers between SQL server 2000 and 2005 servers.
• Transferred data using (ETL) to Data ware house Environment using SSAS.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSAS package
• Extracted logs from the UNIX for the defects by retrieving the log files from the server and reported to the developers for better tracking the defect
• Place the huge table/non-clustered index on the separate file group to improve the performance.
• Created cluster/non-cluster indexes on the tables, create views, stored procedures and triggers. Trace out for any table required any indexes and determine the type of index on it.
• Involved in database designing using Normalization.
• Monitoring system performance and suggest for system upgrade like disk, processor, and memory.
• Schema Changes to the database as per application team requirement.
• Database Maintenance by script/wizard for SQL 2005 and 2000.
• Used DTS/BCP, BULK INSERT for data transfer.
• Query Optimization for SQL queries.

Environment: MS SQL Server 2005/2000/7.0 , Windows 2000/2003 Server Operating systems, SSIS, SSRS, Clustering, Performance Tuning, UNIX, MS SQL Reporting Services, Change Management System, Remote Desktop, MS Access.

Confidential, Hampstead, MD

SQL DBA/Developer

Responsibilities:

• Involved in Analysis and Design Documentation, gathering User requirements and maintaining good documentation.
• Supported production and development databases.
• Wrote user requirement documents based on functional specification.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Created Constraints, indexes and rules on database objects
• Developed stored procedures, functions, views and triggers
• Performance tuning to optimize SQL queries using query analyzer.
• Converted the Old systems data from mainframes and FoxPro by using DTS packages.
• Developing SQL scripts for maintaining administration tasks.
• Creating DTS packages to maintain central repository.
• Extensively used different SQL2000 DTS tasks.
• Generate Unix shell script to run the process.
• Using the new features in DTS SQL 2000 and upgraded all the packages. Simplified the DTS functionality by using different tasks in SQL 2000.
• Involved in network issues maintain communication with field offices Installing FTP services.

Environment: Windows 2000/NT4.0, MS-SQL Server 7.0/2000,Erwin3.5.2/4.0, DTS, VB Script, Visual Source Safe and FTP Communication.

Confidential

MS SQL DEVELOPER/Programmer

Responsibilities:

• Actively involved in Normalization & De-normalization of database.
• Installed and Configured SQL Server 2000 on servers for designing and testing.
• Designed DDL and DML for MS SQL Server 2000.
• Developed web based front-end screens using MS FrontPage, HTML and Java Script.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Writing Confidential -SQL statements for retrieval of data and Involved in performance tuning of TSQL
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Used DML for writing triggers, stored procedures, and data manipulation.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine
• Monitor production Server Activity
• Worked with DTS packages to load the massaged data into Data warehousing system
• Tuned the SQL queries using SQL profiler and involved in tuning the database
• Very pro actively identifying the problems before user complaints

Environment: Windows NT server, SQL Server 7.0, SQL Server 2000, FrontPage, IIS 5.0