• In response to your recent email concerning your needs for a Sr. level SQL DBA, I am enclosing a summary of my resume for your consideration. I'm confident that I possess the required communication, organizational, and interpersonal skills you are seeking for this position.
• I believe that my record of responsibilities, integrity, proven abilities, and diversified work history will provide a good match to the requirements of this position. If you agree, I would certainly appreciate the opportunity to discuss how I can contribute to the future success of your company. I look forward to your response, and the opportunity to visit with a member of your organization in the near future.

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 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.

PROFFESIONAL EXPERIENCE:

Confidential

Sr. Database Administrator Production

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 2005 2008,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 2005 to 2008 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 2005 to 2008
• 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 2000 to 2005 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.

Confidential

Projects included:

• Accounting Accounts Payable, Accounts Receivables General Ledger
• Production Telecommunications, Retail management, Call Center
• Development - Telecommunications, Retail management, Call Center

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 capacity planning for current applications, with projected future growth into the terabyte range for Client's database environments. Implemented modifications to the design of the data warehouse. Managed the migration of existing applications and the development of new applications into a web-enabled environment. Was involved in development and execution of project plans, presentations, needs analysis, and delivering customer driven results. Provided 24x7 coverage in a clustered, multi-server production environment and coordinated onsite contractors and staff to resolve problems in legacy systems as well as new development. I provided all error handling procedures. Implemented DTS packages to transfer information to an Oracle based application. While using FTP replication to acquire information from multi-location retail outlets running php with a mySQL for inventory reporting and sales forecasting.

Confidential

Database Administration

B2B project provided shipping information to multi-national corporations for shipping overseas clients included Home Depot, Fed Ex, UPS. Managed all 7 production environments with WWW server farm, DEV. server farm and versioning. Trained in-house development staff in providing best practices for multi-project development teams. Mentoring of individual application/SQL developers. Provided DTS scripting and replication of data/structures using merge and transactional replications schemas in the multi-server environment. Responsible for upgrade and implementation of SQL 2000 clustered servers in both an active/passive development and active/active Production/WEB design. Redesigned and Implemented new maintenance procedures for the current production eCommerce database. Responsible for design and implementation of all stored procedures. Database administration Installation, configuration, application installation and configuration, security both SQL server and Network, system auditing, backup, recovery, user management, check for health, performance tuning, sizing and capacity planning, system uptime, planning and scheduling of system fail over, disaster recovery, etc. . Extraction of eCommerce data from order fulfillment process to decision support reporting. ERWIN Logical and physical design, WEB server IIS 4.5 with both source code management and configuration management experience using Microsoft Visual SourceSafe.