Summary of Experience:

Working in the micro - computer industry for over 30 years with experience as a software engineer, network administrator, application project manager, and database administrator, managing projects through all aspects of development including:

• Concept Formation
• Physical Planning hardware Individual Servers to Data centers
• Feasibility Studies Time and materials with scrum
• Contract Negotiation Resources
• Research Hardware/ Software and process flows
• Installation an Setup of:
• With Security considerations

Audits/Intranet/Extranet/Web apps

• Database Mail / Alerts with best practices
• Analysis Services
• Integration Services
• Replication - Snapshot/Transactional/Merge/ Log Shipping
• Reporting Services
• Notification Services
• Service Brokers
• Full-Text Searching
• Designing Logical models
• Designing Physical models
• Ervin / Embarcadero DB-Artisan
• SSMS, SSIS, SSAS, and SSRS
• Visual Studio 32 and 64bit
• JAVA, PHP, ASP, C, Power shell, learning Android
• I/O subsystem configuration and planning
• Server Services
• XML and web services experience

Microsoft SQLXML, Native XML Web Services

• Sizing from ecommerce sites with 2 products being sold up to call centers with Terabytes of data being inserted/updated daily
• Creation of Databases from scripts
• Creation of tables
• Network configuration and installation
• Installation of cluster Services
• Using the built in Server functions
• Performance Tuning
• Maintenance and Troubleshooting
• OLAP cubes and services
• Installation Management
• Designing Cubes
• Application Implementation
• Staffing/Training
• Technical and End-user documentation, training, and support.

Projects have varied in duration, scope, and complexity from concept through enhancements, and maintenance of mature product lines. Projects in some cases have overlapped in part due to being able to remotely administer the servers.

Classes/Seminars:

Relational Database design and Implementation in MS SQL 2012, Professional SQL Server 2012 Internals And Troubleshooting, Professional MS SQL Server 2012 Analysis Services with MDX and DAX, SQL Server 2000 Deployment and Administration, MCSE Microsoft SQL Server System Administration, MCSE Microsoft SQL Server 2000 Database Design and Implementation, MCSE Windows 2000 Network Infrastructure, FLASH MX Action scripting, FLASH MX Freehand, XML Solutions, XML Programming Oracle WEB application server, E-commerce solutions, ASP scripting, Using Databases in Web Applications, Summit D methodologies, Intro to Oracle, Primitive Object Design, Queries and DDL, Table Joins, PL/SQL/complete, Oracle Database Utilities, D.B.A. Theory I/II/III, Oracle User Administration, Oracle Networking, Oracle Database Security, TCP/IP, Cisco routers, S.A.A. Gateways, Windows NT and N.T.A.S., Microsoft SQL Administration, Data Communications, TCP/IP Advanced Architectures, LAN Architectures, Novel NetWare Concepts, DOS/Microcomputer System administration, Token Ring/Ethernet Architecture, Novel v3.1x Advanced System Manager, Novell NetWare Networking Technologies, Novell Service Support, Novell NetWare v3.1 O/S. Feature Review. Novell v3.1 A.P.I. protocols

PROFFESIONAL EXPERIENCE:

Confidential

Sr. Database Administrator

Hardware: Varies depending on client

Software:

• MS SQL Server 2008 R2
• MS SQL Server 2012
• MS SQL Server 2012 R2
• MS SQL Server 2014
• Log-shipping
• Replication setup and maintenance
• MS SQL Windows Failover Clustering both Active/Active and Active/Passive

Confidential

Sr. Database Administrator Production

Hardware:

• DELL Compellent SAN/ SERVERS
• 458 TB on primary SAN with 250 TB on secondary
• 28 production servers in 14 clusters log-shipping to datacenter
• 143 secondary servers including pre-prod, QA, DEV, Internal clusters w/ offsite datacenters

Software:

• MS SQL Server 2008 R2
• IDERA backups with monitoring
• Redgate Professional DBA tools
• IDERA suite
• Log-shipping
• MS SQL Windows Failover Clustering

Confidential

Database Manager

