SUMMARY:

• Solutions - oriented Database Administrator with specialized knowledge SQL Server, matched with a proven track record of success in the analysis, installation, configuration, administration, and support of robust database-supported business applications.
• Highly effective liaison between technical teams, business representatives, and client management.
• Expertise in the administration and support of numerous technologies and platforms, with specialized knowledge of SQL Server and supporting knowledge of Dot Net.
• Strong project management abilities, with proven aptitude for managing total lifecycle.
• Expertise in the development of core application initiatives, from planning and requirements gathering to implementation and support.
• Database Administrator on SQL Server managing complex databases ranging from 1.5 Terabytes down to 1 Gigabytes, with a user group size from 50,000 down to 500.
• Performance tuning is a production system from end to end is my specialty, this includes web servers performance, hard drive space and databases.
• I work to reduce ticket counts. This reduces costs of operation. By fixing the root causes of errors that produce tickets so the same ticket does not get opened over and over. This reduces time spent on tickets and increases the time for upgrade projects. This benefits the company’s bottom line.
• Advanced database support and maintenance including data backups, development and implementation of maintenance plans, job plans, index tuning (clustered or nonclustered), multiple hard drives for logs.
• Merged replication, log shipping replication
• One of the Paccar factories the database was growing out of control because the vendor archiving process could not keep up. I wrote a replacement SQL stored procedure DBA archiving that can run with part of the factory is up. This resulted in the row counts finally going down and an avoidance of another outage due to the database growth.
• Design and built production data warehouse outbound calling campaign system.
• Decreased IT support travel costs by an average of $8,000 dollars a month by building a remote monitoring system using ASP (active server pages) web pages.
• Created ASP web page to give "at a glance" status of 30 databases and all night processes. This saved 3 man hours per day.

EMPLOYMENT HISTORY:

Senior SQL Server Database Administration

Confidential

Responsibilities:

• Lots of performance tuning and I am proud to say that outages due to database performance have been eliminated at two factories.
• Wrote archiving stored procedure that can run while the factory is running, in comparison the vendor archiving could only run when the factory was completely shut down.
• Collect performance data using standard tools such as PerfMon. Participate in team meetings to plan for future scalable growth.
• Databases versions range from SQL Server 2005 to 2014. I was given a second factory to performance tune and I have eliminated outages due databases there as well. I use a gentle adjustment approach for continuous improvement.
• Web server management as well as server management. Build virtual machines in VMware.
• Data conversion projects including MS Access conversion, Oracle and data import
• Ticket count reduction is something that I do by performance tuning database or changing code
• SharePoint administration: Converted SharePoint 2010 to SharePoint 2013. Keeping a SharePoint server running require gentle adjustments constantly. I create new sites, answer any question from any one of 400 sites and when I did not know the answer, I could put them in touch with someone that did know the answer.

SQL Server Database Administration

Confidential

Responsibilities:

• Collect performance data using standard tools such as PerfMon, SQLDiag and SQL Profiler. Backup and restore databases, performance tuning, code promotion, grant user access.
• Participate in team meetings to plan for future scalable growth. Most databases are SQL Server 2012.
• Database conversion projects including SQL Server and MS Access conversion these were company acquisitions
• Cost reduction by fixing repetitive job failures
• MySQL database administration version 4.5 to 5.5.

SQL Server Database Administration

Confidential

Responsibilities:

• 204 production servers in 2005, 2008 R2, 2012.
• I am known for clearing the ticket queue and being able to troubleshoot unusual tickets.
• Build new servers according to standard template. Install SQL Server 2012 in cluster.
• Collect performance data using standard tools such as PerfMon, SQLDiag and SQL Profiler. Backup and restore databases, performance tuning, code promotion, grant user access. Participate in team meetings to plan for future scalable growth.

SQL Server Database Administration

Confidential

Responsibilities:

• Install and configure SQL Server 2012 new features such as High Availability / AlwaysOn, Contained databases, or ColumnStore indexes.
• Build Windows 2012 cluster in PowerShell in minutes.
• Grant users in database security roles. Create domain groups and put users into domain groups in Active Directory.
• Database conversion projects from MS Access, excel and SQL Server

SQL Server Database Administration

Confidential

Responsibilities:

