Production DBA administering a diverse vendor / in-house database environment consisting of 75+ database servers spanning dev/QA/UAT and production. Database versions range from SQL Server 2005 up to SQL Server 2016 (2005/2008/2008r2/2012/2014/2016). Server environments are a mix of standalone and SQL Server Always on Availability Groups. Many applications are vendor provided requiring close interaction with vendors and internal business teams to implement changes. Typical tasks include; Work with project team to review project scope, specifications, timelines and resource availability Create databases and assign appropriate security per instanceReview / implement RFC’s and resolve or refer issue to development teamRefresh target databases from source systemsEnsure mission critical databases are available on DR siteReview database security to validate appropriateness for the login / instance

Production DBA administering a diverse vendor / in-house / Azure database environment consisting of 900+ databases on 75+ database servers spanning dev/QA/UAT and production. Database versions range from SQL Server 2000 up to SQL Server 2016 (2000/2005/2008/2008r2/2012/2014/2016). Server environments are a mix of standalone, Azure, Windows Clustering and SQL Server Always on Availability Groups. Many applications are vendor provided requiring close interaction with vendors and internal business teams to implement changes, enhancement scripts and occasional FTP transfers of DB’s to vendor site. Created an inventory database to track server/database information, such as, server/database location, version, compatibility mode, uptime, etc. Typical tasks include; Work with project team to review project scope, specifications, timelines and resource availability Create databases and assign appropriate security per instanceReview / implement RFC’s and resolve or refer issue to development teamEducate developers on best practices and standards as requiredRefresh target databases from source systemsEnsure mission critical databases are available on DR siteReview database security to validate appropriateness for the login / instanceSetup / monitor Maintenance Plans and SQL Agent JobsInstall SQL Server and componentsOracle 2017 - PresentPart of a 3 person DBA team assisting BI developers with implementing Oracle Exalytics BI solution, which is, Oracle’s In Memory database appliance machine. This implementation is hosted on Oracle Linux.

Execute database change scripts provided by development teams and third party vendorsPerform database refreshes from production to downstream instances; dev, QA and UATEnsure proper security rights are granted based on instance and job requirementsMonitor DBA team developed SQL Server utilities to minimize down timeMember of 4 man on-call rotation troubleshooting production SQL Server outages as necessarySchedule SQL Agent jobs as necessaryDeploy/schedule/monitor DTS packages as neededDeploy/schedule/monitor SSIS packages as neededEstablish database mirror as part of DR planTest DR plan with appropriate DR and dev team members as neededResearch scripts and DMV queries to help troubleshoot and answer database related questionsInstall and configure new SQL ServersDocument database environment as needed

Created databases, load rules and updated security as required. Monitored databases and performed troubleshooting as required. Planned and implemented upgrade of all Essbase databases and client PC software. Wrote customized Essbase calc scripts to handle special processing needs.

Originally worked on IBM mainframe FOCUS (Information Builders) budgeting and forecasting application up to 1998 when we switched to Essbase. Technical side of team recommending/implementing Essbase at CCE for volume planning forecasting activity.

Designed/coded a Marketing Customer Information database system (15+ million records)(Innovative design allowed marketers to quickly target customer mailings)Instructed end-users (bankers) how to produce ad-hoc reports (Developed and taught the 2 day training class)

Supported financial reporting system that produced 800+ property management reportsDesigned/coded a time reporting system that tracked project and hourly employee time entryfor the I.S. department (85 - 100 employees)Represented I.S. department as liaison to Human Resources and Accounting