Description:
The expectation is that you will work closely with other staff from TOCS and beyond, including 3rd parties, to ensure the database is estate functions as required alongside collaborating with projects and other teams to ensure that change within the database environments is managed and controlled effectively and safely.
What You’ll Be Doing…
- Support and problem solve on all Production databases as a priority alongside supporting the databases within the Pre-Production environment through proactive identification of risk, swift resolution of live issues and proposal of appropriate fixes/improvements for future
- Upgrade, decommission and deliver new databases alongside supporting changes required to existing databases on the estate including but not limited to patching, tuning / optimisation and disaster recovery testing.
- Think “outside the box” to improve our processes through process automation, innovation and continuous improvement.
- Work with Lead Database Engineers, Infrastructure Designers and Project Managers to ensure solutions meet the organisation’s strategic needs and service being kept safe is in mind at all times.
- Collaborate with internal and external parties, escalating where necessary to Lead Database Engineers / Team Leads, to ensure operational issues are resolved within agreed SLAs to ensure we provide excellent customer service.
- Improve our processes through process automation, innovation and continuous improvement.
Our work is highly specialised, high profile and fast paced, so you will be expected to self-manage in a professional and proactive manner in conjunction with your Team Lead who will assign you tasks.
Following a period of training the expectation is that the successful candidate would join a 24/7 on-call rota . Due to the operational nature of the role, there will be times when you may need to work out with your core hours therefore flexibility is key .
To be successful you’ll need….
- A strong understanding and experience of database administration (across Oracle and SQL Server) in a Production setting.
- An ability to troubleshoot Production issues quickly in an analytical manner alongside making recommendations to resolve issues and/or deliver enhancements.
- Experience of undertaking database builds, patching, migrations and upgrades.
- Experience of High Availability and Disaster Recovery Methods including setup, troubleshooting and support - Oracle RAC, Oracle Restart, ASM, Oracle Data Guard, flashback technologies and SQL Server Always On High Availability.
- Database performance tuning and optimisation skills.
- Experience of using Oracle Enterprise Manager.
- Oracle / Red Hat Linux, Windows, AIX, and Solaris Operating System experience.
- An ability to take ownership for your own development, including taking proactive steps to improve and maintain your skills, knowledge, and behaviours.
- To display collaborative behaviours and excellent verbal / written communication skills.
- ITIL Service Management awareness (Incident, Change and Problem Management processes).
- The self-motivation and desire to keep knowledge current in regards to database technologies including but not limited to Oracle, SQL, Exadata and OCI.
The Following Would Be Brilliant...but Not Essential.
- Experience of managing databases (including patching, maintenance, and support of the appliances themselves)within cloud or cloud @ customer environments (Oracle OCI, Oracle Exadata Cloud @ Customer and/or Microsoft Azure) with an awareness of emerging industry trends such as PAAS, DBAS, IAAS.
- Experience of working with other database technologies aside from Oracle and SQL Server i.e. Cosmos, PostgreSQL or similar.
- Competence in scripting languages such as Bash/PowerShell/Python.
- Experience of Dynatrace tooling.
- ServiceNow usage
- Knowledge of the full software development lifecycle: from business/systems analysis, through requirements gathering and functional specification authoring, to development, testing and delivery.