John Merager

206-***-****

adhm8r@r.postjobfree.com

Mill Creek, WA 98012

Work Experience:

Performance Lead

Elyon International (at Boeing) May 2019 – Sept 2020

SAP performance and functionality testing using Loadrunner (Application Owner/Admin). Developed IIS website for reporting which contained over 90 SQL queries. Some reports had the ability to kill related processes and stop/start services for non-Admins where specific people were allowed. Developed several powershell scripts. One of the scripts was a UI for querying Active Directory. Created complex server build scripts for test team. The server build script would change settings to avoid popups and fix other issue which enabled playback scripts to runs smoothly. Setup Worksoft Execution Manager on multiple servers. Developed DSC scripts to maintain server settings and user profile settings. Developed automation scripts for SAP database refresh projects for MS SQL and Live Cache. Increased productivity of test team by setting up servers for remote login just before everyone was required to work from home. This enabled everyone to use their own computer while running/replaying test scripts on remote servers. Came up with work around for SAPGUI bugs related to LoadRunner performance testing where SAPGUI would go into an endless loop depending on conditions. A ticket was opened with SAP Company. Also opened tickets with Micro Focus Company on various LoadRunner issues. Created several data collecting jobs for performance, remote desktop login tracking, application version, services, server info, cluster info, process info, events and other information. As an IIS SME, gave advice to another team who ran into issues when migrating/upgrading IIS websites to new servers. As a SME with SQL, helped with or mentored others on various MS SQL server issues and questions. Some of which included upgrades, AlwaysOn, parallelism for SAP, and SQL settings related to Worksoft applications. Setup VTS tables on multiple servers and automated script for loading Excel data into both VTS tables and SQL (used for LoadRunner). Created special reports to show automated Worksoft Execution Manager playback jobs and their run status. This report updated a spreadsheet and kept history in CSV and Excel files. Created/maintained over 300 domain accounts, 6000 SAP accounts, and other application accounts.

(Total time at Microsoft) Microsoft Sept 1993 (hired Oct 1995) – May 2019

SAP Basis System Senior Software Engineer

Valente/Accenture (at Microsoft) Sept 2018 – May 2019

Sr SQL DBA, Sr Windows Admin, Sr Web Admin, and SAP Admin. Level 4 (highest level) support on SAP Basis Team at Microsoft. Mentor others daily. Go-to person for other support levels and others for anything related to Security, Web Services, File Servers, SQL, Windows, Automation, Monitoring, Scripting, command line tools for team, Accounts/Passwords, certificates, hardware load balancer, data collection, network, server inventory, MSCS cluster, Scheduled Tasks, Windows Services, Application version info, server aliases, performance, drive/db growth, Disaster Recovery, Replication, SAP, and other issues. SME (Subject Matter Expert) in supporting and developing new version of complex file server security application. Working on a project for scrambling highly sensitive data in non-production systems. Create/maintain data collection jobs, password database, and a technical reporting/dashboard website.

Technical Specialist HCL America (at Microsoft) Dec 2015 – Sept 2018

Sr SQL DBA, Sr Windows Admin, Sr Web Admin, and SAP Admin. L4 support on SAP Basis Team at Microsoft. Mentor others daily. Go-to person for L3 and others for anything related to Security, Web Services, File Servers, SQL, Windows, Automation, Monitoring, Scripting, command line tools for team, Accounts/Passwords, certificates, hardware load balancer, data collection, network, server inventory, MSCS cluster, Scheduled Tasks, Windows Services, Application version info, server aliases, performance, drive/db growth, Disaster Recovery, Replication, SAP, and other issues. SME (Subject Matter Expert) in building new version of complex file server security application. Migrating file server and IIS servers to Azure VM's. File server replication, upgrades and redesigns. Wrote security related scripts for migrating to new accounts. The script detects where related existing accounts are used and adds new accounts. Developed Webservice Management Application UI in powershell (16,000+ lines of code). Manage password database. Manage a reporting/dashboard website. Audit/update Windows and SQL security. Create/manage data collection jobs.

Service Engineer Microsoft Aug 1998 – April 2015

Service Engineer on the SAP Basis Team at Microsoft. Administrator of SAP, Window Servers, SQL Servers, and IIS Servers.

Environment: Manage 640+ servers, 290+ Virtual Machines, 200+ SQL Servers, 100+ SAP Systems, 100+ IIS servers, 555+ webservices, 70+ MSCS clusters, 18+ Azure/IaaS servers, 25+ VIPs in F5 Hardware Load Balancing, 2500+ shares on file servers, SCOM monitor system, Presentations & KT sessions, Upgrade/Migration, Capacity Planning, Development/Testing/Acceptance/Production (change control)

