Key Responsibilities:
● Database Administration & Optimization:
○ Manage, optimize, and monitor 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.
Required Skills and Qualifications:
● Experience:
○ 6+ years of experience in database administration with hands-on experience managing enterprise-level databases (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.
○ Basic idea 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.