SUMMARY

• Around 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 creating Cassandra databases on almost 150TB, 1500 nodes and has experience on Cassandra tuning when migration is in process.
• 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

SQL DBA / Developer

Confidential, New York, NY

Responsibilities:

• Installed and configured SQL Server 2014 on both physical and virtual machines.
• Migrated databases from SQL server 2005 to SQL server 2014.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY
• Configured Always on in both Synchronous and Asynchronous modes as per Application requirements.
• Configured and managed virtual Servers and worked on virtualization and clustering environment.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Experience designing Cassandra database associated with a web service that has high volume user profile data to vertical teams. And migrated high volume OLTP transactions from SQL Server to Cassandra.
• Involved in building and maintaining SSIS packages to import data into Data Warehouse from Excel, Flat files and OLEDB sources.
• Extensively worked on developing SSAS cubes, KPIs, Measures, Partitioning Cubes, Data Mining models and Deploying and Processing SSAS objects.
• Created various ad - hoc reports like table, matrix, and sub-reports etc. as per end user requirements.
• Handling tickets on Service Now for Production support.

Environment: Windows 2008 R2/2012, Linux, MS-SQL Server 2014/2012/2008 r2/2005, Cassandra, Oracle 11g, Java,.NET Framework, Visual Studio, SSIS, SSAS and SSRS, Light speed.

SQL DBA / Developer

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, Charlotte, NC

Responsibilities:

• Assisted in complete Life Cycle including Design, Development and Testing of an Application.
• As a part of SQL DB team, was primarily responsible for planning DR, ensuring databases are online and providing infrastructure and application DB support.
• Developed application using C#.Net, ASP.NET.
• Troubleshooting and Performance tuning of SQL Server using DMV's, Performance Counters and Extended Events.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• As a developer created complex Stored Procedures, triggers, cursors, and other SQL joins and statements for applications.
• Created database Maintenance Plans, SQL Server Jobs and deployed custom maintenance scripts to schedule regular DBA tasks for enhancing the performance ofSQL Server. Some of these tasks included Database Integrity checks and Re - Indexing, Updating Statistics, Full and Transactional Log Backups and DBCC Cleanup.
• Created web pages using HTML5, JQuery, CSS, JavaScript developed layout pages.
• Solely maintained a database for the reporting purposes like creating database and other SQL table objects.
• Worked on SSIS packages to load the date from application database to reporting database.
• Installed, configured and maintained MS SQL fail over clustering for critical production servers.
• Daily routine Developer/DBA tasks like handling user's permissions and space issues on Production and UAT Servers and handling maintenance Jobs.
• Excellent experience configuring and maintaining all three types of replication like transactional snapshot and merge replication.

Environment: SQL Server 2008R2/2012, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSRS, SQL Profiler, C#.Net, ASP.NET.

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.