Senior Database Administrator at Bankly

Job Summary

• The Senior Database Administrator we need will play a critical role in designing (when necessary for new platforms), implementing, and maintaining Bankly's database systems.
• Their expertise will be essential in ensuring the availability, performance, security, and integrity of these databases.
• They will be collaborating with cross-functional teams and contribute to strategic decisions related to database architecture and management.

Key Responsibilities

Database Management

• Oversee the installation, configuration, and maintenance of various database systems, including relational, NoSQL, and cloud-based databases.
• Ensure high availability, performance, and scalability of databases by implementing best practices, tuning parameters, and optimizing query performance.
• Monitor database systems regularly to proactively identify and address issues, ensuring minimal downtime and maximum system uptime.

Security and Compliance

• Implement and enforce security measures to safeguard sensitive data and ensure compliance with industry regulations (e.g., GDPR, HIPAA) and organizational security policies.
• Manage access controls, user authentication, and data encryption to protect the confidentiality and integrity of the databases.
• Backup and Recovery:
• Develop and maintain backup and recovery strategies to ensure data preservation and disaster recovery readiness.
• Regularly test backup and recovery procedures to verify their effectiveness and reliability in case of system failures.

Database Design and Architecture

• Collaborate with application developers and data architects to design and optimize database schemas, ensuring efficient data storage and retrieval.
• Participate in capacity planning and scalability discussions to accommodate future data growth and system demands.

Performance Tuning and Optimization

• Analyze and optimize SQL queries, indexes, and database configurations to enhance overall system performance and response times.
• Identify and resolve bottlenecks and performance issues through query optimization and system tuning.

Development Operations (DevOps)

• Familiarity with CI/CD concepts and tools such as Git, AWS CodePipeline and Azure DevOps especially in relation to database deployment and management.

Automation and Scripting

• Develop scripts and automation tools to streamline routine database tasks, such as backups, maintenance, and monitoring.
• Implement proactive monitoring and alerting systems to detect and address potential issues before they impact users.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field (Master's preferred).
• Proven experience as a Database Administrator, with a focus on managing and optimizing large-scale databases.
• In-depth knowledge of primarily Microsoft SQL Server, MongoDB and PostgreSQL.
• Familiarity with other database management systems will be an advantage.
• Proficiency in SQL query optimization, performance tuning, and troubleshooting.
• Familiarity with cloud database services (Primarily AWS RDS, Google Cloud SQL will confer an advantage).
• Experience in database security, backup and recovery strategies, and disaster recovery planning.
• Strong scripting skills (e.g., SQL, Python, PowerShell) for automation and maintenance tasks.
• Excellent problem-solving skills and the ability to work effectively in a collaborative team environment.
• Strong communication skills to interact with technical and non-technical stakeholders.
• Relevant certifications such as AWS Certified Database(Specialty), MongoDB Certified DBA, etc., are a plus.