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