Russ Schaffer

**** * **** *** • Gilbert, AZ ***** • 480-***-**** • acp2lz@r.postjobfree.com

Jr MS SQL DBA/Developer

Experienced inbound and outbound technician with emphasis in home hazard and SQL Server based applications. I am seeking a MS SQL DBA position that will allow me to work daily with maintenance and support of MS SQL applications as a DBA.

8 years experience with SQL Server 2003, 2005 and 2008 and 2012. Daily direct support of MS SQL Server based Point of Sale and Inventory Databases for 1500 remote customers was shared with 10 technicians.

EDUCATION

MS SQL DBA Certification Training, 2014. DBA University Online, An Oracle Silver Partner. 80 class hours plus 40 hours labs. Emphasis on database planning, installs, administration, SQL 2012 architecture, TSQL, query editor, server agent, backup and recovery, server security, performance tuning and data import/export.

Bachelor of Science, Business Administration, 1992. Ambassador University, Big Sandy, TX.

12 Units Advanced Accounting, 1993 and 1994. UCLA School of Business, Los Angeles, CA.

Associate of Arts, Liberal Studies, 1990. Ambassador University, Big Sandy, TX.

Skill Port Six Sigma Greenbelt Management Training, 2010.

Customer Contact Council Member, 2009_ and 2010.

PROFESSIONAL EXPERIENCE (Recent 12 years)

QBE First, Chandler Arizona

Loss Drafts Production Analyst

8/2011 to Present

www.qbefirst.com

Daily monitoring of 100-300 home hazard claims. Great attention to detail, and communication is required by our lenders, and I take a personal interest in every file I work to try to minimize the devastating effects of property loss.

I work with MS Office applications Word, Excel, Access, MS SQL 2012, PowerPoint and Outlook.

Duplication of all efforts with servicing group on SQL 2008 based IRESS system and Tracksource database.

American Auto Recycling, Gilbert Arizona

Inventory Warehouse Specialist

2010 to 2011

www.americanaz.com

Primary database administrator, responsible for entry of all incoming inventory into Pinnacle Yard Management System.

Daily database maintenance for remote parts and stock tickets and interchange accuracy.

Ensure daily updates to SQL based remote server machine.

Audatex, a Solera Company, Ann Arbor, Michigan

Floor Escalation Manager, Client Services

4/2006 to 07/2010

www.audatex.com

Daily verification of MS SQL events and jobs for insurance claims and SQL based point of sale, inventory, customer and tax databases for 3000 remote SQL Server machines.

Trouble ticket escalation and remote SQL queries for bad data.

SQL Server backups and restores.

Worked with SQL 2005, 2008 and 2008R2.

Analysis of corrupt data and ensuring daily incremental backups in MS SQL.

Worked with host system on site to ensure SQL database efficiency and redundancy.

Special projects included special SQL local tax database patches and assistance with software updates and development on enhancement requests.

ADP Claims Services Group and Audatex, a Solera Company

Plymouth, Minnesota and Ann Arbor Michigan

Technical Support Representative and Support Coach

10/2002 to 4/2006

www.audatex.com

Direct inbound call representative assigned to assist end to end troubleshooting support for MS SQL point of sale, inventory, customer and reports databases.

SQL 2003 and 2005 primary support for nationwide incremental daily jobs for 3000 user remote parts database. Adding and removing users as SQL admin.

Customer issues ranged from networking and printing issues to how to tutorial sessions and database migration and corruption issues.

Daily work with SQL and MSDE databases in verifying parts exchange network files and incremental data exchange updates were monitored and verified.

Adding and removing users from EDEN network

Monitoring of event viewer in verification of daily SQL job execution.

Contact this candidate