Stephanie Richter

Stephanie Richter Email and Phone Number

SQL Server Database Administration (DBA) Consultant, AWS CCP / President, Richter Consulting, Inc @ Richter Consulting, Inc.
200 South Wacker Drive,
Stephanie Richter's Location
Niles, Illinois, United States, United States
Stephanie Richter's Contact Details
About Stephanie Richter

• Over 30 years of experience designing, testing, implementing, tuning, migrating, upgrading and supporting relational databases in corporate environments• Over 25 years of experience in SQL Server administration, including installation and configuration, maintenance, performance tuning, migrations, upgrades, security, disaster recovery, data mart and data warehouse design, replication, clustering / high availability, and advanced Transact-SQL (T-SQL)• Over 15 years of experience creating SQL Server Reporting Services (SSRS) reporting systems• Over 15 years of experience developing SQL Server Integration Services (SSIS) ETL packages• Experienced in organizing and managing multiple projects, project teams, and deliverable deadlines in changing environments keeping within scope and within budgetDatabases: SQL Server 2019, 2017, 2016, 2014, 2012, 2008R2, 2008, 2005, 2000, 7.0, 6.5 (64- and 32-bit)Systems: Windows Server 2019, 2016, 2012, 2008, 2003, 2000, Vista, Windows XP, NT, MS-DOSLanguages: T-SQL, SQL, PowerShell, HTML, VBScript, DOSTools: AWS, DMS, SCT, Clustering, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), SentryOne, ER/Win, ER/Studio, Change Manager, Visual Studio, SQL Profiler, Performance Dashboard, sp_Blitz, Performance Monitor, Dynamic Management Objects and Views (DMOs/DMVs), OSQL, ISQL, SQLCmd, Crystal Reports, VMWare, Data Transformation Services (DTS) Packaging, OLAP, LiteSpeed Backup, Veritas tape backups, WebTrends, Tivoli SQL database backups, Spotlight, MS Office Suite (Word, Excel, PowerPoint & Outlook), Microsoft Project, Visio

Stephanie Richter's Current Company Details
Richter Consulting, Inc.

Richter Consulting, Inc.

