SUMMARY

• Over 7 years of experience in database modeling, analysis, implementation, administration, performance monitoring and tuning using SQL Servers 2008R 2/ 2008/2005/2000 in the fields of communication, healthcare management, financial.
• Installed, upgraded, and administered SQL Servers 2008 R2/2005/2000 in clustering & non clustering environments;
• Expert in configuring cluster environments: SQL Server 2008 R2/2008/2005 Active/Active and Active/Passive Cluster on window 2008, 2003;
• Installed sp1, sp2 on SQL 2000, sp1, sp2, sp3, sp4 on SQL 2005, and sp1 on SQL 2008.
• Installed security updates, and hotfix in SQL 2000, 2005, and 2008;
• Worked in Windows 2003 Advanced Server, Windows 2000 Server, and Windows NT Server environments;
• Experienced in performance Monitoring and Tuning, Query Optimization via T - SQL, DMVs, System Monitor(Perfmon), DBCC Utilities, Database Tuning Advisor/Index Tuning Wizard, and SQL Profiler;
• Analyzed and documented the root causes of performance issues in both development, test, and production environment;
• Used third party tool Idera’s SQL Diagnostic Manager to monitor performance.
• Implemented Replication Models, i.e., Snapshot, Transactional, and Merge;
• Tested and implemented Log Shipping used for hot backup solution for MS SQL Server 2005/2008 databases;
• Experienced in implementing Database Mirroring in SQL Server 2005;
• Developed, documented, and maintained procedures for database backups, restores, replace, and recovery in production environment;
• Experience in database backup and recovery, security, and Data Transformation Services (DTS);
• Implemented RAID technologies;
• Installed and configured Clustered Servers in Active/Passive mode;
• Used Third-party backup software, such as SQL Litespeed, to perform SQL Server Backups.
• Created objects such as user-defined functions, tables, databases, indexes (clustered and non-clustered), stored procedures, views, triggers, cursors, using T-SQL;
• Transformed complex business logic into database design and maintained the referential integrityvia triggers and constraint;
• Experienced in SQL data modeling using SQL Diagram, Case Studio 2, and Visio;
• Experienced in business requirement analysis and conversion to database design;
• Good knowledge of System Development Life Cycle (SDLC);
• Experienced in normalization/denormalization, access optimization;
• Experience in database capacity planning and migration;
• Good knowledge of multi-sourced transformations, including flat files, XML and relational systems.
• Strong debugging skills and the ability to solve complex problems;
• Developed and documented database migration strategies, ETL using SQL SSIS/DTS, Import/Export and BCP utilities.
• Created packages, schedules jobs, and sent alerts using Database Mails/SQL Mails;
• Created, altered, and maintained system roles and permissions to users on various database objects;
• Good knowledge of SQL Analysis Services and Created reports via SQL Reporting Services (SSRS);
• Working knowledge of Data Warehousing.
• Experience with .net technology like asp.net and c#

TECHNICAL SKILLS

Languages: Transact-SQL

RDBMSMS: SQL Server 2008/2005/2000 , MS Access

SQL Server Tools: SQL Server Profiler, SSIS, SSMS

Reporting Tools: SQL Server Reporting Services (SSRS)

Analysis Tools: SQL Server Analysis Services (SSAS)

Data Modeling Tools: Case Studio 2, SQL Diagram, Erwin 3.x, MS Visio

Operating Systems: Windows Server 2003, Windows 2000 Advanced Server, Windows NT 4.0, Windows XP Professional, Unix

Other Tools: Idera SQL Diagnostic Manager v4.0, Lumigent LogExplorer, SQL litespeed

Survey Tool: Perseus SurveySolutions

Recording Tool: RWD UPerform

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

SQL Server DBA/Developer

Responsibilities:

