Sql Server Manager

Work Experience

Database Manager/DevOPS

July ***3 – Present Broadridge San Diego, California

●Currently managing database systems across geographical locations.

●Implementation and migration of Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) systems.

●Accountable for the strategic direction, implementation, support, and development of key data centric applications, including Data Warehouse and large implementation of Web Analytics systems.

●Vast (over 14 years) experience in implementing various “data centric” solutions spanning across multiple disciplines

●Successfully led a highly customized ERP replacement project for financial advisor support business units

●Implemented Business Intelligence (BI) solutions (e.g., Reporting Portal (SSRS 2016), Crystal Reports, Tableau, Analytics application and PowerBI)

●Implemented hardware and software (virtual and physical) upgrades to multiple mission critical applications

●Established change management and security policies complying with PCI-DSS requirements

●Design and architectural solutions highly resilient database scale out across multiple geographical locations

●Project managed (owner) of large scale rollout of Web Analytics systems

●Over 15 years hands-on experience creating and managing a variety of complex database driven applications

●Implemented and maintained data-scale out transactional replication solutions

●Supported subscription billing solutions (e.g., provide creative solutions in automation of recurring billing modules)

●Managed Multi DBMS which span across multiple geographical data centers

●Created highly resilient Messaging Queue (service Broker) Database application

●Authored Web Services (SOAP and REST) to support business needs.

Lead the architectural design/development functions using Microsoft SQL Server (i.e., schema changes, stored procedures, etc). Worked with cross-functional departments to implement new BI initiatives. Proactively seek to improve upon systems and processes. Design and develop reporting solutions using Microsoft SQL Server Reporting Services 2016 (SSRS) Reporting Portal. Create, maintain and monitor Extract, Translate, and Load ("ETL") processes for Data marts using SSIS. Proactively monitor usage and performance statistics. Create, maintain and monitor transactional replication servers. High availability solutions using clustering, replication and log shipping.

Database Administrator/Developer

February 2002 – July 2003 Glacier Water Services Vista, California

Developed complex windows based applications using VB 6.0, SQL Server 7 and custom VB controls. Applications included serial-Port communications and remote networking. Responsible for SQL administrative tasks i.e. DTS and SQL JOB Replication, Batch processing, Security, Database Maintenance, Reports. Created complex TSQL triggers and stored procedures to apply business rules to database processes.

Technologies

●Certifications: Microsoft Certified Database Administrator (MCDBA-SQL Server)

●Database: MS SQL Server 7-2016, SQL Server Analysis Services (OLAP), MS Access, MYSQL

●NOSQL: MONGO, DocumentDB

●Programming Languages: C#, ASP.NET, VBScript, Transact-SQL, ASP, WML/WAP, XML, HTML, Power Script

●Applications: MS Visual Studio. NET, PowerBI, Crystal Reports (Enterprise Edition 10.0), Great Plains 2016, MS Visio, MS Project, IIS, MS Reporting Services

●Cloud Experience: Azure, AWS

●Operating Systems: Windows Server 2016, 2012

Education

BS, Emphasis in Management of Information Systems May 2001 San Diego State University

Languages

Bilingual English/Spanish

Contact this candidate