Database Designer

Job Title: Database Designer

Location: Bangalore

Job Type: Full-Time

Role Overview

We are seeking a highly skilled Senior Database Designer to join our innovative product team at TiaMeds Technologies. In this role, you will lead the design and implementation of robust database architectures that ensure high availability, scalability, and performance for our enterprise applications. You will collaborate closely with cross-functional teams to drive data strategy and influence architectural decisions that support our mission of transforming data into actionable insights.

Responsibilities

• Lead the design and implementation of high-performance database solutions, ensuring optimal data flow and accessibility
• Develop and enforce database standards, policies, and procedures to ensure data integrity and security
• Collaborate with application development teams to design data models and database schemas that meet business requirements
• Monitor and optimize database performance, implementing tuning and troubleshooting techniques as necessary
• Conduct data modelling exercises and facilitate discussions to gather requirements and translate them into effective database designs
• Stay abreast of emerging technologies and trends in database management, recommending innovative solutions that align with the company's goals

Required and Preferred Qualifications

• 5+ years of experience in database design and management, with a strong focus on relational and NoSQL databases
• Strong data modelling and schema design capabilities (ER modelling, normalization, indexing strategies).
• Proficiency in SQL scripting across major RDBMS platforms (e.g., PostgreSQL, MySQL, SQL Server, Oracle).
• Solid understanding of backup and recovery strategies, including point-in-time recovery and disaster recovery planning.
• Experience with multi-tenant and multi-server architectures, including data isolation, sharding, and replication strategies.
• Experience with data modelling tools and methodologies, including conceptual, logical, and physical data modelling
• Proven ability to lead database migration and upgrade projects, ensuring minimal downtime and data loss
• Strong understanding of database security principles and data governance best practices

Preferred:

• Experience with cloud-based database services (e.g., AWS RDS, Azure SQL Database, Google Cloud Spanner)
• Familiarity with data warehousing concepts and tools (e.g., Snowflake, Redshift, BigQuery)
• Knowledge of programming languages such as Python or Java for data manipulation and automation

Technical Skills and Relevant Technologies

• Expertise in database management systems such as PostgreSQL, MySQL, Oracle, or MongoDB
• Proficient in using database design and modelling tools like ERwin, Lucidchart, or similar

Soft Skills and Cultural Fit

• Strong analytical and problem-solving skills, with a keen attention to detail
• Excellent verbal and written communication skills, capable of conveying complex technical concepts to non-technical stakeholders
• Proactive and self-motivated, with the ability to work independently as well as collaboratively within a team
• A passion for mentoring and developing junior team members, fostering a culture of continuous learning.