PROFESSIONAL SUMMARY:

• MS SQL Server Database Administrator and Developer with around Seven years of IT experience in administration, analysis, design, development, testing and presentation.
• Expertise in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and non - clustered environments.
• Experience in installation and working with Windows 2008/2003, Windows Vista, Windows XP and Windows 7and packages & patches.
• Experience in migration of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and Loading of data using MS SQL Server SSIS and DTS.
• Developed and documented backup, recovery strategies, disaster recovery plans and participated disaster recovery drills for various environment. Successfully implemented Log shipping for DR solutions.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional
• Experience in Performance monitoring & Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Good knowledge in Performance tuning using various MS SQL Server Commands and Database Tuning Adviser.
• Experience on identifying different bottlenecks and their mitigation for better performance.
• Experience in using tools like MS SQL Profiler, Windows Performance Monitoring utility and performance counters for monitoring and Tuning MS SQL Server Performance, Idera Diagnostic manager, Quest Spotlight and NetIQ.
• Design and document Logical and Physical data models using various tools like Erwin and MS Visio, Visual Paradigm, MS Excel and Gliffy.
• Worked on SAN (EMC, IBM and HP Arrays) for MS SQL Server Databases and good understanding in capacity planning. Comprehensive knowledge in providing suggestions of using best RAID Technologies based on application requirement.
• Security emphasized by creating security model which was structured by windows and/or server authentication modes, logins, roles and appropriate permissions for those accordingly their needs.
• Experienced in managing systems and staff in high-availability environments across multiple data centers in compliance with Sarbanes-Oxley, HIPAA, PCI and other regulations.
• Expert in Database Normalization, De-Normalization, Backup/Restore, Data Import/Export, Troubleshooting, and Objects Creation such as Tables, Views, and User created Data Types, Index Optimization, Stored Procedures, Cursors, Triggers and Partitioning.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting query performance and MS SQL server bottle necks including Network Traffic, Hardware usage and Blocking and using trace flags.
• Experience in MS SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views and DTS.
• Good exposure to Oracle databases. Experienced using PL-SQL Store Procedure & Triggers. Migrated Oracles data to MS SQL.
• Knowledge of different methodologies such as Agile, Waterfall, Scrum and RUP.
• Ability to gather business and technical requirements from both formal and informal sessions, documented As Is and To Be Processes and prepared Business Workflow Models
• Moderate knowledge in Risk Identification, Risk Analysis, Risk Management. Derived and documented the root cause analysis for production issues
• Flexible, Enthusiastic and Project oriented Team player with solid communication and leadership skills to lead tasks to meet the SLA and beyond that to develop creative business continuity solutions.

TECHNICAL SKILLS:

RDBMS/DBM: MS SQL Server 2008 R 2/2008/2005/2000, MySQL, MS Access

Operating Systems: Windows server 2008/2003, Windows 7, Windows Vista and Windows XP.

Hardware: Dell Power Edge R900, Dell Power Edge M710, HP ProLiant BL460c Server

Front End Tools: MS office, MS Project, SQL Server Management Studio, SQL Server Profiler, SSRS, SSIS, DTS, SQL Query Analyzer, Enterprise Manager, LiteSpeed, Red Gate SQL DBA Bundle.

Data Modeling Tools: Erwin, Microsoft Visio, Visual Paradigm, Excel and Gliffy.

Languages: T-SQL,XML, HTML, C and C++

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

MS SQL Server DBA

Responsibilities:

• Involved in installing SQL Server 2008/2008R2 on Development, Production and UAT environments.
• Experience in installation and configuration of Cluster SQL Server in Active/Passive and Active/Active nodes in MS SQL Server 2008R2/2008.
• Creating and maintaining various databases on production/development servers and provide 24x7 support
• Involved in migrating SQL Server Databases from Development to Production Server.
• Configured Log shipping from Production to Disaster Recovery server as part of the disaster recovery plan.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Implementation of system wide security policies and trouble shooting.
• Troubleshooting high availability and disaster recovery scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Deployed and scheduled SSIS package.
• Maintained security policies. Managed Logins and User: adding logins, roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.

Environment: SQL Server 2008R2/2008Enterprise Edition, Windows Server 2008 R2 Enterprise edition, Quest LiteSpeed, SSIS, MS Visio, Dell PowerEdge R900.

Confidential, Minneapolis, MN

MS SQL Server DBA/Developer

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2005 service to SQL Server 2008.
• Created logical and physical database design, data structures, and implemented databases using Erwin.
• Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions.
• Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning and Data Normalization.
• Implemented Database Mirroring in SQL 2005/2008.
• Successfully implemented Log Shipping in SQL Server 2005/2008.
• Analyzed business recovery requirements and maintained strategies and plans for critical databases.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Wrote T-SQL stored procedures and functions to efficiently perform complex business logic to summarize data.
• Migrated databases and database objects between multiple servers across production, QA and development platforms.
• Involved in Performance Tuning, Indexing, Query Optimization.
• Involved in resolving locking and blocking issues.

Environment: SQL Server 2005/2008 Enterprise Edition, Windows Server 2003/2008 Enterprise edition, Dell Power-Edge M710, Redgate SQL DBA Bundle, Erwin.

Confidential, Texas

MS SQL Server DBA/Developer

Responsibilities:

• Verify, maintain & troubleshoot database backups, integrity checks, and scheduled jobs.
• Troubleshoot and monitor SQL performance issues.
• Created stored procedures, scripts, cursors for the Bulk application, tested them on the test servers and moved them to production.
• Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments.
• Involved in setting up Transactional Replication and Snapshot replication.
• Maintain DTS packages and SQL scripts for generating reports.
• Provide support to other developers and work with them to solve critical problems.
• SQL performance tuning.
• Involved in setting up and Troubleshooting clusters Application Center Clusters Performance tuning, and optimization of procedures and queries.
• Developed and document disaster recovery plan.
• Created Triggers to enforce data and referential integrity.

Environment: SQL Server 2008/2005 Enterprise Edition, Advanced Windows 2003 Server, QuestLiteSpeed, HP Proliant BL460c Server

Confidential, Middletown, CT

MS SQL Server DBA/Developer

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created & managed the Database Users, Login and Security.
• Scheduled database backups and restored the Database from DR.
• Provide 24 X 7 support to all Production, QA & Development MS SQL Server Environments.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configured Replication Server, worked on replication server.
• Logical and Physical Data Modeling using Erwin.
• Identified the necessary steps to enhance user response time by checking fragmentation and re-index tables for efficient application access methods.

Environment: SQL Server 2008/2005 Enterprise Edition, Advanced Windows 2003 Server, Erwin, RedGate Bundle, Dell Power Edge 8450

Confidential

MS SQL Server Developer

Responsibilities:

• Developing T-SQL queries, triggers, functions, cursors and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Created linked server to Oracle 10G and imported data to MS SQL Server 2005.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Designed and implemented stylish report layouts.
• Identified and defined the Datasets for report generation and also included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Implemented full and differential backups and also created and managed DB objects.
• Make recommendations for File group Creation and Placement.
• Scheduling backups and automating weekend maintenance tasks.
• Created users and roles for login authentication and validating permissions.
• Administering MS- SQL Server, performing day-to-day tasks such as Database tuning.
• Upgraded SQL Server 2000 to SQL Server 2005.
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.

Environment: MS SQL Server 2005/2000, Oracle 10G, T-SQL, MS Integration, Analysis and Reporting Services, Query Analyzer, Windows 2003 Server.