Database Senior Consultant Resume
Margate, FloridA
TECHNICAL SKILLS:
Windows Development: 20 Years - Sybase Powerbuilder 5/7/11.5 - Visual Studio 6 - Visual Studio .NET
Webservices: 6 Years - Sybase Powerbuilder .NET 11.5 / 12.5
SQL DATABASE: 20 Years - DBA MS SQL Server 7/2000/2005/2008/ 2012/2014/2016 - SSMS - SSAS – SSRS – SSIS - Allways on - Failure Clustering Instances - Availability Groups - Redgate Toolbelt
Sybase DATABASE: 20 Years – Sybase Adaptive Server Enterprise - Adaptive Server Anywhere - Replication Server
POS Retail: 20 Years - OPOS / Barcode / Loyalty / RFID / Biometric ID / Scales / Supply Chain Management / Inventory Control
Mobile Development: 10 Years – Titanium Apcelerator – Javascript – PocketBuilder
Legacy Development: 30 Years - Clipper / FoxBase / Dbase / IBM 4680 Basic / Apple 4th Dimension
Documentation: 20 Years – RedGate Sql Doc / Erwin ERX / PowerDesigner / MS Visio / RoboHelp / Camtasia
Payment Processing: EMV Out Scope integration / ISO 8583 transaction processing
WORK EXPERIENCE:Confidential, Margate, Florida
Database Senior Consultant
Responsibilities:
- Administrate and support more than 500 installations of SQL Server 2008R2 to 2016 version with multiple configurations including replication, cluster mirroring and Always ON setups.
- I'm in charge of a team of eight professionals and we handle the planning, administration, backup policy, performance tuning and disaster recovery
- Developed a SAAS platform for business intelligence dashboard and reporting based on SQL Server 2016, SSRS, SSAS, SSIS, excel pivot tables and power bi with hundreds of customers.
Confidential, Delray, Florida
ETL Consultant
Responsibilities:
- Short term contract position.
- Build ETL process for importing Medical Practices Financial and Appointment information to the Prospira Data Warehouse based in SQL Server 2012 SSAS / SSIS
Confidential
Data Architect
Responsibilities:
- Designed the architecture of SQL Server database for the CheckOUT POS software solution including a proprietary multiplatform two - way replication architecture that includes support for Sybase ASA / ASE / Oracle
- Designed and implemented a data warehouse solution based in SQL Server / SSIS / SSAS 2008 and Excel Pivot Table embedded in a proprietary app using OLE automation
- Supported and administered SQL Server and Sybase ASA installations of more than 11000 customers with db sizes from 2 to 500 Gb
- Implemented interfaces with more than 20 ERP solutions including SAP R/3 with BAPI
Confidential
Chief Information Officer
Responsibilities:
- Managed a team of developers for the design, creation, testing and release of two new main versions of software
- Supervised the daily operation of the IT infrastructure and software systems in a mission critical environment with 7x24 availability demand
- Managed budget, evaluated and contracted personnel and lead more than 15 projects coordinating with vendors and external contractors
- Designed and implemented the database structure, triggers and stored procedures of the client / server POS and Product Management platform based in Sybase SQL Server
