Brian Stork Email & Phone Number

Seattle, Wa, Us

Seattle, Washington, United States

Greater Seattle Area

Seattle, Washington

Bellevue, Wa

Lead position on small Agile team, solving interesting problems in large, high-traffic healthcare databases which served as back end in a Software-as-Service flagship, best-in-class web application. Extremely visible, high availability product provided ample opportunities for performance tuning, metrics gathering, and constantly expanding SQL knowledge including partition schemes, automated maintenance programs, index evaluation, query tuning. Spearheaded and completed initiative to get all database code into source control system, created system to monitor schemas and data and alert on undocumented changes, automated rollout/rollback script creation. Mentored several junior-level developers (and some managers) in best practices and new features of SQL Server. Initiated test-driven database development with tSQLt framework, included SQL test suite into automated delivery pipeline.

Bothell, Wa

Researched, designed, coded new stored procedures, functions, views, tables, indexes, and triggers. Troubleshooting and tuning of existing procedures. Maintained database source in ERWIN Modelmart. Generated procedure for purging archive data into XML format. Instrumental in preparing database to migrate from stand-alone to networked application. Created daily builds of SQL code for testers, created C# application to maintain build instructions in detached XML files. Created XML-based schema and export procedures to allow standardized communication between our product and client’s medical information system. Developed configuration tools (C#), XSLT transformations and UI design (Javascript/CSS) for web-based Medical Record product. Developed documentation of build procedures and best-practices for SQL coding.

Seattle, Wa

As SQL Developer, responsible for designing and developing new procedures, tables, triggers, views and Agent Jobs to automate and improve web-based analytical report engine relating to the telecommunications industry. Created 'hands-off' load system to populate fact and dimension tables (ETL). Analyzed, evaluated and improved existing third-party application code.

Bellevue, Wa

As an internal developer, was responsible for creating logical and physical data models, logic-flow diagrams, scope and design documents, and all SQL objects with installation NT-batch scripts. Conceived, designed, created and presented an award-winning software solution to the Microsoft Certification team.

Bellevue, Wa

As a contractor for Microsoft, worked in the web-statistics department maintaining and improving existing systems across multiple servers. Responsible for monitoring automated log-collection, file import and report generation processes. Created tools to further automate and monitor the systems. Also responsible for maintaining the group's inter-office web page.