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.