Database Administrator

The ideal candidate will have at least 5 years of experience with Cassandra and MongoDB in production environments, as well as expertise in ensuring high uptime and performance for databases supporting critical business applications. Experience with RDBMS technologies and database automation is a plus. You will also be responsible for supporting the architecture, development, and deployment of NoSQL technologies, working closely with our engineering teams to meet the database needs of high-performance financial applications.

Key Responsibilities:

• Database Management & Reliability Engineering:
• Manage, support, and maintain NoSQL databases (Cassandra, MongoDB, Redis) in line with architectural guidelines and policies, ensuring they meet high availability and performance requirements.
• Collaborate with Database Reliability Engineering (DBRE) teams in the architecture, development, and deployment of database technologies in high-SLA environments.
• Support and manage RDBMS technologies as needed, ensuring consistent and reliable database performance.
• Database Administration for Mission-Critical Applications:
• Provide database administration for both off-the-shelf and internally developed applications, ensuring 24x7 operational availability and performance in support of mission-critical financial business applications.
• Participate in on-call rotation, offering support during database outages, incidents, or performance issues to minimize downtime and impact on business operations.
• Installation, Configuration & Maintenance:
• Install, configure, monitor, upgrade, and maintain MongoDB and Cassandra databases in both production and non-production environments to ensure continuous database health and optimal performance.
• Manage database patching, upgrades, and migrations while minimizing downtime and risk.
• Disaster Recovery & Backup:
• Participate in Database Maintenance activities, including disaster recovery (DR) planning, implementation, and testing, to ensure data durability and high availability.
• Assist with developing and implementing backup strategies and ensuring recovery time objectives (RTO) and recovery point objectives (RPO) are met.
• Automation & Scripting:
• Write and maintain OS-level scripts for database automation (e.g., backups, health checks, and application maintenance) to improve operational efficiency and reduce manual intervention.
• Develop automation solutions for database provisioning, scaling, monitoring, and alerting to reduce administrative overhead.
• Database Performance Tuning & Troubleshooting:
• Continuously monitor and optimize database performance for Cassandra, MongoDB, and Redis to ensure minimal latency and high throughput in high-traffic production environments.
• Diagnose, troubleshoot, and resolve complex database issues, including performance bottlenecks, query optimization, and resource contention.
• Collaboration with Engineering & Development Teams:
• Collaborate closely with development and engineering teams to ensure the successful integration of NoSQL technologies into new and existing applications.
• Provide guidance on best practices for database design, data modeling, and integration.
• Capacity Planning & Scalability:
• Perform proactive capacity planning for database systems to ensure the infrastructure scales effectively in response to growing data volumes and application demand.
• Ensure database systems can handle increased loads while maintaining high performance and availability.

Required Skills and Qualifications:

• At least 5 years of experience working with Cassandra in a high-availability production environment, including advanced database architecture, performance tuning, and troubleshooting.
• Strong experience with MongoDB and other NoSQL databases (e.g., Redis), with the ability to scale and optimize these technologies in demanding environments.
• Expertise in Database Reliability Engineering (DBRE), including managing distributed databases, ensuring continuous uptime, and implementing high-availability solutions in NoSQL databases.
• Experience with RDBMS technologies (e.g., MySQL, PostgreSQL, Oracle) is a plus.
• Hands-on experience with database automation and scripting (e.g., Bash, Python, etc.) to support ongoing database maintenance and operational efficiency.
• Proficiency in disaster recovery and backup strategies for mission-critical databases, including Cassandra and MongoDB.
• Solid experience with database monitoring tools (e.g., Prometheus, Grafana, Datadog) for tracking database performance, availability, and health metrics.
• Strong knowledge of data modeling, schema design, and performance tuning techniques specific to NoSQL databases.
• Familiarity with cloud environments (AWS, GCP, Azure) and their database services is a plus.
• Experience with financial industry regulations related to data security, compliance, and privacy is a strong advantage.
• Ability to troubleshoot complex issues in distributed database systems and propose effective solutions.
• Strong communication and collaboration skills, with the ability to work effectively with cross-functional teams (development, operations, engineering).