PROFESSIONAL SUMMARY:

• About 11 years of experience in IT including Database Design, Development and Administration of Database Management in MS SQL SERVER 2016/2014/2 on Windows environment.
• Expertise in installing, configuring, planning, testing MS SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005, 2000 and associated database tools, updating with latest service packs, hot fixes and security patches.
• Architected, designed and developed user applications using T - SQL, SSIS, ASP VBScript
• Experience in creating Maintenance plans for backups, indexing database integrity check and cleanup.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in Normalization, Database design, Performance Analysis and Production Support.
• Implemented MS SQL Server Security developing T-SQL scripts to create SQL logins, users, roles, assigning users to the roles, assigning permissions to tables.
• Hands-on experience in Database Mirroring, Log-Shipping and Replication
• Provided support SQLServer Reporting Services (SSRS) environment by installing, configuring and deploying reports from DEV/Test to PROD environments.
• Provided support SQLServer Reporting Services (SSRS) environment by installing, configuring and deploying reports from DEV/Test to PROD environments.
• Refreshing dev and staging servers with production data by restoration of databases for constant synchronization of dev and staging servers with production servers.
• Experience in different types of backups, restoration of the database and also using SQLServer agent to schedule jobs and Maintenance Plans and set Database Mail settings for notifications or alerts.
• Successful experience designing SQL Database for user applications, developing all procedures for data processing.
• Extensive experience developing T-SQL database reports for applications and upon users requests.
• Experience working with SSIS such as developing SSIS packages for data manipulations
• Implemented Integration Services Catalog for SQL Server 2014 to store SSIS packages, configured the security per package
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.

TECHNICAL SKILLS:

T: SQL, CMD, C, C++, C-Shell, Perl, JavaScript, HTML, CSS.

Database Application Software: SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000 , MS SQL Azure

DB Utilities: SSMS, Query Analyzer, SQL Profiler, Activity Monitor, Job Activity Monitor

ETL Tools: SSIS, DTS, DATA IMPORT & EXPORT (SSMS).

Application Software: Microsoft Office

Operating Systems: Windows Server 2016/2012/2008 R 8/2008/2003/2000

WORK EXPERIENCE:

SQL Server DBA / Developer

Confidential, Glenn Allen, VA

Responsibilities:

• Successfully supported Manhattan SCALE and Billing Management SQL Databases on Prod and QA environments, resolved application and DB issues
• Configured, tested and implemented SQL Database backup solution.
• Performed emergency database restores and recoveries.
• Worked with 3rd-party consultants to troubleshoot and fix the issues with the Manhattan software over the phone
• Performed DBCC consistency checks, index rebuild and error logs monitoring.
• Developed SSRS Reports and T-SQL database Stored Procedures for enhanced Manhattan SCALE application reports.
• Developed a project for the incremental database data extracts and imports for the foreign client company.
• Optimized database schema and extracting T-SQL scripts to minimize extracting time and to maximize the performance.
• Troubleshooted performance issues and fine-tuned queries and stored procedures

Environment: Windows Server 2014, MS SQL Server 2016/2014

SQL Server Developer/DBA

Confidential, Clearwater, FL

Responsibilities:

• As a member of the Development team successfully converted/migrated a number of unsupported user MS Access applications to the managed MS SQL/.Net platform
• Designed and implemented application security model according to the bank's standards and policies
• Implemented Integration Services Catalog for SQL Server 2014 to store SSIS packages, set the permissions per SSIS package
• Programmed security configuration scripts (T-SQL) for automated applications deployment
• Developed SSIS package to convert report from mainframe to SQL Server
• Performed checklist of newly built SQL Server Instances
• Successfully performed the depliyment of the applucations to the Test, UAT and Prod servers according to the time schedule
• Responsible for Monitoring and Tuning Report performance.
• Supervised oversea's programmers, verified the newly built code for security and safety purpose, making sure the naming convension is met.
• Documented the projected, wrote detailed instractions for future possible changes and troubleshootings

Environment: Windows Server 2014, MS SQL Server 2014/2012

SQL Server DBA / Developer

Confidential, NYC, NY

Responsibilities:

