SUMMARY

• Proven success as an innovative, reliable, and highly capable database technologist.
• Proven track record in successful database development projects, database administration and database management as well as strategic technical planning for SaaS products and services.
• Highly adaptive at anticipating new technologies and changing business requirements for implementation into product plans.

• Database technologies
• RDBMS (MS SQL Server, MySQL)
• NoSQL (Cassandra, Hadoop, Neo4j)
• SDLC Processes (Agile Scrum)
• Project tracking systems (Jira, TFS, others)
• Code management (TFS, GIT)
• Database Modeling
• ERD (Erwin, Visio)
• Conceptual, Logical, Physical, Dimensional
• SQL Server Optimization (architecture, TSQL code)
• ETL - SSIS
• OLTP, OLAP (SSAS)
• SaaS (hosted, hybrid cloud)
• Database analysis / System Monitoring (Profiler, Extended Events, CloudWatch, Sys. Center)
• Database Administration
• Capacity planning
• High Availability (Failover Cluster, Mirror, HA groups)
• Disaster Recovery (Log Shipping)
• Software as a Service (SaaS)

PROFESSIONAL EXPERIENCE

Confidential

Principal Consultant / Owner

Responsibilities:

• Provide expertise in SQL Server database development, administration, planning, integration, and database system security (performance analysis, High Availability, Data Management and capacity planning)
• Deep database high availability experience using SQL Server Mirroring, Log Shipping (for Disaster Recovery), Clustering (High Availability)
• Demonstrated ability to analyze and correct database architecture, models, performance, security, and data flow issues.
• Successfully upgraded several SQL Server systems to 2014 and 2016.
• Automation of ETL processes (using SSIS data tools and SQL Agent)
• SDLC process enhancement and Agile Scrum implementation/assessment utilizing a strong knowledge of software processes and structure (Agile Scrum, security, SDLC, database code management, and project management).

Environment: SQL Server (2008 R2 to 2016), TSQL, Database Mirroring, Log Shipping, TFS 2015. SSIS, SQL Profiler

Confidential

Technology Lead

Responsibilities:

• As technical leader, oversaw hiring of UI and Middle-tier developers and designers while creating documentation for databases
• Created RDBMS data model and data dictionary documentation from existing SQL Server structures and Python ORM code
• Utilized historical data from Tableau and existing data in SQL Server and Cassandra for capacity planning.
• Created a plan for moving a hybrid (hosted and cloud) based SaaS to 100% cloud based architecture. This analysis considered the existing use of Cassandra, Redis, and MS SQL Server 2008 R2 and planned for a more consolidated architecture that accounted for current and future functionality.

Environment: SQL Server 2008 R2, Cassandra, SQLAlchemy, Amazon Web Service (AWS), Python, Jira, Tableau, Ansible

Confidential

Senior Director of Product Development (database), Director of Database and Reporting

Responsibilities:

• Responsible for all things related to data (Data Architect) as well as managing data team - Reliability, Availability, Maintainability, and analytics as well as development planning, estimation, meeting release dates, collaboration with product teams, and release deployment.
• Initiated use of geo-spatial data types for location based smartphone messaging via SQL Server 2012.
• Drove use of SQL Server strongly typed XML datatype.
• Oversaw and crafted design and plan for ETL of MySQL databases (as part of acquisition merger) into SQL Server via SSIS.
• Initiated Maintaining a list of technical debt and associated risks for future consideration.
• Directed SQL Server architecture of SSAS OLAP cubes and Reporting Services (SSRS) reports.
• Established creation of custom BI reports for sales, marketing, planning and legal needs (Excel and SSRS).
• Lead role on 2 Patents, and key contributor on two other patented technologies using MS SQL Server 2008 R2.
• Transformed development process to Agile Scrum and performed Scrum Master role when available.
• Lead designer of database system changes to accommodate growth. 600% increase in customers and 2500% increase in maximum messages per day.
• Maintained 99.99% database uptime (achieved 99.99%/year and some years 99.999%/year uptime).
• Working with operations team, maintained and built high availability and disaster recovery architecture, processes and plans.
• Core member of team that led the technical push to a next generation version of Connect.

Environment: TSQL, SQL Server (2008 R2, 2012), SSIS, SSAS, Cluster, Log Shipping, MySQL, Visio, TFS, OLTP, JIRA

Confidential

Owner/Consultant

Responsibilities:

• Core team member (database) on first ever airline reservation system built on MS SQL Server for a major airline ( Confidential Airline, UK - system called eRes).
• Provided database and system design and architecture to accommodate growth due to acquisition. Necessitated handling 2x the original design capacity. Analyzed and implemented system and database changes to achieve needed capacity. Gathered analytical data for a full system capacity study.
• Key source for marketing, sales and technical planning reports (Excel).

Environment: TSQL, SQL Server (2000, 2005), Failover Cluster, Log Shipping, Erwin, TFS (various), OLTP