Database Administrator
CurrentServe as primary Database Administrator for 14 SQL database servers and over 30 databases located in multiple sites as part of one of the largest forensic laboratory systems in the United States. Design and support SQL Server replication to remote sites. Develop views, stored procedures, jobs, and triggers using T-SQL. Develop automated ETL solutions to receive data from external agencies. Design and Develop databases and data models for custom applications. Design and develop the integration of data output from analytical instruments into the LIMS application database. Primary database support for over 300 laboratory staff as well as over 12,000 external Criminal Justice users. Develop custom reports using Crystal Reports and SQL Server Reporting Services (SSRS) Troubleshoot database performance issues and optimize databases for optimal performance