Michelle Prather

Michelle Prather

Sr. Database Administrator at McAfee

Location
Portland, Oregon Area
Industry
Computer Software

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Michelle Prather know in common
  • Get introduced to Michelle Prather
  • Contact Michelle Prather directly

View Michelle's full profile

Michelle Prather's Overview

Current
Past
  • Sr. Database Engineer at Mentor Graphics
  • Acting Sr. Windows Server Engineer at Mentor Graphics
  • Database Administrator and Build Manager at Forest City Trading Group
  • Information Systems Analyst II / Database Administrator/Build Manager at Multnomah County
Education
  • Umpqua Community College
  • Chatsworth High School
Connections

326 connections

Websites

Michelle Prather's Summary

Databases: SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7.0, MySQL 5, Access, AlwaysOn, Clustering, Polyserve, Database Mirroring, Replication, Log Shipping, SSIS/DTS Packages/ETL, Storage database snapshots, SQL Server Database Snapshots, Index maintenance, Performance Monitoring.

Operating Systems: Windows 2008 Server, Windows 2003 Server, Windows 2000 Server and Client Administration, UNIX, Linux

Application Development: Powershell, VB.NET, VB 6.0, GUI Programming, COM Object programming, C++, C#, SQL Scripting, IIS Administration, MTS/COM+ Administration, Code Build Management,
Change Management, Source Control, Software Implementation, Technical Lead, Project Lead,
Business Analysis, Business Writing, Technical Writing, Software QA Testing

Server Administration: VMware ESXi, Citrix Administration V3 and V4, Server Builds, Software Installation and Configuration, Troubleshooting, Monitoring Administration, Active Directory 2003 Network Administration, Web Server Configuration, Web Content Publishing Administration, Security Configuration, Microsoft Clustering, Load Balancing, Server Backup Administration

Specialties: Database Administration, Database Architect, Project Manager, Build Manager, Business Analysis

Michelle Prather's Experience

Sr. Database Administrator

McAfee/Intel Security Group

Public Company; 5001-10,000 employees; MFE; Computer & Network Security industry

December 2011Present (2 years 10 months) Beaverton, OR

SQL Server administration for the McAfee Labs team. Upgraded a clustered and replicated, 4TB SQL Server 2005 database to SQL Server 2012 AlwaysOn with minimal downtime. Upgraded SQL Server Integration Services packages to SQL Server 2012 Project Deployment Model. Set up DR infrastructure. Streamlined build release process and change management procedures.

Sr. Enterprise DBA Lead

Columbia Sportswear

Public Company; 1001-5000 employees; COLM; Sports industry

May 2010November 2011 (1 year 7 months)

Managed a team of Sr. Database Administrators supporting over 2000 databases on over 275 SQL Server instances, several Oracle instances and three Data Warehouse environments on Teradata.

• Vendor application support including installation, upgrades and patching as well as SQL Server upgrades
• In-house application support including database refreshes to non-production environments, database and data comparisons, code reviews and performance tuning SQL
• Implemented ITIL processes and procedures including Change Management, Incident Management, Root Cause Analysis and Remediation and Service Management
• Worked with the team to successfully move all production servers from Portland to Denver which included virtualizing 98% of the SQL Server instances and Geo-clustering the remaining instances
• Trained team on Best Practices for installing, configuring and supporting SQL Server instances and troubleshooting and resolving performance issues
• Resolved various performance issues

Instrumental in the success of upgrading BizTalk in order to meet the demand of the web orders and SAP implementation project.
http://www.microsoft.com/casestudies/Microsoft-SQL-Server-2008-R2-Enterprise/Columbia-Sportswear-Company/Outdoor-Apparel-Manufacturer-Speeds-Online-Order-Processing-and-Boosts-Service/710000000246

Sr. Database Engineer

Fiserv

Public Company; 10,001+ employees; FISV; Information Technology and Services industry

March 2009May 2010 (1 year 3 months)

