Remote Database Architect - UK

Description:

• As a Database Architect, you will be responsible for designing, optimizing, securing, and maintaining our database schema and infrastructure to support enterprise-class SaaS operations.
• The ideal candidate will have a strong background in database administration, design, architecture, performance optimization, security, and cloud database technologies.
• You will enhance our data architecture for scalability and efficiency, focusing on reliability, quality, security, efficiency, and automation.
• Your solutions will directly contribute to customer success and help drive TradeCentric’s next phase of growth.
• You will report to the Sr. Director of Architecture and work remotely.

What You'll Do:

• Maintain and optimize database schema and performance, ensuring high security, availability, and scalability.
• Implement and enforce database security and integrity best practices, access controls, and compliance policies such as GDPR and PCI-DSS.
• Develop, test, and maintain backup, replication, and disaster recovery strategies for business continuity.
• Set up and manage database monitoring tools, proactively addressing performance bottlenecks.
• Proactively analyze and optimize queries to enhance performance and reduce system load.
• Research, plan, and execute cloud database migrations between leading platforms including Amazon RDS and Google Cloud SQL.
• Develop automation scripts for database maintenance, monitoring, and infrastructure provisioning.
• Collaborate with engineering teams to design scalable, efficient, and well-structured databases, optimizing query and transaction processing.
• Guide and support the development of data pipelines and ETL processes.
• Work with developers, DevOps engineers, and product teams to align database strategies with business needs.

Requirements:

• You must be an effective communicator, positive team player, and natural collaborator.
• You should have 7-9 years of database administration experience in a SaaS environment.
• A Bachelor’s Degree in Computer Science, Engineering, or a related field is strongly preferred.
• You need expertise in MariaDB/MySQL on Amazon RDS and/or Google Cloud SQL, and ElasticSearch.
• A deep understanding and application of database security best practices, encryption, access control, and compliance requirements including GDPR is required.
• You should have experience implementing reliable backup, restore, and disaster recovery strategies.
• A proven track record of optimizing complex queries, indexing strategies, and caching mechanisms is necessary.
• You must have the ability to assist in the design of scalable and efficient database schemas.
• Experience in establishing database monitoring tools and processes is required.
• You should have experience in automation and infrastructure scripting using Python, Bash, or Terraform.
• Experience supporting or working with data pipeline architectures is necessary.
• You must have experience working with CI/CD pipelines and Infrastructure-as-Code (IaC).

Benefits:

• TradeCentric offers a health benefits reimbursement program to support employee well-being.
• Employees can benefit from a pension plan with a generous company match.
• A work-from-home allowance is provided to facilitate remote work.
• Flexible Time Off is available to promote work-life balance.
• Volunteer Time Off is offered to encourage community engagement.
• Paid Parental Leave is provided to support employees during family transitions.