David Hewes

David Hewes Email and Phone Number

Lead Database Administrator @
David Hewes's Location
Greater Philadelphia, United States
David Hewes's Contact Details

David Hewes personal email

n/a

David Hewes phone numbers

About David Hewes

Microsoft SQL Server Expert 18 yearsData Modeling Expert 18 yearsETL (Back-End BI) (SSIS and DTS) Expert 13 yearsData Warehousing Strong 13 yearsSQL Server Analysis Services Moderate 12 yearsErwin (old version) Moderate 7 yearsMDX Moderate 6 yearsSQL Reporting Services (SSRS) Expert 10 yearsASP.NET Expert 10 yearsVisual Basic Expert 18 yearsC#, Expert 11 yearsAccess Development Expert 18 yearsSQL Server Integrated Services and DTS Expert 15 years

David Hewes's Current Company Details
Interactive Advisor Services & Technology™, a Lincoln Investment company

Interactive Advisor Services & Technology™, A Lincoln Investment Company

Lead Database Administrator
David Hewes Work Experience Details
  • Interactive Advisor Services & Technology™, A Lincoln Investment Company
    Database Engineer Lead
    Interactive Advisor Services & Technology™, A Lincoln Investment Company Oct 2016 - Present
    Egg Harbor Township, Nj
  • Carekinesis, Inc
    Business Intelligence Developer
    Carekinesis, Inc May 2016 - Oct 2016
    Moorsetown
  • Sun National Bank
    Avp Sr Sql Server Dba\Dbd
    Sun National Bank Jan 2008 - May 2016
    • Responsible for all database development including performance, tuning and standards.• Tuned and optimized 5TB databases and tables with over 2 billion rows.• Reviewed database code from all other developers. • Other developers came to me for suggestions on how to improve performance and reliability. • Corrected a lot code that would have returned incorrect results in various situations. • Handled all DBA tasked (time permitting) on all in house application databases.• Designed and architected reliable and scaleable SQL Server databases. • Trained and mentored C# and SQL Server developers and contractors. • Written applications in ASP.net, AJAX, C#, Reporting Services and JavaScript. • Written SQL Server development standards. • Reorganized the way all application work together while maintaining modular design environment. • Responsible for all and written most ETL, data migration and integration and SQL Server Intergraded Service packages.• Completed all projects using Agile Software Development methodology.• Project lead on many high profile projects.
  • Commerce Bank (Td Bank)
    Sql Developer / Sr. Programmer Analyst / Data Migration And Integration / Data Modeler
    Commerce Bank (Td Bank) Mar 2005 - Jan 2008
    Designed, developed and worked on nearly all of the in house applications at Commerce Bank. These applications were written in ASP.net, AJAX, C#, VB.net and C++. Helped designed and write an enterprise security system. Designed reliable and scaleable SQL Server databases. Created logical and physical data models normalized and denormalized databases for optimum performance in relational and dimensional database environments. Designed and implemented multi stage ETL environment. Fully involved in various activities of all projects like information gathering, analyzing the information gathered, documenting the functional or business requirements. Wrote test planes and test cases of the business process for UAT. Also, worked with other tools, such as Oracle, DotnetNuck, DataStage (IBM’s ETL tool), ERWin, DTS, SSIS, Proclarity and Business Objects (Crystal).
  • Payroll Associaties
    Sql Server Developer / Programmer Analyst
    Payroll Associaties Mar 2002 - Feb 2005
    Responsible for all phases of SQL Server 2000 from design and development to support on production databases and their associated systems. Supported and programmed many existing products in Visual Basic and dot net. Designed and coded large projects in Visual Basic. Used Erwin for designing and developing accounting databases. Other responsibilities include installation, configuration, maintenance, backup / recovery, upgrades, applicable patches, job creations, growth and performance monitoring, trend analysis, security and user management. Became an expert at Reporting Services.
  • Payroll Associaties
    Programmer
    Payroll Associaties 2001 - 2005
  • Microwarehouse
    Sql Server Dba / Sql Developer / Data Modeler / Sr. Programmer Analyst
    Microwarehouse Jan 2001 - Mar 2002
    Design and implemented SQL Server 7.0 and 2000 database. Preformed all administration tasks. Wrote and/or modified hundreds of stored procedures and DTS packages for ASP websites and administration. Used Erwin for bulk of database design. Created design and requirements documentation on all projects. Worked together with a team to design and implement a Data Warehouse project. Used OLAP Services to construct multidimensional cubes for analysis. Developed good skills in performance optimization and tuning large databases. All projects were completed on time and under budget.
  • Pc Help Service Inc
    Sql Server Developer /Sr. Programmer Analyst
    Pc Help Service Inc Sep 2000 - Dec 2000
    Responsible for creating reports, database administration, programming MS Access, SQL stored procedures and Data Warehousing database with MS SQL. Administrator of CA Unicenters TNG Advanced Help Desk with SQL server as the backend database. Wrote step-by-step documentation on all projects.
  • Camanco Communications Inc.
    Systems Engineer / Dba Consultant
    Camanco Communications Inc. Aug 1998 - Jun 1999
    Worked as a Systems Engineer and DBAs on many contracts for a variety of companies. Gained experience in the PC and server environment where capabilities include application and OS loading, workstation rollouts, hardware troubleshooting, server setup and implementation, network design, network troubleshooting, LAN topologies and assorted network hardware. Also worked with Intel LANDesk, Microsoft SQL, Access, Windows NT

David Hewes Skills

Microsoft Sql Server Data Warehousing Databases Ssis Business Intelligence Database Design Sql Ssrs Etl Sql Tuning Sharepoint Disaster Recovery Integration Database Administration Sdlc Dts Oracle Data Modeling .net Data Migration Analysis Services Visio Performance Tuning Software Documentation C# Asp.net Javascript Operating Systems Visual Basic Vb.net Stored Procedures Servers Access Security System Administration Olap Idera Sentryone Jira Confluence Slack Hipchat Sharefile Redgate

David Hewes Education Details

  • Camden County College
    Computer Science / Engineering
  • Camden County Technical School
    Camden County Technical School
    Computers And Electronics
  • Microsoft Certified Database Administrator
    Microsoft Certified Database Administrator
  • Microsoft Certified System Engineer
    Microsoft Certified System Engineer
  • Microsoft System Professional + Internet
    Microsoft System Professional + Internet
  • Microsoft Certified Professional
    Microsoft Certified Professional

Frequently Asked Questions about David Hewes

What company does David Hewes work for?

David Hewes works for Interactive Advisor Services & Technology™, A Lincoln Investment Company

What is David Hewes's role at the current company?

David Hewes's current role is Lead Database Administrator.

What is David Hewes's email address?

David Hewes's email address is dh****@****est.com

What is David Hewes's direct phone number?

David Hewes's direct phone number is +126799*****

What schools did David Hewes attend?

David Hewes attended Camden County College, Camden County Technical School, Microsoft Certified Database Administrator, Microsoft Certified System Engineer, Microsoft System Professional + Internet, Microsoft Certified Professional.

What skills is David Hewes known for?

David Hewes has skills like Microsoft Sql Server, Data Warehousing, Databases, Ssis, Business Intelligence, Database Design, Sql, Ssrs, Etl, Sql Tuning, Sharepoint, Disaster Recovery.

Not the David Hewes you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.