Eric Dycus Email & Phone Number

Supporting applications such as Accounting, Budgeting, and Forecasting, Labor Relations, and Risk Management and Governor Application databases which are critical to internal and statewide systems. Responsible for the security of the SQL servers by implementing and auditing the servers. Performance by troubleshooting query plans and improving performance. Operations in being proactive by monitoring and correcting issues. I am responsible for the administration of data warehouse and DataMart’s for the State Enterprise Reporting system. Installing, configuring, upgrading and patching SQL server 2000 – 2016 databases for 130 Microsoft SQL servers as Enterprise applications. During this time I have made the following changes: • Provided technology recommendations for Agency.• Provided business direction, feedback and guidance of best practices and LEAN.• Demonstrating to younger DBA’s various tasks for proper management of SQL servers.• Create, Implement and maintain Disaster Recovery and Security policies • Migrated SSIS package for ETL process, Creates SSRS reports for KPI dashboard.• Performance troubleshooting for data warehouse by creating indexes and other optimizing techniques.• Automated SQL install using a new technology called PowerShell DSC.• Reduced problems by standardizing backups and maintenance operations.• Responsible for installing and using monitoring tool called Spotlight for proactive maintenance on server.• Create T-SQL stored procedures as needed for automation and maintenance.• Create custom inventory process by using PowerShell• Implement and organize documentation repositoryDeveloped TSQL Store Procedures and scripts to solve issues and support overall database administration. MySQL, PostgreSQL and MongoDB experienced. Developed PowerShell scripts to solve issues and support overall database administration. Experience working with Vendors on COTS solutions and other state agencies for Backup and recovery strategies.

Listed skills include Active Directory, Vpn, Process Improvement, Microsoft Exchange, and 11 others.

• 

  Gardner-Webb University

  Computer Information Systems