SUMMARY

• Over 7+ years of IT experience on Database Administration and Deployment with MS SQL Server technology and managing VLDB (very large database).
• Experience in Software Development Life Cycle (SDLC) and project methodologies.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2000/2005/2008/2008 R 2/2012/2014.
• Experience in tuning SQL queries and improving the performance of the database
• Experience in implementing and maintaining High Availability solutions like Clustering, Database Mirroring, Replication, Log shipping and Always On.
• Proficient in Database migration to new versions and editions of SQL Server as part of datacenter or server consolidation or upgrade projects.
• Experience in SQL Server Performance Tuning using tools like System Monitor, SQL Server Profiler, DMVs, Optimized expensive running Queries using Database Engine Tuning Advisor, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Created custom - tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task.
• Proficient with Disaster Recovery Solutions.
• Experience in implementing SQL Server Security and Database Permissions.
• Well experienced in scheduling SQL Server Jobs, Maintenance plans and executing them.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
• Well experienced in performing root cause analysis and using SQL Profiler for troubleshooting.
• Experience in working RAID and SAN environment and have good understanding in capacity planning.
• Transformed data between servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Audited database user’s audits using SQL profiler and costumed stored procedures\packages.
• Experience in Replication strategies for setting up and configure replication (snapshot, transactional, or merge) to copy, distribute and synchronize data across multiple servers.
• Worked extensively in Clustered environment (Active / Passive, Active / Active) to further increase scalability and stability of business critical systems
• Knowledge in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Experience working with developers on large scale projects and solutions.
• Exposure to various tools and technologies like Redgate, spotlight and LiteSpeed for database administration, monitoring and maintenance.

TECHNICAL SKILLS

Operating Systems: Windows 9x/NT/2000/XP, Windows server 2000/20

Databases: MS SQL Server 2000/2005/2008 R2/2012/2014

Database Tools: SSMS (SQL Server Management Studio), SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, SQL Agents, SQL Alerts, SQL Jobs, Database Mail, SQL Client Configuration utility, Backup and Restore, Replication, Log Shipping, Redgate, Idera

ETL Tools: DTS (Data transformation services), SSIS (SQL Server Integration Services)

Modeling Tools: Erwin, MS Visio

Languages: SQL, Transact SQL (T-SQL)

Reporting Tools: SSRS (SQL Server Reporting Services)

PROFESSIONAL EXPERIENCE

SQL Server DBA

Responsibilities:

• Installation, Configuration and Administering of SQL Server 2014/2012/ 2008/2005/2000 and Multi-Instance Servers and applied Security Patches.
• Installed SQL server Engine and Services component on Windows 2003/2008 Enterprise Edition cluster servers for test, QA and Production environment. Also installed service packs and hot fixes for database engine.
• Used upgrade advisor for compatibility check for databases before updates. Performed in-place and side by side migration of existing SQL server 2005 user’s client critical databases. Also changed configuration of databases like enabled AWE, increased physical memory, and enabled full-text indexes. Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. backup/restore, export/import and attach/detach.
• Created, altered, maintained system roles and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS) by using Visual Studio 2008.
• Identified long running queries and tune them. Resolved blocked and locked objects issues. Created new Clustered, Non-Clustered Indexes and constraints on frequently used tables in application.
• Designed Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures.
• Implementation of Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Used DBCC commands, System monitor, Dynamic views, Execution plans as part of trouble shooting and performance tuning.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Monitoring Server performance using SQL Profiler to analyze long running slow queries and tune the same to optimize application and system performance and also worked on resolving dead locks.
• Implemented Replication (Snapshot and Transactional) between primary production server and offsite (disaster recovery) server.
• Used the SSIS Import/Export, migrated the heterogeneous Database such as Oracle and Access database, flat files to SQL server.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created many SSIS jobs and scheduled them with SQL Agent.

Environment: Windows 2003/2008, SQL Server 2014/2012/ 2008/2005/2000 , SSIS, SSRS, Performance Monitor, Spotlight and Redgate.

Confidential, Baltimore, MD

SQL Server DBA

Responsibilities:

• Installed SQL server and its component on Windows 2003/2008 cluster servers
• Created custom-tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task. Upgraded/migrated databases from lower version of database to higher version
• Excellent in Replication strategies for setting up and configure replication (snapshot, transactional, or merge) to copy, distribute and synchronize data across multiple servers.
• Well versed in various high availability solutions like clustering, mirroring, log shipping.
• Worked extensively in Clustered environment (Active / Passive) to further increase scalability and stability of business critical systems
• Created, altered, maintained system roles and permissions to users on various database objects.
• Loaded flat files into stage tables by using Bulk Copy Program BCP and DTS packages. Scheduled database jobs for automation of DBA tasks.
• Planned and co-coordinated database security measures
• Intensively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
• Tested and Implemented Log shipping technique for disasters recovery.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.

Environment: Windows 2003/2008 Enterprise, SQL Server Management Studio, MS-SQL Server 2005/2008 R2, T- SQL, Clustering, SQL Navigator, SSIS, SSRS, Replication, SSMS, DTS, Query Analyzer, SSRS

Confidential, Lebanon, MO

Sr. SQL Server DBA

Responsibilities:

• Install clustered and stand-alone SQL server 2005 and 2008 and patched them periodically.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan;
• Exposed to Performance Monitor, Database Tuning Wizard, Performance monitoring tools, Network Load balancing, Performance counters, analyzing profiler outputs, Mirroring, IIS (Internet Information Services) Microsoft Failover clustering
• Administered and managed SSIS packages and SSRS reports.
• Implemented the new features like Data partitioning, Snapshot isolation, database mirroring, database snapshot, ETL (Extract Transform Load), DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, SQLCMD and dedicated admin connection
• Worked in Active Active cluster environment
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies
• Perform database backups by using LiteSpeed backup tool.
• Scheduled multiple daily and weekly SSIS packages and SQL jobs using SQL server Agent.
• Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
• Created Linked Server between SQL Servers. Worked with SQL Profiler/SQL Trace to Generate Traces.
• Maintaining the database consistency with DBCC at regular intervals
• Monitor SQL Server log files.

Environment: Windows Server 2003/2008, MS SQL Server 2008/2005/2000 , SQL Server Reporting services, SQL, T-SQL, SQL Query Analyzer, Profiler, Erwin, VSS.

Confidential, Branchville, NJ

SQL Server DBA

Responsibilities:

• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Evaluated data storage considerations to store databases and transaction logs.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Handled Active/Active Clustering between two Production Servers and performed daily backups and developed recovery procedures.
• Created, built and deployed successfully SSIS packages by using BIDS. Migrated DTS packages to SSIS 2005 packages.
• 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.
• Responsible for monitoring and making recommendations for performance improvement in databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Using Log shipping for synchronization of database.

Environment: SQL Server 2008/2005/2000 , Windows 2003, Microsoft Windows 2008 Server

Confidential

SQL Server Developer

Responsibilities:

• Performance tuning of SQL servers and application issues related to migrations.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP.
• Worked on High Availability, Log shipping, Mirroring, Disaster Recovery and Replication
• Analyzed long running, slow queries and tuned the same to optimize application and system performance
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Setup Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.

Environment: SQL Server 2005/2000, Windows 2003/ 2008 Server