SQL Server Database Architect

Persistent; Pune District; Hybrid; INR 3,000,000 - 4,500,000; Full time

Benefits offered by this job

Competitive salary

Growth opportunities

Cutting-edge tech

Engagement events

Annual health checks

Insurance coverage

Job summary

Persistent is seeking a seasoned SQL Server Database Architect to lead architecture, governance, modernization, and operational excellence of enterprise SQL Server platforms. The role spans on-premises and cloud, driving HA/DR, security, and performance improvements across all Persistent locations.

The candidate will architect standards, mentor DBAs, and collaborate with cybersecurity, risk, and compliance teams to ensure resilience and regulatory compliance.

Qualifications

• 12 to 17 years of experience in Database Administration, Engineering, or Architecture.
• Extensive experience with SQL Server 2016, 2019, 2022 in large enterprise environments.
• Proven expertise in Always On Availability Groups and WSFC.
• Deep knowledge of HA, DR, backup/restore, and business continuity.
• Experience with change, incident, problem, and release management.
• Database modernization, upgrade, consolidation, and cloud migration programs.
• Advanced T-SQL, execution plans, indexing, and performance tuning.
• Windows Server administration and supporting infrastructure technologies.
• Active Directory, Kerberos, storage, networking, virtualization, monitoring.
• Security architecture, auditing, compliance, and governance.
• Automation with PowerShell and scripting technologies.
• Enterprise architecture frameworks and governance processes.
• Excellent stakeholder management, leadership, communication, and decision-making.

Responsibilities

• Define current-state, transition-state, and target-state SQL Server architectures across on-prem and cloud.
• Develop reference architectures, standards, design patterns, and decision frameworks.
• Establish standards for clustering, Always On, backup, recovery, monitoring, and encryption.
• Create roadmaps for lifecycle, capacity, modernization, and migrations.
• Act as the design authority for enterprise database solutions.
• Ensure alignment with enterprise architecture, cybersecurity, and governance standards.
• Drive technical debt reduction and platform modernization initiatives.
• Design and implement High Availability and Disaster Recovery solutions.
• Lead recovery planning, failover testing, and resilience assessments.
• Define indexing strategies, query optimization, workload management, and performance tuning.
• Establish performance baselines, capacity models, and forecasting processes.
• Lead incident response during major outages and root-cause analyses.
• Define database security architectures and governance; control auth, encryption, auditing, patching.
• Collaborate with cybersecurity, audit, risk, and compliance teams; address findings.
• Ensure regulatory and operational resilience compliance; support data protection and governance.
• Provide architectural leadership and mentorship to DBAs and engineers.
• Review and approve complex implementation plans and designs.
• Drive automation using PowerShell and infrastructure automation tools.
• Evaluate database technologies, vendors, and modernization opportunities.
• Collaborate with infra, apps, cloud, and security teams on dependencies.
• Maintain architecture repositories, service maps, and technical docs.

Skills

SQL Server architecture

HA/DR planning

Security governance

PowerShell scripting

Stakeholder management

Cloud modernization

Performance tuning

Automation

Vendor evaluation

Tools

WSFC

Always On

PowerShell

SQL Server 2016/2019/2022

Job description

About Position:

We are seeking a highly experienced SQL Server Database Architect to lead the architecture, governance, modernization, and operational excellence of enterprise SQL Server platforms. The ideal candidate will possess deep expertise in SQL Server architecture, high availability, disaster recovery, performance engineering, database security, and operational resilience.

• Role: SQL Server Database Architect
• Location: All Persistent Locations
• Experience: 12 to 17 Years
• Job Type: Full-Time Employment

What You'll Do:

• Define current-state, transition-state, and target-state architecture for SQL Server environments across on-premises and cloud platforms.
• Develop reference architectures, engineering standards, design patterns, and decision frameworks for SQL Server platforms.
• Establish standards for clustering, Always On Availability Groups, backup, recovery, monitoring, encryption, and privileged access management.
• Develop lifecycle management, capacity planning, modernization, consolidation, and database migration roadmaps.
• Act as the technical design authority for enterprise database solutions.
• Ensure alignment with enterprise architecture, cybersecurity, resilience, data governance, and service management standards.
• Drive technical debt reduction and platform modernization initiatives.
• Design and implement High Availability (HA) and Disaster Recovery (DR) solutions aligned to business requirements.
• Lead recovery planning, failover testing, restore validation, and resilience assessments.
• Define standards for indexing strategies, query optimization, workload management, and database performance tuning.
• Establish performance baselines, capacity models, and forecasting processes.
• Lead technical response during critical incidents and major platform outages.
• Drive root-cause analysis and implement long-term engineering improvements.
• Define database security architectures and governance standards.
• Implement controls for authentication, authorization, encryption, auditing, patching, hardening, secrets management, and service accounts.
• Partner with cybersecurity, audit, risk, and compliance teams to address control requirements and audit findings.
• Ensure database platforms comply with relevant regulatory and operational resilience requirements.
• Support data protection, retention, governance, and compliance initiatives across the organization.
• Provide architectural leadership and mentorship to database administrators and engineering teams.
• Review and approve complex implementation plans and solution designs.
• Drive automation initiatives using PowerShell and infrastructure automation tools.
• Evaluate database technologies, vendor solutions, and platform modernization opportunities.
• Collaborate with infrastructure, application, cloud, and security teams to manage technical dependencies.
• Maintain architecture repositories, service maps, support models, standards, and technical documentation.
• Contribute to strategic technology planning and database platform governance.

Expertise You'll Bring:

• 12 to 17 years of experience in Database Administration, Database Engineering, or Database Architecture roles.
• Extensive experience with SQL Server 2016, 2019, and 2022 in large enterprise production environments.
• Proven expertise in designing and implementing Always On Availability Groups and Windows Server Failover Clustering (WSFC).
• Deep understanding of High Availability, Disaster Recovery, Backup, Restore, and Business Continuity strategies.
• Strong experience supporting mission-critical business applications under formal change, incident, problem, and release management frameworks.
• Expertise in database modernization, upgrade, consolidation, and cloud migration programs.
• Advanced T-SQL development, execution-plan analysis, indexing, query optimization, and performance troubleshooting.
• Strong understanding of Windows Server administration and supporting infrastructure technologies.
• Experience with Active Directory, Kerberos Authentication, storage systems, networking, virtualization, and monitoring platforms.
• Strong knowledge of SQL Server security architecture, auditing, and compliance requirements.
• Hands-on experience with automation using PowerShell and scripting technologies.
• Experience working with enterprise architecture frameworks and technical governance processes.
• Excellent stakeholder management, leadership, communication, and decision-making skills.

Benefits:

• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Annual health check-ups
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind.