We provide IT Staff Augmentation Services!

Database Senior Consultant Resume

5.00/5 (Submit Your Rating)

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

We'd love your feedback!