Senior SQL Server DBA Data Modeling & Architecture

Job Description

We are seeking an experienced Senior SQL Server Database Administrator with strong expertise in data modeling, database architecture, and performance optimization
. The ideal candidate will design scalable data models, build robust database architectures, and manage SQL Server environments to ensure high availability, security, and optimal performance.

• Design conceptual, logical, and physical data models.
• Develop scalable OLTP/OLAP database architectures.
• Create and enforce data standards, naming conventions, and modeling best practices.
• Partner with application architects to align data design with system workflows.

• Install, configure, upgrade, and maintain SQL Server environments /Azure SQL).
• Administer Always On Availability Groups, clustering, log shipping, and replication.
• Manage backup/restore strategies and disaster recovery planning.

• Analyze and tune SQL queries, indexing strategies, statistics, and execution plans.
• Resolve locking/blocking issues, parameter sniffing, and resource bottlenecks.
• Implement partitioning, compression, and storage optimization techniques.

• Implement RBAC, TDE, Always Encrypted, auditing, and data masking.
• Maintain compliance with organizational and regulatory security standards.
• Ensure database hardening and controlled deployments.

• Automate repetitive tasks using Power Shell and T‑SQL scripts.
• Support CI/CD pipeline integration for database deployments.
• Build monitoring and alerting solutions for performance and health checks.

• Work closely with developers, architects, and data teams to improve database design.
• Review T‑SQL code and provide performance recommendations.
• Maintain documentation for data models, architecture diagrams, and DBA procedures.
• Mentor junior DBAs and contribute to data governance initiatives.

• 7-12 years of experience as a SQL Server DBA.
• Strong expertise in data modeling
  , normalization, and relational design.
• Solid understanding of OLTP and OLAP database structures.
• Advanced T‑SQL scripting and query optimization skills.
• Hands‑on experience with Always On AGs
  , clustering, and high‑availability solutions.
• Knowledge of Azure SQL, Managed Instance, and hybrid cloud environments.
• Proficiency with monitoring tools (e.g., Redgate, Sentry One, Solar Winds DPA).
• Strong analytical, communication, and problem‑solving abilities.

• Experience with ER modeling tools (ERwin, ER/Studio, Visio).
• Azure certifications (AZ‑900, DP‑300, DP‑203).
• Familiarity with Dev Ops pipelines (Azure Dev Ops, Git, CI/CD).
• Knowledge of ETL / Data Warehousing environments.