Summary

• Around 8 years of professional experience as SQL SERVER Database Administration and Production Servers maintenance related to Financial, Health care and Manufacturing databases.
• Expertise and Interest include Administration, Database Design, Performance Analysis, configuring more than 2GB ram, highly transactional servers and Production Support for Large (VLDB) and Complex Databases.
• Extensive experience with configuring high availability and Disaster recovery scenarios like clustered environments, Set up diff topologies in replication, Log shipping and mirroring.
• Extensively worked on 32 bit, 64 bit clustered and standalone server environments.
• Thorough Understanding of different RAID levels implementation
• Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients. Complete Administration of Microsoft SQL Server Databases is my primary responsibility.
• Thorough knowledge of SDLC and Expert in Documentation.
• Experience in implementing 2005 concepts like online indexing, Data partitioning, Database mirroring, Db Snapshot, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Dealing with Financial Statements, Ratios, Analysis, Top performing stocks and institutional holdings, Market Quotes and Daily Share price.
• Data modeling Experience like Physical data modeling and logical by using ERWIN.
• SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages and SSAS with OLAP.
• Strong knowledge in compliance, blotter, trading application, financial ratios, financial statements and share price ratios and CEO compensations.
• Compare and synchronize your database schemas or data by using redgate.
• Hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full–text indexing, and Database Application Development using varied development tools.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Extensively implemented the change management processes by using team foundation server (TFS), Visual source safe (VSS) and Clear case.
• 24 X 7 Production Database on Call Support
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with client
• Experience in Batch processes, SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.

Project Domain: Application Development, Systems Integration and Database Administration of MS SQL Server 2008/2005/2000/7.0/6.5,Oracle, Sybase.
Languages: Visual Basic 6/5, ASP, C, XML, HTML
Database: SQL Server 2000/7.0/6.5, DB2 8x UDB, MSSQL, Access and, Sybase
Tools: Visual Basic, Active X, IIS, SSIS, DTS, MTS, Redgate, litespeed, Spotlight, Crystal reports, ASP.NET, VB Scripts
Operating System: Windows 2000 Advanced Server, UNIX, NT & Windows 9x.

Education:
Bachelor of Technology.

Professional Experience:

Confidential,NJ June 2009 – TILL DATE
Sr. SQL Server DBA/Developer/SSIS

Monmouth County Division of Social Services is a county government agency located in Monmouth, New Jersey which is a part of Monmouth County Department of Human Services. Monmouth County has cities, towns and even a village. Its governing body is the Monmouth County Board of Chosen Freeholders. Monmouth County Division of Social Services assists Monmouth County residents in need of social services, financial assistance and medical assistance.

Responsibilities:

• SQL Server 2008/2005/2000 Database Administration.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2008.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning and Snapshot Isolation.
• Experience in Database security and integrity planning.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Configured more than 2 GB ram on 32 bit Environment.
• Migrated DTS packages to SSIS packages.
• Successfully implemented the Capacity planning for different servers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Checking Database Health by using DBCC Commands and DMVS
• Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors
• Wrote scripts that extract data from database tables and write the data to text Files.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created SQL reports, data extraction and data loading scripts for different databases and Schemas.
• Generated server side T-SQL scripts for data manipulation and validation and created various Snapshots and materialized views for remote instances.
• Developed procedures and functions for business & data transactions with error handling
• Assisted on the Adhoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Tuned stored procedures by adding the try catch blocks for error handling.
• Created the documentation for issue diagnostics reports.
• Managing the VERITAS net backups and Litespeed.
• In-depth knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.

ENVIRONMENT: Windows 2003/2008, MS SQL Server 2000/2005/2008, Oracle, .net, VB and ASP

Confidential,CT May 2008 – May 2009
On call Support Sr. SQL Server DBA/Developer/SSIS

At Hartford Investment Management, is an investment organization focused on anticipating the needs of both institutional and individual investors. As an SEC registered investment advisor (SEC registration does not imply a certain level of skill or training), provides investment management services to a wide range of clients, including affiliated and non-affiliated corporations, endowments and foundations, individuals and employee benefit plans. Understanding our clients’ needs and responding by providing a range of long-term investment solutions. Our collective focus is to identify and capitalize on ideas that we believe have the greatest risk-adjusted return potential by applying a wide spectrum of investment tools and techniques with a willingness to take compensated risks.

