We are seeking a highly skilled and detail-oriented Database Administrator (DBA) with strong expertise in MySQL, MariaDB, and PostgreSQL to join our growing team. This role is critical to ensuring our database environments are reliable, scalable, and optimized for performance. You will play a pivotal role in managing data infrastructure and collaborating with cross-functional teams to drive innovation and efficiency.
Key Responsibilities
Design & Implementation of Databases
- Architect and implement robust, scalable, and secure database solutions using MySQL, MariaDB, and PostgreSQL.
- Collaborate with software engineers and solution architects to design database schemas that align with application requirements and performance goals.
- Participate in data modeling exercises, schema reviews, and capacity planning.
Performance Optimization & Tuning
- Conduct in-depth performance analysis of database systems to identify slow queries, inefficient indexing, and resource bottlenecks.
- Utilize tools and best practices to tune database configurations and improve response times and throughput.
- Implement caching strategies and review query plans to ensure optimal performance under varying workloads.
Backup & Recovery Strategy
- Develop and maintain comprehensive backup and disaster recovery plans for mission-critical systems.
- Implement automated backup routines and conduct periodic restore tests to validate recovery procedures.
- Ensure high data availability through failover, replication, and high availability (HA) setups.
Monitoring & Troubleshooting
- Set up proactive monitoring tools and alerts to ensure database uptime, health, and performance metrics are tracked in real time.
- Troubleshoot database-related issues including deadlocks, locks, connection issues, and data corruption.
- Perform root cause analysis and propose preventive measures to avoid recurrence.
Security & Compliance
- Apply and enforce database security best practices including user access controls, encryption, and audit logging.
- Regularly review roles and permissions to ensure compliance with internal and regulatory requirements.
- Address vulnerabilities by staying current with patches, updates, and industry trends.
Documentation & Reporting
- Create and maintain comprehensive documentation for database configurations, operational procedures, standards, and troubleshooting guides.
- Provide detailed reports on performance metrics, incident history, capacity usage, and improvement efforts.
Customer & Stakeholder Engagement
- Interface directly with internal and external stakeholders to understand their data requirements and provide tailored solutions.
- Deliver expert-level support and resolution to database-related customer inquiries with a focus on high satisfaction and reliability.
Data Migration & Upgrade Management
- Plan and execute seamless data migrations between different environments or versions.
- Lead upgrade initiatives with minimal downtime and data loss, including change impact assessments and rollback strategies.
Continuous Improvement
- Propose and implement Service Improvement Plans (SIPs) to elevate operational efficiency, performance, and maintainability.
- Leverage automation tools for routine tasks such as backups, monitoring, user provisioning, and deployment.
Professional Development & Technology Watch
- Keep abreast of the latest advancements in open-source and enterprise database technologies.
- Evaluate and recommend tools, frameworks, and strategies to future-proof our data platform.
Required Qualifications
- Proven experience in managing MySQL, MariaDB, and PostgreSQL databases in production environments.
- Strong expertise in writing complex SQL queries, stored procedures, triggers, and views.
- Hands-on experience with replication, clustering, and failover mechanisms.
- Solid understanding of Linux/Unix operating systems as they relate to database administration.
- Familiarity with monitoring tools like Prometheus, Nagios, Zabbix, or similar.
- Excellent troubleshooting and analytical skills.
- Strong communication and documentation skills.
Preferred Qualifications
- Experience with cloud-based database services such as AWS RDS, Azure Database for PostgreSQL/MySQL.
- Scripting knowledge in Bash, Python, or similar for automation tasks.
- Knowledge of containerized environments (Docker, Kubernetes) and DevOps practices is a plus.
- Certifications in MySQL/PostgreSQL administration will be an added advantage.
Why Join Us?
- Work on challenging and high-impact database systems in a supportive and innovative environment.
- Be part of a collaborative team that values continuous learning and growth.
- Enjoy competitive compensation, flexible work arrangements, and opportunities for career advancement.
If you're a passionate database professional who thrives in a dynamic and fast-paced environment, we would love to hear from you!