Ian A. Meitzen

Masters in Computer Science

859-***-**** adr696@r.postjobfree.com

Professional Summary

Built and Implemented SQL Server databases, performed Report Writing in T-SQL, Accomplished programming and network projects in a variety of areas including Education, Warehousing, and E-Commerce and Healthcare.

Skills:

Programming languages: T-SQL, HTML, JavaScript, PL-SQL

Application software: Visual Studio, MS SQL server, MS Office,

Operating Systems: Windows 2003-Windows 2008 Servers

PracticeMax--Feburary 2022 to present – Sr. SQL DBA MySQL DBA

MySQL and well AS SQL Server database administration and tuning.

Design and develop Servers, database systems, tables, views, T-SQL, Stored Procedures, establish database integrity

Healthcare Electronic Healthcare Records (EHR), Personal Healthcare Information (PHI)

Upkeep of MySQL/MariaDB across the network.

7/11_Speedway-- August2021 to February 2022 Sr. SQL DBA/ ETL Programmer (Contractor only)

Working with HR/Accounting databases (4+TB)

Performance tuning including re-indexing, CPU tuning, and memory enhancements, saving company 100K+ a year in licensing costs

T-SQL performance tuning pulling down I/O down 50% by tuning worst performing queries.

Transactional Replication

Troubleshooting ETL/SSIS processes

Assurecare-- May 2019 to August 2021 Sr. SQL DBA/ ETL Programmer

Proofed and wrote T-SQL for enterprise SQL Database

Implemented and maintained Merge replication for 900+ articles

CDC, Always on Availability clustering

Wrote SSIS packages in SQL 2012-2016 for various data ingestion and ETL purposes

UAT in Production and non-production environments.

Healthcare Electronic Healthcare Records (EHR), Personal Healthcare Information (PHI) and

Credit Card (PCI) Activity for insurance companies and states across the nation.

Database tuning for many 20TB+ Dbs

Capacity planning for new clients

Backups/restores

Database Security

Humana-- Application Report Writer T- SQL Netezza May 2018 -May 2019(Contractor)

Started Programming in Python for ETL, TSQL, Stored procedures and reporting in Qlikview.

SQL server – Programming and DBA Work

Worked inside of Netezza SQL for the purpose of upgrading scripts from sandbox to production

Worked with Healthcare data for thousands of clients.

Corrisoft--Contractor ETL/SSIS August 2017- May 2018 (Contractor)

●ETL contracting from Company database to State of for auditing and compliance purposes

Aegon/Transamerica- Sr. SQL DBA Jan 2016-August 2017 (Contractor)

● one of 35 dbas in an enterprise environment administering 900 DBs all over the world.

●Backups/restores Data migration and upgrades.

●Performed SQL auditing for code migrating from test to production.

AIG (Answers_In_Genesis) SQL DBA/SSIS/SSRS/ETL 2010-Jan 2016

SQL Development and administration including backups, restores, query tuning for 40+ servers

Licensing

Database Architecture and diagramming, data warehousing

SSIS-Loaded data into Data warehouse also complete all needed aggregations, Placed data in Excel, SSRS, Access and other databases on request.

SSRS- Installed SSRS, Pulled data from Sprocs,and from Production and made them available to the end user.

SSIS loading data warehouses.

T-SQL coding- Sprocs, functions, tables ect…

Server upgrades from SQL server 2008 to 2012 and 2005 to 2008

Multiple major projects

Perform server and database tuning, monitoring process performance and trouble-shooting issues using performance monitor, profiler, query execution plans

Created and managed server and database security access

Design and develop Servers, database systems, tables, views, T-SQL, Stored Procedures, Triggers, DTS, establish database integrity

Application Support

Worked with application developer’s teams to resolve performance problems with .NET programs.

DMinsite (September, 2008 –September 2009)

SQL server 2005 ETL / Web Application support /Analytics

Perform database maintenance as needed as well as loading data for multiple websites to increase throughput of data

HTML, and JavaScript for clients to increase effectiveness of branding

Helped clients build web pages with proprietary web development software thereby increasing sales and better error checking and resolution.

SEO and Google Analytics tracking increasing sales of online items 30%.

J.D. Patton ATC (August, 2004-June, 2008)

Technical Lead

Taught students programming principals in VB.NET, Java and SQL for the purpose of seeking employment and additional university schooling

Developed and build classroom infrastructure including firewalls, servers, routers and switches for classroom use including DHCP, and DNS servers.

Teach Web development using HTML, JavaScript and C# using Visual Studio.NET. allowing many to compete, for the first time in the school’s history, in state and national competitions.

Made decisions concerning purchases of technical related equipment and software for the use of the entire school.

Trained and worked inside ESRI GIS software ArcView, ArcGISEngine and Arc Explorer. Creating 3D maps of utilities in the area for education purposes. Access Database build.

VPN access and port forwarding to classroom for offsite work by students.

Education

West Texas A&M June 1997- B. A. Music

Regis University December 2005 -Masters Computer Science

First ever to receive an internship to remotely administrate a student Oracle database.

Contact this candidate