SUMMARY:

• Around 3 years of strong professional experience in SQL Server 2008/2005/2000 as Database Administrator and Developer.
• Highly experienced in installing, configuring and administering SQL Server 2008/2005/2000 .
• Upgraded and migrated several servers and databases from SQL Server 2000 to SQL Server2008/2005.
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Experienced in Configuring, Implementing and Maintaining Database Mirroring.
• Good Knowledge in implementing in different Replication Models (Snapshot, Merge and Transactional) with different topologies.
• Highly experienced in Configuration, Implementation and Maintenance of Log Shipping.
• Extensive experience with backup and Restore methodologies using Native and third party tools (LITE SPEED, NetBackup, and Red Gate).
• Highly experienced with Business Intelligence in MS SQL Server 2005/2008 in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Expertise in migrating servers using in place and side by side upgrade.
• Experience in capacity planning, performance tuning, and disaster recovery and troubleshoot performance issues.
• Extensive knowledge in design of logical and physical data modeling using Erwin data modeling tool.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Developed Dash Board Reports on COGNOS 8.4 report studio
• Highly experienced in creating Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Experienced in programming tasks - Stored Procedures, Triggers, and Cursors for SQL Server 2000/2005/2008 .

TECHNICAL SKILLS:

Databases: SQL SERVER 2000/2005/2008, Oracle 9i, MS-Access

Programming Languages: SQL, PL/SQL, VB 6.0, VB.Net, C, C++, C#

Web Technologies: Asp.Net, HTML, DHTML, XML, IIS 6.0, Java Script

Tools: SQL Server Management Studio / Enterprise Manager, SQL Navigator SSRS, SSAS, SSIS, SSMS, Toad, Visual Studio, Cognos 8.4, Excel Macro 2007/2003, Erwin

Utility Tools: MS Office, MS Project, ClearQuest, Visual Source Safe 6.0, Rational Clearcase

Operating Systems: Windows 95/98/2000/2003/2008/ XP/NT 4.0, Unix, Linux, MS-DOS

PROFESSIONAL EXPERIENCE:

SQL Server DBA Developer

Confidential, NJ

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring.
• Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers.
• Supported production servers in Fail over cluster environment.
• Implemented several new features of SQL Server 2008 including Resource Governor, native SQL Server encryption, Data Compression.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Designed and populated reporting tables, views and stored procedures.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues promptly.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Created Dash board reports using COGNOS report studio.

Jr. SQL Server DBA Developer

Confidential

Responsibilities:

• Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.
• Migrated from SQL Server 2000/2005 to SQLServer 2005/2008.
• Configured security and access per SOX and PCI standards.
• Created Linked Servers for OLEDB Data Source and Native Sources.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.
• Used 3rd party tools like Quest Lite Speed in taking the backups to optimize performance and restoring.
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Configured Database mirroring, multi-instance SQL Server clusters as part of high availability solutions for mission critical TJX database Servers.
• Monitored backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Implemented table and index partitioning to resolve performance issues for Instant Credit application.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Fixed several SQL Query performance issues by examining execution plans, tuning indexes, creating plan guides, adding hint words.
• Monitored SQL Servers to examine top resource consuming queries and tuned them to reduce the server load.