All Things Data & Tech

Welcome! I’m a tech geek/writer. After 15 years in the Oracle Database space, I’ve pivoted to writing mostly fiction. This blog is a place for my data and tech insights, including years’ worth of posts on Oracle, RAC, Clusterware, database administration and SQL.

Did you say Oracle?

I got into databases in the first dot-com boom as a DBA/Developer working in SQL, PL/SQL and Perl, then joined Oracle in 2007 as part of the Real Application Clusters (RAC) support team. RAC is simply the best clustered database available. I wrote over 100 support documents while with RAC Support.

My last position for Oracle Corporation was as a Developer Advocate for SQL for Oracle Corporation. SQL and the relational model are powerful abstractions that let developers and data analysts focus on the data.

Did you say… writing?

When I’m not playing with databases, I like to play with words. You can find my writing website here: http://nrmroshak.com.

Tech Things I Can Do…

  • 15 years’ experience in database administration, programming and support
  • OCP certified
  • RAC and Clusterware guru

Database Programming and Analysis

Before joining Oracle, I was a database administrator and PL/SQL programmer with a focus in data integration and systems reconciliation.

  • ETL programming; data cleaning
  • Query and code optimization
  • SQL, PL/SQL, Perl, bash

Database Architecture

  • ER diagrams
  • Physical and logical data models
  • Full life-cycle database, system and code architecture