Database Architect

Qentelli; Hyderabad; On-site; INR 6,000,000 - 10,000,000; Full time

Job summary

Qentelli is seeking a seasoned Database Architect to lead database development and design efforts across SQL Server, PostgreSQL, and MongoDB. You will mentor a team, enforce best practices, review schemas, and optimize queries while aligning solutions with business goals.

The role requires deep expertise in RDBMS development, database administration, data security, and cross-functional collaboration to deliver scalable, high-performance data systems.

Qualifications

• Minimum 12+ years of experience in Database Development and Design with hands-on PostgreSQL / MS SQL Server / MySQL and MongoDB.
• Extensive experience in writing complex SQL queries, stored procedures, views and triggers.
• Strong knowledge of database normalization, indexing, and query optimization techniques.
• Proven experience in database architecture design and building scalable databases.

Responsibilities

• Lead design, implementation, and maintenance of efficient database structures and data models.
• Design scalable, high-performance databases in collaboration with cross-functional teams.
• Review and optimize database schemas and relationships for performance.

Skills

Database architecture

Team leadership

Mentoring

SQL

Query optimization

Data security

Communication

Tools

SQL Server

PostgreSQL

MongoDB

SSIS/SSRS/SSAS

Git

Erwin

Job description

Role & responsibilities

Job Summary: We are seeking a highly skilled Database Architect with extensive experience in Database Development and Database Design to join our dynamic team. The ideal candidate should have a strong foundation in RDBMS Development, coupled with a solid understanding of Database Administration. This role will involve leading database development initiatives, ensuring best practices, and mentoring junior developers. You will play a critical role in shaping the database architecture, optimizing queries, and implementing effective database solutions in alignment with business goals.

Key Responsibilities:

Database Development & Design:

• Lead the design, implementation, and maintenance of efficient database structures and data models.
• Work closely with cross-functional teams to design scalable, high-performance databases.
• Review and optimize database schema, relationships, and structures for improved performance.

Database Development:

• Design and write complex SQL queries, stored procedures, functions, different types of indexes and triggers to support application development using RDBMS and NoSQL.
• Implement performance tuning and query optimization techniques.
• Develop and maintain ETL processes to ensure data accuracy, transformation, and loading from multiple sources.

Database Administration:

• Assist in the overall administration of RDBMS databases and NoSQL databases, including database configuration, replication, sharding and disaster recovery strategies.
• Monitor and troubleshoot database issues, ensuring minimal downtime and high availability.

Team Leadership & Mentoring:

• Lead a team of database developers, providing guidance on best practices and technical expertise.
• Collaborate with developers and stakeholders to translate business requirements into robust database solutions.
• Ensure that junior developers follow coding standards and practices.

Data Security & Compliance:

• Enforce data security measures, ensuring that sensitive data is properly handled and compliant with regulatory standards.
• Implement user roles, permissions, and auditing within database to control access.

Collaboration & Stakeholder Management

• Collaborate with project managers, architects, and stakeholders to gather requirements and deliver database solutions that align with business objectives.
• Prepare and deliver presentations on database solutions and best practices.

Performance Optimization:

• Continuously evaluate and optimize database performance by identifying and resolving bottlenecks and improving query performance.
• Use tools like SQL Profiler, Execution Plans, and Indexing Strategies to enhance database performance.

Documentation & Reporting:

• Create detailed documentation on database designs, structures, and processes.
• Provide regular status reports to leadership regarding ongoing database initiatives.

Preferred candidate profile

Experience:

• Minimum 12+ years of experience in Database Development and Database Design, with a strong track record in Database Development preferable PostgreSQL / MS SQL Server / MySQL and MongoDB.
• Extensive experience in writing complex SQL queries, stored procedures, functions, views, and triggers.
• Strong knowledge of database normalization, indexing, and query optimization techniques.
• Proven experience in database architecture design and building scalable databases

Technical Skills:

• SQL Server, including Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• PostgreSQL with extensions like dblink, pg_cron, foreign data wrapper, etc.
• MongoDB with sharding technique, different types of indexes
• Experience with database performance tuning and troubleshooting. Knowledge of ETL processes, data migration, and data warehousing concepts.
• Expertise in database security, backup, recovery, and disaster recovery planning.
• Proficiency in version control tools like Git or similar.

Database Administration:

• Strong understanding of SQL Server / PostgreSQL Database Administration tasks, including configuration and performance monitoring.
• Ability to manage high availability and disaster recovery solutions.

Leadership & Communication:

• Proven experience in leading a team of database developers.
• Strong communication skills, capable of collaborating with business and technical teams effectively.
• Ability to mentor and guide junior developers.

Preferred Skills:

• Experience with cloud-based databases (e.g., Azure, AWS RDS).
• Experience in Data Modeling tools like Erwin, or similar.
• Familiarity with NoSQL databases like MongoDB.