CAREER SUMMARY:

Highly skilled professional who has worked with the hardware as a technician and the software as a computer operator, technical support representative, programmer, systems analyst, Senior SQL Database Administrator and Data Architect. Successful project member, project manager, technical trainer and supervisor.

COMPUTER KNOWLEDGE:

Languages: T - SQL, SSIS, SSAS, SSRS, XML, HTML

Environment: s: Windows 10, 8, 7, 2003/NT/XP/ 2000/98/95/3. X, DOS

Software: SQL Server 6.5 - 2017, Apex suite for SQL, Spectral Core Full Convert, Polar zip, Visual SourceSafe, TFS, Jira, Confluence, Idera SQL Safe, Idera SQL diagnostic manager

PROFESSIONAL EXPERIENCE:

Sr. SQL DBA/ Data Architect/Database Developer

Confidential, West Palm Beach, FL / Boca Raton, FL

Responsibilities:

• Production database support for all things SQL. (Azure Servers, Always On, Backups, Reindexing and other maintenance jobs. Etc.)
• Data Warehouse Architect/Developer
• T-SQL Development and Tuning
• Created and enforced all SQL naming and development standards
• Installed and maintained Apex SQL Software Suite
• Manage all database auditing utilizing DML and DDL Triggers
• Monitor and maintain Idera Diagnostic Manager

Sr. Database Developer/SSAS Developer/Data Architect/DBA

Confidential, Palm Beach Gardens, FL

Responsibilities:

• Production database support for all things SQL. (30+servers, VLDB, SOX Compliance, Replication, Backup. Reindexing and other maintenance jobs. Etc.)
• BI (SSIS) Developer
• Created and enforced SQL Development Standards
• Multi-dimensional and Tabular Cube Designer (SSAS)
• T-SQL Developer and Tuner
• Primary Data Architect and Warehouse Architect for all existing and new projects
• Agile / Scrum team member

Consultant BI Developer/ Database Developer/DBA

Confidential, Columbus, OH

Responsibilities:

• BI Developer for a large warehouse system
• SQL developer
• Developed large scale regression testing process for BI changes
• Production database support

Consultant Data Architect/ Database Developer/DBA

Confidential, Columbus, OH

Responsibilities:

• Data Architect on all new and existing projects.
• Web Development Team DBA for several SQL 2008R2 Servers.
• DBA in charge of maintenance procedures, monitoring, security and coding standards.
• Database and Object tuning.
• Designed and implemented a data warehousing strategy.
• Built several SQL Servers including tiered and mirrored environments.
• Designed SSRS reports and SSIS jobs for ETL.
• In charge of SQL Source Control using Visual Source Safe and Team Foundation Server.
• In charge of SQL object deployment to and from all tiers. (DEV/QA/PROD)

Assoc. Vice President / Database Management Analyst

Confidential

Responsibilities:

• Sr. Level SQL Database Administrator in a large team supporting hundreds of SQL servers from SQL 2000 through SQL 2008 R2.
• DBA in charge of maintenance procedures and standards. (Within 2 months of hire)
• “Go to DBA” and final authority for all tuning and TSQL issues.
• Built several SQL servers in non-clustered, clustered, mirrored and log shipping environments.

SQL DBA/Architect

Confidential

Responsibilities:

• Primary Database Administrator for numerous servers and virtual servers with hundreds of databases.
• Migrated older versions of SQL from 6.5 through 2005 to SQL 2005 and SQL 2008 R2.
• Designed and implemented a Data Warehouse system, SSIS packages and T-SQL for loading a data warehouse, star schemas for loading SSAS Cubes and SSRS reports for displaying data from cubes.
• Data Architect for all research projects.
• Final authority on SQL development standards and practices.
• Tuned inefficient T-SQL
• Replaced outdated DTS packages with their SSIS equivalent.
• Designed and maintained SQL backups, source control and server maintenance utilities replacing insufficient Database Maintenance plans.

Senior SQL Database Administrator

Confidential

Responsibilities:

• Primary Sr. Database Administrator for over 30 MS SQL servers from MS SQL Server 6.5 through MS SQL Server 2005.
• Migrated older versions of SQL to SQL 2005.
• Converted systems using DTS and old T-SQL to SSIS packages and new T-SQL which utilized newly available functionality.
• Designed normalized table structures, numerous nested stored procedures, DTS packages, SSIS packages, functions and triggers to support numerous IT retail and rebates systems.
• Implemented and maintained numerous SQL Replicators, both snapshot and transactional, to synch data between branches in California and Columbus Ohio.
• Designed and maintained SQL backups, source control and server maintenance utilities.
• Performance tuned older SQL using various combinations of rewriting T-SQL, indexing, temp tables and process migration to newer servers.

DBA & Programmer

Confidential

Responsibilities:

• Database architect for Confidential ’s half of a SQL 2000/VB6/ASP/XML driven system.
• Designed numerous SQL 2000/VB6 projects for support of web sites, error control and alert projects, data upload and software controlled claims faxing.
• Responsible for Navision Financial software support and development utilizing a SQL Server 2000 background.
• Designed table structures, numerous nested stored procedures and triggers to support an inventory and credit card processing system.
• Designed and maintained SQL Server 2000 backups, maintenance and source control procedures.

Consultant DBA & Programmer

Confidential

Responsibilities:

• Maintained and upgraded SQL Server/ Visual Basic 6.0 systems for Arvin Meritor.
• Designed a new SQL Server 2000 database system for a new VB system.
• Designed new VB6 programs for future needs and maintenance screens.
• Created a program to output data to Excel and email those documents.
• Redesigned a “Bartender” integrated system to track and display live inventory.
• Maintained the SQL side of a Visual Basic 6.0/SQL system for Lane Bryant.
• Designed VB programs for future needs and maintenance screens.
• Primary responsibility was SQL Server database administration.
• Designed a project for CheckFree Corporation to convert data and reporting tools from MS Access and MS Excel to SQL server databases with a Visual Basic 6 front end. Created several stored procedures, tables and views in SQL Server 2000.

Systems Analyst/DBA

Confidential

Responsibilities:

• Lead programmer for the Electronic Reports system. The Electronic Reports System is a very extensive Visual Basic 6.0 controlled system that generates Microsoft Excel workbooks of sales information incorporating data derived from AS400, mainframe and SAP systems. The system spans thirteen servers and distributes over twenty-five thousand reports per month. Reports are distributed to thousands of sellers per day using Lotus Notes databases and emails. Data is derived using SQL Server 7.0. Data was populated in Microsoft Excel workbooks using extensive VBA and Excel Macros.
• Automated the SQL stored procedures using the Control-M scheduling package.
• Maintained the source code in Visual Source Safe.
• Installed, maintained and controlled a mock system for testing and quality assurance.
• Troubleshoot and install SAP GUI