SUMMARY:

• Over 8 years of professional experience in Microsoft SQL server database administration and development.
• Extensively involved in installation of MS SQL SERVER 2000,2005,2008,2008 R2.
• Involved in all phases of Software Development Life Cycle (SDLC).
• Experience in Database Administration on performance T - SQL tuning and optimization of queries for reports that take longer execution time using SQL Profiler, Database Design, Maintenance with outstanding troubleshooting capabilities, maintaining very large and complex databases.
• Configuring more than 2GB RAM for 32-bit and 64-bit systems using AWE switches.
• Experience in Setting up High availability solutions like Log shipping, Replication, Clustering and mirroring.
• Extensively worked on Merge Replication, Snapshot Replication and Implemented Transactional Replication as a part of Disaster Recovery (DR) solution.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Assisted in configuring Database mirroring in SQL Server 2008 for multiple databases.
• Experience in SQL Server 2008 new features like Policy Based Management, Data Compression, Backup Compression Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Experience in using Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) for finding out long running queries.
• Experience in Extracting, Transforming and Loading 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.
• SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Experience in using third party tools like LiteSpeed (Backup and Database Recovery), and data modeling tools like ERWIN.
• Expertise on physical storage SAN configuration on different RAID levels.
• Extensive experience in Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
• Migrated SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008.
• Experience in upgrading SQL Server software to new versions and applying Service packs and hot fixes.
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Experience in in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
• Rebuilding indexes with different fill factors and updating statistics.
• Experience in Linked Server setup, which allows access to the distributed, heterogeneous queries against OLE DB data sources for EXCEL, MS ACCESS and Text files and running the Batch Processes.
• Experience working with server side trace.
• Expertise in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Good knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Experience in working with system administrators for creating/modifying/user/group accounts in Windows Active Directory in order to authenticate SQL server users through domain group/user accounts.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Provide 24x7 on-call production support in case it requires.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008R2/2008/2005/2000/7.0, Oracle, MYSQL.

Languages: T-SQL, C, C++, C#, vb.net, JAVA, ASP.NET, Visual studio2005/2003, XML, HTML.

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

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Integrator, Data transformation services (DTS).

Third Party Tools: Erwin, Red gate, Litespeed, fog lite.

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Applications: Microsoft Office Suite, Adobe Photoshop.

PROFESSIONAL EXPERIENCE:

Confidential, Norcross, GA

SQL Server DBA

Environment: MS SQL Server 2005/2008R2, Windows 2003, SSRS, SSIS, MS Access, VB, C#, Erwin and Litespeed.

Responsibilities:

• Support and troubleshoot very large databases (VLDB).
• Implement and maintain routine DBA tasks like scheduling jobs, creating maintenance plans.
• Implemented high availability concepts like Database Mirroring and Transactional Replication as a part of DR plan.
• Use log shipping for synchronization of database.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively use SSIS tool to load data from MS Access, Excel spreadsheets, and flat files into the target SQL Server database.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked on moving database files, backup and database restores.
• Daily routine DBA tasks like handling user’s permissions and handling maintenance Jobs.
• Checking database health by using DBCC Commands and created maintenance plan.
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDLtriggers, mirroring and online indexing.
• Develop all the required stored procedures, user defined functions, and triggers using T-SQL.
• Creating logins and roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Implement and manage the clustering environment like Active/Passive and Active/Active.
• Performedbackup using backup compression and Data compression in SQL Server 2008R2 on clustered environment.
• Moved files between file groups and partitioned the tables to improve the performance.
• Configure the RAID levels for data files, log files and tempdb at server level.
• Migrated SQL Server 2005 to 2008 R2 and DTS to SSIS (ETL).
• Created tables, views, indexes, functions and advanced queries for databases by using SSMS.
• Involved in setting up SQL Server Agent Jobs for periodic backups with backup devices, database maintenance plans and recovery.
• Created custom reports using SSRS.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breaches.

Confidential, Denver, CO

SQL Server DBA