Environment: SQL Server, 2012, 12 Active/passive Clusters mirrored to DR, MS SQL 2012 AlwaysOnGroups, Windows 2003 Server, VB script, Dell R810/R510, Dell Compellent SAN storage, Crystal report, MS Office, ETL, Service Oriented Architecture, T-SQL, OLAP, .NET, DDL, DML, OSSQL, TCP/IP, Named Pipes, DTS, SSIS, SSMS,SSAS, SSRS, Team Foundation Server, Powershell 2.0 3.0, windows 2003, 2008, HTML, CSS, IIS, XML, DNS, ODBC, ERWIN, Quest Spotlight, Redgate DBA ToolBelt.

Responsabilities included:

• While working closely with the business units on multiple projects with teams of engineers to improve the commercial web sites. Reported directly to the CIO/Project Managers/Directors as well as assisted in the maintenance of all 2 environments, quality assurance and production.
• Managed the work of SQL Server Team to include establishing objectives and work plans, priorities, tasks, and reporting on accomplishments. Provided technical leadership to the DBA Development team by assisting junior team members and sharing knowledge and research of tools/techniques
• Work closely with Architecture, Integrations, data warehouse and BI teams in meeting responsibilities with regard to project management, operations, and implementation of future technical requirements
• Installation and maintenance of all SQL servers.
• Review of MS SQL 2012 Migration of SQL 2005 and 2008 R2 to 2012
• Replication log shipping complete, Transactional with replication monitor.
• Mirroring of all OLTP databases to offsite DR site
• Clustering 12 complete clusters
• Always On Groups of databases Set up of Finance applications with multi-subnet for DR
• Master Data Services using MD Manager, MDS Model Deploy with web services with add-ins for EXCEL
• Use of Multiple Active Result Sets MARS .
• Dimension / Cube Design
• MS Great Plains from ver 9 to ver 2013, upgrade of four separate companies.
• Worked with Team members to solve current issues as well as planning for software rollouts.
• Responsible for all imports of data from multi-dimensional, sources sizes from 2k to 800gig per session
• Reporting of all production issues to be presented to management
• Reporting new technologies to both data team and development team
• Working in a multi project environment was able to maintain stability within all levels
• Development of best practice for CLR assemblies and SSIS packages in 2005 and 2008 integrating 2010
• Brought in VS 2012 to upgrade to 64bit support for data transfers
• Implemented a design search to bring the data up to and maintain the current PCI standards for confidential information
• Complete ownership of the SQL Servers, on 24/7
• Provide continuous feedback on project status and offer constructive options to ensure project continues to meet original expectations
• Identified resources and/or schedule conflicts and changing of project scope
• Identified and presented resolutions of business/project issues, as well as the monitoring, tracking and reporting on project deliverables to ensure adherence to project plan
• Monitored database performance and space utilization investigate and resolve reported issues as well as recommend upgrades/updates
• Assisted project teams in setting up and testing development, test, and production environments
• Research, analyze, and recommend patches, tools, and/or database upgrades to resolve issues and add features/functionality
• Assist project teams in data modeling and architecting/designing data accesses methods
• Expense budget planning and adherence

Confidential

Projects included:

• Database Administrator While working closely with the business units on multiple projects with teams of engineers to improve the commercial web sites. Reported directly to the CIO/Project Managers/Directors as well as assisted in the maintenance of all 3 environments, development, quality assurance and production.
• Review of MS SQL 2008 Migration of SQL 2k and R2
• Replication log shipping complete, Transactional and snapshot and replication monitor.
• Worked with Team members to solve current issues as well as planning for software rollouts.
• Responsible for all imports of data from multi-dimensional, sources sizes from 2k to 800gig per session
• Reporting of all production issues to be presented to management
• Reporting new technologies to both data team and development team
• Working in a multi project environment was able to maintain stability within all levels
• Development of best practice for CLR assemblies and SSIS packages in 2005 and 2008 integrating 2010
• Brought in VS 2012 to upgrade to 64bit support for data transfers
• Implemented a design search to bring the data up to and maintain the current PCI standards for confidential information
• On-call rotation including one week per shift as well as at least one late day per week
• Investigated and researched problem areas and identified areas of interest to increase performance

Confidential

Projects included:

