Sr Lead - Database Development

1. Primary DBA Ownership (Core Accountability)

Act as the primary DBA for all Data Protection databases across production, UAT, and development environments.

Own database availability, performance, capacity, security, backup, recovery, and lifecycle management.

Serve as final technical escalation for database incidents, outages, and data integrity issues.

Define and enforce DBA standards, operational guardrails, and support models.

2.Database Architecture & Engineering

Design, build, and maintain enterprise grade SQL Server databases (on premise and cloud, including Azure SQL Managed Instance).

Own physical and logical database design, including:

o Schema design

o Indexing strategies

o Partitioning

o Performance tuning

Lead database strategy for new Data Protection services, integrations, and platform migrations.

Govern schema evolution to ensure backward compatibility and reporting stability.

3. Performance, Reliability & Capacity Management

Proactively monitor and tune database performance (queries, indexes, memory, IO).

Lead capacity planning and forecasting, including storage, compute, and growth modelling.

Design and test backup, restore, disaster recovery, and high availability strategies in line with enterprise RTO/RPO expectations.

4. Data Ingestion, ETL & Automation

Provide senior DBA oversight and hands on support for ETL and ingestion pipelines.

Ensure ingestion processes are performant, resilient, recoverable, and auditable.

Optimize ingestion for high volume, complex, and inconsistent datasets.

Drive automation to reduce manual DBA intervention and operational risk.

5. SQL Engineering & Reporting Enablement

Develop and govern complex SQL queries, views, and stored procedures that underpin:

o Regulatory reporting

o Audit evidence

o Executive dashboards

Ensure reporting accuracy, data lineage, and traceability.

Act as escalation point for reporting failures driven by database issues.

6. Security, Controls & Regulatory Readiness

Own database level security controls, including:

o Access control models

o Service account governance

o Credential rotation

o Encryption and secure connectivity

Ensure databases meet audit, regulatory, and risk management expectations, including evidence production.

Partner with Risk, Audit, and Control teams to remediate database related findings.

7. Operational Leadership

Lead response to major incidents and post incident root cause analysis.

Mentor engineers and analysts on database best practices without direct line management.

Provide clear risk signals, options, and recommendations to senior stakeholders.

Represent DBA interests in architecture, change, and governance forums.

8. Documentation & Standards

Own DBA runbooks, operational documentation, health check reporting, and capacity plans.

Define repeatable operational procedures for database changes and main

Required Qualifications

This role requires deep, proven DBA expertise.

Bachelors degree in Computer Science, Information Technology, or equivalent experience.

Extensive hands on experience as a Database Administrator in enterprise environments.

Advanced expertise with Microsoft SQL Server, including:

o Performance tuning

o Indexing and query optimization

o Backup and recovery

o High availability / disaster recovery

Strong experience with Azure SQL Managed Instance or equivalent cloud database platforms.

Demonstrated experience operating as the primary DBA for business critical systems.

Proven experience supporting regulated, audit driven environments (financial services preferred).

Ability to operate autonomously with full accountability for database risk.

Preferred Qualifications

Experience supporting Cyber Security, Data Protection, or Risk platforms.

Experience supporting large scale ingestion and analytics workloads.

Exposure to BI or reporting platforms (e.g., Power BI) from a DBA performance and stability perspective.