Erik L.

PROFESSIONAL EXPERIENCE JPay February 2015 – Current Database Administrator • Worked with always on Availability Groups on Windows and Linux OS • Redirected read only queries to readable secondary replica of Availability Groups using listeners and read only routing • Log shipped databases from multiple Clusters to one destination server for reporting purposes. • Work with High Availability Groups in failover clusters. • Transaction Replication of tables between Availability Groups on different Clusters. • Configured, Restored, and Upgraded SSRS services. • Partitioned multiple tables to optimize index maintenance • Analyzed cached query plans for index suggestions • Supported production environments with SQL Server upgrades • Encrypt data with always encrypted using powershell script to import certificate and assign permissions for all web server and services servers Kaplan University June 2006 – February 2015 Database Administrator/BI Developer • Maintained and modified existing SSAS databases and cubes • Developed and maintained ETL for data warehouse using SSIS • Developed new SSAS cubes • Used SQL Sentry and Confio tools to find database performance issues for Enterprise applications • Created custom SSRS reports for database performance counters and Sql trace data • Monitored 200+ SQL instances of about 20TB of data • Performed clustered and non-clustered SQL Server installs • Performed multiple Service Pack upgrades on clustered and non-clustered SQL server • Created an application using C# and RMO to script out all of the replication in every environment automatically • Helped created and enforce standards for TSQL and SSIS • Created an application using C# to aid in the processes of code review and automation of code deployment from TFS • Database code reviewed TSQL objects for 25+ developers • Disaster Recovery plans for clustered SQL servers, multi-server install of SQL reporting services and analysis services • Index optimization, created procedures to selectively rebuild indexes and statistic on problem databases • Help support transactional replication in production, stage and development • Used Virtual Server to create a test environment for to help teammates gain SQL clustering skills BLUEGREEN CORP. June 2004 – June 2006 Database Administrator • Helped audit existing SQL Server logins and permissions to comply with Sarbanes-Oxley and privacy act. • Maintained 20+ Develop, Stage and Production SQL servers with databases severing 1000+ users • Performed code review and performance tuned databases