• Creating stored procedures for backup and restore of system and user databases from Disaster Recovery;
• Verifying and maintaining database backups, integrity checks, and scheduled jobs;
• Creating and testing schema object such as stored procedures, triggers, and functions on the test servers;
• Migrating databases and database objects between multiple servers across production and development platforms;
• Troubleshooting, monitoring, and tuning SQL server and databases performance using SQL Profiler, System Monitor;
• Creating and maintaining SSIS packages and SQL scripts for generating reports;
• Providing support to other developers in solving development issues;
• Creating stored procedure and complex SQL queries required for producing internal weekly reports;
• Managing day-to-day SQL Server operations in SQL Servers 2005/2008/2008 R2;
• Installing and configuring Multi-node Cluster environment with SQL Server 2008 R2 as high availability.
• Designing and implementing Disaster Recovery Procedures like Log Shipping, Replication.
• Created and implemented SSIS Packages for importing and exporting data to other data storage;
• Checking the Configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation and the impact on system performance using System Monitor, SQL Profiler, and DBCC utilities;
• Resolving issues related to query optimization, database optimization and index tuning;
• Developing and documenting data dictionary, tables, views, stored procedures, queries, triggers, indexes, and functions using T-SQL;
• Deploying Idera Diagnostic Manager for monitoring SQL Server;
• Troubleshoot production environment in .net framework 3.5 using asp.net and C#.
• Used Microsoft Dynamics to import export customers’ information and sales information.

Confidential, NY

SQL Server DBA

Responsibilities:

• Installation of SQL Server 2005 with latest Service Packs.
• Performed Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments writing stored procedures for report generation in migration process and replication.
• Implemented the migration of SQL Server 2000 to 2005.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Installed and configured SQL Server Cluster on SQL Server 2005 with Windows 2003/2000 Advanced Server and configured 2-Node Active/Passive Clustering for failover on production server.
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication, writing scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to productionWrote scripts to review object permissions in all databases.
• Configured MS SQL Server 2005 in-built log shipping from primary server to standby server for report generation.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Involved in Monitoring Performance of different production servers.
• Creating tables, indexes and designing constraints.
• Involved in Logical and Physical design of SQL Server databases using Erwin.
• Upgrade DTS Packages to SSIS Packages
• Involved in migration of databases from MSSQL 2005 to MYSQL 5.0.
• Documented installation steps for migrating databases from MS SQL 2005 to MYSQL 5.0.
• Experience in managing, monitoring and troubleshooting of MS SQL Server 2005 and MYSQL 5.0.
• Recommended system design approaches, which are consistent with the application's business requirements.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Tuned SQL queries using Show Plans and Execution Plans for better performance.
• Creating and Maintaining Database Maintenance Plans.
• Requirements gathering from the end-users.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Sever database.
• Involved in analyzing the system for setting up new server and server configuration.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2005 backend.
• Worked in 24x7 production environment.

Environment: MS SQL Server 2000, Windows 2003 Advanced server/NT, IIS Server 5.0, Database Maintenance Plan Wizard, Diagnostic Manager, Database copy Wizards, Performance Monitor, Lumigent Log Explorer, SAS (Statistical Analysis System), MS Excel.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Upgraded SQL Server 2000 to SQL Server 2005; installed and tested SP2 for SQL Server 2005;
• Developed T-SQL Stored Procedures for maintaining data in existing system and newly developed applications;
• Working knowledge of data warehousing;
• Integrated, transformed, and loaded data from heterogeneous data sources to the data warehouse using SQL Server 2005 Integration Services (SSIS);
• Created reports via SQL Reporting Services (SSRS Report Designer/Report Builder) over data warehouse;
• Designed and implemented database backup and restore on SQL 2005;
• Used SQL Server Management Studio (SSMS) for monitoring, maintaining, and troubleshooting;
• Documented capacity planning of all servers and made recommendations accordingly;
• Consolidated various databases and tables in SQL Server 2005;
• Designed and implemented Disaster Recovery Procedures like Log Shipping and Mirroring between production and Disaster Recovery Servers;
• Developed and tested Stored Procedures;
• Used SQL Compare and SQL Data Compare for pushing changes from test servers to production servers;
• Documented newly added databases, objects, jobs, and the changes to the databases;
• Created Linked Servers to access data from one server to another;
• Solved server performance and disk space issues;
• Troubleshoot issues related to Query Optimization, Database Optimization and Index Tuning;
• Deployed third party tool Idera Diagnostic Manager for monitoring SQL Server;
• Used extended stores procedures for creating alerts for critical production jobs;
• Developed stored procedures to produce predefined reports that could access the corporate intranet for gaining business intelligence.

