Technical Systems Adminstrator
CurrentAt this position, I have the following responsibilities: -Responsible for Maintenance, Upgrades, Performance, and Troubleshooting of various MSSQL environments (2012-2019).-Responsible for Backups, Replication of Production Databases, Creation of Test/Dev Environments for MSSQL Environments.-Familiar with 3rd Party SQL administration tools, including Red-Gate DBA toolkit.-Researched and implemented best practices on SQL Maintenance plans via the Ola Hallengren’s Maintenance Solution for Test/Dev/Production environments.-Migrated multiple SQL database environments from SQL 2012 to SQL 2016 and higher, including environments with Reporting Services which split into separate services after SQL 2016.-Practiced in creation of linked servers between existing and new SQL server environments, as well as linking SQL environments with external database/application sources such as Salesforce via 3rd party applications.-Tableau Server Administration/Software Upgrade experience. Duties included maintaining licensing, adding users, integrating into MSSQL, troubleshooting, and keeping Tableau Server up to date on latest software.-VMWare vSphere virtualized server maintenance and creation, including: Windows Updates, Software Upgrades, Advanced Troubleshooting for in-house and 3rd party applications, backup solutions for server environments. -Active Directory Domain Administration Experience with creation of Users, Security Groups, OUs, and integration of Security Groups within SQL environments.-Responsible for planning budgeting and purchase of various IT related equipment/software, as well as working with vendors to facilitate purchases.