SUMMARY

• A forward - thinking developer offering more than Six years of experience as SQL Server DBA/Developer (2008, 2012, 2014) in Production, Development, Installation, Upgrades, Patches, Scheduling Backups and Restores, Configuration, Implementation and Maintenance for Disaster Recovery solutions (using Log Shipping, Transactional and Merge Replication) and Tuning.
• With some strong communication and managerial skills and an excellent team player.

TECHNICAL SKILLS

• SQL SERVER 2005/2008/2012/2014 R2/2016
• MS-Access
• Windows Server 2003/2008/XP/98
• SSIS
• SSRS
• Linux
• UNIX
• PL/SQL
• VB 6.0
• VB.Net
• C#
• VBScript
• Ad-hoc
• ETL
• Shell Script
• Asp.Net
• HTML
• XML
• IIS 6.0
• Java Script
• Clustering/Always On.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

SQL DBA / SSIS DEVELOPER

Responsibilities:

• Extracted data from various sources like SQL Server 2008/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Involved in the Migration of Database from different SQL Servers.
• Performed Replications (snapshot, Transactional replication, Merge Replication, Mirroring and Peer- Peer).
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environment.
• Involved in gathering business requirements from clients about the credentials needed to access their servers, firewall settings and managements.
• Performed Backups and Recovery of many company databases.
• Involved in creating/reviewing functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Performed Clustering on servers.
• Delivered adequate reporting solutions needed for Business intelligence platform,SSRS and SSIS processes.
• Created Data-driven Packages in SSIS as part of the automating the process for the Referral Process.
• Wrote some scripts using Shell and PowerShell.
• Reviewed & Tested packages, fixing bugs (if any) using SQL 2008 Business Intelligence Development Studio.
• Design,Developed,Modified and troubleshoot SSRS Reports.
• Tested existing reports as needed.
• Wrote and developed complex stored procedures, queries, triggers, functions and cursors for the OLAP/OLATP batch, processes and for automation tasks. Also, created indexes, constraints, rules on database objects.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• On-Call support to esteemed customers to resolve issues for business requirements.

Confidential, Fairfax VA

SQL Server DBA/ Developer

Responsibilities:

• Involved in Migration of Databases from SQL Server 2008 to SQL Server 2014 and was involved in Technical decisions with Clients team, Business Analysts for planning and up of System Configuration.
• Planned, Configured, Installed, Maintained SQL Server in environment of Multi-Node Cluster with Multi-instances.
• Setup and troubleshoot for Active/Active/Passive Clustering in SQL Server 2008.
• Configured and Monitored Database Mirroring for Application Development environment
• Migration of DTS packages to SSIS packages.
• Participated in Developing and refining Business Intelligence and Reporting Projects.
• Created and Maintained Data models for Business Intelligence and Reporting requests.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Configured Disaster Recovery solution with Transaction Replication from Distribution Server with multiple subscriptions with Updatable Subscribers for (Push & Pull) methods.
• Scheduled & Maintained ETL packages in terms of data validation and consistency.
• Scripted OLAP database backup and scheduled a daily backup using SQL Server agent job.
• Performed Database Refresh tasks from production to Development, Staging Servers and used Database Engine Tuning Advisor to resolve Performance Issues.
• Involved in writing Stored Procedures and Functions, Cursors to handle database automation tasks.

Confidential, Arlington Texas

SQL Server DBA/ Developer

Responsibilities:

• Setup and troubleshoot for Active/Passive Clustering in SQL Server 2012.
• Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation and Trouble-shooting for Business workflow with Log Shipping mechanism.
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2012.
• Performed Database Refresh tasks from production to Development and Staging Servers.
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Developed ETL frame work based on the existing SAS models by using SSIS and SQL Server.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Provided On-Call support to Mission Critical Environments and expertise with Disaster Recovery mechanisms.
• Maintained two different databases: Read-only reporting database and Disaster recovery database.
• Performed security tasks like Grant, Revoke permissions for security tasks.
• Involved in auditing and performing the transactions on Databases.
• Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks.
• Involved in training Update features for Business solution of SQL Server.
• Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions.