Sr Lead, Database Development

About Northern Trust As a global leader in innovative wealth management, asset servicing, asset management and banking services, Northern Trust (Nasdaq: NTRS) is proud to guide the world’s most successful individuals, families, corporations and institutions. Since 1889, we have aligned our efforts with our three guiding Principles That Endure: Service, Expertise, and Integrity. Together, they reflect the three cornerstones of business conduct which we strive to instill in our employees, whom we call partners, and to provide to our clients and the communities we serve worldwide. With more than 135 years of financial experience and over 24,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service. 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