SUMMARY:

A highly organized and resourceful SQL Database DBA and Developer having 13 years of SQL Server Database Administration and Development experience.

TECHNICAL SKILLS:

Database Servers: MS SQL Server 2016/2014/2012/2008/2005/2000

Database Tools: T - SQL (SPs, Triggers, Reports), SSMS, SSIS/DTS ETL Solutions, CDC, SSRS, High Availability Solutions, Database Mirroring, Database Replication

WORK EXPERIENCE:

Confidential

Responsibilities:

• Successfully planned, configured and performed SQL server 2005 and 2008 migrations from physical Clusters to Virtualized environment.
• Migrated Microsoft SQL Database, Reporting, Integration and Analytical services
• Administeted SQL Database Servers 2014/2008/2005 , monitored performance, backups, scheduled jobs
• Performed Technical Support of the Property Management Software - VTS, Argus Enterprise, TransTrek, P2P PM & IP,

SQL Server DBA / Developer

Confidential

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.
• 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 maximize the performance.

SQL Server Developer/DBA

Confidential

Responsibilities:

• As a member of the Development team successfully converted/migrated a number of Unmanaged MS Access applications to the 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
• 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

SQL Server Developer/DBA

Confidential, Arthur, IL

Responsibilities:

• Successfully supported Production, Test and Dev MS SQL 2014/2008 servers environments.
• Performed scheduled schema synchronizations.
• Managed and supported DB-backups, configured Linked servers
• Performed development of the T-SQL stored procedures, SQL reports and scheduled jobs, SSIS data migration jobs
• 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

SQL Server DBA

Confidential, Detroit, MI

Responsibilities:

• Managed and supported 800+ Pro instances of the Production MS SQL Server 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. 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.

SQL DBA

Confidential

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, monitored database backups and servers performance.
• Performed operational tasks managing user accounts in Global360 and RightFax, massive creation of the accounts, changing accounts and passwords. Resolved users faxing issues.
• Successfully developed a solution for server side network printing via firewall.

SQL Server Developer/DBA

Confidential

Responsibilities:

• 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 is used by approx. 100 users across Confidential Canada and Confidential 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 DTS/SSIS, provided data pulls according to the business requests.
• Developed Command-prompt batch scripts for server data migration, user logon scripts, folder security settings reset.
• Successfully deployed, provided day-to-day support, troubleshoot infrastructure and application Windows Servers 2008/2003/2000 according to the SLO. Carried hot pager for the 7x24 system support.
• Planned, built from scratch and managed around 40 Prod instances of the MS SQL Server 2008/2005/2000. 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 all the SQL Servers, installed Service Packs and Security patches.
• Designed DRP and BCP solutions for a number of systems and applications including SQL servers. Performed the testing and trained the users. Deployed High Availability solutions - Transaction Log shipping, DB replication

System Administrator

Confidential

Responsibilities:

• Administered factory network LANs & WAN of 4 remote sites, configured Cisco switches and routers.
• Implemented and supported Windows NT4-domain, Windows NT 4.0 DCs, File/Print, various Application servers, provided users support
• Administered FMS1 application for factory management support on AS/400 server, managed users accounts and printing queues.
• Supported UNIX-Internet server (DNS, SMTP, Apache server).