Job Description
Job Overview:
We are looking for an experienced Senior Database Administrator (DBA) to join our growing team. In this role, you will manage and optimise databases for our SaaS-based web application in the fintech domain. Your expertise in MySQL, MongoDB, PostgreSQL, and Redis will ensure the availability, scalability, and performance of our databases that power our mission-critical fintech solutions. The ideal candidate will have enterprise-level experience, a strong understanding of database design and performance optimisation, and a passion for ensuring high availability and security in a high-demand environment.
Key Responsibilities:
- Database Administration & Optimization:
- Manage, optimize, and monitor MySQL, MongoDB, PostgreSQL, and Redis databases to ensure high availability and peak performance across the application stack.
- Perform routine database tuning and optimization tasks, including indexing, query optimization, and system resource utilization improvements.
- Ensure proper database configuration, performance monitoring, and troubleshooting to maintain the efficiency and stability of production systems.
- High Availability & Disaster Recovery:
- Design, implement, and manage high-availability and disaster recovery strategies for databases, ensuring uninterrupted service for our SaaS platform.
- Maintain and monitor database replication (e.g., Master-Slave, MongoDB ReplicaSets), failover mechanisms, and backup strategies.
- Security & Compliance:
- Develop and enforce database security policies to safeguard sensitive financial data, ensuring compliance with industry regulations (e.g., PCI-DSS, GDPR).
- Perform regular security audits and vulnerability assessments on the database systems.
- Ensure proper database encryption and manage access controls to maintain data integrity and confidentiality.
- Collaboration with Development & DevOps Teams:
- Work closely with development and DevOps teams to ensure seamless integration of database systems with application code and deployment pipelines.
- Collaborate on database schema design, new features, and continuous improvement efforts.
- Assist in database troubleshooting, query optimization, and support for ongoing application enhancements.
- Capacity Planning & Performance Scaling:
- Proactively monitor database performance, identify bottlenecks, and implement solutions to scale database systems to handle increasing user traffic and data growth.
- Assist in database migrations, upgrades, and the introduction of new database technologies when appropriate.
- Documentation & Best Practices:
- Document database configurations, performance tuning guidelines, and troubleshooting procedures.
- Establish and follow best practices for database management, backup, recovery, and performance tuning across the team.
