PROFESSIONAL SUMMARY:

• Strong 9 years of experience as SQL Server DBA (2014, 2012, 2008R2, 2008, 2005, 2000) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP).
• 24/7 on Call Support for Production Databases.
• Experience and good Knowledge about the newly added features like Always ON High Availability and contained databases in MSSQL
• Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Mirroring and Clustering.
• Extensive experience in Installation, Configuration, Patches, Upgrades and Administration for SQL Servers in Clustered (Fail - over) and Non-Clustered Environments.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Migrating Oracle & MYSQL databases to MSSQL using SSMA tool.
• Experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and to troubleshoot SQL Server related CPU, memory, Disk I/O, and other resource contention.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Experience in Monitoring Databases for Deadlock, capturing long running SQL queries, used HINTS for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Managing and Coordinating with the offshore team on daily Database maintenance activities
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Experience in T- SQL Development skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries.
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed5.0 and Red Gate SQL Backup).
• Strong in PowerShell scripting and automating day to day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.

TECHNICAL SKILLS:

DBMS: SQL Server, MY SQL, MS-Access

Database Utilities: SQL Management Studio, SQL Server Profiler, Query Analyzer, IDERA

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

Reporting Tools: SQL Server Reporting Services (SSRS)

Languages: T-SQL Visual Basics, .Net, JAVA, C++, HTML

Operating System: Windows 2000/ XP/7, Windows Server 2003, 2008, 2010 UNIX

PROFESSIONAL EXPERIENCE:

Confidential, NY

SQL Server DBA

Responsibilities:

• Migrated Databases from SQL Server 2005 to SQL Server 2008R2/2012 in Production and test Environments.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Installed/Configured MSSQL 2012/2014 Instances with Cluster Configuration.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Implemented High Availability in SQL 2012 by configuring Always On Availability groups across Windows Server Failover Clustering using Failover Clustering Instances
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Deploying and Troubleshooting SSIS packages with a multitude of Data sources and complex data conversion logics.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Created Linked servers accordingly in between the different servers based on the requirement.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Worked on Migrating Oracle & MYSQL databases to MSSQL using SSMA tool.
• Implementation of Backup, Re - index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures and Implemented Pager options to inform correspondingDBAbasis on each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Define db scripts versioning system to keep track of database versions for all environments.
• Administer, maintain, develops and recommends policies and procedures for ensuring the security and integrity of the company's databases.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.

Environment: MS SQL Server 2014/2012/2008 R2/2008/2005, T-SQL, MS SQL Server Integrated Services (SSIS) SQL Agent, SSRS, SQL Profiler, Windows 2008/2003 server, Visual Studio, .Net Framework.

SQL DBA

Confidential, Washington, DC

Responsibilities:

• Perform the role of a DBA for assigned applications
• Implemented SQL encryption across all the company servers
• Build and maintain several ETL packages to load the various client files in different formats into the company database
• Actively participated in the design and building of data warehouse integrating all the systems across the company
• Installed, configured SSRS servers and migrated reports
• Develop complex client specific data load scripts for medical claims Rx claims
• Recommend and implement DBA best practices to fix data and code issues
• Extensive use of SSIS and .Net Framework in day - to-day operations
• Handle the production support across applications
• Develop and maintain executive reports using SSRS
• Troubleshoot and tune complex SQL queries to improve performance
• Design and implement minor enhancements to existing .Net websites
• Monitor and tune complex SQL Server Agent jobs
• Actively participate in DB tool evaluations and submit recommendations
• Design and develop business solution using Agile/SCRUM methodologies

Environment: MS SQL Server 2012, SSRS 2008, Visual Studio 2010, SQL & T- SQL, SSIS, Microsoft Team Foundation Server, Visual Source Safe, jira.

SQL DBA

Confidential, Buffalo, NY

Responsibilities:

• Installed SQL server 2008 on windows 2003/2008R2 advanced servers, applied security fixes.

• Involved in Migrating SQL Server 2005 Servers to SQL server 2008.
• Installed and Configured MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of theDBATasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R 2
• Developing SQL scripts for maintaining administration tasks.
• Additionally, designed and implemented a disaster recovery system.
• Configured CDC on Replicated Database and created jobs/maintenance plans for Database.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Developed ER Diagrams using Visio 2000. Designed Star and Snowflake data model.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Using SQL server reporting services (SSRS) delivering enterprise, Web - enabled reporting so create reports that draw content from a variety of data sources.
• Creating DTS/SSIS Packages migration of data across different servers and Other Databases such as Oracle, Sybase and DB2 UDB.
• Created jobs for rebuilding of indexes and updating statistics.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes.

Environment: SQL Server 2005/2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Teradata, DB2 UDB.

SQL DBA

Confidential, Seattle, WA

Responsibilities:

• Installing and configuring and tuning and providing 24X7 support for SQL Server 2000/2005/2008 R2
• Created and scheduled jobs to setup log shipping between production servers.
• Implemented Database Mirroring on the SQL Server 2005 production databases.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating databases and logins with permissions in SQL Server 2005 as per the developer's request.
• Worked extensively on SQL Server Reporting Services to generate reports.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Involved in Migration from SQL Server and 2008
• Created Database Diagrams using ERW in Data Modeler.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Migrated and tested DTS packages to SQL Server 2005 Integration Services.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re - indexing.
• Restore Development and Staging databases from production backups as per the requirement.
• Extensively used SSIS to move data from text files to SQL Server.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Perform database enhancement and modification as per the requirements in DB2.
• Prepare daily report on the job failures, backup failures and disk space.
• Extensively used Database Performance Monitoring tools for performance tuning.
• Designedandimplemented database maintenance plan.
• Used Index tuning wizard and rebuilding indexes for faster Query Performance.
• Assist in capacity planning, space management and data maintenance activities for database system in DB2.
• Involved in resolving dead lock issues and performance issues.

Environment: MS SQL Server 2000/2005, Windows 2000/2003 servers.NET, MS Access.