Environment: MS SQL Server 2008/2005, Windows 2008, Excel, HTML, XML,VB and ASP.NET, LiteSpeed, MS Visio, C#, SSIS, Microsoft SQL server Visual Studio 2005/2008.

Responsibilities:

• Managed and Administrated SQL Server 2008/2005 production and non-production servers.
• Migrated servers from SQL SERVER 2005 to 2008 both in place and side by side.
• Installed SQL Server 2008/2005 on cluster environment.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Implemented the new SQL Server 2005 concepts like Data-partitioning, Snap-shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Daily routine DBA tasks like handling user’s permissions and handling maintenance jobs.
• Checked Database Health and consistency by using DBCC commands and DMVS.
• Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using native SQL Server tools like profiler and performance monitor.
• Managing the Litespeed backups, restore the databases transaction log on Production/Development servers as per Business/IT needs using SQL safe.
• Hands on experience in trouble shooting database issues.
• Performed all basic Database activities like moving databases between servers, copy databases etc.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Designed and developed SSIS packages for data migration.
• Implemented the SQL Server 2008 new features like Policy Based Management, Data Compression, Backup Compression Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Implementation of SQL server logins, roles and authentication modes as a part of security policies.
• Configure the RAID levels for data files, log files and tempdb at server level.
• Implement data availability solutions like online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Successfully implemented the capacity planning for different servers.
• Performed data partitioning for efficient management of database tables and indexes.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Export or Import data from other data sources like flat files using Import/Export through SSIS.

Confidential, VA

SQL Server DBA

Environment: SQL Server 2008/2005/2000, Windows 2003 server, C#.net, VB and ASP.NET, LiteSpeed, MS Visio, Microsoft SQL Server Visual Studio 2005/2008, ERWIN.

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Performance metrics reports daily, weekly and monthly.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• 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 based on level of Fragmentation.
• Extensively worked on performance issues like update statistics, Auto Stats.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Wrote T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Maintaining the database consistency with DBCC at regular intervals.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Expertise in setting up and troubleshooting Database mirroring, Log Shipping.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.
• Solving Tickets on Daily Basis for Production Issues.
• Creating and Maintaining Database Maintenance Plans.
• Monitoring SQL Server logs to ensure whether the backup operations,batch commands, scripts have completed successfully.
• Experience in using ERWIN tool for designing the reporting databases.
• Created Database mail Profiles and used them for sending emails for the notification of completion of jobs and processes.
• Granting permissions to users on development servers.

Confidential

SQL Developer/DBA

Environment: MS SQL Server 2000/7.0, Windows Server 2000, Developer 2000, SQL Server Enterprise Manager, DTS, VB Script, MS Access.

Responsibilities:

• Continuously interacted with users to gather the business requirements.
• Performed regular Administration activities from Managing system resources, users and database to the fine-tuning level and implemented the project successfully.
• SQL Server optimization, DBCCs, debugging scripts and automating DBA tasks.
• Designed and developed tables, stored procedures and cursors using T-SQL.
• Wrote complex T-SQL queries for reporting and data extraction.
• Created query plans and made sure each and every query is using appropriate useful indexes.
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Set up some tables in the main server as a snapshot publication and push.
• Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created new Databases and maintained existing User / System Databases. Involved in Logical/Physical design of database and maintenance.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Design and implementation of Security Model, policies and procedures
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Created programs using Developer 2000, PL/SQL, and Oracle.
• Wrote DTS scripts for data transfer.
• Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS).
• Monitored the event logs and server error logs for troubleshooting.
• Identified the bottlenecks and troubleshooting them for optimal performance.

Confidential

SQL Server Developer

Environment: MS SQL server 2000, Windows 2000, VB .Net, Enterprise manager.

Responsibilities:

• Installed and configured SQL Server 2000.
• Created programs using Developer 2000, PL/SQL, Oracle.
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Involved in creating Stored Procedures, views, tables, constrains.
• Created stored procedures and triggers for Data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Wrote complex stored procedures to process employee’s requirement and generating.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.