Domain Expert at Quest Software
Greater Chicago Area
- Current
-
- Microsoft SQL Server MVP at Microsoft SQL Server MVP
- Domain Expert at Quest Software
- SQL Server DBA at (PASS) Professional Association for SQL Server
- Past
-
- Database Administrator at JPMorgan Chase
- Senior SQL Server Database Administrator at Southern Wine & Spirits
- Data Warehouse Administrator at Kanbay
- Database Admin & Architect at UniFocus
- Network Administrator & Programmer at Wright Investment Properties
- Network Administrator & Budget Analyst at Lane Hospitality
- Recommended
-
14 people have recommended Brent - Connections
-
270
connections
- Industry
- Information Technology and Services
- Websites
Brent Ozar’s Summary
A database administrator & project architect with a proven ability to get reliable and scaleable projects out on time.
My SpeakerRate page:
http://www.speakerrate.com/speakers/3091-brentozar
Brent Ozar’s Experience
-
Microsoft SQL Server MVP
Microsoft SQL Server MVP
(Information Technology and Services industry)
2009 — Present (less than a year)
-
Domain Expert
Quest Software
(Public Company; 5001-10,000 employees; QSFT; Information Technology and Services industry)
April 2008 — Present (1 year 8 months)
-
SQL Server DBA
(PASS) Professional Association for SQL Server
(Information Technology and Services industry)
2007 — Present (2 years )
-
Database Administrator
JPMorgan Chase
(Public Company; 10,001 or more employees; JPM; Banking industry)
March 2008 — April 2008 (2 months)
-
Senior SQL Server Database Administrator
Southern Wine & Spirits
(Privately Held; 10,001 or more employees; Wine and Spirits industry)
March 2006 — March 2008 (2 years 1 month)
Microsoft SQL Server 2000 and 2005 performance tuning including index tuning, query modifications, partitioning and hardware optimization. Database administration for databases up to 2 terabytes, including T-SQL coding, stored procedures, backup/recovery, high availability. SAN administration for nearly 100 terabytes of storage.
-
Data Warehouse Administrator
Kanbay
(Public Company; 5001-10,000 employees; KBAY; Information Technology and Services industry)
October 2005 — March 2006 (6 months)
Managed 200gb sales & inventory data warehouse on SQL Server 2000, migrated to 2005.
Designed and populated data mart reporting tables, views and stored procedures.
Wrote stored procedures to audit and cleanse incoming data from other enterprise systems including AS400, DataStage.
Worked with BusinessObjects developers to optimize their queries, test their reports, and validate their logic.
Linked customer data with TDLinx / ACNielsen demographic data for better sales reporting.
Implemented automatic source code control so that all database schema changes were logged in Visual Source Safe every 4 hours.
Used partitioning in SQL Server 2000 to handle tables with 150+ million rows of data.
Created and tested migration plan for SQL Server 2005.
Responsible for backups & restores across production, QA and development servers.
Data modeling & design using Case Studio.
Wrote technical documentation for other developers and the client’s network teams. -
Database Admin & Architect
UniFocus
(Privately Held; 51-200 employees; Information Technology and Services industry)
October 1999 — October 2005 (6 years 1 month)
Grew & tuned database servers to handle rapid growth from a single machine handling a few dozen web clients to a pair of replicated SQL servers handling thousands of logins per day with 24/7 uptime to service clients around the world.
Reinvented company reporting from shipping tens of thousands of monthly paper reports to thousands of hotels, to using web-based reports available instantly. Customer satisfaction went up, printing and shipping expenses disappeared, and profit increased.
Created new web-based tools being used by hundreds of hotels like The Venetian, Colonial Williamsburg, Intrawest Resorts. Reinvented traditional hotel paper comment cards: these hotels now email the guest within 24 hours of checkout, email the guest's feedback to the hotel immediately, and respond quickly.
Created a company intranet that controlled everything from help desk requests, customer supply orders, printing & shipping, software development requests. -
Network Administrator & Programmer
Wright Investment Properties
(Privately Held; 1001-5000 employees; Leisure, Travel & Tourism industry)
September 1997 — October 1999 (2 years 2 months)
Created web-based sales management tool for marketing staff to manage daily productivity
Wrote, designed and produced internet-based data transmission system to get financial numbers to headquarters within 30-60 seconds rather than 1-2 hours.
Designed company web sites and intranet in ASP and SQL Server 7.
Implemented Windows NT Servers & Workstations to replace Unix terminals, including purchasing & installation.
Managed 30-computer network at corporate office, plus networks at over 25 hotels, including purchasing, choosing contractors for repairs, and internet services.
Trained company staff on accounting, computer use. Led presentations at company-wide conferences.
Wrote company internal audit and accounting manual.
Responsible for ensuring license compliance and training staff.
Reported directly to Chief Financial Officer. -
Network Administrator & Budget Analyst
Lane Hospitality
(Privately Held; 5001-10,000 employees; Hospitality industry)
August 1994 — September 1997 (3 years 2 months)
Wrote, designed and produced company budget spreadsheets for hotels and imported them into the accounting system.
Managed 20-node Novell Netware network and Windows workstations.
Designed & maintained company web site.
Was instrumental in regional managers investigating ways to cut costs and increase efficiencies in hotel budgets.
Reported directly to Vice President of Operations.