Support of highly available, high-transaction hosted online banking environments for over 20 Financial Institutions with up to 3.5 million customers and ~400 databases. Also performed as Project Manager of System Center Operations Manager and System Center Configuration Manager implementation, which included research, purchasing, planning, coordination, installation, configuration and rollout to production servers.

• Reviewed and approved all production application changes including a code review of all database changes
• Application installations, hot-fixes and upgrades as well as SQL Server upgrades
• Index analysis and maintenance
• Clustered database servers utilizing various SAN technologies on SQL Server 2000, SQL Server 2005 and SQL Server 2008
• Log Shipping support to DR environments in 3 different locations
• Database Mirroring and SAN Replication for DR purposes
• Performed DR tests including re-synchronization of DR to production
• Installation and configuration of new clusters for new customers
• R&D for a virtualized environment to lower costs for our hosted customers

Sr. Operations Database Engineer

Vesta

Privately Held; 1001-5000 employees; Insurance industry

May 2008March 2009 (11 months)

Support of highly available, high-transaction payment processing for pre-paid phones and pre-paid payment cards and services for over 40 customers including AT&T, Sprint, T-Mobile, Verizon, Boost and many others. Infrastructure consisted of 5 production clusters housing over 100 production databases ranging up to 1.5TB in the US, one cluster and reporting server in Europe, a data warehouse cluster and a reporting cluster.

• Reviewed, tested and implemented all application related changes to the production database environment on a daily basis
• Database refreshes to non-production environments as part of the development lifecycle
• Operations support of large, high volume transactional databases including maintenance, monitoring, troubleshooting performance issues and operational maintenance
• Implemented High Availability, Reporting and Disaster Recovery options including Microsoft Clustering, NetApp SnapManager database clones, SQL Server Database Mirroring and Replication
• Analyzed index fragmentation and set up processes to re-index frequently updated and fragmented indexes on a regular basis
• Determined root cause for all performance issues and worked with others to fix any issues that arose

Sr. Database Engineer

Mentor Graphics

Public Company; 1001-5000 employees; MENT; Computer Software industry

August 2003May 2008 (4 years 10 months)

Managed over 100 SQL Server databases and applications including monitoring, patching, SQL Server installation and configuration, server replacement, elevated application/database support, backups and recovery. In addition to my duties as a DBA, I was responsible for leading the Windows Data Center Team on and off while we hired replacement staff. This included leading a staff of 4 with Windows Administration of over 200 Windows NT/2000/2003 servers.

• Consolidated instances by implementing virtualization using PolyServe for SQL Server and virtualizing SQL Server hosts on VMware ESXi.
• Implemented and supported standard SQL Server HA and DR technologies including Microsoft Clustering, Replication, Database Mirroring and Log Shipping
• Standardized SQL Server backups to ensure that all databases were being backed up in a frequent and consistent manner
• Standardized the SQL Server installation and configuration process across all database servers
• Implemented a failover SQL Server for all key database servers
• Instituted re-occurring verification of tape backup copies of the database backups to ensure that the database backups were being captured and were useable
• Tested the Disaster Recovery Process on key databases
• Configured monitoring for the server Operating System and for SQL Server based on communication and decisions of other IT Professionals
• Created DTS Packages to import and export data to/from other database platforms

Acting Sr. Windows Server Engineer

Mentor Graphics

Public Company; 1001-5000 employees; MENT; Computer Software industry

August 2003May 2008 (4 years 10 months)

In addition to my duties as a DBA, I was responsible for leading the Windows Data Center Team on and off while we hired replacement staff. This included leading a staff of 4 with Windows Administration of over 200 Windows NT/2000/2003 servers including vendor management, hardware purchasing, server builds, Citrix administration, VMware ESXi administration, Resonate IIS load balancer administration, Repliweb web content administration, server monitoring and backups.

Standardized the Operating System build process along with the help of the System Administrators. Standardized the server and database patching process so that all servers are patched to the current level of patches released by Microsoft and ensured that future patches are applied in a standardized manner. Performed server backup audit to ensure that all servers were being backed up. Coordinated and managed effort to replace over fifty expired servers. Provided root cause analysis and reporting on all issues that I assisted in troubleshooting and resolving. Coordinated the purchase and implementation of all new or replacement servers. Liquidated retired assets.

