Job Title: Senior Database Administrator (DBA) - MySQL, MSSQL, Redis, Cosmos DB With Cloud experience
We are seeking a highly skilled and experienced
Senior Database Administrator (DBA)
to manage our cloud-based database infrastructure, which includes MySQL
, MSSQL
, Redis
, and Cosmos DB
across cloud platforms such as AWS
, Azure
, and Google Cloud
. This role involves managing, optimizing, and securing high-performance database systems, ensuring reliability, availability, and scalability in the cloud environment. The successful candidate will also provide strategic guidance on database architecture, performance tuning, and operational excellence.
Cloud Database Management:
- MySQL & MSSQL Management: Administer and optimize both MySQL and MSSQL databases hosted in cloud environments, ensuring they are configured for high availability, performance, and security.
- MySQL & MSSQL Management: Administer and optimize both MySQL and MSSQL databases hosted in cloud environments, ensuring they are configured for high availability, performance, and security.
- Redis Management: Oversee the deployment, scaling, and performance optimization of Redis clusters for caching and high-performance data storage solutions.
- Cosmos DB Management: Administer and optimize Cosmos DB for NoSQL workloads, ensuring effective partitioning, scaling, and integration with other cloud services.
- Cloud Infrastructure: Work with cloud service providers (AWS, Azure, GCP) to ensure database deployments align with best practices for cost-efficiency, reliability, and security.
Database Performance Optimization:
- Query and Index Optimization: Perform deep analysis on database performance, focusing on query optimization, indexing strategies, and identifying resource bottlenecks in MySQL, MSSQL, Redis, and Cosmos DB.
- Capacity Planning and Scaling: Monitor and predict database resource requirements, performing proactive capacity planning and ensuring resources scale automatically based on demand (vertical and horizontal scaling).
- High Availability & Disaster Recovery: Design and implement high-availability (HA) and disaster recovery (DR) solutions, ensuring continuous database uptime and minimal impact from failures.
Automation and Scripting:
- Automation of Database Tasks: Automate common database tasks (backups, scaling, monitoring) using scripting languages (e.g., Python, Bash, PowerShell) and cloud-native automation tools (e.g., AWS Lambda, Azure Automation).
- Infrastructure as Code (
IaC):
Leverage tools like Terraform
, CloudFormation
, or ARM Templates
to automate database deployment and management across cloud environments.
Security and Compliance:
- Database Security: Implement best practices for database security, including encryption, role-based access control (RBAC), and compliance with regulatory standards such as GDPR, HIPAA, SOC2, etc.
- Auditing and Logging: Ensure proper logging of database activities and provide regular audits to ensure compliance with organizational and industry standards.
- Vulnerability Management: Stay up to date on security patches and vulnerabilities, proactively applying patches and mitigating potential risks to databases.
Cloud Database Monitoring and Maintenance:
- Database Monitoring: Set up and manage continuous monitoring for database health, performance, and availability using tools such as CloudWatch (AWS), Azure Monitor, Prometheus, Grafana, or custom monitoring scripts.
- Incident Response & Troubleshooting: Diagnose and resolve complex database issues such as replication failures, performance bottlenecks, and connectivity issues in cloud environments.
- Backup & Restore: Implement automated backup solutions with an effective retention policy and regularly test recovery plans to ensure quick and efficient disaster recovery.
Collaboration and Knowledge Sharing:
- Cross-Functional Collaboration: Work closely with application developers, data engineers, and DevOps teams to design and implement database solutions that support application requirements.
- Documentation & Reporting: Document cloud database architectures, procedures, maintenance activities, and best practices for internal knowledge sharing and operational transparency.
- Training and Mentoring: Provide guidance, training, and mentorship to junior DBAs and development teams on cloud database best practices, troubleshooting techniques, and new technologies.
Database Migration & Upgrades:
- Cloud Migration Projects: Lead and manage database migration projects from on-premise to cloud platforms, ensuring a smooth transition with minimal downtime and data loss.
- Version Upgrades & Patching
:
Plan and execute major and minor database version upgrades, applying patches to ensure the latest features and security fixes are in place.
Experience:
. - Proven experience working with
MySQL
, MSSQL
, Redis
, and Cosmos DB
in production environments, particularly within cloud infrastructure (AWS, Azure, Google Cloud). - Extensive experience in managing cloud databases, including
backup/recovery
, performance tuning
, and replication
. - Familiarity with
cloud-native services
(e.g., RDS
, Cosmos DB
, ElastiCache
, Azure SQL Database
) and experience managing large-scale cloud environments.
Technical Skills:
-
Database Platforms:
Advanced knowledge of MySQL
, MSSQL
, Redis
, and Cosmos DB
. -
Cloud Platforms:
Expertise in AWS
, Azure
, or Google Cloud
services related to database management, including EC2
, RDS
, Redshift
, ElastiCache
, Cosmos DB
, and Kubernetes
. -
Database Performance Tuning:
Proficient in query optimization, index management, and database performance troubleshooting. -
Scripting & Automation:
Strong experience with Python
, Bash
, PowerShell
, or other scripting languages for database automation tasks. -
Infrastructure as Code (IaC):
Familiarity with Terraform
, CloudFormation
, or ARM Templates
for provisioning and managing database resources.
Other Skills:
- Strong experience with
cloud monitoring tools
(e.g., CloudWatch
, Azure Monitor
, Prometheus
, Grafana
). - Knowledge of
CI/CD pipelines
and integration with database environments. - Familiarity with containerization technologies such as
Docker
and Kubernetes
for database deployment and orchestration.
