JEFF HAMILTON

Database Administrator/Developer

PROFILE

I have been working with databases since 1999 and enjoy a challenge.

CONTACT

PHONE:

970-***-****

EMAIL:

adwho8@r.postjobfree.com

HOBBIES

Member of Denver and Boulder SQL Server User Groups

Co-Founder of Northern Colorado SQL Server User Group

Soccer coach

EDUCATION

University of Northern Colorado - Greeley, Colorado

1994 - 1998

B.S. Business Administration Emphasis in Computer Information Systems

WORK EXPERIENCE

Orion Advisor Tech Database Developer

September 2021 to Present

- Member of a DevOps team

- Support and develop Turnkey Asset Management software

- Troubleshoot support issues and develop new features while

assisting with database performance and best practices.

-AWS environments including Redshift.

Banner Health Database Administrator / Data Architect

September 2005–September 2021

-Part of a team of DBAs that support nearly 1,000 instances of SQL Servers ranging from SQL Server 2000 to SQL Server 2019.

-Contribute to Development teams using Agile and Scrum Technology to develop in-house business applications for several departments including Legal, HR, Physician Billing Offices.

-Develop High Availability Solutions using SQL Server 2014, SQL Server 2016, and SQL Server 2019

-Support NoSQL And MongoDB environments

-Develop dashboards interfacing clinical data and aggregating key indicators for Enterprise Outcomes and goal tracking.

-Develop with SQL Server Analysis Services and SQL Server Reporting Services

-Develop and support ETL solutions

USDA Forest Service Systems Analyst

January, 2001–September, 2005

-Designed and developed in Perl, Java, and various UNIX scripting tools (ksh, sh, bsh)

-Utilized XML, HTML, JSP, Apache/Tomcat on HP-UX configurations

-Developed Custom Unit testing in Perl and ksh

-Developed Procurement software in Oracle Forms and Reports

-Developed with PL/SQL

-Created and Maintained replication environment using Snapshots for over 300 satellite sites using Oracle Replication

Global Commerce Systems Database Engineer

October, 1999–January, 2001

-Member of a team that provided an e-commerce system to one of the largest suppliers of corporate and private credit cards in the World.

-Architected and implemented the data store including the OLTP and the data warehouse.

-Developed Perl DBI load scripts for the OLTP Bootstrap data.

-Developed Web-based reports using Actuate Developer Workbench.

-ETL development that mapped credit card transactional data to the Oracle 8i database using Informatica Power-center

Excelsior Software Inc Application Developer

June, 1998–October, 1999

-Responsible for modifying applications according to customer specifications.

-Debugged and developed education software using Visual Studio C++

SKILLS

SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019

Powershell

Perl and shell scripting

ETL Development

Report Writing

Database Administration and Development

MongoDB and NoSQL

SQL Azure

AWS Redshift

Contact this candidate