Database Architect
- Qentelli
- 13 - 22 years
- Hyderabad
- 8 days ago
- Email to a friend
- Report this job
Job Description
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 SQL Server 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.
SQL Server Development:
- Design and write complex T-SQL queries, stored procedures, and triggers to support application development.
- 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 SQL Server databases, including installation, configuration, patching, and upgrades.
- Implement backup, restore, and disaster recovery strategies for databases.
- 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 SQL Server 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 SQL Server Development.
- Extensive experience in writing complex T-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.
Technical Skills:
- SQL Server (2012/2014/2016/2019) expertise, including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
- 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 Database Administration tasks, including installation, configuration, and performance monitoring.
- Ability to manage high availability and disaster recovery solutions for SQL Server environments.
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 SQL Database, AWS RDS).
- Experience in Data Modeling tools like Erwin, or similar.
- Familiarity with NoSQL databases like MongoDB or Cassandra.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Technical ArchitectEmployement Type: Full timeContact Details:
Company: QentelliLocation(s): Hyderabad
Keyskills: Architecture Database Design SQL Server Database Development Database Architect Database Administration Performance Optimization SQL Server Development SQL Development Ms Sql Development Performance Tuning Ms Sql Database
Similar positions
Qentelli
Qentelli at Glance:- Qentelli is a technology company that accelerates digital transformation and cloud transformation journeys through DevOps, Automation, Agile transformation, AI and Deep learning. Forrester recently recognized our efforts at using AI and ML in the augme...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in