Database Architect

Root Systems is seeking a versatile database expert to join our team and take charge of our movie database and data handling strategies. You will be responsible for designing, implementing, and maintaining our database architecture, ensuring data integrity, and optimizing query performance. Additionally, you will play a key role in shaping our overall data strategy as we scale our platform.

Responsibilities:

• Design and implement a robust, scalable database architecture for our movie metadata, with a focus on graph/node databases
• Develop and optimize database queries for efficient data retrieval and manipulation in both relational and graph databases
• Ensure data integrity, security, and compliance with relevant regulations
• Collaborate with the backend team to integrate the database with our API and services
• Implement data backup, recovery, and archiving processes
• Monitor and optimize database performance, troubleshoot issues, and implement solutions
• Contribute to the development of our data governance policies and best practices
• Assist in data migration and integration tasks as we expand our platform
• Stay up-to-date with the latest database technologies and trends, particularly in the graph database space

Required Skills:

• Strong proficiency in SQL and experience with relational databases (e.g., PostgreSQL, MySQL)
• Extensive experience with graph/node databases (e.g., Neo4j, Amazon Neptune)
• Deep understanding of graph data modeling, Cypher query language, and graph database optimization techniques
• Knowledge of database design principles, normalization, and indexing strategies
• Experience with database performance tuning, query optimization, and troubleshooting
• Familiarity with database security best practices and data protection regulations
• Understanding of data warehousing and ETL (Extract, Transform, Load) processes
• Ability to work with large datasets and develop efficient data processing workflows
• Experience with data modeling and schema design
• Familiarity with NoSQL databases (e.g., MongoDB, Cassandra) is a plus
• Proficiency in Python or another scripting language for data processing tasks
• Excellent problem-solving skills and attention to detail
• Good communication and collaboration abilities
• Experience with version control systems like Git
• Familiarity with DevOps principles and the ability to set up and manage your own test environments independently

Our tech stack includes PostgreSQL as our primary relational database and Neo4j for graph data management, with Python for data processing tasks. We are looking for someone who is passionate about data management, has strong experience with graph databases, enjoys optimizing database performance, and can help us build a solid foundation for our data infrastructure. If you have the right mix of database expertise, coding skills, and a strategic mindset, we'd love to hear from you. This is an exciting opportunity to play a key role in shaping our data architecture at a new startup.

Competitive salary and benefits package included.