IT‑IS‑Networking
Technology › Design & Engineering

SQL & Data Platforms

SQL Server administration and database design from 6.5 onward — and object database work that predates it.

Also known as SQL Server, Object Databases

Left to right is time. Each row is one of the 9 disciplines this one worked alongside, ordered so kindred disciplines sit next to each other rather than alphabetically — a landscape only means anything if neighboring rows belong together. Height is the work running in that domain in that year, weighted by what failure would have cost — life-safety ×3, a statutory obligation ×2.2, the estate itself ×1.5, an evaluation ×1. Every project declares which of those it was, so each ridge traces to an entry you can open and disagree with. Only the work that used this technology is counted, so what shows here is the company it kept rather than the record around it. Height and color are on the record-wide scale rather than this page’s own, so a modest estate draws a modest landscape and any two of these pages can be read against each other.

SQL Server 6.5 and 7.0 administration and database design, certified across four component exams, applied to Prudential’s paperless system databases, StorComm’s imaging platforms and the web-based change management system built for JEA.

Object database design goes back further still, to the CSX railroad map digitization in 1996.

Applied in

  • Enterprise GIS Platform2006–2023Seventeen years of architecture authority over the City's geospatial estate — and the record of it is a capacity and availability record rather than a mapping one.
  • Enterprise Business Intelligence Platform and Capability2012–2016Architecture authority over the City's analytics platform, held deliberately apart from the group that built the reports — with the capability hired and taught to a published standard.
  • Insurance Carrier E-Commerce Platform2001–2003Mainframe to public web in 2001, across a colocation tunnel and two firewalls — where the deliverable was the boundary, not the website, and the documentation reached revision 243.
  • JEA Change Management System2000–2003A web-based change management process and system designed from first principles, later carried to the City as the enterprise standard.
  • Prudential Scanning, Imaging and Workflow Program1997Specialized support for a two-year imaging and workflow program, as one of three on the imaging team.
  • CSX Railroad Map Digitization1996Digitizing CSX property maps dating back to the 1800s, with MDL application development against MicroStation.

Career

Attested by

  • MCSE 2000+I1996 · LapsedMicrosoft Certified Systems Engineer + Internet on the Windows 2000 track, held continuously from 1996 — the systems and data layer beneath the network architecture.

See also

Also searched as

  • ETL
  • ELT
  • data warehouse
  • OLAP
  • dimensional modeling
  • star schema
  • analytics platform