SQL Server Database Architect

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 Let's unleash your full potential at Persistent
- persistent.com/careers "Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."