Summary

SQL Server Database Administrator DBA / Implementation Analyst 2 / Chain Facilitator

• Networking, SharePoint, C , Microsoft Azure
• MySQL 5.1.54 Community
• Over 18 years of professional IT experience providing technical support in positions as Database Administrator DBA , Chain Database Analyst , Implementation Analyst 2 and Chain Facilitator.
• Experienced in Database support, Database builds and Administration, technical support, application support, conversion support, training, documentation, quality assurance, system builds, server swaps, installations, custom Crystal Reports creation and modification, Windows Networking, system demonstrations, testing, de-bugging and on-site visits.
• Computer Experience
• Microsoft SQL Server 2012,2008, 2005, 2000 Publisher-Subscriber replicating environments, SSIS,SSRS,SSMS,T-SQL, Log-Shipping
• Microsoft Office, Microsoft Visual Studio, Microsoft Visual SourceSafe, Microsoft
• Microsoft Windows Server 2008, 2003, 2000, Windows 8.1 Pro,XP Professional

• PCAnywhere
• File Transfer Protocol FTP
• Electronic Data Interchange EDI
• Remote Access Service
• Citrix GoToAssist

• Provide Support-Live Chat Software
• TSYS Credit Card Authorization
• IBM Sterling Commerce EDI

• InterSpire email marketing and
• autoresponder software
• Epicor CRM and Back Office

• Seagate Crystal Reports

• McKesson Pharmaserv for Windows and Host for Windows, pharmacy application software

• Quintus CustomerQ CRM software
• JIRA issue tracking software

Experience

Confidential

SQL Server Database Administrator DBA

• My primary responsibility while at American Laser Skincare was maintaining the POS system for all of the backend SQL data changes. I worked directly with the Marketing team, Finance department and POS developers on a daily basis creating the required discounts, inventory updates/additions and all of the customized promotions via T-SQL. This included testing, debugging and deploying the changes to Production.
• Other responsibilities included, daily database maintenance tasks, new SQL job creation, monitoring previously created SQL jobs, custom reporting, stored procedure updates, custom queries for various departments and log-shipping administration.

Confidential

SQL Server Database Administrator DBA

• Planning, implementing and supporting database maintenance strategies. Monitoring data system performance, developing and implementing improvements. Devised new processes and procedures. Testing, debugging and documenting database and data management systems. Performed data maintenance, including data source gathering, data integrity, data synchronizing, data extraction and transactional loading. Provided daily internal support for the member service representatives and other non-IT departments within the company.
• Maintained large company production and non-production databases with data for 5,700 investment clubs and 45,600 total investors/members.
• Assisted with the development and maintenance of the synchronization process between the CRM SQL data and the InterSpire email marketing application consisting of over 900,000 contacts.
• Using SSIS and ETL, developed a DTSX package using T-SQL and several custom stored procedures for updating member credit card information monthly to ensure successful processing of over 800 recurring orders prior to the execution of the recur job.

Confidential

Database Engineer 2 SQL DBA /Chain Database Analyst

• Daily internal and external database support and administration. Windows 2003 System builds, server swaps, server backups and support. Microsoft SQL Server database builds, replication/synchronization install and support, SQL Server user and system stored procedure maintenance and analysis, database backups, SQL script creation, execution, troubleshooting and debugging, disaster recovery planning and administration. Database restores, database purges, systems analysis, application support, network support, FTP support, EDI support, quality assurance support, managed documentation for DBA department, multi-tier database and application support for the various support departments throughout the company. Acted as the liaison between the development department, Quality Assurance and the various support departments.
• Installed and supported 60 Chain Host servers with 500 synchronized replicating stores.
• Managed and created documents for the DBA library consisting of over 200 technical documents.
• Built and supported 100 SQL Server replicating test servers for the Quality Assurance department.

Confidential

Chain Facilitator

• On-site hardware and software support for 60 Chain Headquarters and their pharmacies. Store visits, Headquarter visits, new pharmacy 'live' support. Chain Host training. Pharmacy software application support. On-site conversion coordinator and install coordinator. New pharmacy initial drug inventory setup. Business consulting and new store training assistance. Created custom Crystal Reports as needed upon request. Monthly status calls with Pharmacy personnel and their corresponding headquarters. Assisted various support departments at McKesson Pharmacy Systems with phone support of all products.
• Converted 200 XENIX Pharmacy servers to Windows servers on-site at various client locations throughout the United States. The on-site conversions provided zero down-time for the newly converted sites.
• Trained client's IT staff to perform their own on-site conversions. This provided clients the flexibility to convert their stores based upon the store's schedule and not McKesson Pharmacy Systems schedule.
• Provided on-site training for 100 stores following the successful conversion of the hardware and software to the new platforms. This provided McKesson Pharmacy Systems with a savings in the tens of thousands of dollars in not having to provide individual trainers for each location.