Processq India logo

Database Architect - SQL Architect

Processq India

14 - 20 years

Hyderabad

Posted:1 day ago

Job Description

Role & responsibilities

Immediate Joiners Preferred Hyderabad

Job Title: SQL Server Database Architect

Work Location:

Job Summary

SQL Server Database Architect

The ideal candidate should be capable of designing scalable, high-performing, secure, and highly available database solutions while providing technical leadership and architectural guidance to development and infrastructure teams.

Key Responsibilities

  1. Design and define enterprise-level Microsoft SQL Server database architecture, standards, and best practices.
  2. Develop database strategies covering scalability, performance, availability, security, and disaster recovery.
  3. Architect and optimize complex database schemas, stored procedures, functions, views, and indexing strategies.
  4. Perform advanced SQL query optimization, execution plan analysis, and performance tuning.
  5. Design and implement High Availability (HA) and Disaster Recovery (DR) solutions.
  6. Work on SQL Server Always On Availability Groups, Failover Clustering, Replication, and Log Shipping.
  7. Define database backup, recovery, monitoring, and maintenance strategies.
  8. Identify and resolve complex database performance bottlenecks and production issues.
  9. Ensure database security, access management, auditing, and compliance with organizational standards.
  10. Collaborate with application architects, developers, DevOps, and infrastructure teams.
  11. Lead database migration, modernization, version upgrades, and cloud database initiatives.
  12. Provide technical leadership, mentor database developers and administrators, and review database designs.

Required Technical Skills

  • Strong expertise in Microsoft SQL Server architecture and database design.
  • Advanced knowledge of SQL, T-SQL, stored procedures, triggers, functions, and indexing.
  • Expertise in database performance tuning and query optimization.
  • Hands-on experience with SQL Server HA/DR solutions.
  • Knowledge of Always On Availability Groups, Replication, Clustering, and Log Shipping.
  • Strong understanding of database security, encryption, and access controls.
  • Experience with database backup, recovery, monitoring, and troubleshooting.
  • Experience in database migration, upgrades, and large-scale data management.
  • Knowledge of SQL Server on Azure / Azure SQL is an added advantage.
  • Exposure to automation, scripting, and DevOps practices for database deployments is desirable.

Candidate Profile

  • Strong analytical and problem-solving capabilities.
  • Ability to independently drive database architecture and technical decisions.
  • Excellent communication and stakeholder management skills.
  • Experience working with enterprise-scale applications and high-volume databases.
  • Ability to guide and mentor technical teams.

Location & Availability

  • Location:

    Hitech City, Hyderabad.
  • Work Mode:

    Candidates willing to work from office are preferred.
  • Joining:

    Immediate joiners or candidates serving notice with immediate availability will be preferred.

Interested candidates can share their updated resumes along with current location, total experience, relevant SQL Server experience, current CTC, expected CTC, and notice period.

Suggested experience level

–20 years of overall experience

This will help distinguish a genuine Database Architect from candidates whose experience is primarily limited to SQL Server DBA or database development.

Preferred candidate profile

Skills Required

Performance tuning Database migration Architecture Recovery SQL Server Query Tuning Optimization SQL

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Processq India logo
Processq India

RecommendedJobs for You

Processq India logo

Hyderabad

Processq India logo

Hyderabad