• Performance tuning ACT custom application for Confidential using facts from performance counters.
• Install new SQL Server instances on new VMware servers as needed. Some were 2012, clustered, Reporting Services farms or distributed reporting services, and some were standard installs.
• Advise management on best practices for database performance.
• Performance tune SQL instances, for example 1 temp database file per CPU.
• Performance tune SQL queries and stored procedures while mentoring developers. For example make a query that took 21 minutes run instantly.
• Grant users in, create domain groups and put users into domain groups.

SQL Server Database Administration

Confidential

Responsibilities:

• Architect a plan to upgrade from 2005 to 2008 and carried it out.
• Database conversion projects from MS Access and SQL Server
• Architect security for the first time and mentored the existing staff on role based security (group based security).
• Collect performance data using standard tools such as PerfMon, SQLDiag and SQL Profiler for performance tuning. Backup and restore databases, code promotion, grant user access.

SQL Server Database Administration

Confidential

Responsibilities:

• 120 production servers with well over 20 TB total, with a single database having 5 TB.
• Build new servers according to standard template.
• Manage memory and performance for SQL Server, SSRS, SSIS, SSAS.
• Collect performance data using standard tools such as PerfMon, SQLDiag and SQL Profiler. Backup and restore databases, performance tuning, code promotion, grant user access. Participate in team meetings to plan for future scalable growth.

SQL Server Database Administration

Confidential

Responsibilities:

• Database conversion projects from MS Access and Oracle
• Document what SQL Servers there are, design and create support plan, design and create security model, design standards and publish documents. Create email alerts, create a backup plan, a security plan. Created the first development database and change control. Implement a new 2008 feature Resource Governor.

Database Architect & Administration

Confidential

Responsibilities:

• Architect and migrate the pharmaceutical database into the data warehouse. The old database also needed some performance tuning to extend its life long enough to get the migration done.
• Technical lead and architect for team of three. Interface with the business users to gather requirements, implement, and user acceptance testing, to final sign off.
• The new database is in 2008 and uses SSIS packages and stored procedures.
• Database conversion projects from MS Access, excel and SQL Server

SQL Database Administrator

Confidential

Responsibilities:

• Project lead and Architect of outbound calling campaign system to place calls on behalf of customers. The system uses SSIS packages, stored procedures and Genesys software to run the IVRs.
• Collect performance data using standard tools such as PerfMon, SQLDiag and SQL Profiler. Backup and restore databases, performance tuning, code promotion, grant user access. Participate in team meetings to plan for future scalable growth.
• Replication using SQL Server: Bidirectional replication between two cities to take payments and normal replication between the reporting servers and transactional server locally.

SQL Server Database Administrator SQL

Confidential, TX

Responsibilities:

• Backup and restore databases, performance tuning, code promotion, replication using Golden Gate 7.2. Plan, test and upgrade Golden Gate to v9.5.
• Grant user access.
• Participate in team meetings to plan for future scalable growth.
• Monitor performance of production database using standard tools such as PerfMon, SQLDiag and SQL Profiler.
• Database conversion projects from MS Access, Oracle and SQL Server

SQL Server Performance Tuning Consultant

Confidential, TX

Responsibilities:

• Performance tuning DBA for 1TB databases.
• Collect performance data using standard tools such as PerfMon, SQLDiag and SQL Profiler. Analyze recorded data and write detailed reports on how to improve performance. The reports are targeted for upper management, but include nuggets of information for the DBA on best practices and future tuning strategy.
• Assist giving Microsoft feedback on the 2008 CTP builds, conducted Proof Of Concept (POC) reports to customers wanting hard numbers for what table compression can do for them.

SQL Server Database Admin / ETL Developer

Confidential, Irving, TX

Responsibilities:

• Using SQL Server Profiler to create traces upon request.
• Use Idera’s Diagnostic manager to find the poorest performing T-SQL code. Grant user access permissions in production.
• Promote code from Dev to Test to Production using Red Gate SQL Compare v5.3.0.44 and SQL Data Compare v.5.3.0.68 when data needed to be promoted also. Participate in Litespeed upgrade from v3.1 to v3.8.1. Manage Litespeed licenses and responsible for Litespeed backup verification. Developed Report Services custom reports developer for Litespeed reports.
• Database conversion projects from MS Access, excel and SQL Server
• Extract Transform Load (ETL) using DTS and SSIS (SQL Server 2005) . There were some 3000 DTS packages that we were converting to SSIS when time allowed. We use UC4 as a scheduler to run the ETL processes.