Job Title:  Consultant | Azure Cosmos DB | Bengaluru | Engineering

Senior Cloud Database Administrator (DBA) - MySQL, MSSQL, Redis, Cosmos DB, Maria DB

Job Overview:

We are seeking a skilled and motivated Cloud Database Administrator (Cloud DBA) to join our growing team. The ideal candidate will be responsible for the administration, optimization, and management of cloud-based database platforms across major providers like Amazon Web Services (AWS), Microsoft Azure, and Google Cloud. As a Cloud DBA, you will work closely with the infrastructure, development, and DevOps teams to ensure that the cloud databases are secure, scalable, and performant. You will have the opportunity to implement cutting-edge cloud database solutions and work with large-scale, mission-critical systems.

Key Responsibilities:

Cloud Database Administration:

• Administer and manage cloud-based databases across AWS, Azure, and Google Cloud, including databases like Amazon RDS, Azure SQL Database, Google Cloud SQL, and NoSQL databases like DynamoDB, Cosmos DB, and MongoDB.
• Manage database instances in cloud environments, including provisioning, scaling, patching, and backups.
• Collaborate with cloud architecture teams to ensure the database infrastructure is aligned with best practices for scalability, security, and performance.

Performance Tuning & Optimization:

• Continuously monitor cloud database performance, including query optimization, resource usage, and storage optimization.
• Implement proactive tuning techniques to ensure high availability and efficient performance of cloud-based databases.
• Review and optimize SQL queries, indexes, and database structures for optimal performance in the cloud.

High Availability & Disaster Recovery:

• Design and implement high-availability solutions in the cloud, such as automated failover, replication, and clustering for cloud-based databases.
• Implement robust disaster recovery plans with real-time backup and restore procedures to minimize downtime.
• Regularly test and update disaster recovery strategies to ensure quick and efficient data restoration during emergencies.

Cloud Database Security & Compliance:

• Enforce cloud database security policies, including data encryption, secure user access management, and access control configurations.
• Implement secure cloud database environments by applying cloud provider security tools and best practices (e.g., IAM policies, encryption, VPC configurations).
• Ensure compliance with regulations and industry standards (e.g., GDPR, HIPAA, PCI-DSS) within the cloud databases and perform regular security audits.

Automation & Infrastructure as Code:

• Leverage cloud-native tools and frameworks (e.g., AWS CloudFormation, Azure Resource Manager, Terraform) to automate database provisioning, scaling, and management.
• Develop and maintain automation scripts for routine tasks, such as backups, health checks, and monitoring.
• Implement infrastructure as code (IaC) practices for reproducible and scalable cloud database deployments.

Database Monitoring & Reporting:

• Utilize cloud-native monitoring tools such as Amazon CloudWatch, Azure Monitor, or Google Stackdriver to track database performance, availability, and health.
• Design and maintain custom dashboards and alerting systems for proactive database management.
• Generate regular performance and health reports to provide insights into database operations and guide improvements.

Collaboration & Support:

• Collaborate with application development teams to design, deploy, and maintain cloud-native database solutions that meet business needs.
• Provide second- and third-level support for database-related issues, troubleshooting performance or security problems in the cloud environment.
• Assist with cloud database migrations from on-premises systems to cloud environments, including hybrid and multi-cloud strategies.

Innovation & Continuous Improvement:

• Stay current with the latest trends, tools, and technologies in cloud computing and database management.
• Propose and implement database innovations that improve performance, security, and cost-efficiency in the cloud.
• Continuously optimize cloud database costs by monitoring and optimizing resource usage and storage.

Experience:

• At least 3-5 years of experience as a Database Administrator, with a strong focus on cloud-based databases.
• Hands-on experience with major cloud platforms such as AWS, Microsoft Azure, or Google Cloud, and their database services (Amazon RDS, Azure SQL Database, Google Cloud SQL, etc.).
• Experience with database migration to the cloud and managing hybrid cloud environments.
• Familiarity with cloud-based NoSQL databases, including DynamoDB, Cosmos DB, or Firebase.

Technical Skills:

• Strong expertise in managing relational databases (SQL Server, MySQL, PostgreSQL) and NoSQL databases (MongoDB, DynamoDB, Cosmos DB).
• Familiarity with cloud-native database tools and services for high availability, backups, security, and scaling.
• Proficient with SQL, database performance tuning, and optimization techniques.
• Strong scripting skills (e.g., Python, PowerShell, Bash) and experience with cloud automation tools (Terraform, CloudFormation, Ansible).
• Understanding of cloud security principles (encryption, VPCs, IAM, security groups, access control).
• Experience with cloud monitoring and logging services (Amazon CloudWatch, Azure Monitor, Google Stackdriver).

Certifications (Preferred):

• AWS Certified Database - Specialty.
• Microsoft Certified: Azure Database Administrator Associate (DP-300).
• Google Professional Cloud Database Engineer.
• AWS Certified Solutions Architect – Associate.
• Microsoft Certified: Azure Solutions Architect Expert.

Key Attributes:

• Problem-Solving: Strong troubleshooting skills and the ability to analyze complex database problems and implement efficient solutions.
• Adaptability: Comfort with cloud technologies, willingness to learn new tools and platforms.
• Collaboration: Ability to work effectively with cross-functional teams, including development, infrastructure, and security teams.
• Attention to Detail: Commitment to database security, data integrity, and performance monitoring.
• Communication: Clear communication skills for liaising with technical and non-technical stakeholders.