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.

• Bachelor's 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.