View
SQL Server Database Administration (DBA) Consultant, AWS CCP / President, Richter Consulting, Inc
200 South Wacker Drive,
Website:
richterconsulting.com
Employees:
36
Stephanie Richter Work Experience Details
  • Richter Consulting, Inc.
    Sql Server Database Administrator (Dba)
    Richter Consulting, Inc. Feb 1995 - Present
    Clients:AZ Dept of Transportation, GetSwift, VW Credit, CDW, Insurance Auto Auctions, US Cellular, Chicago Transit Authority, Chicago Public Schools, Dell Professional Services, Heller Financial, , Arthur Andersen, American Bar Association, Arthur Andersen & Co, S.C., Eplexity, Applied Pathways, Omeda, Betzold Investment Group, Information Management Group, CommerxClient project details follow.
    View
  • Major Financial Services Corporation
    Sql Server Database Administrator
    Major Financial Services Corporation Jun 2022 - Present
    • Provided 24x7 support to 100+ servers with 3400+ databases on physical and virtual servers in development, testing, staging, and production environments, including those in Failover Clusters with Availability Groups across multiple data centers and on AWS EC2 servers• Migrated databases and instances to newer versions of SQL Server, including on-prem to AWS EC2 cloud servers• Developed standardized processes for SQL Server installation and configuration including Database Mail, alerts, and operators, to implement across all database serves• Implemented a Centralized Management Server and custom all-server data collection and proactive reporting process• Implemented Read-Only Routing on several Availability Groups in the clustered production environments
  • Taylor Corporation \ Venture Solutions \ Neps
    Sql Server Database Administrator
    Taylor Corporation \ Venture Solutions \ Neps Nov 2021 - Apr 2022
    Performed database-level and server-level performance tuning review on production, useracceptance test (UAT), quality assurance (QA) and development (DEV) database environments• Worked with SQL Server Profiler, Database Management Views (DMVs), PerformanceMonitor, Performance Dashboard, SQLQueryStress, SSMS, T-SQL report queries• Implemented recommendations at the server level related to SQL Server installation andconfiguration settings• Implemented recommendations at the database level and worked with the developers and thesupport team to test and implement code-based recommendations
  • Arizona Department Of Transportation \ Getswift
    Sql Server Database Administrator
    Arizona Department Of Transportation \ Getswift May 2020 - Jun 2021
    • Supported several different client projects based on AWS cloud-based technologies, including SQL Server RDS and SQL Server EC2• Converted databases from on-premise to cloud-based using AWS tools, including AWS Data Migration Service (DMS) and AWS Schema Conversion Tool (SCT)• Redesigned, standardized and automated the SQL Server environment set-up, including daily database-level and server-level maintenance routines, alerting, and Database Mail configuration
  • Vw Credit, Inc.
    Sql Server Database Administrator
    Vw Credit, Inc. Oct 2019 - Apr 2020
    Reston, Va, Us
    • Solely supported over 130 servers, including over 40 production servers, in a highly-available OLTP and reporting environment that included multiple availability groups, clusters, stand-alone servers, replication and linked servers• Redesigned and standardized the environment, including daily database-level and server-level maintenance routines, alerting, and Database Mail configuration• Implemented a CMS-based all-server reporting environment, including availability group login and job discrepancies, error log messages, invalid logins and orphaned users issues• Created several SSRS reports, including database, database growth and job history information
    View
  • Insurance Auto Auctions
    Senior Sql Server Database Administrator
    Insurance Auto Auctions Nov 2018 - May 2019
    Westchester, Il, Us
    • Supported almost 200 servers, including over 50 production servers, in a highly-available OLTP and reporting environment that included multiple availability groups, clusters, stand-alone servers, replication and linked servers• Planned and executed all SQL Server service pack updates and security patch updates• Improved the upgrade process though process and document standardization
    View
  • Coyote Logistics
    Senior Sql Server Database Administrator
    Coyote Logistics Jan 2018 - Jun 2018
    Chicago, Illinois, Us
    Senior SQL Server Database Administrator - SQL Server 2017/2016/2014/2012/2008R2, Windows Server 2012/2008• Supported over 120 servers, including over 60 production servers, in a highly-available OLTP and reporting environment that included multiple availability groups, clusters, stand-alone servers, replication, log shipping and linked servers• Reduced the run-time of mission-critical OLTP application stored procedures utilizing various tools including SentryOne, SQL Profiler tracing, Performance Dashboard, sp_Blitz, Performance Monitor, query plans, and Dynamic Management Views (DMVs)• Led a project to standardize all cross-server DBA maintenance routines, including backup procedures, index optimizations and database integrity checks• Wrote a custom reporting process to identify missing logins and jobs on related availability groups as well as on related standby servers• Developed an environment and process to use a Centralized Management Server to host multiple reporting and environment check processes• Documented multiple physical database environments, including availability groups, clusters, linked servers, replication, IP addresses and SQL Server versions using Visio objects
    View
  • Applied Pathways Llc
    Sql Server Database Administrator (Dba)
    Applied Pathways Llc Nov 2016 - Apr 2017
    Senior SQL Server Database Administrator, MS SQL Server 2016/2014/2012/2008R2, Windows Server 2012/2008 (32- and 64-bit), Amazon Web Services (AWS)• Developed performance-tuning recommendations for current and future client implementations in Amazon Web Services (AWS), virtual and standard environments• Executed performance testing utilizing various tools for including SQL Profiler tracing, Performance Dashboard, sp_Blitz, Performance Monitor, query plans, and Dynamic Management Views (DMVs)• Designed and implemented standardized maintenance routines, backup procedures and proactive alerting in AWS, virtual and standard environments• Reviewed existing development, testing and production environment database designs and database implementations• Documented physical database environment, including hardware and software configurations, as wells as database design of tables, views, columns, and indexes
  • Cdw
    Sql Server Database Administrator (Dba)
    Cdw Apr 2016 - Nov 2016
    Vernon Hills, Il, Us
    Senior SQL Server Database Administrator, MS SQL Server 2014/2012/2008R2/2008, Windows Server 2012/2008 (32- and 64-bit), SSRS, SSIS, VMWare, DDBoost, Replication• Supported 300+ servers with 3600+ databases on physical and virtual servers in development, test and production environments• Installed, monitored and enhanced standardized optimization and integrity routines, backup procedures and proactive alerting across all database servers• Reduced runtime of multiple processes significantly through stored procedure query tuning using SQL Profiler tracing, Performance Dashboard, sp_Blitz, Performance Monitor, query plans, and Dynamic Management Views (DMVs)• Provided SQL Server expertise on company project using agile/scrum methodology• Developed and supported SQL Server policy alerting using T-SQL and PowerShell• Provided company-wide 24x7 off-hours support 1 out of every 4 weeks
    View
  • U.S. Cellular
    Sql Server Database Administrator (Dba)
    U.S. Cellular 2015 - 2015
    Chicago, Illinois, Us
    Senior SQL Server Database Administrator, MS SQL Server 2012/2008/2005, Windows Server 2008 (32- and 64-bit), SSRS, SSIS, VMWare, SQL DB backups• Supported multiple SQL Server database servers/instances, including multiple databases, multiple instances and multiple environments• Standardized optimization and integrity routines and backup procedures across all database servers• Performed and documented environment assessment and recommendations• Reduced runtime of multiple processes significantly with environment reconfiguration
    View
  • Chicago Transit Authority
    Sql Server Database Administrator (Dba) / Sql Server Developer
    Chicago Transit Authority 2011 - 2014
    Chicago, Il, Us
    Senior SQL Server Database Administrator, MS SQL Server 2012/2008/2005/2000, Windows Server 2008 (32- and 64-bit), SSRS, SSIS, VMWare, VPN, Tivoli SQL DB backups• Supported over 35 SQL Server database servers/instances, including multiple databases, multiple instances and multiple environments• Standardized maintenance routines and backup procedures across all database servers• Reduced runtime of multiple processes significantly using smart procedures• Trained several employees on database administration concepts and procedures
    View
  • Omeda
    Sql Server Database Administrator (Dba) / Sql Server Developer
    Omeda 2006 - 2008
    Chicago, Illinois, Us
    Senior SQL Server Database Administrator/SQL Server Developer, MS SQL Server 2008, Windows Server 2008, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), VMWare, VPN, Clustering• Planned, developed and supported the SQL Server clustered systems, including multiple databases, multiple instances and multiple environments• Reduced runtime of multiple processes significantly using performance tuning tools• Designed and implemented multiple database reporting structure using SQL Server Reporting Services (SSRS)
    View
  • Chicago Public Schools
    Sql Server Database Administrator (Dba)
    Chicago Public Schools 2005 - 2006
    Chicago, Il, Us
    Senior SQL Server Database Administrator, MS SQL Server 2000 64-bit Clusters, Windows Server 2003 64-bit Clusters, ER/Studio, Visio, Veritas, VPN• Planned, developed and supported SQL Server 2000 Enterprise 64-bit, 32GB RAM environments, including Windows 2003 Datacenter 64-bit, 32GB RAM clusters with multiple database instances• Worked very closely with the Data Modeler using ER/Studio to develop the physical database components of the operational data store, including primary keys, foreign keys, indexes and alternate keys• Developed failover and failback strategy and testing• Assisted implementation of Veritas database tape backups• Designed and implemented application database security documentation and strategy
    View
  • Dell
    Sql Server Database Administrator (Dba) / Sql Server Developer
    Dell 2004 - 2004
    Round Rock, Texas, Us
    Senior SQL Server Database Administrator, MS SQL Server 2000, Windows 2000, MS Visual SourceSafe and Embarcadero ER/Studio and Database Compare products• Performed as a DPS Consultant to DPS client• Planned, developed and supported several 5-20GB intraweb-based application databases in a SQL Server 2000 / Windows 2000 environment• Assisted in the design of new databases using Embarcadero ER/Studio• Supported database environment using SQL Server 2000 tools and Embarcadero Change Manager• Determined and implemented performance tuning measures• Developed SQL replication creation and deletion scripts• Implemented various Data Transformation Services (DTS) packages• Maintained database environment security for development, test and pre-production environments
    View
  • Various Companies
    Sql Server Database Administrator (Dba) / Sql Server Developer
    Various Companies 1995 - 2004
    Betzold Investment Group, Information Technology, Chicago, IL 2003 – 2004 Database Administrator / Data Warehouse Architect, MS SQL Server 2000, Windows 2000, MS Visual SourceSafe and Embarcadero productsClerisys Technologies, Information Technology, Chicago, IL 2002 – 2003 DBA/Data Warehouse Architect, SQL Server 2000, Windows 2000 & Crystal Reports 8.5Information Management Group, Inc., IMG University, Chicago, IL 2001 Online Instructor / Online Trainer, MS SQL Server 2000 and Windows 2000Heller Financial, Information Technology, Chicago, IL 2000 Database Administrator / Upgrade Coordinator, MS SQL Server v6.5-to-7.0 ConversionCommerx, Information Technology, Chicago, IL 1999 – 2000 Database Administrator, MS SQL Server 7.0Heller Financial, Information Technology, Chicago, IL 1998 Database Administrator, MS SQL Server v6.5 ConversionArthur Andersen, Technology Services, Chicago, IL 1997 Database Administrator, Voice and Information GroupAmerican Bar Association, Information Systems Group, Chicago, IL 1996 Application Database Administrator, Project 2000 Data WarehouseArthur Andersen & Co., S.C., Information System Services, Chicago, IL 1995 - 1996 Programming Supervisor and Application DBA, North American Payroll System
  • Andersen Consulting
    Sql Server Database Administrator (Dba) / Sql Server Developer
    Andersen Consulting Jun 1991 - Feb 1995
    Dublin 2, Ie
    Team Leader, Database Architecture team, Boston – Sybase SQL Server, UNIX.Database Administrator, Process/1 development team, Chicago - Windows NT, Microsoft SQL Server, DEC VAX, Rdb/VMS, COBOL, ISO 9000.Team Leader, PC Development Technical Support Team, Chicago - MicroFocus's COBOL Workbench, XDB, Stingray, Endevor, DOS, Novell LAN, Compaq and Dell 486/33 PCs.Developer/Analyst, Technical Architecture and Support team's Test Data Management and Client Workbench teams, Chicago - DB/2, COBOL, IMS, IBM 3090, Andersen Consulting's MAC-PAC/D product, TSO ISPF Dialog Management clists, skeletons, tables, panels.
    View
  • Arthur Andersen
    Relational Database Specialist
    Arthur Andersen 1988 - 1991
    Developer/Analyst/Application Database Administrator, Personnel Information Database team and North American Payroll System team, Chicago - DB/2, COBOL, CICS, IBM mainframe, TSO ISPF, and CASE tools.

