Overview
Skills
Job Details
Key Responsibilities:
Database Administration & Management
Manage, monitor, and maintain Azure SQL, MySQL, and PostgreSQL environments.
Ensure high availability, reliability, and optimal performance across all database systems.
Performance Optimization
Diagnose and resolve slow-running queries and performance bottlenecks.
Design and implement indexing strategies, query tuning, and schema/database refactoring.
Migration & Replication
Perform seamless database migrations across environments and platforms.
Configure and manage replication, read/write replicas, and synchronization strategies.
Backup & Recovery
Develop and maintain robust backup and disaster recovery plans.
Regularly test and validate restore strategies to minimize downtime.
Security & Compliance
Implement strong access control, authentication, and password management policies.
Ensure compliance with security standards and industry best practices.
Automation & Scaling
Develop scripts and automation for routine administrative tasks.
Implement auto-scaling and optimization strategies for large-scale workloads.
Collaboration & Support
Partner with DevOps, Cloud, and Development teams to meet application and infrastructure needs.
Provide expertise in database design, schema creation, and query optimization.
Required Skills & Experience:
10+ years of experience as a Database Administrator or similar role.
Strong expertise in Azure SQL, MySQL, and PostgreSQL.
Hands-on experience with database performance tuning and optimization.
Proficiency in database migration, replication, and scaling strategies.
Experience with backup/recovery solutions and disaster recovery planning.
Knowledge of database security, compliance, and access control policies.
Scripting skills (e.g., PowerShell, Bash, Python, or SQL scripts) for automation.
Excellent problem-solving skills and ability to work cross-functionally with teams.
Nice to Have:
Experience with cloud-native database services (AWS RDS, Google Cloud Platform Cloud SQL).
Exposure to DevOps practices, CI/CD pipelines, and Infrastructure-as-Code tools (Terraform, Ansible, etc.).
Familiarity with monitoring tools (Grafana, Prometheus, New Relic, etc.).