Job Description

Job Title: Database Administrator (SQL & Azure)Location: Ahmedabad, Bangalore, HyderabadJob Type: Full-time, working from office 5 days a weekExperience Level: 5 yrs 10 yrsReporting To: Sr. Director, Software EngineeringJob Overview:We are looking for a skilled SQL Database Administrator with expertise in Azure SQL to manage, optimize, and secure our database infrastructure. The ideal candidate will proactively monitor performance, implement backup & disaster recovery strategies, ensure security compliance, and support development teams in troubleshooting and optimizing database interactions.Key Responsibilities:1. Performance Monitoring & OptimizationContinuously monitor database performance using Redgate SQL Monitor, Azure Monitor, Query Store, and Extended Events.Identify and optimize slow-running queries through indexing, query tuning, and execution plan analysis.Evaluate and fine-tune automatic tuning options (e.g., force last good plan, auto-index management).2. Backup & Disaster Recovery (DR)Ensure automated backups (point-in-time recovery, long-term retention) are configured and tested.Implement and maintain High Availability (HA) and Disaster Recovery (DR) strategies using Azure Auto-Failover Groups and Geo-Replication.3. Security & ComplianceManage database user access and permissions following least privilege principles.Regularly audit database security and firewall rules.Review and address issues identified in Azure Vulnerability reports.Monitor for suspicious activity using Azure Defender for SQL.Ensure compliance with regulatory requirements such as GDPR, HIPAA, and company policies.4. Maintenance & HousekeepingMonitor and manage database size growth, archiving historical data and purging obsolete records.Perform index maintenance (rebuild/reorganize based on fragmentation levels).Update statistics for efficient query execution.Identify and deprecate unused or outdated database objects.5. Troubleshooting & Incident ResponseRespond to database alerts and performance degradation issues.Investigate and resolve blocking, deadlocks, and long-running transactions.Collaborate with developers to troubleshoot and optimize application-database interactions.

Ajmera Infotech Inc.