Oracle/SQL Server DBA – Performance & DR Expert

Avance Consulting; United Kingdom; On-site; GBP 60,000 - 90,000; Full time

Job summary

Avance Consulting is seeking an experienced DBA to install, configure, and maintain Oracle and SQL Server database systems across the UK. You will manage upgrades, patching, migrations, backups, and high-availability deployments.

You will optimize queries, tune performance, implement RMAN/Data Guard/AlwaysOn, and collaborate with development and infrastructure teams on schema design. On-call rotation and L2/L3 support form part of the duties, with security and DR planning emphasized.

Qualifications

• Must have a valid current SC Clearance.
• Collaborate with solution architects, developers, and infrastructure teams on database related initiatives.
• Serve as the SME for database performance incidents, root cause analysis, and major production events.

Responsibilities

• Install, configure, and maintain Oracle and SQL Server database systems.
• Perform regular database upgrades, patching, migrations, and backups.
• Manage users, roles, access privileges, and security policies.
• Monitor and tune database performance (indexing, partitioning, AWR reports, traces).
• Troubleshoot slow-running queries and optimize SQL code.
• Analyze system performance and recommend improvements.
• Implement and manage RMAN, Data Guard, AlwaysOn, and other HA/DR solutions.
• Perform backup validation, disaster recovery planning, and failover testing.
• Ensure database compliance with security policies and regulatory standards.
• Conduct audits, risk assessments, and security hardening.
• Work closely with application development teams to design database schemas, stored procedures, views, and triggers.
• Provide L2/L3 support for database-related incidents.
• Participate in on-call rotation for critical production environments.

Skills

Oracle DBA

SQL Server DBA

Linux/Unix

Windows Server

On-call

SC Clearance

Job description

Avance Consulting is seeking an experienced DBA to install, configure, and maintain Oracle and SQL Server database systems across the UK. You will manage upgrades, patching, migrations, backups, and high-availability deployments.

You will optimize queries, tune performance, implement RMAN/Data Guard/AlwaysOn, and collaborate with development and infrastructure teams on schema design. On-call rotation and L2/L3 support form part of the duties, with security and DR planning emphasized.