Senior Database Administrator

• Mar 2020 - Present

Senior Database Developer

• Jan 2019 - Mar 2020

Senior DBA

• Jul 2017 - Jan 2019

Data Operations Lead

• Jan 2016 - Jul 2017

Senior Data Architect

• Jun 2012 - Jan 2016

Data Architect, developed a Data Warehouse for medical data (member eligibility, medical claims, providers). Responsible for ETL process automation, dealing with data sets of up to 200 million records. Proficient with SSIS and SSRS. Skilled TSQL developer using all functionality SQL Server has to offer; creating tables, views, indexes, stored procedures, functions (user/window), triggers, schemas and server jobs. Currently managing a team of 3 Data Analysts. Data Architecture/Modelling: * Experienced in designing Data Warehouse / Data Marts using different design paradigms * Design database back-end for web applications from scratch or adding to existing ETL: * Loading medical data from Health Plans, the Department of Health and various other sources. Validate data after load, create error files, scrub data and change it into the desired format. This is done in staging and production areas using SSIS and stored procedures. * Incorporating various source and target file formats (CSV, Excel, tab delimited / fixed width text files, XML, Access). SSIS: * Played a key role in converting DTS packages to SSIS as part of a server migration in 01/2014 (MSSQL 2000 to MSSQL 2008 R2). * Creating SSIS package on a daily basis to move data to/between servers, using data flow tasks (including derived columns, multicasts, row-counts, lookups), loops, variables, expressions, script and email tasks to notify users after successful update/load. SSRS: * Creating self-service reports based on specific needs, both static and dynamic (allowing to change the output based on drop-downs, text fields and checkboxes). * Using subscriptions to automatically distribute reports by email. Show less

SQL Database Administrator

• Sep 2010 - Dec 2011

Maintenance and administration of multiple MS SQL 2005 Server instances and databases, including Microsoft Dynamics NAV (ERP Software) used by up to 200 users simultaneously from on and off site locations. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements. * MS SQL Server 2005: planning, installation, migration, maintenance, job-handling, monitoring * Microsoft consoles: WSUS, Active Directory, Group Policies, Exchange 2007/2010, MS SCOM,Hyper-V * Provide PCs/VMs with Windows XP, Windows 7 and Windows 2003 - 2008 R2 Server installations * Remote maintenance using RDP, TeamViewer, VNC and MS Remote Assistance * Server and network maintenance beyond regular working hours * User, subsidiary and customer (on-site/remote) support using OTRS ticket system Show less