Job
Description
Working Model: Our flexible work arrangement combines both remote and in-office 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) In-depth knowledge of: PaaS & IaaS subscription types, pricing tiers, and FinOps for cost optimization vCore-based architecture, RAM allocation, and compute sizing Azure Storage accounts (Standard/Premium), IOPS, and throughput considerations Implement and maintain: Always On Availability Groups (multi-subnet) Replication, CDC, Geo-replication, and PITR (Point-In-Time Recovery) Disaster Recovery strategies and execution 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 role-based 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, row-level 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 service-related issues Optimize and troubleshoot package execution, 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 Cross-Platform 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 cross-functional 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 decision-making 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 hands-on 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 (DP-300) Azure Solutions Architect Expert (AZ- 305 or AZ-104) Azure Fundamentals (AZ-900).