Responsibilities:

• SQL Server 2000 contains 2 TB of Data and SAN infrastructure of 60 Server. 2 NODE cluster Active / Active and Active passive for different environment.
• Installation & configuration 2005 enterprise Edition.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
• Migrating SQL Server 2000 data bases into SQL Server 2008.
• Converting DTS packages to SSIS packages.
• Dynamic configuration for memory.
• Designed the reporting databases by using Erwin.
• Transformation of data (Millions of records) to SQL server by SSIS, DTS, BCP.
• Played a key role in business requirements analysis, architecture designs, physical and logical Data modeling, application development by using Erwin.
• Rebuilding the indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Compare and synchronize your database schemas or data by using red gate
• Migrate databases easily from SQL Server 2000 to SQL Server 2005 by using redgate.
• Etl experience with SSAS and SSIS.
• Build the cubes by using SSAS and SSIS.
• Install and upgrade packaged databases remotely by using red gate.
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering
• Suggest replication techniques to meet business needs.
• Maintain transactional replication on production SQL Servers.
• Set up transactional, snapshot replication and maintain the active replication(s).
• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Performed daily backup and created named backup devices to backup the servers regularly.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Performance tuning and optimization of Query of SQL server.
• Supporting programmers for moving objects to different environments.
• Creating and maintaining user’s logins and Roles.
• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitored the size of the transaction log. Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Estimated space requirements for a database.
• Worked on Clustering, DTS, Import and Export utility, BCP Utility and replication tool for transferring data. Planned and setup replication.
• Converted and imported data from an Oracle Database to a SQL Server Database.
• Worked in tune with strategic planning for improving the mapping and data migration.

Environment: Windows 2003, MS SQL Server 2000/2005/2008, Oracle, .net, VB and ASP.

SQL Server DBA

GDBA (Global Database Administrator’s) team was responsible for the database administration within the Data Center Consolidation (DCC) Program. The project primary focus was the consolidation of the about 110 HP datacenters located all around the world into six datacenters in 3 locations within US for easier maintenance. The Main focus of the project was Migrating/Moving the databases from different location worldwide to the 6 data center located in Americas.

Responsibilities:

• Database Administrator/Database Programming/Product specialist.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Extensively worked on compliance issues.
• Expertise in blotter issues.
• Database Reverse engineered by using Visio.
• Export or Import data from other data sources like flat files using Import/Export from Bloomberg.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Compare and synchronize your database schemas or data by using redgate
• Migrate databases from SQL Server 2000 to SQL Server 2005 by using redgate.
• Install and upgrade packaged databases remotely by using redgate
• Back up, package and distribute databases more efficiently by using redgate
• Rescue and troubleshoot your databases by using redgate
• Automate common tasks and use functionality in applications by using redgate
• Track and analyze SQL Server object dependencies by using redgate
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2 Terabytes.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• Good experience in data modeling a metadata services.
• Expertise in SQL Server Analysis Services.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Extracting the fixed length format files from DB2 databases.
• Maintaining the database consistency with DBCC at regular intervals

Environment: SQL Server 2000/2005 with clustering, T-SQL, Windows 2003, Oracle, .net. And ASP.

Confidential,Ohio Dec 2004 – Sep 2006
SQL Server Developer/DBA

The Science Direct online Web Product is the system users interact with when they want to complete any of the functions available to them as consumers of the product. Primarily, this means electronic delivery of journal data to customers via the World Wide Web. Understanding the Science Direct product, its basic functionality and users, as well as the population of users is a crucial foundation to have prior to understanding the technical underpinnings of the system. At its most fundamental level, Science Direct is the product developed by Elsevier Science to deliver electronic versions of it’s over 1900 scientific journals to its subscribers and the behind-the-scenes technical workings that make this product work.

Responsibilities:

