Principal Engineer - Database Design & Architecture (8-13 yrs)

Job Description :

Responsibilities :

- Lead the design, development, and implementation of complex database architectures, including relational, NoSQL and cloud-native databases.

- Develop and implement database best practices, including data modeling, schema design, indexing strategies, and query optimization.

- Ensure high availability, performance, and scalability of database systems through proactive monitoring, performance tuning, and capacity planning.

- Collaborate with software engineers, data scientists, and data analysts to understand their data needs and translate them into effective database solutions.

- Participate in all phases of the software development lifecycle, from requirements gathering and design to implementation, testing, and deployment.

- Mentor and guide junior engineers on database technologies, best practices, and problem-solving techniques.

- Stay abreast of the latest advancements in database technologies and industry best practices.

- Contribute to the development and improvement of our data platform and infrastructure.

Qualifications :

- 8+ years of professional experience in database engineering or a related field.

- Strong proficiency in SQL and experience with at least one major relational database system (PostgreSQL, MySQL, Oracle).

- Experience with NoSQL databases (MongoDB, Cassandra, Redis) and cloud-native databases (Amazon Aurora, Google Cloud SQL, Azure SQL) is a plus.

- Experience with data warehousing, data modeling, and ETL/ELT processes.

- Experience with database performance tuning, query optimization, and indexing strategies.

- Experience with database security best practices, including access control, encryption, and data masking.

- Experience with DevOps practices, including CI/CD, infrastructure-as-code, and containerization (Docker, Kubernetes).

- Strong analytical and problem-solving skills.

- Excellent communication and collaboration skills.

- Ability to work independently and as part of a team.