Job Title: Manager | Azure SQL DB | Bengaluru | Engineering
- Administer, support, and maintain SQL databases including MySQL, PostgreSQL, MongoDB, Cosmos and Redis Cache for optimal performance and high availability.
- Monitor and optimize database performance by identifying bottlenecks, implementing tuning strategies, and ensuring efficient queries and indexes.
- Manage AWS and Azure hosted databases and caching services, including provisioning, monitoring, and scaling database instances and cache clusters.
- Implement and maintain database backups, restores, and disaster recovery plans for both on-premise and cloud environments.
- Ensure database security by enforcing data protection policies, user roles, and access controls.
- Troubleshoot database-related issues, provide root cause analysis, and implement corrective actions.
- Develop and implement database automation scripts to improve efficiency and reduce manual interventions.
- Collaborate with development teams to design, implement, and support new database solutions and applications.
- Work with the DevOps team to automate deployment, scaling, and monitoring of database environments.
- Participate in database migrations, upgrades, and patch management, including both SQL databases and cloud-based database services.
- Maintain system documentation, including architecture diagrams, recovery plans, and other relevant technical information.
Required Skills & Qualifications:
- Proven experience as a SQL Database Administrator (DBA) or in a similar role, with strong expertise in MySQL, PostgreSQL, and Redis.
- Solid experience with AWS (Amazon RDS, Aurora, ElastiCache) and Azure (Azure SQL Database, Redis Cache, Cosmos DB).
- Strong understanding of database design, optimization, replication, clustering, and backup/restore strategies.
- Expertise in managing database security, including encryption, authentication, and authorization.
- Hands-on experience with database performance tuning and troubleshooting, query optimization, and capacity planning.
- Knowledge of database high-availability architectures and disaster recovery solutions.
- Strong scripting skills in SQL, Bash, PowerShell, or similar scripting languages for automation.
- Familiarity with Docker, Kubernetes, and other container orchestration tools for managing database services in the cloud.