Analyze current database systems, including relational and non-relational databases, to identify inefficiencies, bottlenecks, and scalability issues.
Develop a comprehensive re-architecture plan that includes database schema redesign, index optimization, query optimization, and improved data models.
Lead initiatives to migrate databases to cloud platforms (AWS, Azure, Google Cloud, etc.) or hybrid cloud solutions, ensuring minimal downtime and data integrity.
Optimize the database for performance, ensuring faster query execution times, efficient indexing, and improved data access speed.
Ensure that all database re-architecture efforts comply with industry best practices for data integrity, privacy, and security, including encryption and backup strategies.
Work closely with software engineering teams, DevOps, and infrastructure teams to align database re-architecture efforts with overall system architecture and application goals.
Implement strategies for scaling the database to handle increasing load, and design systems for high availability and disaster recovery.
Create detailed documentation for the new database architecture, including data flow diagrams, schema changes, indexing strategies, and operational guides.
Stay updated with the latest database technologies and methodologies, recommending continuous improvements to the database architecture.
Provide guidance and support to internal teams on best practices for database design, performance tuning, and cloud-based database solutions.
What you offer:
Bachelor's or Master's degree in Computer Science, Information Systems, or related field.
5+ years of experience in database architecture, design, and administration.
Proven track record of leading large-scale database re-architecture projects.
Expertise in relational databases (e.g., MySQL, PostgreSQL, Oracle) and non-relational databases (e.g., MongoDB, Cassandra). QLIK, Goldengate
Hands-on experience with cloud platforms such as AWS, Azure, or Google Cloud, specifically in migrating and managing databases.
Deep understanding of database performance tuning, query optimization, and indexing strategies.
Strong knowledge of data security and privacy standards.
Experience with database replication, sharding, and high availability strategies.
Excellent problem-solving and communication skills.