PROFESSIONAL SUMMARY:

• Over 4 years of IT experience on Database Administration and development with MS SQL Server technology
• Experienced in Pharmaceutical, Clinical and Health, Finance, Insurance domains
• Excellent knowledge in Relational Data Base Management System concepts
• Well experienced in upgrades and maintenance of SQL Server 2000/20 /2014
• Extensive experience in Installation and Configuration of SQL Server 2000/20 /2014 service packs and hot fixes
• Experience in implementing login and database security and managing permissions
• Extensive experience in developing and implementing backup and restore strategy and high availability solutions
• Strong SQL Server 2000/2005/2008 developer skills including writing stored procedures, user defined functions, views, indexes, cursors, triggers and queries
• Experience in tuning SQL queries and improving the performance of the database.
• Very strong in implementing and maintaining Database Mirroring, Replication(Transactional & snapshot), Log shipping
• Proficient in Migrating Databases from SQL Server 2000/2005/2008
• Experience in establishing routines to ensure that indexes are defragmented regularly and statistics are up - to-date
• Experience configuring SQL Server Agent Jobs scheduling, creating, alerts
• Experience in resolving issues and identify root cause and proactively improve the reliability of the data
• Monitoring and Troubleshooting SQL Server Performance using SQL Server tools (Profiler, DTA, SSMS, PerfMon, DMVs, system sprocs)
• Developing SSIS packages to automate SQL Server day to day monitoring tasks
• Developing and Managing in SSIS to populate the target database repositories from the source systems
• Very good communication, conceptual, analytical, writing and documentation skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008R 2/ 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, Wayne, NJ

SQL Server DBA

Responsibilities:

• Maintained and monitored all production databases for performance and system uptime
• Participated at an intermediate level in the logical and physical design of systems architecture services.
• Installation of SQL Server 2008R2/2008/2005 with latest Service Packs
• Installed and maintained Active/Passive and Active/Active SQL Server Clusters in Windows 2008 R2 with SQL Server 2008 R2
• Wrote SSIS Packages to migrate users, logins, stored procedures, and tables
• Set up and supported QA and Dev environment
• Writing stored procedures for report generation in data migration
• Involved in migrating SQL Server and SQL Server
• Running DBCC consistency checks and fixing data corruption in application databases
• Set up and supported Database Mirroring for mission critical databases as a DR Solution.
• Imported data from Oracle, DB2, Flat File, MS Access and Excel spread sheet into SQL Server 2008 databases using SSIS packages
• Extensively involved in replication and implemented Snapshot, Transactional Replications
• Involved in Monitoring Performance of different production servers.
• Provided 24x7 production support in on call basis.
• Used Idera Diagnostic Manager for Monitoring solutions
• Involved in semiannual Disaster Recovery Testing drills
• Identified flaws with DR strategies and offered suggestions of improvement
• Monitored SQL Logs to ensure success of schedules, jobs, and backups
• Configured Log Shipping in SQL Server 2005
• Wrote custom scripts and jobs to manage backups due to lack of disk space
• Working with the end user gathering requirements for the system
• Worked with application team to help Installing applications and establish the connectivity with the database
• Managed database space issues proactively
• Used Lite Speed tool to Backup and Restore database and backup compression.

Environment: MS SQL Server 2008/2005/2000 , Windows 2008/2003 Enterprise edition, SQL profiler, Idera Diagnostic Manager, SQL Light speed Backup Software

Confidential, VA

SQL Server DBA

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.

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.

Confidential, Brentwood, Tennessee

SQL server DBA / SSIS developer

Responsibilities:

• Installed and configured SQL Server 2008R2 Instances on both cluster and stand-alone environment.
• Estimated data growth from past years history and allocated SAN Space. Managed gigantic databases across the multiple disks on SAN using the file groups.
• Databases migrated as backup restore and loaded table’s data using SSIS packages.
• Created backup strategies based on database size and scheduled Maintenance plans, automated DB refresh jobs in Test & Development environments.
• Responsible for daily routine activities backups, updating stats, refreshing databases as per requirements.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Configured and managed log shipping between DC and DR servers for Disaster recovery solution.
• Configured Database Mirroring with high performance and high availability mode.
• Created Linked Servers between SQL server 2005 and 2008/2008R2, Oracle, Teradata and SAS using third-party RDBMS driver tools.
• Involved in SQL Server Hardening.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Created Operators and Configured Database Mail
• Monitored the event logs and server logs for troubleshooting and problem solving
• Used ETL packages to move logins and jobs from one server to another server.
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms
• Created SSIS Packages to import the data from Oracle databases, XML, text files, Excel files.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Installed and configured SSRS. Deployed RDL files on report server and managed report’s security.
• Implemented enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS), RAID levels.
• Responsible for SSIS, SSRS package executions and availability.

Environment: MS SQL Server 2005/2008/2008 R2 64 bit, Enterprise, Windows server 20 bit, Business Intelligence Development Studio - SSIS, SSRS, Performance Monito

Confidential

SQL server DBA

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.
• Performed backup 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 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.

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