We provide IT Staff Augmentation Services!

Senior Database Administrator Resume Profile

Kansas City, MO

Experience

Confidential

Senior Database Administrator

  • 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
  • Integrated SQL with all the banking vendors
  • Designed Databases with ERWIN 8.5
  • Project Manager during the acquisition of a new company
  • Experienced T-SQL Developer
  • Monitored and repaired all performance issues on all Servers with RedGate and Performance Monitor

SQL Team Lead

Confidential

  • SQL team lead Managed a team of 4 during the rewrite of the legacy app
  • The group and I created and maintained over 2000 views an stored procedures
  • lead a team of 3 while redesigning the database for the legacy rewrite of the title and appraisal program with over 1000 tables
  • 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

Database Administrator

Confidential

  • Setup Transactional Replication between Pittsburg and Prairie Village, KS
  • Added the BPO company to legacy layout

Data Designer/SQL Developer

Confidential

  • Redesigned Legacy App using Erwin
  • Recommended Structure changes to improve performance

Confidential

Director of IT DBA

  • Director of IT and SQL 2000 DBA during the creation of a multi-tier data warehousing system
  • Managed a Team of 5 VB developers
  • Created a program to collect marketing information for Swatch Watches
  • Created a program to collect marketing information for Hill's Science Diet

Confidential

Director of IT

  • Managed a team of four
  • Created and sold a registration program to TWA and American Airlines
  • Installed and administered MSExchange
  • Network administrator 40 station network

Programmer/Analyst

Confidential

  • Created a group meeting system used to run marketing meetings for Marion Merrill Dow
  • Created a program that would scan the airline flights for lowest fare fewest connections

TOOLS

Microsoft DynamicsNav, SQL 2000, SQL 2005, SQL 2008 R2, SQL 2012 SSMS 2012, ERWIN, T-SQL, SSIS, SSRS,SSAS,RedGate

Hire Now