Stephanie Richter Skills

T Sql Microsoft Sql Server Databases Ssis Ssrs Crystal Reports Database Administration Sql Data Warehousing Sql Server Relational Databases Database Design Database Development Database Management Disaster Recovery Database Admin Management Performance Tuning Vmware Backup And Recovery Systems Stored Procedures T Sql Stored Procedures Cluster Sql Server Management Studio Database Queries Transact Sql Sql Server Integration Services Sql Server Reporting Services Sql Report Writing Database Engine Tuning Advisor Replication Etl Tools Integration Windows Server Microsoft Servers Troubleshooting High Availability Security Software Development Software Documentation Software Installation Powershell Testing Performance Enhancement Performance Improvement Visual Studio Microsoft Office Software Development Life Cycle Business Intelligence

Stephanie Richter Education Details

  • Augustana College
    Augustana College
    Business Administration

Frequently Asked Questions about Stephanie Richter

What company does Stephanie Richter work for?

Stephanie Richter works for Richter Consulting, Inc.

What is Stephanie Richter's role at the current company?

Stephanie Richter's current role is SQL Server Database Administration (DBA) Consultant, AWS CCP / President, Richter Consulting, Inc.

What is Stephanie Richter's email address?

Stephanie Richter's email address is rc****@****aol.com

What is Stephanie Richter's direct phone number?

Stephanie Richter's direct phone number is +184783*****

What schools did Stephanie Richter attend?

Stephanie Richter attended Augustana College.

What are some of Stephanie Richter's interests?

Stephanie Richter has interest in Exercise, Sweepstakes, Home Improvement, Shooting, Reading, Gourmet Cooking, Sports, Home Decoration, Cooking, Electronics.

What skills is Stephanie Richter known for?

Stephanie Richter has skills like T Sql, Microsoft Sql Server, Databases, Ssis, Ssrs, Crystal Reports, Database Administration, Sql, Data Warehousing, Sql Server, Relational Databases, Database Design.

Who are Stephanie Richter's colleagues?

Stephanie Richter's colleagues are Timothy Maag, Cpa, Khaula Ajmal, Howard Gross, Matthew Goldsmith, Jeremy Maron, Marc Yedid, Michael Zhu.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.