Professional 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/2008R2/2008/2005/2000/7.0 in Production, Development and Test Environments.
• Administered the Installations, Configurations and patch management of MS SQL Server 2012/2008R2/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.

Skills

PROJECT EXPERIENCE

Confidential

SQL Server DBA/Developer/SSIS/SSRS

Responsibilities:

• Create and maintain various databases for Development and Testing Environment using SQL Server 2012/2008R2/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 T-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/2008R2/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

SQL Server DBA/Developer/SSIS/SSRS

Responsibilities:

• Using SQL Server Integration Services SSIS to populate data from various data sources using the concept of OLE DB.
• Expert in using Bulk Copy Program BCP , Data Transformation Services DTS packages and SSIS integration services with MS SQL Server 2008/2005/2000.
• 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.
• Migrated DTS 2000 Packages to SSIS using DTS Migration Wizard.
• 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

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

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

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 T-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