Senior Database Administrator
CurrentAs a member of a DBA team I maintain a conglomerate of Oracle and SQL database with over 1700 databases on 120+ virtual servers. Most of the instances exist on premises with a few in AWS and Azure. Responsibilities greatly vary day to day but have included 1) attending to alerts for resources such as disk space or CPU usage, 2) resolving SQL Agent, Crontab and Tidal jobs that have either failed or running long, 3) fulfilling request for new or modified user access, 4) implementing application accounts with the appropriate privileges, 5) creating new databases or building new database servers, 6) supporting replication via Oracle Data Guard or SQL Server Always On or QLIK Replicate, 7) support internal and external audits, 8) patching, 9) automating repeatable processes via scripts and schedulers like SQL Agent and Tidal Automation, 10) resolved query performance issues often caused by plan regression, 11) use of and often support maintenance of DBA tools like SolarWinds Database Performance Analyzer (DPA), SolarWinds SQL Sentry (formerly SentryOne), RedGate SQL Compare, SQL Server Management Studio (SSMS), Oracle SQL Developer, SQLPlus, Oracle Enterprise Manager (OEM).