Senior Database Administrator
2019 - PRESENTLexisNexis Risk Solutions- Performed database maintenance and administration, performance tuning, troubleshooting, managing backups, security maintenance, monitoring, and disaster recovery.
- Configured and maintained DR solutions including AlwaysOn, database mirroring, and peer-to-peer replications.
- Planned and performed SQL Server upgrades, migrations, and installations.
- Migrated databases from on-premises servers to Azure.
Technologies: SQL Server DBA, Business Intelligence (BI), Always On, Azure SQL, Database Replication, Database Mirroring, Windows PowerShellSenior Database Administrator
2012 - 2019Kaplan Inc.- Automated refreshes of Azure and SQL Server databases using PowerShell.
- Automated standard maintenance tasks for SQL Server and Azure databases.
- Supported database mirroring and peer-to-peer replication.
- Assisted in upgrade planning, testing, and deployment.
- Oversaw monitoring and maintaining system performance with tools such as SQL Sentry and SolarWinds.
Technologies: SQL, SQL Server DBA, Business Intelligence (BI), Azure SQL, Windows PowerShell, Database Mirroring, Database Replication, SolarWindsSenior Systems Analyst
2009 - 2012Kaplan University- Oversaw maintenance and support of the SQL Server back end of a third-party system containing thousands of tables, views, and stored procedures.
- Analyzed data schema, corrected defects in code when the application vendor was unable to provide solutions for defects, and developed code for in-house APIs.
- Served as lead developer on various projects, including design of the solution, coding, and documentation.
- Automated many financial aid functions that were previously run manually by integrating two third-party applications.
Technologies: SQL, Crystal Reports, Business Intelligence (BI)SQL Developer
2006 - 2009Open Finance Network- Developed and maintained processes to aggregate data from websites, data feeds, and internal applications to create new (and update existing) clients and their accounts.
- Developed, deployed, and maintained reports for internal and external clients using T-SQL and SSIS packages.
- Managed schema changes (tables, stored procedures, functions, and views) related to enhancements to internal applications.
- Oversaw data migration and transformation between two concurrently running systems with different back-end structures.
Technologies: SQL, Business Intelligence (BI)