Database Architect

Crew Kraftorz; Hyderabad; On-site; INR 4,500,000 - 7,500,000; Full time

Job summary

Crew Kraftorz is seeking a seasoned Database Architect to lead the design and development of scalable databases, shaping data models and optimizing queries to meet business goals.

You will mentor junior developers, oversee ETL processes, ensure data security and high availability, and collaborate with cross‑functional teams to implement robust SQL/NoSQL solutions, performance tuning, and disaster recovery planning.

Job description

Database Architect

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.

Mandatory Skills & Qualifications:

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.