Glenside, Pennsylvania, United States
Current role: Operational enterprise database management, provide strategic design and direction for ETL/SSIS framework supporting DW/BI initiatives. Manage multiple vendor management SQL databases in highly available, highly secure, cost efficient operation. Full service SQL DBA, from download/install/configuration through design, maintenance, troubleshooting and support. MS SQL Server 2008R2-2019 Full suite) MS Azure SQL Server MS Azure SQL Database
SQL administration, ETL architecture, troubleshooting, optimization and infrastructure support. Current tasks include P2V/Host VM analysis and planning, DB server consolidations and resource analysis. Plan, install and support of High Availability Clustering for Windows 2008/2012, SQL Server 2008R2/2012/2014/2016/2017 environments. Support app teams with SQL/DB2 provider, communication troubleshooting services. Creating SQL solutions enabling efficient and secure extension of SQL services via impersonation methods.
Provided SQL Server Database administration services. Delivered easy deploy SSIS 2008 ETL solution for a 'third party to in house' Data Store. Worked with JVR Consulting in providing enterprise level SQL Administration.
Responsibilities include operational support, performance tuning, development, conversion of DTS to SSIS, Reporting Services. Build out framework for Data Integration architecture. Managed team off shore Database specialists.