• Upgrade all the servers from 2000 to 2005 including production servers.
• Designed and implement database logical and Physical Schemas using Erwin 3
• Supported production and development databases.
• Good in High availability like Mirroring, Log shipping and Replication.
• Coding experience in Stored Procedures, Triggers, Cursors and views.
• Replication between field offices and Headquarters, merge replication, snapshot replication By Internet creating all the necessary scripts for publication and Subscription maintaining replication servers and backup and recovery plans.
• Developing SQL scripts for maintaining administration tasks.
• Creating DTS packages to maintain central repository. Extensively used different SQL2000 DTS tasks.
• Backup and Recovery plans for Field office and Headquarters, central repository database servers. Maintaining good Documents and SQL scripts for those administration tasks and scheduling those tasks.
• Users and user group creation and maintenance.
• Using the new features in DTS SQL 2000 upgrade all the packages. Simplify the DTS functionality by using different tasks in SQL2000.
• Trouble shooting Problems by using SQL server profiler.
• We have done replication from 32 sites to head quarters. Maintaining 32 databases at Headquarters. We are responsible for total 23 servers in PAHO.
• Performance tuning in Database level, T-SQL level and operating system level, Change the replication and SQL mail scripts according to SQL2000.

Environment: MS SQL server 2000/2005, Windows 2000/2003, VB, .Net, Enterprise manager, Query Analyzer, DTS, SQL profiler.

Confidential,VA Sep 2003 - Nov 2004
SQL Server DBA.

Description: Genworth Financial, Inc. is a leading financial security company dedicated to helping people achieve their dreams in a world of growing and shifting financial burdens, serve 15 million customers in more than 25 countries by provide financial security and protection to millions of people through retirement income, life and long term care insurance, Medicare supplement insurance, and related financial and wellness advisory services.

• Involved on Migration of SQL Server 7.0 instances to SQL Server 2000
• Installing all software upgrades for SQL Server.
• Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
• Used Data Transformation Services (DTS) to populate data from various data sources.
• Research on upgrading the SQL Server from 7.0 to 2000
• Researching database issues (specifically performance issues).
• Written CustomScripts & procedures to Extract, Transform & Load data through DTS packages
• Modified the existing stored procedures, views and triggers to meet the current design.
• Monitoring of database size, disk space in all (Production, Model & Development) the environments.
• Creating and monitoring all maintenance jobs (backups, integrity, optimization, etc.) on all databases.
• Creating, modifying and monitoring Replication on all databases.
• Attending team meetings regularly.

Environment: MS SQL Server 7.0/2000, T-SQL, DTS, Windows 2000 Server, SQL profiler, Upgrade Advisor

Confidential,India May 2001 – Aug 2003
SQL Server Developer
Insurance Management System

Union Insurance provides a wide range of insurance policies such as Life Insurance, Health Insurance, Fire Insurance, Motor Vehicle Insurance, Aviation Insurance, General Insurance, Marine Insurance, Shop Keeper Policy, Transportation Policy, and Accident Insurance etc. This project is developed as a process of automation for Insurance Policy Management. The system, which has the policy proposals, claims, accounts and reports.

Responsibilities:

• Installation and configuration of MS SQL Server and Clients.
• Database designing, Logical and Physical Data modeling using Erwin. Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.
• Good in high availability database mirroring and Merge Replication
• Excellent knowledge Import / Export using DTS and BCP utility.
• Setting up DR sites using log-shipping and Wrote dynamic stored procedures for moving Databases from production server to DR server
• Setting up Replication using Dynamic scripts and solving problems
• Discussions with Product team for new features
• Propping up the new schema changes and additional new features on Development, Staging/QA and Production servers
• Designed DTS packages to refresh data on Development and QA/Staging
• Wrote dynamic stored proc to create Database Roles and grant permission to roles and adding logins to specified roles
• Designed new schema for data partition and created Partition views for better performance.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks
• Performance Tuning, Analyze, tuning and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.
• Created updatable partitioned views
• Created Stored Procedures and triggers to perform automated rules, updating to related tables

Environment: MS SQL server 2000, Windows 2000, VB, .Net, Enterprise manager, Query Analyzer, DTS, SQL profiler.