• Successfully planned, configured and performed a number of SQL server 2005 and 2008 migrations from physical Clusters to Virtualized environment.
• Built MS SQL Server accordingly, prepared all migration scripts, performed the actual migration during tbe maintenance window
• Migrated Microsoft SQL Database, Reporting, Integration and Analytical services
• Administeted SQL Database Servers 2014/2008/2005 , monitored performance, backups, scheduled jobs
• Planning for backup and recovery of database information and maintaining Backups.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Developed SSIS package for a large data extract, scheduled for the repeated execution, monitored the Logs
• Performed Technical Support of the Property Management Software - VTS, Argus Enterprise, TransTrek, P2P PM & IP
• Converted Excel Spreadsheets into MS SQL Database tables using SSIS
• Performed data analysis to eliminate duplicated data and orphaned records
• Developed various reports on T-SQL for the needs of business upon requests

Environment: Windows Server 2014/2008R2/2003, MS SQL Server 2016/2014/2008 R2/2005, SQL Cluster, Mirroring, Replication

SQL Server Developer/DBA

Confidential, Arthur, IL

Responsibilities:

• Successfully supported Production, Test and Dev MS SQL 2014/2008 servers environments.
• Performed scheduled schema synchronizations from Dev to QA and Dev to Prod servers.
• Managed and supported database backups, configured Linked servers.
• Configured backup and performed restores. Performed performance tuning with SQL Profiler, improved the applications performance.
• Successfully implemented High Availability solutions - DB mirroring, Transaction Log shipping and backup replication processes.
• Developed SQL maintenance scripts, designed and implemented advanced DRP procedures, recovered the databases after the failures.
• Managed security on all the SQL Servers, installed Service Packs and Security patches.
• Designed DRP solutions for a number of systems and applications including SQL servers. Performed required tests and trained the users.
• Assisted programmers in development of the T-SQL stored procedures for thein-house ERP application, helped to find solutions and resolve the issues
• Successfully developed SQL reports upon users request.
• Performed Database consistency checks with DBCC and monitored error logs.
• Developed SSIS package for the large report involving multiple linked servers.
• Successfully developed and deployed to Production a number of the data conversion and data migration projects.
• Created Dev and Test servers and established a procedure for the development team for the proper development life cycle.

Environment: Windows Server 2014, MS SQL Server 2016/2014

SQL Server DBA

Confidential, Detroit, MI

Responsibilities:

• Managed and supported 800+ Pro instances of the Production MS SQL Server 2012/2008R2/2005 across the world. Performed SQL Server installations, configuration and troubleshooting.
• As a primary DBA on a daily basis reviewed and resolved backup issues.
• Installed, maintained and upgraded SQL Server binaries, instances and databases. Migrated, refreshed databases, handled database failovers and recoveries.
• Successfully planned and performed Servers migrations from MS SQL 2008 to MS SQL 2012, migrated Databases and all the servers configurations.
• Supported database structure changes and data changes for Application development, testing and deployment.
• Supported SQL Server High Availability solutions in Production environment like mirrored databases and clustered environments.
• Performed periodical Disaster Recovery testing of the solution developed internally
• Enforced IT policy and security requirements for database access and controls.
• Worked with ticketing systems that coordinate incoming incidents and customer requests.
• Performed on-call duty.

Environment: Windows Server 2012/2008/2003 , MS SQL Server 2012/2008R2/2005, Cluster, DBReplication and Mirroring

SQL DBA/Developer

Confidential, Glenn Allen, VA

Responsibilities:

• Successfully supported OPENTEXT Global360 imaging Production system including the Windows 2008 server, the MS SQL 2008 servers application database and the client application.
• Provided support of for the applications and SQL servers performance.
• Developed Vendor Audit Management (VAM) system for the Quality Management dept. on MS SQL Server 2005. Developed stored procedures with T-SQL and created ASP-pages with VBScript. Designed DTS/SSIS-data import solutions. The developed system was used by ~120 users across Nestle Canada and Nestle USA.
• Developed Marketing Consumer Relation Management system for marketing dept. Built MS SQL 2005 database, created T-SQL-scripts for the data de-duplication.
• Performed automated data loads with SSIS, provided data pulls according to the business requests.
• Planned, built and supported ~40 Prod instances of the MS SQL Server 2008/2005, installed patches and updates.
• Planned the backup strategy, scheduled backup jobs and backup purge strategy.
• Performed operational tasks managing user accounts in Global360 and RightFax.
• Performed massive creation of the accounts, changing accounts and passwords.
• Resolved users faxing issues.
• Successfully developed a solution for server-side network printing via firewall.

Environment: Windows Server 2008/2003, MS SQL Server 2008R2/2005,