Mark E. Johnson
Littleton,CO
Summary
Versatile IT specialist with extensive experience in database administration across multiple platforms including SQL Server, Oracle, and MySQL. Proficient in physical and logical database structures, backups, recovery processes, and performance tuning. Demonstrated ability to manage complex database environments and provide exceptional customer support to a global client base. Skilled in utilizing tools such as SSMS, SSRS, SSAS, and SSIS for effective data management and reporting.
Overview
43
43
years of professional experience
1
1
Certification
Work History
Cache Matrix/BlackRock
2018.03 - Current
- Supported migration from Cache Matrix data centers to BlackRock data centers, addressing challenges related to size and scale through multi-file backup solutions.
- Executed upgrades across multiple servers and instances from SQL Server 2012 to 2014, and subsequently from 2014 to 2019.
- Implemented upgrades for SSRS, enabled read-only instance access for SQL Server, and established disaster recovery capabilities for SSRS and all portal instances.
- Addressed challenges associated with standard versus enterprise SSRS, SSIS, and patching.
- Provided daily operational support, streamlining the team from three members to one
ICS Consulting for Cache Matrix/BlackRock
2017.12 - 2018.03
- Supported database instances and applications over the Holiday Season.
- Able to step in and learn quickly the procedures needed for the given environment.
- Was able to offer solutions to problems related to OS patching and locking blocking situations.
IT Specialist and Database Administrator
CIBER, Inc.
2004.06 - 2018.01
- Supported diverse platforms including SharePoint 2007/2010 on SQL Server 2008 R2, and multiple database applications on SQL Server versions 2000 through 2016.
- Provided primary support for SQL Server environments and contributed to Oracle 11g administration and 12c training.
- Migrated MySQL databases to Microsoft SQL Server and managed restore and refresh operations for both Oracle and SQL Server using RMAN, SSMS, and scripting.
- Led disaster recovery testing and implementation for SQL Server and Oracle systems.
- Installed and supported Microsoft Dynamics database environments, migrated MySQL applications to SQL Server and VB.NET, and developed PowerShell solutions for Active Directory provisioning.
- Delivered backend support for SharePoint and MS Dynamics CRM, and evaluated clustering and mirroring strategies for SharePoint.
- Facilitated data migration from merged to individual content databases for client solutions.
- Acted as Data Warehouse ETL Architect for an in-house data warehouse initiative.
Database Consultant
Digital Consulting & Software Services, Inc.
St. Louis, MO
1994.09 - 2004.06
- Provided database administration for multiple major manufacturing companies.
- Worked on physical database structure, logical database layout, standby databases, replication, stored procedures, security, SQL services, SQL Loader, imports and exports, transparent gateways, ODBC connectivity, enterprise manager, utilities, performance tuning, upgrades, and installs.
- Cross-trained additional DBAs in support roles for various databases.
- Supported SAP databases.
- Worked with Oracle's transparent gateway (for SQL Server) and Oracle Names server.
- Upgraded Oracle servers to 7.3, 8.0, 8.1.7(8i), 9.2(9i).
- Worked with multiple developers to troubleshoot performance issues.
- Upgraded SQL Server to 7.0, 2000. Implemented workaround for 6.5 application during migration to Windows 2000 environment.
- Worked with developers on performance issues on SQL Server.
- Supported the upgrade of RDB from 5 to 6.5 and 7.0-6. Worked with developers on performance and locking issues.
- Implemented MS Access user interfaces using SQL Services.
- Designed, performed, monitored and documented the testing for Y2K on all databases.
- Moved users from Lotus Notes to Access.
- Served as a member of a large (30+ person) development team for a major agricultural company through implementation of a new order processing application.
- Performed change control configuration management, software testing.
- Supported formal testing process through integration, system, user acceptance, and stress testing phases. Work required knowledge of multiple systems and programming languages.
- Provided on-call and after-hour system administration support for various companies.
- Also provided training and support for their applications.
- Provided system support for a Lights Out Computing Environment, incorporating tools for data centers world-wide.
- Developed system utilities and procedures to provide relief from manual systems.
- Met with various user groups to gather requirements, write formal Requirements Specifications, coordinate with key team members to attain sign off, write Design Specifications, lead requirements and design reviews, and prototype software tools to be developed.
Developer/System Administrator
Penn Corporation
St. Louis, MO
1989.11 - 1994.08
- Managed data dictionary, developed Powerhouse applications, and provided training.
- Used Powerhouse toolkit to enhance multiple modules.
- Investigated technologies for future development needs.
- Supported DIBOL applications.
Customer Service Supervisor
Custom Computer Applications
Memphis, TN
1986.03 - 1989.11
- Responsible for all special projects, including audio response and PC interfaces.
- Performed Application development for customer support.
- Taught various training seminars for customer sites around the country.
- Traveled to numerous client sites to support upgrades, applications, and patches.
Data Processing Coordinator
Federal Employees Credit Union
Kansas City, MO
1983.08 - 1986.03
- Managed the data processing department.
- Maintained all software and hardware.
- Provided training, and coordinated the computer center relocation.
- Provided the entire user training and support for a major conversion.
Education
MS - Agriculture, Collateral field Computer Science and Statistics
Northwest Missouri State University
Maryville, MOBS - Agriculture Education
University of Missouri
Columbia, MOSkills
- Authorize
- Autogen
- Backup
- BASIC DIBOL
- CMS
- COBOL
- CuSTAR
- DCL
- Debugger
- DECnet
- Documentum
- Dynamics
- ECOM
- EDT
- EMS
- EVE
- FDL
- FILEMASTER
- Install
- JIRA
- LATcp
- Librarian
- LMF
- LOTUS
- LSE
- MMS
- Monitor
- MS Access
- MS Excel
- MS Windows
- MS Word
- NET
- NCP
- OCR
- Oracle 7/8/9i,10,11g,12c
- Pascal
- Pathworks
- Patrol
- PC Kermit
- Perl
- PowerPlay
- PowerShell
- QUMAS
- Raxco
- RMS
- R
- SAP
- Scribe
- Sharepoint
- SQL Server 2005,2008,R2,2012,2014,2016,2019
- Sysgen
- Sysman
- TMS
- Toolkit
- UNIX Shell (Korne, Borne)
- Visual Basic
- VAX ACMS
- VCS
- VPA
- Watchdog
- WhereScape Red
- Windows 7,2008,2012,2016
- Ubuntu
- Digital UNIX
- DOS
- RSTS
- VAX/VMS
Certification
- MCTS SqlServer 2008 Administration
- MCTS SqlServer 2005 Administration
- BrainBench SqlServer 2000 Administration
- MCP SqlServer 7 Administration
- OCP for Oracle 7/8X
Training
- Data Warehouse Administration utilizing Microsoft SQL Server 2005
- Documentum 5.1
- SAP R3 Database Administration
- SQL Server 2008 Clustering
- PowerShell for Administration
- MySQL: Administration, Transactions, Optimization, Scaling, Backup, and Recovery
- Microsoft SQL Server 2016: Data Access and Permissions
- Working on SQL Server 2012, 2016, 2019 and Data Science using R, 2017 Linux
- Bronze Python Certificate
- Azure Fundamentals
Work Preference
Job Search Status
Not actively lookingSalary Range
$100000/yr - $200000/yrTimeline
Cache Matrix/BlackRock
2018.03 - Current
ICS Consulting for Cache Matrix/BlackRock
2017.12 - 2018.03
IT Specialist and Database Administrator
CIBER, Inc.
2004.06 - 2018.01
Database Consultant
Digital Consulting & Software Services, Inc.
1994.09 - 2004.06
Developer/System Administrator
Penn Corporation
1989.11 - 1994.08
Customer Service Supervisor
Custom Computer Applications
1986.03 - 1989.11
Data Processing Coordinator
Federal Employees Credit Union
1983.08 - 1986.03
MS - Agriculture, Collateral field Computer Science and Statistics
Northwest Missouri State University
BS - Agriculture Education
University of Missouri