Summary of Experience

• Over Seven (7+) years of experience in IT industry as a Database Administrator, Designer, Developer andSupport of MS SQL Server 2008R2/ 2008/ 2005/ 2000 in Production, Test, Development and Replication & Cluster Server Environments.
• Experienced in Installation, Configuration, Maintenance and Administration of SQL Server 2000/2005/2008/2008R2/2012(Test Environment).
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV’s.
• Worked on SQL Server 2005/2008 tools Management Studio, Business Intelligence management Studio.
• Experienced in working withWindows server 2008 R2, Windows server 2008, Windows server 2003, and Windows server 2000 Administration.
• Experience in upgrading/migrating SQL Server from version 2000/2008 to 2005/2008 and 2005 to 2008R2.
• Experienced indesigning and implementing complete Software Development Life Cycle (SDLC) for client servers and database applications.
• Designed and documented Logical and Physical Data Models.
• Experience in relational database modeling using tools likeCA Erwin, Microsoft Visio and Microsoft SQL Server Database Diagrams.
• Expert in installation and configuration of MS SQL Server 2008, 2005 & 2000 in different32/64 bit environments.
• Expert in developing and documenting the backup and disaster recovery plan.
• Expertise in Installing and configuring SQL Server 2008/2005 Active/Active and Active/Passive clusters on 32/64 bitWindow Server 2003, Window Server 2008and Window Server 2008 R2.
• Implemented Database Mirroring as High Availability in SQL server 2005 & 2008/R2.
• Expertise in implementing Log Shipping as backup solution for MS SQL Server 2000/2005/2008/R2 databases.
• Experienced in implementing Replication Models such as Transactional, Snapshot and Merge in SQL Server 2000, 2005 and 2008/R2 in OLTP environments.
• Excellent skills in developing Backup& Recovery proceduresandDatabase Security procedures to maintain Data Integrity.
• Experienced in implementing Company’s policies through Policy Based Management.
• Experience in implementing SQL Server security and Object permissions.
• Implementing and Monitoring SQL Server jobs using custom scripts.
• Experienced in Installing and Configuring SQL Server on VM Ware. In both clustered and non-clustered environment.
• Expertise in Promoting the SSIS/DTS Packages from Dev.
• Highly experienced in DevelopingDTS/SSIS Packages for data extraction, transformation, and loading from various heterogeneous sources.
• Experienced in developing and deploying complex reports using SSRS (Reporting Services).
• Expertise in monitoring the production server with native tools like SQL Profiler, Window System monitor.
• Expertise in identifying, troubleshooting issues and documenting root cause analysis (RCA).
• Experienced in configuring and managing Linked Server, Data transfer between SQL Server and other Databases
• A team Good interpersonal, Analytical and Communication skills.
• Proven ability to deliver productivity and quality improvements through well-managed, on-time Projects.
• Dedicated, self-motivated achiever who is committed to success and adept at juggling multiple tasks in high- pressured environment.

Certificate of Excellence from Microsoft

• Microsoft SQL Server 2008 -Designing, Optimizing and Maintaining a Database Administrative Solution ( 070-450)
• Microsoft SQL Server 2008 - Implementation and Maintenance (070-432)

Technical Skills

RDBMS: MS SQL Server 2012(Test Environment), 2008R2, 2008, 2005, 2000
Operating Systems: Windows server 2008/R2, 2003, Windows 2000, Windows NT 4.0, Windows 95/98/ XP
SQL Server Tools: Management Studio, Business Intelligence management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Performance Monitor, Database Tuning Advisor, Resource Governor
Data migration: MSDTS, SSIS, BCP, Data Migration, Import/Export Wizard
Cluster Solution: Microsoft Windows Cluster
Technologies: RAID, SAN
Version Control Tools: Visual Source Safe, Source Gear Vault
Other Tools: Erwin Data Modeler, MS Visio, BMC Remedy, DeskPro
Languages: C, C++, T-SQL, Java script
Third PartyTools: Lite Speed, Spotlight, Foglight, Idera’sSQL Diagnostic Manager, SQL Nexus, Lumigent’s
Explorer, SQLIOSIM, Red-Gate

Application Areas

• Database Security
• Backups and Recovery
• Clustering (Active/Active and Active/Passive Environments)
• Database Mirroring
• Log Shipping
• Replication
• Performance Tuning
• DTS (Data Transformation Services)/SSIS
• SSRS

Professional Experience

Confidential,New York, NYSept 2011 to till date 
SQL Server DBA

Description:
Confidential acquired BizFilings a few years back. I worked as a DBA for Bizfilings after it was acquired by Confidential. Headquartered in Madison, Wisconsin, BizFilings is the online incorporation provider of choice for more than 500,000 entrepreneurs. It offers a full range of business filing and compliance products and tools, includingRegistered Agent Servicein all 50 states, to help businesses remain in compliance with state regulations. 

