Requests
0
Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
WebPTSenior Manager - DBA
Sep. 2024Phoenix, Arizona, United States
WebPTDirector SRE
Nov. 2023 - Dec. 2024Led SRE team in consolidating various monitoring tools to Dynatrace
Created and presented metrics in large teem meeting Team assisted with move from colocation datacenter to AWS
WebPTManager, Database Engineering
Jun. 2022 - Nov. 2023Led the DB team to increase database reliability to exceed unexpected downtime SLAs.
Spearheaded getting upgrades to database environments.
Participated in rotation of major incident managers.
Directed team in automating tasks for reliability and efficiency.
WebPTSr. Database Adminstrator
Mar. 2019 - Jun. 2022
Sherwood AdventureCo-Owner
Oct. 2016Sherwood Adventure offers the mobile entertainment company with its first attraction SAFE Archery HoverBall.
International Cruise & Excursions, Inc. (ICE)Sr DBA
Jul. 2014 - Mar. 2019- Upgraded most servers to SQL 2014 - Setup care and feeding of several HA clusters
- Monitoring of current environment for issues
- Performance tuning of poor running queries
Headwaters, IncDatabase Administrator
Apr. 2014 - Jul. 2014Made improvements to existing processes to increase speed.
Documented all SSIS packages.
Used Powershell to automate manual processes.
Scottsdale Insurance CompanySql Server Dba
Aug. 2013 - Apr. 2014Monitor and maintain over 50 production, testing and development SQL Servers.
Support on Oracle Servers.
Perform backups restores and data migrations.
Run security scan and remediate issues. Work with application support for any outages both internal and customer facing. Development of SQL stored procedures and SSIS Packages.
Developed Powershell scripts for pulling a list of all users on all servers and get domain information.
Mutual of OmahaDatabase Administrator
Oct. 2012 - Aug. 2013MS SQL DBA responsible for setting direction of SQL Server resources.
Monitor and maintain over 100 production, testing and development SQL Servers.
Perform backups restores and data migrations.
Work with application support for any outages both internal and customer facing. Create and analyze existing indexes for better performance of queries. Tune poorly performing queries. One query was timing out the customer web site. Increased query time from 30 sec to 2 milliseconds. Another process was brought down from 26 hours to 90 minutes. Develop and execute a transition plan to bring the SQL environment up to industry best practices.
Lead a team of Business Intelligence developers, database developers and database administrators.
Development of SQL stored procedures and SSIS Packages.
Developed Powershell scripts for backups and monitoring.
Gather business requirements to help in both Agile and Waterfall projects.
Work with server and storage teams to optimize both physical and virtual servers. In the past 3 months have moved 80% of SQL servers to a virtual environment.
Planning datacenter move of over 4 Terabytes of SQL data from Tempe to Omaha.
Mutual of OmahaBusiness Intelligence Team Lead
Apr. 2011 - Oct. 2012Lead a team of Business Intelligence developers, database developers and database administrators.
Wells FargoDBA
Jun. 2004 - Jan. 2011Senior MS SQL DBA, responsible for system capacity planning, monitoring and audit. Maintained Production environment with hot backup server using log shipping.
Off Hours contact for all SQL related outages or issues.
Migrated servers into a new datacenter from Tempe to Phoenix and from Phoenix to Minneapolis
Setup log shipping for over 150 databases. Improved core queuing and tracking system to increase uptime and system usability.
Directed contractor resources on a large Oracle project to replace a core business system. My design increased up time by 93%. Oracle development Backup to the Windows Administrator responsible for OS, logins, permissions, and shares. This includes troubleshooting backups, to SAN and Tape, and server hardware.
Advertising Checking BureauDatabase Developer
Jul. 2003 - Apr. 2004Handled customer technical relationship with a large international client. Recommended and built a new server which increased process speed by 70%.
Updates and changes to DTS packages, stored procedures, triggers and custom functions.
Backup SQL DBA, Backups, restores, query tuning and indexes.
Arizona Department of Health ServicesDatabase Contractor
Jul. 2002 - May. 2003Brought back for updates to system that I built earlier for the customer.
Oracle database development for combining data from many systems for federal government reporting. Gathered customer requirements, changed system to new requirements, and provided extensive documentation for internal department to handle changes after my departure. Created reports for federal government reporting.
Developed a series of reports to help manage clinics better by normalization and statistical analysis Reworked Oracle queries to perform better.
Worked with user community to gather requirements for new projects.
Created multi-dimensional OLAP cubes to provide data to the federal government and internal customers using a web based reporting tool and Excel Pivot tables.
Developed a Visual basic app to assist in running Oracle queries for information gathering.
WorldCom WirelessDatabase Developer
Apr. 2000 - Jun. 2002Responsible for creating and maintaining daily data loads to the data warehouse from Access, Btrieve, text files, Oracle, SQL Databases. This included integrity checks to be sure the data imported correctly and maintaining transactional replication between the production and reporting SQL Servers. Created and maintained reports using Brio Reports.
Created database models for new databases and data marts, and modified the data models for existing databases due to account for new data requirements.
Designed, created and maintained several SQL databases. One was 160 million records and 40 GB in size.
Performed general maintenance, provided user security access, and resolved emergency problems on several MS SQL servers. This includes after hours work to not interfere with the database users. Analyzed queries to determine indexes and data model changes to increase system performance. Assisted the network administrator with backups, backup schedules and restores of databases.
Upgraded development servers from SQL 7.0 to SQL 2000.
Used VB scripts to change parameters in DTS packages. This allowed the automation of many daily import jobs. Used DTS VB scripts and DOS Scripts to create ftp scripts, copy files and verify data imports and exports.
Created DTS packages with decision loops. This would loop through a list of ZIP files in multiple locations and process any file that had not been imported.
Created VB applications to clean a 133 million row data file before importing.
Changed user queries into stored procedures to reduce the load on the database server and WAN.
Intch is a Professional Networking App for the Future of WorkSee more people like Jeff on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
1006506 people
16
Producer @ iHeartMedia Cincinnati
16
Creative
15
Production Assistant
41934 people
16
Creative
15
Production Assistant
18
Creative Systems Consultant | Instructional Designer | Corporate Trainer