Database And Monitoring Specialist
Current• Architect and DBA lead on all database deployments, configurations, performance changes, continuous improvements, incidents, testing and BAU. • Databases include SQL Server, Oracle Enterprise 19C with RAC and DataGuard, Vertica, Postgres with PGPool, MariaDB and Hadoop (within Cloudera Suite).• Ensure High availability and disaster recovery requirements are met whilst providing support on various issues, improvements, requests, user permissions, backups/restore, performance mgmt and new deployments. • Work with purchasing and suppliers to obtain, maintain all SQL Server and Oracle licences for NRTS ensuring all audits taken place are successful and in place. • Create technical, design and support documentation based on current and new build. This is to maintain application/database roadmap to ensure vender support is maintained• Conducting security Patching and upgrades to both DBA and Solarwinds responsibilities.• Various reports and queries to allow reporting services (QLIK Sense/ECM/SQL SSRS) to manage trends and data reporting to higher mgmt.• Work as a 3rd line dev support for Solarwinds. Involved with new deployments, improvements, and request. Also point of contact for SWIS, jobs, Failover, internal Solarwinds Engine issues. • Create projects for Solarwinds automation using Custom properties. Working with the team to help alerting and users to self-manage/access their corresponding systems.