Senior Database Administrator

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.

Requirements

Required Skills and Qualifications:

• Experience:
• 7+ years of experience in database administration with hands-on experience managing enterprise-level databases (MySQL, MongoDB, PostgreSQL, Redis) in a SaaS or fintech environment.
• Strong experience in high-availability, disaster recovery, and database performance tuning in a production environment.
• Technical Expertise:
• Deep knowledge of database design, indexing strategies, query optimization, and performance tuning for MySQL, MongoDB, PostgreSQL, and Redis.
• Experience managing replication, sharding, and clustering strategies for high availability and fault tolerance in distributed database systems.
• Advanced understanding of database backup strategies, restoration procedures, and failover techniques.
• Familiarity with cloud platforms (AWS, GCP, Azure) and their database services (e.g., RDS, MongoDB Atlas).
• SaaS & Fintech Experience:
• Experience working in a SaaS-based application environment and understanding the performance, scalability, and compliance needs of a fintech platform.
• Knowledge of financial services or fintech-related database requirements, such as secure transactions, audit logs, and regulatory compliance.
• Automation & Scripting Skills:
• Proficiency in scripting languages (e.g., Python, Bash, or Perl) to automate common database management tasks.
• Familiarity with DevOps tools and CI/CD pipelines for database automation and continuous integration.
• Security & Compliance:
• Strong understanding of database security best practices, including data encryption, authentication, and auditing.
• Experience with regulatory compliance frameworks like PCI-DSS, SOC 2, GDPR, and their implications on database management.
• Problem Solving & Analytical Skills:
• Strong troubleshooting skills and the ability to analyze complex database issues.
• Excellent problem-solving skills, particularly in high-pressure, time-sensitive environments.

Preferred Qualifications:

• Education:
• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Relevant certifications (e.g., AWS Certified Solutions Architect, MySQL or PostgreSQL DBA certification) are a plus.
• Domain Knowledge:
• Experience working specifically within the fintech domain or financial services industry is highly desirable.
• Communication & Collaboration:
• Excellent written and verbal communication skills, with the ability to explain complex database concepts to non-technical stakeholders.
• Strong interpersonal skills to work effectively in a cross-functional, collaborative environment.