Responsibilities:

• Providing 24 X 7supports for production environment.
• Configuration and Installation of SQL Server 2008 Active- Passive and Multi Node Cluster(4 Nodes) on windows 2008.
• Migrating and upgrading SQL instances from SQL 2000 to SQL 2005/2008 in dev/test/production environments.
• Project DBA for databaseapplications. Activities - Installing/configuring SQL server, patching, troubleshooting, performance tuning.
• Primary DBA for various assigned servers in development/test/staging/production environments.
• Deployed the DTS/ SSIS Packages and did the Optimization of the Packages.
• Used the DTS Designer tool to execute the DTS packages on SQL Server 2005.
• Promoted the SSIS Packages in different Environments like QA, Staging and Production.
• Populated the Database tables from heterogeneous source of the business clients using the SSIS Packages.
• Proactive DBA maintenance Tasks to monitor the health check of SQL Server, Log Space, fragmentation.
• Optimization and Performance tuning using Idera’s SQL Diagnostic Manager, SQL Profiler, Performance Monitor and SQL Nexus.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks.
• Optimization of Stored procedures, Slow running Queries and indexes.
• Implemented Log-shipping as a High availability feature.
• Implemented Resource governor for one of the critical server for better performance.
• Applied Page and row compression to efficiently organize the space.
• Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
• Implemented the Data Collector to capture the CPU, DISK, Memory counters.
• Implemented POLICY BASED MANAGEMENT on SQL Server 2008, to follow company protocols more closely.
• Set up and supported environment with transactional replication for the in-house reporting.
• Set up and supported Database mirroring as High Availabilitysolution for critical operational databases.
• Promoting new databases in different using Red gate SQL compare and SQL Server Management Studio.
• Actively involved in capacity planning/requirement analysis and I/O capacity using SQLIOSIM.
• Experience in load testing and implementing the changes to Staging servers and Production servers.

Environment:
Windows server 2003/2008, MS SQL Server 2008/2005/2000, SQL Server Management Studio, SQL Profiler, SQL Server Tuning Advisor Idera’s SQL Diagnostic Manager, SQL Litespeed, SQL Nexus 3.0, SQLIOSIM, Red-gate SQL Compare.

Confidential, NC Jan 2011 to Sept 2011 
SQL Server DBA

Description: 
Headquartered in Winston Salem, NC, USA. Founded in 1939 as Motors Insurance Corporation, the GMAC Insurance Group is a property and casualty insurance company in the United States and is a subsidiary ofAlly Financial.GMAC Insurance is the only insurance company in theUnited Statesto come from within the automotive industry. 

Responsibilities:

• Involved in Migration of Databases from SQL Server 2000 to SQL Server 2005/2008.
• Installed, Configured and maintained the SQL Server Cluster 2005 on Windows Server 2003.
• Configured and Monitored Database Mirroring.
• Involved in Installation, configuration and maintenance of the Reporting Services.
• Configured and maintained Database mirroring for transferring the Archived Data to the Report Server using snapshots.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Used the ETL functionality of SSIS to retrieve/send the Data from/to the heterogeneous sources.
• Configured TransactionReplication on the Production server.
• Controlled and coordinated the installations (Security Patches, Service packs) and evaluated the performance before Pre-deployment.
• Involved in daily code drops and archives on the production databases during maintenance windows.
• Performed Regular Database Maintenance process, checking the disk Defrag procedures in different environments.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
• Used Idera’s Diagnostic Manager and Performance monitor for monitoring SQL Server Activities and keep a real time check on health, availability and performance of SQL Server.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Work involvement in performance monitoring of Memory, Processor, DiskI/O and fine tuning.
• Handled Scheduled backups and restore operations with Lite speed 5.0 and monitored the tasks and Maintenance plan.
• Involved in writing Stored Procedures and Functions, Cursors to handle different tasks.
• Automated Weekly, Monthly system maintenance report for Database backups.
• Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity etc.
• Provided 24x7 supports to SQL application developers in implementing the applications on production server.

Environment
Windows Server 2003,MS SQL Server 2005/2008, SQL Server Management Studio, SQL Profiler, SQL Server Tuning AdvisorQuest ‘s Spotlight , LiteSpeed5.0, CA Erwin 4.0

Confidential, Dallas, TX Nov2009 – Dec2010 
SQL Server DBA

Description:
Confidential, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions. Confidential provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services and wealth management.

Responsibilities:

