Database Administrator Resume Profile, CO - Hire IT People

LinkedIn profile

DATABASE ADMINISTRATOR

Database administrator with experience configuring, designing, administering, tuning, supporting, troubleshooting, and monitoring SQL Server environments from SQL Server 2000 on. Specialize in ETLs using SSIS. I currently administer 35 instances of SQL Server in 2008r2/2012/2014, and create/maintain 100 ETLs each year.
I have ten years of background as a developer using Coldfusion, .NET, and Director. I also maintained a network of half a dozen Windows servers NT 4.0, 2000, 2003 for part of that time.
DBA skills: SQL Server Administration 2000, 2005, 2008r2, 2012, 2014 , ETL with SSIS, TSQL, Backup/recovery, Query tuning, Replication, SSRS administration, Powershell, Data warehousing
Aging skills: ColdFusion, ASP.Net, VB.Net, Director, CSS, HTML, Dreamweaver, Visual Studio, Visio, MySQL, IBM Client Access AS400 , Microsoft Server NT 4/2000/2003 , Sugar CRM, IIS 4,5,6 , Active Directory, DNS

EXPERIENCE

Database Administrator

Administer SQL Servers. 35 servers, most virtual hyper-v , four environments production, staging, test, qa , versions 2008R2 through 2014. Most servers are 2008R2, with some 2012 and 2014. Configure, backup, replication, daily maintenance, query tuning, permissions, upgrading, monitoring. 200 databases in production. Prior experience with SQL 2000 and 2005.
Create and maintain ETLs. Using SSIS, versions 2005 through 2014. 100 ETLs to load data warehouse, marts, federal reporting, and other needs, of varying complexity and run frequency, most in 2012 and 2014.
Architect and load data warehouse and datamarts. Inmon style warehouse that receives data from 20 source databases and external data sets at varying frequency. Physical design and approval of new work. 40 datamarts loaded at varying frequency. SSIS is used to move data.
Assist data analysts and research team with ad-hoc queries as needed.
Review and approve all database designs and changes by team of 21 application developers. Mentor and troubleshoot with them as needed.

Confidential

The MASTER Teacher

Developed CD-ROMs, Mac/Windows platforms, for both catalog sales and outside clients with Adobe Director.
Developed websites to enhance products, create new revenue streams, for both catalog sales and outside clients.
Maintained ecommerce website with 1,000,000 revenue stream.
Provided technical support and training for products to customers and company staff.
Webmaster for Adobe Coldfusion websites. IIS 5 and 6. Managed domain names.
Database administration for 2 instances of SQL Server 2000 and mySQL.
Created a basic data warehouse from SQL Server, iSeries, and mySQL server sources for business reporting.
Provided ad hoc query data to members of management team on demand.
Mentored other programmers to solve problems with their applications.
Maintained Windows network with 7 servers in-house and remote servers with AT T and MCI. Active directory and DNS.
Directed small IT staff for projects as needed and desktop support.
Managed projects with tight deadlines on a yearly basis.
Oversaw data entry for databases as needed.
Created Scope, Functional Requirements and Detailed Design Documents for projects as required.