• Database Administrator While working closely with the business units on multiple projects with teams of engineers to improve the commercial web sites. Reported directly to the CIO as well as assisted in the maintenance of all 3 environments, development, quality assurance and production.
• Installation and review of MS SQL 2008 Migration of SQL 2k and
• Replication merge of multiple masters as well as log shipping complete, primary and secondary and a monitor.
• Responsible for set up and maintenance of all three in-house environments, as well as supervisory roles in set up and maintenance of client sites and data centers in national and international environments, including USA, Panama, UK.
• Complete support of clients Tier 1 through tier 3
• Worked extensively with teams of application developers to resolve issues and debug both front-end code as well as SQL server to create a stronger faster application.
• Implemented the change management process, including best practices, upgrades and application of patches.
• Monitored database servers and assigned workloads.
• Worked with multiple projects giving priority and implementing solutions for each.
• Implemented MMC to use as monitor and access point for the servers.
• Used Erwin to create logical models that translated into physical models with scripts to build and document the production environment.
• Used Microsoft's tools to perfmon, profiler to gather both baseline information as well as defining bottlenecks within the systems.
• Planning and executing of all scheduled database activities then following up on jobs to make sure they ran properly
• Implemented and maintained database security with groups, roles, users
• Met with clients and upper management to maintain communication throughout the development lifecycle
• Developed and implemented disaster recovery policies and procedures for both onsite and offsite situations
• Used a variety of hardware including
• ProLiant tower servers
• ProLiant rack servers
• ProLiant blade servers
• IBM / HP Blade System for medium-sized businesses
• HP Tape, disk-based backup products - Data protection for high performance, reliable recovery
• NAS solutions - Flexible, windows-based network storage and file sharing access
• SAN solutions - Consolidate and manage shared pool of storage assets
• Testing of the new G6 servers with MSA2000i with a ProCurve Ethernet switch
• Defined best practices for current staff as well as for client sites
• Worked with SQL developers to fine tune stored procedures, ETL, and SSIS procedures.

Clients to include:

• Thread-Rite Current projects include conversion tables, ecommerce solution, current maintenance with production support.
• Culinary International Current projects include: email marketing and maintenance
• GoRadioActive.com Current projects include: Stock photography and site maintenance
• Katrina Longo Current projects include: production support
• Michael St Amand Current projects include: 2005 report services maintenance
• Prima Luce on the River Current projects include: Real estate Broker office, with project management

Confidential

Projects included:

• Training of jr level DBA's
• Documenting all necessary configurations, processes, and policies for both usage and administration
• Upgrading and updating installed systems, processes, and documentation as necessary
• Audit of production servers as well as implemented best practices in development and production
• Reengineered the backup and recovery process
• Business process review interconnecting AS400/ DB2 with SQL 2000/ 2005

Confidential

Projects included:

• Created a complete WEB front end to Microsoft Business Financials
• MS SQL 2005/ Macromedia Flex 1.5/2.0 / ASP / WEB Services ASP and xml
• Retail management back end integration to Microsoft Small Business Management. Our primary goal for the client was to provide a Point-of-sale package for the clients retail outlets, a secondary objective was to provide the client with a digital dashboard of real time information throughout the day.
• Responsibilities to include configuration, and maintenance of MS SQL Server 2000/2005 DBMS in a NT 2003 environment. Conversion of SQL Server, Development and implementation of automated backup and recovery strategies, performance tuning, creating policies, setting standards for security, and documentation of the MS SQL Server environment.
• In addition to the backend I was required to learn Macromedia Flex 1.5 3.1.
• Creation of Web services for credit card verification.
• Creation of receipt printing templates
• Drivers for barcode scanners and Epson printers.

Confidential

Projects included:

• Statistics production fine tuning
• Production Support On call level 3
• Development DTS backup and recovery

Responsible for the installation, configuration, and maintenance of MS SQL Server 2000 DBMS in a NT / HP-SAN environment. Supervision of automated backup and recovery in both production and development. Implemented modifications to the design of the data warehouse. Provided 24x7 coverage in a clustered, multi-server production environment Implemented DTS packages to transfer information to an Oracle based application.

Confidential

• MS SQL Server 2k multiple production and development
• Projects included: ALLINONE, Document imaging, Assist, RFS, Phonebook
• Responsible for the installation, configuration, and maintenance of MS SQL Server 2000 DBMS in a NT environment. Development and implementation of automated backup and recovery strategies, performance tuning, creating policies, setting standards for security, and documenting the MS SQL Server environment.
• Provided management with Documentation for current and legacy systems, using ERWIN 4.1.2 volumetric planning, and replication between sites.

dger, and Payroll. Other duties included training employees.