Job Summary:
Qentelli Solutions is seeking a seasoned Database Architect (SQL Server) to join our dynamic technology team in Hyderabad. The ideal candidate will bring in-depth expertise in database development, SQL Server optimization, database design, data modeling, and performance tuning. You will be responsible for architecting, designing, and developing robust, scalable, and high-performance databases to support complex applications and business needs. A foundational understanding of cloud platforms (Azure or AWS) is expected.
Required Skills:
- Architect and design scalable, secure, and high-performance database solutions using Microsoft SQL Server.
- Lead end-to-end database development, including schema design, stored procedures, triggers, indexing, and performance optimization.
- Design and implement data models (conceptual, logical, and physical) to support business requirements.
- Conduct database performance tuning, query optimization, and capacity planning.
- Define and implement database best practices, development standards, and guidelines.
- Collaborate closely with application development teams, DevOps, and BI teams to integrate databases seamlessly into applications.
- Ensure high availability, backup, disaster recovery planning, and maintenance strategies are in place.
- Provide technical leadership, code reviews, and mentoring for database developers and junior team members.
- Participate in cloud readiness and migration projects, ensuring databases are optimized for cloud environments.
Mandatory Skills:
- 12-18 years of overall experience in database design and development, with primary expertise in Microsoft SQL Server.
- Proven experience in SQL Server Development T-SQL, stored procedures, views, triggers, UDFs, indexing, etc.
- Strong experience in data modeling (OLTP and OLAP), ERD tools, normalization, and schema design.
- Expertise in performance tuning query optimization, indexing strategies, and execution plan analysis.
- Proficient in database architecture design, capacity planning, and partitioning strategies.
- Hands-on experience with SSIS/SSRS or similar data integration and reporting tools.
- Exposure to cloud platforms like Azure SQL or Amazon RDS for SQL Server deployment, configuration, and basic troubleshooting.
- Excellent problem-solving, analytical, and communication skills.
Preferred Skills:
- Experience in cloud-native databases (Azure SQL, AWS RDS, or Aurora).
- Familiarity with CI/CD practices and integrating SQL code in DevOps pipelines.
- Exposure to NoSQL databases like MongoDB, Cosmos DB is an added advantage.
- Understanding of data governance, security best practices, and GDPR/Compliance considerations.
- Experience with Agile methodologies and working in cross-functional teams.
Qualifications:
- Bachelors or Master's degree in Computer Science, Information Technology, or a related field.
- Microsoft certifications (e.g., MCSE: Data Management and Analytics) are a plus.
