Database Administrator (remote)

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.