• Involved with maintenance of ACTIVE/PASSIVE Cluster Environments.
• Worked on SQL Server 2005 with latest Service Packs.
• Involved in moving SSIS packages between various environments including Dev, QA, Staging and Production
• Maintaining Dev, QA, Staging and Production servers in sync using Redgate SQL Compare.
• Connecting SQL servers remotely using Terminal services.
• Wrote and tuned the SSIS packages according to the business requirements.
• Migrated and modified the DTS pack to SSIS packages.
• Deployed the DTS/SSIS packages.
• Set up jobs to schedule SSIS packages using SQL Agent.
• Developed Ad-hoc and customized reports using SQL server reporting services (SSRS)
• Createdcomplex SSRS reports using complex expressionsto calculate, group, filter, parameterize and format the contents of a report
• Configured reporting services and managed reporting security by creating groups and granting access to report folders and Ad-hoc reports as required
• Created Database Maintenance Planner for the Performance of SQL Server which covered Database Integrity Checks, Update Database Statistics and Re-indexing.
• Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them whenever necessary.
• Used BCP and Bulk Insert utilities.

Environment:
Windows Server 2003, MS SQL-Server 2008/2005/2000,SQL Server Management Studio, SQL Profiler, SQL Server Tuning Advisor SSIS, SSRS, Idera’s SQL Diagnostic Manager, Quest’s Litespeed, Erwin

Confidential Nov 2007 – July 2009 SQL Server DBA

Description: 
Confidential’s billing solutions enable brands, enterprises and digital content owners to deliver and charge for content and services, generating revenue efficiently and reliably. We provide complete mobile payment, billing, clearing and transaction management solutions, and allowing merchants to offer multi-channel payment options to consumers. Confidential has revenue sharing and mobile billing agreements with global mobile operators and payment clearing houses, giving a wide choice of payment methods including Premium SMS, WAP Billing, Credit Card, Voice and Video Short codes.

Responsibilities:

• Implemented database standards and naming convention for the database objects.
• Developed SSIS Package to migrate the data from .CSV files into MS SQL server.
• Developing SQL scripts for maintaining administration tasks.
• Tuned the SQL queries using SQL profiler
• Involved in developing stored procedures, triggersfor the application.
• Estimating of Table sizes and Record sizes.
• Maintain all the SQL documents include installation and data conversion Procedures documents.
• Developed a Data Dictionary by using Apex SQL.
• Trouble shooting Problems by using SQL server profiler.
• Solved critical production problems and performed point in time recovery plans.
• Installing all software upgrades for SQL Server.
• Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
• Research on upgrading the SQL Server from 2000 to 2005
• Research on database issues (specifically performance issues).
• Worked on Migration of SQL Server 2000 instances to SQL Server 2005.
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Monitoring of database size, disk space in all (Production, Model & Development) the environments.
• Configured Log Shippingto create a stand by server for production server.
• Creating and monitoring all maintenance jobs (backups, integrity, optimization, etc.) on all databases.
• Creating, modifying and monitoring replication on all databases.
• Worked on upgrading DTS packages to SSIS packages.
• Maintaining security permissions for the internal and external users of the respective databases and servers.
• Worked on 24/7 shifts to monitor the servers and to assist the users.
• Management of SQL Servers, databases, storage management for databases sizing from 100GB to 450GB.

Environment: 
MS SQL Server 2005,Windows serve 2003,SQL Compare, SQLServer Management Studio, SQL Profiler, SQL Server Tuning Advisor

Confidential July 2005 – Oct 2007
SQL Server DBA/Developer

Responsibilities:

• Managing of database objects like Tables, views, indexes.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Worked with BCP and DTS to load text files to SQL Server.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Involved in various stages of Software Development Life Cycle like Design (Logical & Physical), Development, Testing, Implementation and Maintenance.
• Worked on Client/Server tools like SQL Server EnterpriseManager and Query Analyzer to Administer SQL Server and develop Distributed Queries.
• Worked on the implementations of an application that included security module, database module, network module, report module using VB.
• Involved in writing queries and optimizing the performance of the queries.
• Helped the front end application developers with their queries.
• Working on different environments like development, staging, production
• Involved with optimization of Stored Procedures, Triggers, Views
• Worked on Server Native tools like SQL Server EnterpriseManager and Query Analyzer to Administer SQL Server.
• Created reports using crystal reports as per the customer requirements
• Gave training session to the end users for the new product such as using the product.
• Successfully resolved deadlock issues by creating traces on objects using SQL Server Profiler.
• Worked to establish connectivity between VB Applications and MS SQL Server by Using ODBC
• Maintained version control of database releases
• Application development using Visual Basic.

Environment: 
Windows 2003 Server IIS 5.0& Windows XP, SQL Server 2000, T-SQL, Windows Server, JavaScript, Access,