SUMMARY:

• 8+ years of experience in Database Administration and Development on MS SQL Server 2008 R 2/ 2008/2005/2000/7.0 on 32 bit and 64 bit environments.
• Good Experience in supporting Highly Transactional and Very Large Data Bases (VLDB).
• Expertise in Database Administration activitiesthat includeInstallation, Configuration, Backup & Recovery, Database Security, Database designing and Query optimization.
• Implemented Transactional Replication as a part of Disaster Recovery (DR) solution.
• Experience in implementing new features of SQL Server 2008 like Policy Based Management, Resource Governor, Data Collector sets and Backup Compression Techniques.
• Expertise in setting up Active/Passive and Active/Active Clusters for High availability.
• Good experience in resolving SQL Server blocking and Dead Lock Issues.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Upgraded databases from MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2000 to MS SQL Server 2005.
• Data Migration using ETL Toolssuch asData Transformation Services (DTS) / SQL Server Integration Services (SSIS)across different databasesfromOracle, DB2, MS Access.
• Implemented Log Shipping Technique for warm backup solutions.
• Hands on Experience with using Data Modeling Tools such as Erwin and MS Visio.
• Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
• Experience in SQL Server Reporting Services (SSRS) and Crystal Reports.
• Overall database design thatinvolvescreating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Create and manage OLAP Cubes on analysis servers and query cubes using MDX queries.
• Experience in upgrading SQL Server software to new versions and applying Service packs and hot fixes and Unattended Installations.
• Provide 24/7 production support for mission critical systems.
• Experience in implementing various RAID1, 5and 10technologies.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Troubleshooting and documenting root cause analysis.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T - SQL Scripts and Batch files.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Develop and manage reports on SharePoint Server.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
• Worked with Third Party Backup solutions like SQL Litespeed for MS SQL Server.
• Flexible, Enthusiastic and project oriented team player withexcellent communication skills and analytical skills to develop creative solution for challenging client needs.
• Administration and Installing of MS SQL Server 2008 R2, 2008, 2005, 2000, 7.0.
• Database Designing and Security.
• Setting up Replication, Log Shipping, Data Mirroring using MS SQL Server 2008, 2005.
• DTS (Data transformation services) and SSIS (SQL Server Integration Services).
• Setting up Active/Passive, Active/Active clustering with multi node environment.
• Experience with writing SQL Scripts and batch files.
• Good hands on experience with T-SQL.

Technical Skill:

Operating Systems: Windows Vista/XP/2000/NT, Server 2003, Exchange 2003.

Databases: MS SQL Server 2008/2005/2000/7.0, MYSQL, Oracle, MS Office Access 97/2000/2003.

ETL TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Data Modeling Tools: Erwin, Red gate, Litespeed.

Languages: T-SQL, C/C++,C#, java script, Visual Studio2005/2003, ASP.NET, VB.Net

Applications: Microsoft Office, Adobe Photoshop and Flash.

PROFESSIONAL EXPERIENCE:

Confidential, Palm Beach Gardens, FL

SQL Server DBA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers. prepared maintained and modified SQL server installation and configuration documents
• Upgraded/Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databasesincludingDTS to SSIS packages and mentored Jr.DBAs and other technical staff.
• Migration from Dev to QA to prod environments
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Handled upto 1.5 TB Size databases with clustered environment.
• Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource GovernorandMERGE statement inT-SQL.
• Set up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev serversand trouble shooting of errors.
• Extensively workedon Profiler, Perfmon, DMVs, DMFs and DTAto tune the databases, servers and query tuning.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Analyzed execution plans and generated suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task.
• Configured and deployedSSIS PackagesfromTest to Production Environments.
• Created, deployed and managed reports usingSQL Server Reporting Services(SSRS)

Environment: SQL Server 2000/2005/2008 (Enterprise Manager, OLAP cubes with SSAS, SSIS. Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server)

Confidential, Santa Ana, CA

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2008 R2 on Test, Development and Production Environments.
• Usage of new compression Techniques in SQL Server 2008 R2 for backup and restore jobs.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Tune slow running queries using SQL Server Profiler.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
• Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
• Create Clustered and Non-Clustered Indexes to improve the performance of database access.
• Create and manage databases across Development and Production instances using SQL Server Management Studio.
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Involved in Logical and Physical Data Modeling process using MS Visio.
• Use MS Visual Source Safe as a Version Control System.
• Involved in Change Data Capture process.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, IDERA Management Tools, Windows 2003 Server, MS Visual Source Safe, IIS 6.0, XML.

Confidential, Irvine,California

SQL Server DBA

Responsibilities:

• Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2005. Planning the location of data, indexes, and Transaction log files on the disk.
• Install and configure SQL Server 2005 on the server and client machines, provide connections and manage databases.
• Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency.
• Resolve locking and blocking issues.
• Tuning the Production server to get the performance improvement.
• Running Index Tuning wizard for optimal query performance.
• Implemented Database Mirroring as part of disaster recovery plan.
• Monitoring and Troubleshooting performance during peak periods with concurrent connections.
• Use of Microsoft Diagnostic utilities to take memory dumps and automated traces.
• Implementing and Monitoring Transactional Replication and other SQL Server jobs using custom scripts.
• Monitoring SQL Server LOGS, Application logs and analyzing the logs.
• Connecting SQL Server remotely using Terminal services.
• Providing 24*7 supports to SQL application developers in implementing the applications on production server.
• Maintaining both DEV and PRODUCTION Servers in sync.
• Creating users and assigning appropriate permissions.
• Creating Backup strategies and scheduling them as a part of database maintenance plans.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Involved in Performance Tuning for source databases, target databases, MS Analysis Server.

Environment: MS SQL Server 2005, Windows 2000 Advanced server NT, IIS Server 5.0, Diagnostic Manager, Reporting Services, XML, Crystal Reports 10, Hewlett-Packard DL580 database server.

Confidential

SQL Server DBA

Responsibilities:

• Designed and implemented multiple systems using MS SQL Server 2000.
• Prepared Estimates for Database, table size growth.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitor connections, locks and performance of SQL server.
• Responsible for MS SQL Server 2000 configuration, tuning and provide 24X7 dedicated support to all Production, development and cluster servers.
• Performed all aspects of database administration, including backups andrecovery.
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Additionally, designed and implemented a disaster recovery system.
• Installed and configured Microsoft SQL 2 node Clustering (Active/Passive).
• Creating Logins and Roles with appropriate permissions.
• Involved in the logical and physical data modeling using Erwin tool.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Create and manage OLAP Cubes on analysis servers and query cubes using MDX queries.
• Develop and manage DTS Packages and scheduled jobs for periodic and nightly batch processes.
• Configured Log shipping of production servers and created the DR servers.
• Implemented and configured Transactional, Snapshot and Merge replication.
• Assign permissions to users and roles. Support column level permission. Administer secure authenticated logins including both Windows and SQL Server Accounts.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Preparing the reports for the day-to-day as well as weekly/monthly purposes.

Environment: MS SQL-Server 2000, DTS, SQL Diagrams, Erwin, Windows 2000 Server, MS Access, MS Excel, MS Analysis Services, MS Reporting Services, HTML 4.0.

Confidential, IL

SQL Server Developer/DBA

Responsibilities:

• Create Databases, Tables, Indexes, Views, Triggers and Stored Procedures.
• Testing Stored Procedures and tuning them for better performance.
• Monitoring disk, log space and dumping transaction log when required.
• Transferring the data using DTS utility.
• Created and populated summary tables based on the existing data in the tables from different databasesaccording to the client requirements.
• Extensively worked on stored procedures to select the data from different databases for each and every summary table to be populated and to perform the calculations for the numeric fields and to extract the values based on theclient requirements for character fields and insert them into the summary tables.
• Wrote scripts for text processing using PERL.
• Created Views and Triggers for security purposes.
• Assisting developers with code enhancements, index tuning for better performance.
• Tested the performance of stored procedures on the test server,modified the code for better performance and successfully implemented on the production server.
• Used BCP utility to transfer the data from summary tables to flat files.
• Extensively worked on different Replication Models including Snapshot and Transactional Replications.

Environment: SQL Server 2000, T-SQL,MS Reporting Services, Windows 2000 Advanced Server.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in gathering User Requirements and System Specifications.
• Filtered unnecessary data using complex T-SQL statements, implemented various Constraints and Triggers for data consistency.
• Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistency Data entry into the database.
• Created Reports from database onto excel spread sheet using DTS.
• Wrote complex stored procedures to process employee’s requirements and generating records between front end and back end.
• Created various reports using Crystal Reports after performing Data Analysis on the various Views of Business Intelligence.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure optimal performance of the server.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Involved in fine Tuning Performance and Query optimization of the Database as required by the application.
• Created Users and Roles, managed security and permissions of the databases.
• Maintained SQL Scripts for creation of Database Objects.

Environment: SQL Server 2000, Windows NT 4 Platform, EXCEL, Erwin 3.x, Crystal Reports 9.

Confidential

SQL Server Developer

Responsibilities:

• Install SQL Server 2000 on Windows 2000 Server.
• Actively participated in gathering user requirements and system specifications.
• Analyze and Design the objects required for the databases.
• Create Database Objects: Tables, Views, Constraints, Functions, Stored Procedures, Triggers, Rules, Defaults, and user defined data types.
• Identify Relationships between tables and enforce referential integrity using Foreign keyconstraints.
• Create Clustered and Non-Clustered Indexes to improve data access performance.
• Create Triggers to generate alerts and notifications.
• Tune the SQL queries using SQL Profiler.
• Use MS Visual Source Safe 6.0 as a Version Control System.
• Work with DTS packages to load the data into Data warehousing system.
• Write and test Stored Procedures and User-defined Functions.
• Troubleshoot the problems and document them.

Environment: MS SQL Server 2000/7.0, VB 6.0, Windows 2000 Server, and Crystal reports 8.0.