John Ertel

Experience

• 

  SJ Web Holdings Inc

  Jan 1998 - Sept 2007

  Owner / Web Developer / DBA / Consultant

  I built from scratch a network of advertiser supporterd consumer interest and community based websites and grew them to an active membership of over 30,000 with a substantial internet reach.

• 

  Kforce Technical Staffing

  Oct 2007 - Jan 2008

  Software Engineer

  Contract position which became permanent at Insphere Insurance. Started as the lead Coldfusion developer in charge of all aspects of marketing websites and lead generation previously developed in Coldfusion and transitioned to also being a member of the .NET development team.

• 

  Insphere Insurance

  Jan 2008 - May 2009

  Software Engineer

  Lead developer for Coldfusion web projects and part of the .NET development team using C#/Visual Studio 2008 for websites targeted to insurance representatives and marketing websites targeted to the consumer. Appointed technical SME in charge of customer support and developer for the 3rd party lead generation service accepting leads through a SOAP over HTTPS web service. Developed supporting database tables in a Microsoft SQL Server 2005 environment as well as supporting T-SQL stored procedures. Show less

• 

  Web Ventures Group

  Jun 2009 - Dec 2010

  Web Developer / SQL Server DBA/Developer

  As part of a small company developing internet applications for e-commerce, consumer news and social networking, I lead and participated in all aspects of deveopment including database and server administration of a microsoft SQL Server 2008 in a windows server 2008 environment. Responsibile for all technical administration issues and maintaining uptime of over 99.999%. In charge of leading a development team to build database driven interactive websites in Coldfusion 8 and C#/.NET featuring social networking features such as image galleries, friend system, interactive discussion forums, etc. Modeled and implemented all associated database structures within the SQL server and developed stored procedures in T-SQL. Optimized and performance tuned the database to insure smooth performance of the server at all times. Implemented backup and strong security plans. Show less

• 

  HigherTech Consulting

  Feb 2011 - Apr 2011

  Database Consultant

  SQL Server database developer and DBA

• 

  FramesDirect.com

  Apr 2011 - Jan 2019

  Senior Sql Server Database Administrator

  SQL Server Database AdministrationSQL Database ArchitectSQL Code DevelopmentSQL Server ETLSQL SSRS Report DeveloperSole database administrator and dedicated sql developer for the company in charge of keeping multiple servers supporting a multi-million e-commerce website running. Met and maintained 99.999% uptime for the sql servers in a constantly growing and changing e-commerce site. Solved efficiency issues as well as intrusion attempts. Responsible for financial report development on which business decisions are made. Show less

• 

  Everi Holdings Inc.

  Jun 2019 - Aug 2024

  Databricks DevOps Data Engineer / Database Administrator III

  Started as Senior Database Administrator for the Data Analytics team. Configured and maintained over a half a dozen dedicated SQL servers for ETL and data warehousing to serve analytics data. Developed and implemented a process for archiving data to Azure to save on premise data storage space. Created pipelines in Azure Data Factory to clean and transform JSON data to parquet for analysis. Implemented delta live tables to capture streaming json data from IoT field devices.Now fulfilling the role of Databricks DevOps Data Engineer, overseeing various devops and data engineering pipeline projects to load data into databricks and support our CI-CD development process. Show less