toptal.com
Contact us: +1.888.867.7001
Mike Stankavich, Data Modeling Developer in Austin, TX, United States
Mike Stankavich

Data Modeling Developer in Austin, TX, United States

Member since December 27, 2013
Mike is a senior data engineer and freelance architect experienced across the development stack. He has extensive cloud and infrastructure experience, with multiple certifications from Microsoft, ISC2, Powersoft, and more. He currently builds data back ends for web apps at scale on RDBMS or NoSQL platforms.
Mike is now available for hire
Hire Mike

Portfolio

Experience

  • DevOps 17 years
  • Data Modeling 13 years
  • Database-driven Web App Development 13 years
  • Data Migration 10 years
  • Change Management 8 years
  • Amazon Web Services (AWS) 2 years

Location

Austin, TX, United States

Availability

Part-time

Preferred Environment

Amazon Web Services (AWS), Python, PostgreSQL, Windows, MacOS

The most amazing...

...thing I've done is co-author an international standard for supply chain data exchange.

Employment

  • Data Engineer, Architect

    2013 - PRESENT
    Certain, Inc.
    • Worked as data lead for a Microsoft SQL Server to Postgres migration.
    • Handled extensive performance tuning, including adding indices, rewriting queries, etc.
    • Selected BI platform and planned migration.
    • Drove ORM best practices with Hibernate developers.
    • Reviewed, enhanced, and approved schema changes.
    Technologies: Adobe ColdFusion, Hibernate, Java, Microsoft SQL Server, PostgreSQL

  • Database Architect, Senior Consultant

    2011 - 2013
    UST Global (Contracted to Intel)
    • Designed and implemented schema changes to support a major multi-year refactoring project.
    • Built a service to full-text index documents in a ~2TB custom file store.
    • Built an asynchronous interface for shop floor control systems with guaranteed sequenced delivery on an SQL Server service broker. Used SQL CLR.
    • Served as subject matter expert, with extensive domain knowledge of the app functionality.
    • Worked as liaison between the offshore development team and onshore developers.
    Technologies: C#, ASP.NET, Microsoft SQL Server

  • Data Modeler, Architect, Reporting Lead

    2010 - 2011
    Deutsche Bank
    • Managed team of 12 Oracle and Cognos developers.
    • Tuned performance and built an ETL for reporting solutions.
    • Conducted interviews and selected candidates.
    • Reviewed and approved schema changes.
    • Coordinated with middle tier developers and changed the management organization to manage projects.
    Technologies: Java, IBM Cognos, Oracle

  • DBA, Enterprise Software Engineer, Developer

    1999 - 2010
    Intel Corporation
    • Worked as application infrastructure platform lead. Coordinated with IT service organizations to specify and manage around 60 servers across multiple data centers.
    • Designed schema, approved changes, and led CCB meetings.
    • Worked on various middleware and back-end development projects.
    • Led the migration from SQL Server 2000 to 2005. Implemented SQL Server failover clustering.
    • Designed and managed the SQL Server transactional replication environment.
    • Participated in the standards building process for supply chain data. Co-authored the international standard for product data exchange.
    • Built interfaces for other enterprise apps, including SAP and shop floor control systems.
    Technologies: SAP, TIBCO, VB, C++, C#, PowerBuilder, ASP.NET, Microsoft SQL Server

Experience

  • International standard for product data exchange

    Co-authored an international standard for product data exchange between supply chain partners.

  • Microsoft SQL Server to Postgres migration

    Transformed, cleaned, and extracted data from MS SQL 2005. Scripted encoding translation and loaded to Postgres for a SaaS vertical.

  • SQL Server 2005 to 2008 migration

    Migrated approximately 30 servers across development, testing, production, and DR environments from SQL Server 2005 to SQL 2008. Implemented SQL Server fallover clustering along the way.

Skills

  • Languages

    T-SQL, SQL, PowerBuilder, PL/pgSQL, VB, Python, PHP, JavaScript, Java, C#, C++

  • Paradigms

    Evolutionary Database Design, DevOps, Database-driven Web App Development, Change Management, Agile Software Development, Waterfall Development, REST, Object-oriented Programming (OOP), Scrum, Cross-platform, Dataflow Programming, OLAP

  • Platforms

    Windows, Amazon Web Services (AWS), Linux, Oracle, MacOS, iOS, Android

  • Storage

    Microsoft SQL Server, Oracle PL/SQL, PostgreSQL, MySQL

  • Other

    Data Migration, Data Modeling, Software Configuration Management (SCM), Offshore Development, TIBCO, MS SQL Developer, TCP/IP, Data Structures, SAP, Ajax, Version Control

  • Tools

    Erwin, Adobe ColdFusion, IBM Cognos

  • Frameworks

    Hibernate, .NET, Django, ASP.NET, ADO.NET

  • Libraries/APIs

    jQuery

Education

  • BS Degree in Computer Information Systems
    2008 - 2009
    Thomas Edison State College - Trenton, NJ

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM