Brent Ozar - SQL Server DBA Rotating Header Image

Resume

Brent Ozar
Cell (281) 433-4054
Email brento@brentozar.com
Web www.BrentOzar.com

Technical Skills

  • Microsoft SQL Server 2008, 2005, 2000:
    • T-SQL, index performance tuning, RAID array tuning, backups, stored procedures, views, triggers
    • OLAP cubes using Databeacon
    • Member of Professional Association for SQL Server (PASS)
  • Storage Area Networking:
    • IBM DS4000 controllers
    • IBM Storage Manager, RDAC
    • Fabric zoning, Brocade switches
  • Hardware & Networking:
    • Hardware including server construction, RAID arrays
    • HP DL line, C-class and P-class blades, System Insight Manager
    • IBM System X, Director
    • TCP/IP, DNS
    • Switches, routers, load balancers
    • Microsoft Certified Systems Engineer (MCSE)

Primary Areas of Expertise (8+ Years)

Microsoft SQL Server 2000 and 2005 management and 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.

Accomplishment Highlights

  • Delivered sales & inventory data warehouse in under six weeks for a company that had struggled with bad solutions for two years.
  • 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.
  • Led the company’s Architecture Review Team to review and approve technology projects, helping to choose the right architectures and vendors across the company. Chosen by executives as one of the original team members, and then elected by the team to serve as leader.
  • Sent to the Microsoft Technology Center in Chicago to work directly with Microsoft staff on optimizing data warehouse processes, applications, hardware and SAN design.
  • Wrote SQL Server training & tuning articles for Quest Software, SQLServerPedia.com and BrentOzar.com.

Experience

SQL Server Domain Expert
Quest Software
5/2008 to Current

  • Editor-in-Chief of SQLServerPedia.com: design new wiki, recruit and manage editors.
  • Train developers, support and sales on SQL Server database administration.
  • Work with customers on beta software.
  • Design new features and validate new development.
  • Write technical whitepapers and articles for trade magazines.
  • Conduct webcasts on SQL Server training topics for the public.

Database Administrator
JPMorgan Chase, Houston TX
3/2008 to 4/2008

  • Worked on a team of 3 database administrators managing over 100 SQL Servers.
  • Supported clustering and replication for servers around the world on 28 different domains.
  • Complied with intricate security and compliance risks inherent with a global financial company.

Database Administrator & SAN Administrator
Southern Wine & Spirits, Miramar FL
10/2005 to 3/2008

  • Managed 25+ SQL Servers, from 20 gb servers to a 2 terabyte SAP BW data warehouse.
  • Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability of sales force automation and product routing.
  • Implemented Quest LiteSpeed backups to network drives to replace outdated tape-based backups. Backup windows shortened from as long as 16 hours down to under 2 hours, enabling company to keep more backups online.
  • Consolidated SQL Servers with SQL 2005, reducing server count by 50% and saving over $200k in licensing in one year.
  • Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
  • Designed and populated reporting tables, views and stored procedures.
  • Implemented partitioning to handle tables with over 300 million rows.
  • Trained developers on how to write better queries, optimize their applications and to become junior database administrators.
  • SAN administration for over 80 terabytes of storage. Performed capacity planning, maintenance, evaluations, purchasing, benchmark testing.

Database Administrator & Architect
UniFocus / Telman, Dallas TX
1999 to 2005

  • Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server, all Microsoft SQL Server 2000.
  • Responsible for all database architecture and program design, including survey systems, report developers, OLAP cubes, and interfaces with clients’ CRM software.
  • Data modeling with Case Studio and Erwin.
  • Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.
  • Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
  • Wrote triggers and stored procedures to integrate 3rd party applications into in-house apps such as project management systems with a minimum of development time, helping the company build new partnerships faster.
  • Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
  • Trained developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.
  • Evaluated OLAP tools, recommended Databeacon, and built web-based OLAP cube reporting systems around it.
  • Created web-based dashboard to show reports produced, average report run time, emails sent, surveys taken, etc.
  • Wrote, designed and produced customer site allowing customers to view reports, place orders, download newer software versions, and set up their own surveys.
  • Created company intranet with help desk ticket and order tracking.
  • Designed and wrote a web application for hospitals to retrieve their billing records over the internet, reducing their retrieval time from 45 days to less than 60 seconds. Achieved a quarter million hits per month from paying clients within 6 months.
  • Worked directly with executives to build demos for sales and marketing.
  • Implemented load balanced web servers for high availability.
  • Evaluated and purchased reporting systems including Actuate, Case Studio, Visual Studio .NET, NetCharts, and UML diagramming.
  • Wrote installation and procedural manuals for support staff.
  • Originally hired as an entry level programmer, and promoted up through the ranks to the lead project manager. Trained and managed a team of 5 programmers to produce systems on time and on budget.
  • Reported to Chief Information Officer.

Network Administrator & Programmer
Wright Investment Properties, Memphis TN
19997 to 1999

  • Managed 30-computer network at corporate office, plus networks at over 25 hotels, including purchasing, choosing contractors for repairs, and internet services. Duties included:
  • 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 in seconds rather than 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.
  • 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, Newport News VA
1994 to 1997

  • 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.