Database Administrator at State Auto Insurance
Indianapolis, Indiana Area
- Current
-
- Database Administrator at State Auto Insurance
- Past
-
- SQL Server Database Administrator at Finish Line, Inc.
- Phlebotomy Technician and Driver at Indiana Blood Center
- President at Emrich Enterprises, Inc.
- Manager/Programmer/Analyst at Internet and Computer Service
- Technician at Conexco
- Subsystem Test Engineer at Interactive Intelligence
- Software Engineer at C/Soft, Inc.
- Software Engineer at Computer Task Group
- Programmer/Analyst at Kittle's Home Furnishings
- Education
-
- Purdue University
- Danville Community High School
- Recommended
-
5 people have recommended Eric - Connections
-
127
connections
- Industry
- Insurance
- Websites
Eric Emrich’s Summary
SQL Server Database Administrator
Overseeing and managing day to day activities to ensure 99.99% availability.
Eric Emrich’s Specialties:
SQL Server management, SQL code, SQL jobs, DTS packages, ActiveX, HTML, Javascript, Visual Basic, ASP.
Eric Emrich’s Experience
-
Database Administrator
State Auto Insurance
(Public Company; STFC; Insurance industry)
December 2008 — Present (8 months)
Help to oversee approximately 450 SQL Server databases, spanning 30+ installed instances; managing day to day activities to ensure 99.99% availability for our user group.
Responsible for maintaining various databases. This includes:
- Normal maintenance (reindexing and index creation; updating statistics)
- Ensure better than 99.99% uptime for all databases across various Windows platforms
- Manage over 450 databases (well over 5,000 tables) across 30+ installed instances ranging in size from 2M to over 2 T in size
- Database tuning and performance enhancements -
SQL Server Database Administrator
Finish Line, Inc.
(Public Company; 5001-10,000 employees; FINL; Retail industry)
October 2004 — December 2008 (4 years 3 months)
Oversee approximately 45 SQL Server databases, spanning 10 installed instances; managing day to day activities to ensure 99.99% availability for our user group.
Responsible for maintaining various databases. This includes:
- Writing and modifying DTS packages
- Normal maintenance (reindexing and index creation; updating statistics)
- Importing and exporting data for third party data loads
- Data loads utilizing various skill sets (DTS packages, stored procedures, VB Script, ActiveX script)
- Ensure better than 99.99% uptime for all databases across various platforms
- OLAP cubes
- Manage over 45 databases (well over 500 tables) across 10+ installed instances ranging in size from 2M to over 900G in size
- Experience with fail-over clustering
- Ensuring PCI compliance
- Database tuning and performance enhancements
- The occasional DOS batch file for FTPing export files and file manipulation -
Phlebotomy Technician and Driver
Indiana Blood Center
(Pharmaceuticals industry)
June 2003 — January 2007 (3 years 8 months)
Phelebotomist and driver. Responsible for setting up drives and helping to ensure a smooth event.
-
President
Emrich Enterprises, Inc.
(Privately Held; Myself Only; Computer Software industry)
January 2002 — November 2004 (2 years 11 months)
General consultant and contract work.
SQL script, DTS, stored procedures, SQL Server, ASP, VBScript, HTML, Javascript, Access, VB Development. -
Manager/Programmer/Analyst
Internet and Computer Service
(Computer Software industry)
February 2002 — June 2002 (5 months)
Responsible for administrative functions:
- Duties include: overseeing staff of programmers ensuring timely delivery of applications to customers
- Responsible for meeting with clients
Duties include: determining client’s particular application needs; defining requirements documents; ensuring client satisfaction with finished application
- Responsible for application development
- Duties include: interpreting requirements documents; writing application to meet requirements; meeting client deadlines for application development -
Technician
Conexco
(Internet industry)
August 2001 — February 2002 (7 months)
Responsible for residential and commercial broadband installation.
Duties include: cable modem install; setting up, configuring and troubleshooting customer’s PC; ensuring good data connectivity from cable tap to modem; educating users on how to navigate the Comcast web-site and how to use email. -
Subsystem Test Engineer
Interactive Intelligence
(Public Company; Computer Software industry)
November 2000 — July 2001 (9 months)
Responsible for testing the installation of database related software
- Tested connectivity through MSMQ, both MSMQ 1.0 and MSMQ 2.0; tested interconnectivity between disparate MSMQ controllers; tested database connectivity using different transport methodologies
- Wrote and maintained test suites used in the testing process
- Visual Basic
- Wrote VB application to streamline the installation of SQL Server DLL and connectivity
- Responsible for setting up and maintaining databases
- Disparate databases included SQL Server 7.0, SQL Server 2000, Oracle 8.1.5 and Oracle 8.1.6; ensure connectivity via network and MSMQ transport; ensured data logging to database
- Responsible for imaging and setting up servers used in testing effort
- Ensured databases were set-up properly
- Tested in-house written software to run on the following O/S: Win 2000 Pro, Windows ME, Windows 98.
- Answered questions from field engineers regarding connectivity -
Software Engineer
C/Soft, Inc.
(Computer Software industry)
January 2000 — November 2000 (11 months)
Wrote and maintained code written in VB Script (ASP Web Pages) accessing an Intranet based database
- Responsible for writing code utilizing VB Script, HTML, JavaScript and SQL
- Wrote and maintained test suites used in the testing process
- Responsible for writing qualification packages -
Software Engineer
Computer Task Group
(Public Company; CTGX; Information Technology and Services industry)
June 1997 — January 2000 (2 years 8 months)
Contracted to Eli Lilly and Company
- Wrote and maintained code written in SQL*Reportwriter; and SQL*Forms
- Responsible for maintaining two in-house written applications used in the manufacture of clinical trial materials
- Wrote VB application, accessing an Access database, to track testing suites and their associated status
- Responsible for supporting third party application including writing qualification
- Win NT server installation and maintenance
- Upgraded software package. Pieces included: six new workstations, one new NT server, copied data from existing database to new database
- Facilitated data conversion from a DB2 database to Oracle database
- Analyzed COBOL application to determine data worthiness
- Wrote SQL code to load data coming from a DB2 database and load an Oracle database -
Programmer/Analyst
Kittle's Home Furnishings
(Retail industry)
April 1993 — June 1997 (4 years 3 months)
• Wrote and maintained programs for the Accounting, Distribution Center, Merchandising, and Customer Service departments using VAX BASIC, DEC Forms, and SQL
• Wrote and rewrote various applications touching numerous departments
• Re-wrote and maintained of Customer Traffic Reports
• Used to track customer traffic throughout the Kittle’s stores
• Helped marketing determine product placement and pricing
• Rewrote code to utilize ORACLE Rdb (formerly known as DEC Rdb)
• Was part of the team to rewrite applications to take advantage of Digital RDB relational database; the existing file structure was ISAM files
• Hand-held and picker mounter RF terminals
• RF terminal maintenance
• Software upgrades – both to the handheld terminals and the transceivers
• Ensuring applications written for the handheld terminals worked properly
Eric Emrich’s Education
-
Purdue University
1992 — 1998
-
Danville Community High School
High School Diploma , Math, Science, English , 1979 — 1983
Additional Information
Eric Emrich’s Websites:
Eric Emrich’s Groups:
-
My Man Mitch - Mitch Daniels, Indiana Governor -
Ex-CTGers
Eric Emrich’s Contact Settings
Interested In:
- career opportunities
- consulting offers
- new ventures
- job inquiries
- expertise requests
- business deals
- reference requests
- getting back in touch
