Our client is a fast-paced fintech company, and they are seeking motivated candidates for an exciting new opportunity. The ideal candidate will be available to start relatively quickly, with the option to begin on a fractional basis before transitioning to full-time. We are looking for individuals who are ready to hit the ground running and bring their expertise to the role.
To streamline the shortlisting and selection process, we require candidates to provide their expected annual compensation figures and availability when applying. Please note that applications without this information will not be considered.
Requirements:
Previous experience working in a Fintech/Financial Services or start-up
Excellent communication and collaboration skills
Works to deadlines and roadmaps
Innovative and can-do and must-do mentality
Demonstrable progressive proficiency in working with PostgreSQL (AWS RDS) database system
Strong knowledge of database design principles, including schema design, normalization, indexing, and data modelling. Ability to design efficient and scalable database structures
Understanding of database security principles, including authentication, authorization, encryption, and compliance with data protection regulations (e.g., GDPR)
Proficiency in using database management tools and monitoring solutions
Proficiency in database backup and recovery procedures to ensure data integrity and availability
Ability to monitor and optimize database performance using tools and techniques like query optimization, indexing, and caching
Expertise in IaC tools such as Terraform (HCL) to automate provisioning and management
Proficiency in scripting languages like Python and Shell to automate routine database and maintenance tasks
Strong analytical and problem-solving skills to diagnose and resolve database issues. Attention to detail is crucial to ensure data accuracy and maintain database integrity
Install, configure, and maintain PostgreSQL database systems in cloud infrastructure. Perform routine database maintenance tasks, including backups, restores, and updates. Implement data retention and archiving strategies
Collaborate with development teams to ensure seamless data operations and integration
Ensure data models are efficient, scalable, and follow best practices.
Implement and monitor database performance and identify bottlenecks and inefficiencies. Optimize SQL queries, indexing, and database configurations to improve performance
Establish and enforce database security policies, including authentication, authorization, and encryption. Ensure compliance with data protection regulations and industry standards
Set up and manage database backup and recovery procedures to protect data from loss or corruption. Perform regular backup testing and validation
Diagnose and resolve database-related issues, such as performance problems, data corruption, and access errors
Monitor database resource utilization and plan for capacity scaling to accommodate data growth
Plan and execute database system upgrades and apply patches and security updates as needed
Create and maintain comprehensive documentation of database configurations, processes, and best practices. Document troubleshooting procedures and resolutions