JL

Jeffrey Laatsch

CEO/Owner · T Affordable Solutions LLC, WA

Port Orchard, WA

In My Own Words

An accomplished Information Technology Specialist, Web Developer-Programmer, Data Base Administrator (DBA), System Administrator (Windows, Unix, Linux) and Programmer with several years of industry background in full system management and technical support expertise including SUN, HP-UX, AIX, LINUX, and WINDOWS: Experienced working with MS SQL Server 2000,2005,2008, 2008R2, 2012,2014, ORACLE 11g, MYSQL: Software technical experienced supporting WordPress, .NET ,C, C++,C# PHP, PERL, VB.NET, SQL, ASP, JAVA, JS, XHTML, XML, CSS, PL/SQL, TransactSQL,3GL, 4GL, dynamic WEB technologies: Analytical thinker and problem solver: Strong team player with good oral and written communication skills: Goal oriented professional who has a Master of Science Degree in Computer Systems with emphasis in Computer programming (C++): Adjunct Instructor Part Time at various Community Colleges and Universities utilizing my several years of experience in Information Systems.

Work Experience

CEO/Owner

T Affordable Solutions LLC, WA

2005 – Present

FREELANCE WEB PROGRAMMER-DEVELOPER: Privately owned FREELANCE Web Programmer-Developer business established in 2005: Working one on one with various clients to gather business and or personal website requirements utilizing Business Analyst skills, Programing Skills and Project Management skillsets: Gather requirements then build from requirements Website utilizing C, C++, C#, .NET,PHP, PERL, VB, SQL, ASP, JAVA, JS, XHTML,HTML5, XML, CSS, MySQL, WordPress, Graphic Design, Website Design, Photography knowledge and programming expertise. Design, Development, Implement, and Maintain websites: I work closely with Clients to ensure complete satisfaction, and as a service to them.

TECHNICAL EXPERTISE: Ensure customer information is secured utilizing security aspects of Programming, and building of Websites: Business Analyst skills, Programing Skills and Project Management skillsets: Gather requirements then build from requirements Website utilizing C, C++, C#, .NET,PHP, PERL, VB, SQL, ASP

Information Technology Specialist

State of Washington, Department of Social and Health Services, Olympia, WA

2015 – Present

WINDOWS SYSTEM ADMINISTRATION/CUSTOMER TECHNICAL SUPPORT: Provide Windows System Administration technical support for Storage Services Infrastructure (SSI) for internal Department of Social and Health Services (DSHS) internal customers: System Administrator utilizing NETAPS, SCOM2012, TREE SIZE, VM vSphere, and other third party tools to provide total management of systems : Storage requirements, System Patching, System Monitoring, User Access, third party Application Installation: Developer experience utilizing Python, Windows Power Shell script, T-SQL to develop scripts to extract information from various areas to populate new FEAF/CMDB Staging Database utilizing Programing expertise: System patching utilizing SCCM tool: Database Administration architect skills in working with Client to determine requirements for new Database projects.

Previous to Promotion: Provided SSPS Customer Technical Support for case managers and providers requiring information on authorizations and payments

Information Technology Specialist

State of Washington, Department of Social and Health Services-Childrens,Lacey, WA

2014 – 2014

DATABASE ADMINISTRATION: Planned, scheduled, tracked database changes, data sets, as well as projects being completed by development team: Provided primary database administration for statewide automated child welfare information case management system, containing over one terabyte of information: Performed daily maintenance on Production OLTP database including User Access, Specific special request permissions, backups, restores, and execution of ad hoc developer queries for each environment (Dev, ST, UAT, Pre-Prod, Prod):Backup Data Warehouse DBA for Production Replications, user access, specific permissions, and ETL Package installations: Maintained all Data Warehouse replication scripts during new releases and in all Development and Test Environments: Monitored replication process utilizing Replication monitor process utilizing Snapshot and transactional replication methods.

TECHNICAL EXPERTISE: Delivered consultation and analysis for database migration from Physical to Virtual

Information Technology Specialist

State of Washington, Department of Labor and Industry, Tumwater, WA

2006 – 2014

DATABASE ADMINISTRATION: Performed, Planned, scheduled, installed, implemented, functional tested, and quality assurance checks, and tracked MS SQL database changes, data sets, as well as projects and SSIS Packages, being completed by development team for third party application databases: Performed daily maintenance on Production OLTP database including User Access, Specific special request permissions, backups, restores, database growth issues, and execution of ad hoc developer queries for each environment: Maintained third party database MySQL used in SOLAR WINDS Networking monitoring application

APPLICATION AND DATABASE ANALYSIS: Analyzed the databases daily, evaluating connections, intrusions, and bottlenecks utilizing SOLAR WINDS and COMPUWARE product application and network monitoring tools: Created Statistical reports which were distributed to other departments. Analyzed recovery scenarios and developed onsite backup requirements.

TECHNICAL EXPERTISE: Delivered consultation

Sys Admin - System Integration Engineer

Computer Science Corporation (CSC) Bangor, WA

2004 – 2006

SYSTEM ADMINISTRATION: Primary System Administration support for MS Windows Servers, Exchange Servers, DNS Server, Proxy Server including the installation of service packs, antivirus software, managing users, device drivers, disk drive installation, and space oversight, Active Directory management, VERITAS backup and recovery third party software, network configuration changes for firewall, and MS Windows Shell script software support. Administrated the Windows System for desktop systems used for application, and on-site training courses utilizing knowledge of Windows Operating System Active Directories, and security with reference to Department of Defense standards.

TECHNICAL EXPERTISE: Delivered Project Management, consultation, analysis, and solutions for Windows Operating System and Network upgrade in mixed Windows environment while migrating up to MS Windows Server 2003 Operating Systems including hardware changes, IT security changes using Department of Defense standards.

Education

Bachelors of Science Degree-

Chapman University

1996 – 2001

Bachelors of Science Degree-

Master of Science-

City Universtiy

2001 – 2003

Master of Science-

CISCO CCNA

Green Rivers Community College

2000 – 2000

CISCO CCNA

Database Management

University of WA- Ext Program

2011 – 2011

Database Management

Interests

PhotographyOutdoorsPublished poet

Industries

Tech

Connections