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 recent 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.

Disclaimer : This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Sr Lead, Database Development (Pune)
🏢 Northern Trust
📍 Pune