Senior Database Administrator Resume
2.00/5 (Submit Your Rating)
Kansas City, MO
Objective
- Looking for an opportunity to work with a team and allow my SQL knowledge help solve problems.
PROFESSIONAL EXPERIENCE
Confidential, Kansas City, MO
Senior Database Administrator
Responsibilities:
- Setup Always on Clustering SQL2014 for a local online university
- Discovered and rewrote several views and store procredures.
- Recommended the setup of the DR environments for several local internet companies
- Recommended structure changes to improve performance
- Recommended the redesign of the databases to allow for archiving
Confidential, Prairie Village, KS
Senior Database Administrator
Responsibilities:
- Administers 20+ SQL servers in development and production using SQL2012, SQL2008R2
- Database DR setting up and maintaining Replicated Mirrored and Log Shipping
- Created Jobs to monitor database growth catching several runaway applications
- Created Jobs to keep track of CPU and Read, Writes allowing for the addition of Indexes or I would rewrite the query
- Integrated Microsoft Dynamics and SQL servers automating the export to the IRS
- Integrated SQL with all the banking vendors including UMB, Chase and BOA
- Used ERWIN 8.5 to redesign Nations MYSQL database to SQL
- Designed all of Nations New Databases with ERWIN 8.5
- Project Manager during the acquisition of NVS
- Experienced T - SQL Developer with over 14 years T-SQL programming
- Monitored and repaired all performance issues on all Servers with RedGate and Performance Monitor
Confidential
SQL Team Lead and Database Administrator
Responsibilities:
- SQL team lead (Managed a team of 4) during the rewrite of the legacy app
- The group and I created all the tables, foreign keys and indexes
- Setup the schema and file groups needed to assist in performance
- In order to keep the new application and the legacy app in sync, I created triggers and stored procedures to write the data in both systems
- I setup merge replication so all 5 of the production servers could communicate with the legacy app
- Redesigned Legacy App using Erwin
- Recommended Structure changes to improve performance
Confidential, Kansas City, MO
Director of IT & DBA
Responsibilities:
- Director of IT and SQL 2000 DBA during the creation of a multi-tier data warehousing system
- Managed a Team of 5 (VB developers) that created applications that collected marketing information
- Created a program to collect marketing information for Swatch Watches improving the sale of watches
- Created a program to collect marketing information for Confidential 's Science Diet improving the sale of Dog food to the veterinaries
Confidential, Kansas City, MO
Director of IT
Responsibilities:
- Managed a team of four (Basic, Foxpro developers)
- Created and sold a registration program to TWA and American Airlines
- Installed and administered MSExchange
- Network administrator 40 station network
Confidential
Programmer/Analyst
Responsibilities:
- Created a group meeting system used to run marketing meetings for Marion Merrill Dow improving the sale of pharmaceuticals
- Created a program that would scan the airline flights for lowest fare fewest connections
TOOLS: Clustering,AlwaysOn,SQL2014,Virtual Machines,SQL 2000, SQL 2005, SQL 2008 R2, SQL 2012 SSMS 2012, Microsoft Dynamics Nav, ERWIN, T-SQL, SSIS, SSRS,SSAS,RedGate,Google Hangout,Gmail