Database Administrator and Build Manager

Forest City Trading Group

June 2001June 2003 (2 years 1 month)

Application Development, Build Management and Project Management of the Enterprise Lumber Trading application re-write project. Application was a 3-tier architecture with servers in multiple locations throughout the country.

Application Development
• Wrote Stored Procedures, tuned existing Stored Procedures, created indexes and managed all database changes
• Scripted all database changes to be migrated to QA and Production environments
• Maintained physical and logical data models
• Requirements gathering and wrote technical specifications documents
Build Management
• Kept track of all database and application changes for two parallel development efforts in a 3-tier environment
• Migrated all database changes to QA and Production environments using SQL scripts
• Handled all software build responsibilities including ensuring all changes were checked-in to source control, verifying dependencies, labeling source control, creating new COM+ components, updating incompatible COM+ components and packaging front-end application
• Implemented all application changes to QA and production middle-tier environments
Project Management
• Define and maintain the project plan for two parallel development efforts
• Coordinate testing and development efforts with the team members and updated defect and enhancement lists so both teams knew what was included in each build
• Communicate with testers and developers regarding testing efforts and defects found and to work with the team and management on implementation schedules
• Communicate project statuses with management, the business, testing teams, development teams and technical writer

Information Systems Analyst II / Database Administrator/Build Manager

Multnomah County

Government Agency; 1001-5000 employees; Government Administration industry

November 1999June 2001 (1 year 8 months)

Systems Analyst
Responsible for all aspects of the development cycle including:
• Gathering and documenting requirements
• Writing Use-Case documentation, technical specifications, test plans and test scripts
• Development of reports, user interfaces and COM objects
• Scripting database changes between environments

Database Administration
• Refreshing test databases and applying database changes for testing
• Database backups, recovery and data changes
• Created DTS Packages to import and export data to/from other database platforms
• Supported various Access database applications

Build Management
• Test and implement all database changes between environments
• Keeping track of all code changes, creating new MTS components for new and incompatible component changes, reviewing VB projects to ensure proper source control and verifying project references
• Build the application code and publish it to the IIS and Citrix servers

Michelle Prather's Skills & Expertise

  1. Database Administration
  2. Databases
  3. Microsoft SQL Server
  4. SSRS
  5. SSIS
  6. Business Analysis
  7. Unix
  8. Windows Server
  9. Database Design
  10. Disaster Recovery
  11. T-SQL
  12. Data Warehousing
  13. SQL
  14. Oracle
  15. SharePoint
  16. Software Development
  17. SDLC
  18. ITIL
  19. IIS

Michelle Prather's Education

Umpqua Community College

AAS, CIS

19951997

Chatsworth High School

1987

Michelle Prather's Additional Information

Websites:
Interests:

Martial Arts, Boxing, Kickboxing, Snowboarding, Scuba Diving, Music

Groups and Associations:

2011 Microsoft TechEd Conference 2009 Microsoft TechEd Conference 2009 Dell EqualLogic Training Professional Association of SQL Server Conferences  2010  2008  2006  2005  2002 2007 Microsoft TechEd Conference 2007 Microsoft Developer Connections Conference 2006 OracleWorld Conference 2005 mySQL Conference, San Jose, CA 2004 SQL Soft, San Francisco, CA  SQL Server High Availability 2004 Oracle, Wilsonville, OR  Oracle 9i Database Administration Fundamentals 1  Oracle 9i Database Administration Fundamentals 2 2001 DevelopMentor, Beaverton, OR  Essential VB.NET class 1999 Infotec, Portland, OR  SQL Server 7.0 System Administration

Contact Michelle for:

  • expertise requests
  • reference requests
  • getting back in touch

View Michelle Prather’s full profile to...

  • See who you and Michelle Prather know in common
  • Get introduced to Michelle Prather
  • Contact Michelle Prather directly

View Michelle's full profile

Not the Michelle Prather you were looking for? View more »

Viewers of this profile also viewed...