Sr Lead, Database Development

About Northern Trust: Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889. Northern Trust is proud to provide innovative financial services and guidance to the world’s most successful individuals, families, and institutions by remaining true to our enduring principles of service, expertise, and integrity. With more than 130 years of financial experience and over 22,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 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 maintenance. • Contribute to Data Protection service documentation and control narratives. Working with Us: As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose. We’d love to learn more about how your interests and experience could be a fit with one of the world’s most admired and sustainable companies! Build your career with us and apply today. #MadeForGreater Reasonable accommodation Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at . We hope you’re excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people. Apply today and talk to us about your flexible working requirements and together we can achieve greater. About Our Pune Office The Northern Trust Pune office, established in 2016, is now home to over 3,000 employees. The office handles various functions, including Operations for Asset Servicing and Wealth Management, as well as delivering critical technology solutions that support business operations across the globe. Our Pune team takes our commitment to service to heart. In 2024, they volunteered more than 10,000+ hours into the communities where they live and work. Learn more.