John, Senior Database Engineer

Murray, UT

 

Skills                

Database Skills                                    Programming Skills/Languages           Other Skills

SQL Server 2000/2005               ASP.Net                                               Database Administration

Oracle                                     VB.Net                                                 Linux

Oracle Applications                PHP                                                      Business Analyst

MySQL                                     ASP                                                      EDI

PL/SQL                                     C++                                                     Amisys/HP3000

DTS                                           Java                                                    System Integration

Stored Procedures                   Pascal                                                  Crystal Reports

Database Design                     Delphi                                                  Windows System Administration

EDI                                           C                                                         Network Administration

Javascript                                            Encryption                                                                                           HTML                                                    Security

                                    Assembly Language                            Web Design

                                                                                                System Upgrade/Migration

                                                                                                DOS Scripting

                                                                                                AS400

                                                                                                Technical/Hardware Support

                                                                                                Novell Netware

 

 

Experience

            Sr. Database Administrator / Network Specialist                     Aug 2005 – Current

Educators Mutual Insurance Association, Salt Lake City, UT

•  Oracle Applications DB Administrator – Performed backup, recovery, and system maintenance.

•  SQL Server 2000/2005 Database Administrator

Designed and maintained databases for new and existing programs and web applications.

                        •  Linux System Administration – Managed Linux servers that ran our Oracle Applications

                        •  Business Design and Analysis

Worked closely with the business to develop new applications and automated processes

•  Designed and implemented Medicare Part D enrollment management system using the following

•  Stored Procedures

•  DTS (Data Transformation Services)

•  Automated Scripts

                        •  EDI – mapped files to database tables and manipulated data

                        •  Designed automated scripts and procedures to automate business processes

•  Synchronized data between Amisys/HP3000 Mainframe and SQL Server

                        •  Implemented Web Based Reporting System

•  Upgraded and migrated several programs and databases

 

                       

Programmer/DBA                                                                     Feb 2003 – Aug 2005

Young Electric Sign Company, Salt Lake City, UT

                        •  Lead Programmer and DBA.

                        •  Created secure web interface for Crystal Reports

                        •  Designed and implemented several applications in Delphi

                                    •  Customer Information System

                                    •  Project Tracking Application

                                    •  Payroll and Sales Commission Application

                        •  Administered several databases including integration/synchronization between the following

                                    •  AS400, SQL Server, MySQL

                        •  Webmaster and web application design for our internal and external websites.

                        •  Training and support for several applications.


 

            Web Design                                                                             Oct 2002 – Jan 2003

NetPath Systems, Salt Lake City, UT

                        •  Designed e-commerce site using VB.Net, ASP.Net, ADO.Net, and MSDE.

 

 

            Technical Support                                                                    June 2002 – July 2002

Microsoft MSN, Salt Lake City, UT

                        •  Technical support for Internet customers

           

           

Computer Technician                                                              June 1997– Nov 1997

            CompuTech Computer Sales and Service, Pinetop, AZ

                        •  Repaired computers

                        •  Provided technical support

                        •  Provided Internet service

                        •  Used Novell NetWare 3.11 & Windows Networking

                        •  Networked and supported local government computer systems

 

 

Education

            Bachelor in Computer Science                                                            Graduated Dec 2002

            Weber State University, Ogden, Utah

            GPA 3.66

 

 

            Related Course Work

•  Programming Languages

•   C++, Java, VB.Net, Delphi, ASP.Net, C, Pascal, Assembly Language, HTML

•  Local Area Networks           (Novell, Microsoft, Linux)

•  Client, Server Programs

•  Unix & Windows 2000 system internals

•  Database design and application development

•  Oracle

•  Microsoft Data Engine(MSDE)

•  SQL Server

•  Object oriented analysis and design

•  Communication circuits

•  Technical writing

•  Digital design

•  Electronics

 

 

            Special Projects

•  Developed algorithms and problem solving skills to write several programs in

    C, C++, Java, and Pascal.

•  Wrote client and server programs in C including a web server.

•  Designed and implemented databases in Oracle, SQLServer, MSDE, & Access.

•  Programmed a personal finance program, software for doctor’s office, and

    baseball simulator with Delphi.

•  Developed an e-commerce web site for NetPathSystems here in Salt Lake

•  Observed and repaired problems in electronic equipment and computers.

                        •  Studied communication circuits found in transmitting equipment.

 

 

Additional Information

        Volunteered for service organization from 1997-1999 in Maine and New Hampshire.

        Oversaw 10 other representatives and trained two new ones.