Scroll To View More
James Bond, Software Developer in Orlando, FL, United States
James Bond

Software Developer in Orlando, FL, United States

Member since October 29, 2017
Professionally, James has made mastering all the ins and outs of the behemoth that is SQL Server his primary career niche. English is a second language, right after T-SQL. His recent work has been focused almost entirely on large enterprise-level MS SQL Server design and development projects. James also received a Bachelor of Science degree from Vanderbilt University, which especially qualifies him for technical writing projects.
James is now available for hire

Portfolio

Experience

  • SQL, 17 years
  • SQL Stored Procedures, 15 years
  • T-SQL, 15 years
  • SQL Server 2016, 15 years
  • SQL Server Integration Services (SSIS), 10 years
  • SQL Server Reporting Services (SSRS), 5 years
  • C#, 3 years
Orlando, FL, United States

Availability

Part-time

Preferred Environment

Microsoft stack, VS, SQL Server, SSIS,SSRS

The most amazing...

...project of my career has been building an enterprise-wide asset management/search tool for Disney. Upgrading the UMG iTunes delivery system was a highlight too.

Employment

  • Database Architect

    2013 - 2017
    Guidance Solutions
    • Developed multiple ETL utilities with SSIS working with raw data, and other RDBMS such as Sybase and Oracle.
    • Focused on maximum reliability for high OLTP eCommerce sites with the capability to handle demands of higher transaction periods.
    • Managed optimization and health for multiple SQL Server databases.
    • Generated processes to automate recommending optimal configurations for new clients based on environment and known best practices.
    Technologies: SQL Server, SSIS, SSRS
  • Senior Engineer

    2012 - 2013
    INgrooves Fontana
    • Hired as full time senior engineer reporting directly to the CTO. Essentially brought on board to continue the UMG consultancy role described below but also to assist the segue towards an Ingrooves-owned digital supply chain SaaS solution and assist in the data architecture for such a system.
    • Created and optimized several complex stored procedures responsible for cross server processing.
    • Designed a process to cleanse multiple data sources to create a master data record for a data governance project.
    Technologies: SQL Server, C#, SSIS
  • Senior Consultant

    2007 - 2012
    Universal Music Group
    • Designed a custom "process-ready" replication engine via SSIS to expose in-flight data to the application only once business logic deemed it conceptually complete.
    • Designed corporate-wide production data and schema auditing processes.
    • Designed custom architecture to use process semaphores to provide the ability to allow multiple anonymous sources to attempt to start stored procedures but allow only one to win.
    • Created a process to clone all required data elements for a new label based on a template label that encompassed generating millions of records with a rules engine to determine data permissions.
    Technologies: SQL Server, SSIS, SSRS, VB.NET
  • Senior Database Architect

    2003 - 2007
    Walt Disney Studios
    • Performed all the duties of a senior SQL Server DBA and SQL programmer for the length of my tenure as the lone database pro. The project was a highly customizable and diverse web-based media asset management application (MAM system) proprietary to Disney.
    • Developed a responsive search engine that considered millions of rows of data across various tables and applied real-time permission data against up to 300 business rules.
    • Architected the design to allow search to split across several threads so that the engine could quickly return the most popular results in a requester's department while simultaneously churning additional results in the background.
    • Implemented a peer-to-peer SQL Server network to consume and share asset metadata across departments.
    • Developed an engine, using Ghostscript and VB objects, to parse PDF and Word documents for terms and developed a codebase to do advanced string searches like terms "near" one another and term count > n.
    Technologies: SQL Server, C#, DTS/SSIS

Skills

  • Languages

    T-SQL, SQL, PHP, C#
  • Platforms

    Windows, Linux
  • Storage

    SQL Server Integration Services (SSIS), SQL Stored Procedures, SQL Server 2016, SQL Server Reporting Services (SSRS), MySQL, SQL Server Management Studio, PostgreSQL
  • Paradigms

    Agile

Education

  • Bachelor of Science degree in English
    1991 - 1995
    Vanderbilt University - Nashville TN
I really like this profile
Share it with others