Lead Consultant - DBA 55169

Sapiensis on the lookout for a Lead Consultant and highly skilled Azure SQL Lead to manage and optimize our Azurebased database infrastructure. The ideal candidate will have indepth expertise in Azure SQL offerings crossplatform database management automation security replication strategies and FinOps optimization. This role requires handson technical leadership and collaboration across cloud development and DevOps teams.

Location:Bangalore India

Working Model:Our flexible work arrangement combines both remote and inoffice work optimizing flexibility and productivity.

This position will be part of Sapiens CTIO division for more information about it click here:

About the Role:

What youll do:

• Design implement and manage:
• Azure SQL Database (PaaS)
• Azure SQL Managed Instance (PaaS)
• SQL Server on Azure VMs (IaaS)
• Indepth knowledge of:
• PaaS & IaaS subscription types pricing tiers and FinOps for cost optimization
• vCorebased architecture RAM allocation and compute sizing
• Azure Storage accounts (Standard/Premium) IOPS and throughput considerations
• Implement and maintain:
• Always On Availability Groups (multisubnet)
• Replication CDC Georeplication and PITR (PointInTime Recovery)
• Disaster Recovery strategies and of DR drills
• Backup & Restore:
• Utilize Azure Backup Center and Recovery Services Vault
• Design backup retention and recovery strategies aligned with RPO/RTO
• Patching:
• Plan and execute SQL Server and OS patching
• Conduct pre/post patch validation monitoring and rollback automation
• DevOps & Automation:
• Integrate Azure DevOps pipelines for CI/CD of database changes
• Automate routine tasks with PowerShell and Azure CLI
• SQL Server Agent & Jobs:
• Design schedule and monitor SQL Server Agent Jobs
• Set up alerting logging and Database Mail notifications for job failures
• Security & Compliance:
• Implement rolebased access control (RBAC) using Azure AD Managed Identities and Service Principals
• Use Azure Key Vault for secrets and encryption key management
• Configure Transparent Data Encryption (TDE) and monitor decryption status
• Apply Dynamic Data Masking rowlevel security and least privilege principles
• Ensure adherence to GDPR and data privacy regulations
• Monitoring & Performance:
• Use Query Store DMVs and Azure Monitor for query tuning and deadlock resolution
• Maintain and optimize indexes and statistics
• Implement and manage SQL Server Maintenance Plans
• Install configure and troubleshoot Data Tools:
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• Manage deployments permissions and servicerelated issues
• Optimize and troubleshoot package report rendering.
• Azure Databricks
• Provision and configure Databricks Workspaces
• Manage clusters notebooks access control and job scheduling
• Integrate with SQL and big data pipelines as part of the data platform

CrossPlatform Database Expertise

Azure PostgreSQL

• Administer Azure PostgreSQL Single Server and Flexible Server
• Implement logical replication for read scaling and high availability
• Monitor replication health and troubleshoot lag or failures
• Perform configuration performance tuning and disaster recovery planning

Azure MySQL

• Administer Azure MySQL Single Server and Flexible Server
• Configure and maintain read replicas for performance and DR
• Monitor and resolve replication health issues
• Handle installations tuning and high availability design

MongoDB (Cloud/Atlas)

• Basic to intermediate administration of MongoDB Atlas
• Perform user/role management backup setup and cluster configuration
• Monitor cluster performance and enforce security practices

Enterprise & ITSM Practices

• Participate and lead in Incident Change and Problem Management processes
• Coordinate with application cloud and infra teams during major incidents and RCA activities
• Document standard operating procedures (SOPs) playbooks and change records
• Ensure compliance with audit and security controls

Leadership Responsibilities:

• Lead and mentor a team of DBAs and database engineers across different time zones
• Collaborate with crossfunctional teams (Cloud DevOps Security Applications) to ensure aligned goals
• Plan and prioritize tasks manage workloads and ensure SLAs are met
• Conduct knowledge sharing sessions and upskill junior team members
• Interface with stakeholders to understand requirements provide status updates and deliver solutions
• Participate in capacity planning roadmap design and strategic decisionmaking for data platforms

What to Have for this position.

Must have Skills.

• 8 years of experience in SQL Server database administration
• 3 years of experience working with Azure SQL offerings
• Strong handson experience in high availability replication and performance tuning
• Expertise in automation using PowerShell and Azure CLI
• Familiarity with data security and compliance best practices
• Experience with cost management and infrastructure optimization in Azure

Preferred Certifications:

• Azure Database Administrator Associate (DP300
• Azure Solutions Architect Expert (AZ 305 or AZ104
• Azure Fundamentals (AZ900

About Sapiens :

Sapiens is a global leader in the insurance industry delivering its awardwinning cloudbased SaaS insurance platformto over 600 customers in more than 30 countries. Sapiens platform offers preintegrated lowcode capabilities to accelerate customers digital transformation. With more than 40 years of industry expertise Sapiens has a highly professional team of over 5000 employees globally.For More information visit us on .

Sapiens is an equal opportunity employer. We value diversity and strive to create an inclusive work environment that embraces individuals from diverse backgrounds.

Disclaimer: Sapiens India does not authorise any third parties to release employment offers or conduct recruitment drives via a third party. Hence beware of inauthentic and fraudulent job offers or recruitment drives from any individuals or websites purporting to represent Sapiens . Further Sapiens does not charge any fee or other emoluments for any reason (including without limitation visa fees) or seek compensation from educational institutions to participate in recruitment please check the authenticity of any such offers before acting on them and where acted upon you do so at your own risk. Sapiens shall neither be responsible for honouring or making good the promises made by fraudulent third parties nor for any monetary or any other loss incurred by the aggrieved individual or educational the event that you come across any fraudulent activities in the name of Sapiens please feel free report the incident at sapiens to .