Environment: MS Windows Server 2003 Enterprise Edition, MS Office Sharepoint Portal server 2003, MS SQL Server 2005, MS SQL Server 2005 Integration Services, MS SQL Server 2005 Analysis Services, MS SQL Server 2005 Reporting Services, MS Office Excel 2003, MS Office Web components.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Performed logical and physical data modeling using SQL Diagram, Visio, and Erwin;
• Created new databases, tables, and fields for data entry, and performed database capacity planning;
• Extensively involved in Normalization (3NF) and denormalization of databases and access optimization;
• Created and managed database objects such as tables, views, indexes, and maintained the referential integrity accordingly;
• Troubleshoot and Fine-tuned database objects and server performance;
• Automated data collection from multiple sources and rolled them up into the management reports;
• Created Optimized Indexes in the Test and the development environment using Index Tuning Wizard;
• Monitored system Performance and Database Consistency Integrity using DBCC commands, like CHECKDB/CHECKTABLE, SHOWCONTIG, SHOWSTATISTICS, etc.;
• Created triggers to enforce Business Logic and data integrity;
• Migrated data from heterogeneous sources(e.g., flat files, XML) to and from SQL Server using BCP and DTS Import/Export;
• Installed, configured, and maintained Transactional Replication the one publisher and 12 subscriber environment for production servers in different locations;
• Developed and tested SQL Server Analysis Services cubes to support the Key Performance Indicators within the MS Office Business Scorecard Accelerator.
• Identified response issues by checking Index Fragmentation and statistics.
• Created Stored Procedures for maintaining SQL Server;
• Designed different kinds of transactions for the OLTP application;
• Created views for the company's occasional users who accessed the SQL Server Analysis Services instead of the relational database;
• Provide 24x7 production support.

Environment: MS Office 2003, MS Office Business Scorecard Accelerator, MS Office, MS Office Visio 2003, MS SQL Server 2000, MS Windows Server 2003.

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL Server 2000 with latest Service Packs;
• Migrated SQL Server 7.0 to SQL Server 2000;
• Extensively involved in database backups and restore;
• Monitored and tuned Performance of different production servers;
• Created Tables, Views, Indexes, and Check constraints.
• Granted logins and roles with appropriate permissions;
• Created and maintained Database Maintenance Plans;
• Created and maintained various databases for Production, Development, and Testing on SQL Server 2000;
• Planned the location of data, index, and transaction log files on the disks;
• Conducted root cause analysis related to coding practices, database bottlenecks, or network latency;
• Resolved Locking and Blocking issues during peak period of website hits;
• Monitored and tuned the Production server to optimize the performance;
• Monitoring and Troubleshooting performance during peak periods with over 100 concurrent connections;
• Monitoring SQL server logs (Enterprise Manager), Application logs (Event Viewer) and analyzing the logs for enhancing performance;
• Provided 24x7 support to SQL application developers in implementing the applications on production server;

Environment: MS SQL Server 2000, MS Application Center 2000, MS Exchange 2000 Server, MS Internet Explorer 6, MS Internet Security MS Office 2000 Professional, MS Operations Manager 2000, MS Windows 2000 Professional, MS Windows Server 2003 Enterprise Edition, MS Windows XP Professional. Dell Latitude C600, Dell OptiPlex GX150, Dell OptiPlex GX110, Dell OptiPlex GX240.