Database Developer - RDBMS (7-10 yrs)

Job Title : Senior Database Developer

Location : Bangalore, India

Experience : 7-10 years

Position Overview :

We are seeking a skilled and innovative Database Developer with expertise in Relational Database Management Systems (RDBMS), NoSQL databases, and emerging Vector databases. The ideal candidate will design, develop, and optimize database solutions to meet our application needs, ensuring high performance, scalability, and reliability. This role involves working with various database technologies and collaborating with cross-functional teams to implement modern data storage solutions.

Key Responsibilities :

Database Design and Development :

- Design and implement database schemas for RDBMS (PostgreSQL, MS SQL Server).

- Implement vector databases for AI/ML applications (e.g., PGVector, Pinecone, Milvus).

- Develop and maintain NoSQL databases (e.g., MongoDB, Cassandra).

Query Optimization and Performance Tuning :

- Write and optimize complex SQL queries, stored procedures, and triggers.

- Analyze query performance and implement indexing strategies.

- Optimize NoSQL data models and queries for high-throughput and low-latency workloads.

Database Administration :

- Set up and configure database instances across RDBMS, NoSQL, and Vector database platforms.

- Monitor database health, performance, and storage capacity.

- Implement backup and disaster recovery solutions.

Collaboration and Documentation :

- Work closely with software engineers, data scientists, and product teams to understand database requirements.

- Document database designs, schemas, and operational processes.

Security and Compliance :

- Implement security best practices for databases, including encryption, role-based access, and auditing.

- Ensure compliance with data protection & privacy regulations (e.g., GDPR, HIPAA).

Required Skills :

Experience :

- 7- 10 years of experience with RDBMS (e.g., MySQL, PostgreSQL, Oracle, or SQL Server).

- Hands-on experience with NoSQL databases (e.g., MongoDB, Cassandra).

- Knowledge of vector databases (e.g., PGvector, Pinecone, Milvus) and their integration with AI/ML workflows.

Technical Skills :

- Proficient in SQL and NoSQL query languages.

- Strong understanding of database indexing, sharding, and replication.

- Experience with database orchestration tools (e.g., Flyway, Liquibase).

Problem-Solving :

- Strong analytical skills for troubleshooting database issues and optimizing performance.

Communication :

- Excellent verbal and written communication skills.

Preferred Skills :

- Experience with graph databases (e.g., Neo4j, Arango DB).

- Familiarity with large-scale data processing tools (e.g., Apache Spark, Kafka).

- Knowledge of AI/ML integration with vector databases.

- Certification in database technologies