Strengths: Sr. SQL DBA, Sr. Windows Admin, IIS Admin, Monitoring, Scripting/Batch/Automation, Security, Troubleshooting, Performance Tuning, Disaster Recovery, Data Collection/Analysis, Go-to person

•SQL DBA: 18+ years experience, All versions including SQL 2014, Database design, Mirroring/AlwaysOn, Log Shipping, Stored Procedures, Relational/Normalized, upgrades, 9 Terabyte databases, Trouble Shoot, Performance, Perfmon/disk/CPU/Memory, Disk/SAN performance/config, Connection Issues, Security/Permissions, Update Stats, Query Plan, Index/Hints, Constraints, Profiler, Management Studio/Query Window, Stored Procedures, Triggers, Functions, case-sensitive/sort order, TSQL, Backups/Restore, Encryption, Defrag, Disaster Recovery, Patching

•Windows Server Admin: 23+ years experience, All versions, Flatten/Rebuild, configure, deploy, evaluate/install software, Trouble shoot, Security

•IIS Admin: Webservices, Authentication, bindings

•Monitoring: SQL Jobs, Scheduled tasks, MOM/SCOM, Scripting

•Scripting: HTML, ASP, VBScript, PowerShell, TSQL, CMD/BAT Batch, Automation, Wrote many Troubleshooting command line tools

•Security: SOX, IIS, Audit Windows/SQL, Accounts, Groups, Password Management, shares

•Troubleshooting: Analyze/Escalate, Windows, SQL, IIS, HLB, Clusters, Network, DNS, DHCP/Static, Active Directory, SAP, IPSec, Authentication, Application issues

•Performance: SQL (Profiler, Queries, Indexes), Windows (Disk, Memory, CPU, Network Card, RSS)

•Data Management: Collecting, Understanding, Transforming, Querying

•Disaster Recovery: File Servers, SQL, IIS/Web Services, SAP

•Migrations/upgrades: SQL, IIS, File Servers

•Go-to person/Mentor others: trouble shooting, scripting, tools, configurations, security, standard process/practices, data management, administration, data collection, monitoring, PC diagnosis

Accomplishments:

•Designed, Built and Manage Application for share security management with multiple approval levels. Has 50 relational tables and 50 stored procedures which interact with website

•Worked with developers to design and Build Windows/SQL Admin auditing application for quarterly audits in Organization

•Developed encryption formula for Password Database and password change tools

•Developed ways to scramble copies of SAP production PII/HBI data to non-prod SAP systems

•Automated server build, monitoring, data collection, and change control processes for IIS servers hosting webservices

•Team Dashboard: Created server data collection jobs, download Server management data feeds, and present data on websites. Websites used for server information/settings, infrastructure data, trouble shooting, and statistics. Wrote 200+ SQL queries to display data on dashboard.

•In SQL 2005, I worked with SQL development to add Operator roles in msdb database. This was based on my feedback to reduce our Operator Security level from Administrators to a lower level. I only granted access needed. I also automated how access was granted to Operators.

Manager of Operators Microsoft Jun 1997 – Aug 1998

Managed graveyard shift Operators. Managed and monitored SAP, VMS/VAX, AS/400, and NT Batch systems. Trouble shooting and escalation of various issues. Automated NT Batch job error checking. Completely automated Unix job monitoring.

Operator Microsoft Oct 1995 – Jun 1997

Managed and monitored VMS/VAX, AS/400, and NT Batch systems. These were highly critical systems. Updated and fixed monitoring scripts. SQL DBA. Trouble shooting issues and batch jobs.

Operator Entex (at Microsoft) Sept 1993 – Oct 1995

Filled in for people on vacation for 2 months. First worked in corporate backups performing hotmail backups. Then worked in Helpdesk for a week. Then worked as an Operator for pack slip printing on VMS/VAX in warehouse, and alternated with a co-worker/Operator every 2 weeks to main campus. Managed and monitored VMS/VAX, AS/400, and NT Batch systems. These were highly critical systems. Updated and fixed monitoring scripts. Trouble shooting issues and batch jobs.

Assistant to Computer System Manager HNTB Sept 1991 – June 1993

Trouble shooting Computer issues with hardware and software. COAX Network cabling. VMS/VAX, Unix, DOS, Win 3.1.

References available upon request

Contact this candidate