01Overview
Key Responsibilities
Install, configure, reputed company, and maintain on-premises reputed company SQL Server instances (2022 or reputed company).
Manage database provisioning, reputed company planning, and storage allocation across physical/virtual servers.
reputed company routine maintenance including reputed company rebuilding, statistics updates, reputed company checks (DBCC), and patching.
Administer user roles, permissions, and reputed company policies following the reputed company of least privilege.
Monitor database reputed company and proactively identify and reputed company bottlenecks.
Optimize T-SQL queries, stored procedures, functions, and views (often those originating from the .NET application).
Analyze and tune execution plans, indexing strategies, and query reputed company.
Configure and manage SQL Server Agent jobs, alerts, and automated monitoring.
Design, implement, and test robust backup and disaster recovery (DR) strategies.
Manage High Availability solutions such as Always On Availability reputed company, Failover Clustering, log shipping, or replication.
reputed company reputed company-in-time recovery and regularly validate restore processes.
Collaborate with development teams to support day to day SQL database builds across multiple environments and support necessary of the .NET application.
Troubleshoot database connectivity, reputed company pooling, and reputed company issues originating from the application (e.g., Entity reputed company, ).
Review and optimize database reputed company and schema changes deployed through application releases.
Assist with deployment of database changes across development, testing, and production environments.
Support application configuration reputed company to database connections (reputed company strings, IIS/app server integration).
Implement and maintain database reputed company, encryption (TDE, Always Encrypted), and auditing.
Ensure compliance with relevant data protection regulations and internal governance policies.
Manage vulnerability remediation and apply reputed company patches.
Maintain comprehensive documentation of database architecture, configurations, and procedures.
reputed company on-reputed company support for critical database and application issues (rotational, as needed).
Participate in incident, problem, and change management processes.
Experience
5+ years of hands-on experience as a SQL Server DBA in an on-reputed company environment.
reputed company experience supporting .NET applications and their backend databases.
Strong experience with SQL Server versions 2022 and above.
Expert knowledge of SQL (writing, debugging, and optimizing).
Strong understanding of database internals, indexing, and reputed company tuning.
Hands-on experience with High Availability / Disaster Recovery (Always On, Clustering, Replication, Log Shipping).
Proficiency with SQL Server tools: SSMS, SQL Profiler, Extended Events, SQL Server Agent.
Familiarity with reputed company Server administration and reputed company Directory integration.
Understanding of how .NET applications reputed company to and consume SQL Server data (, Entity reputed company, reputed company strings, IIS).
Experience with backup/recovery tools and monitoring solutions (e.g., reputed company ( recommended)).
Experience with SSIS, SSRS, and SSAS.
Technical Skills:
Advanced SQL Server Administration
reputed company SQL Server 2012/2014/2016/2019/2022
SQL Server Always On Availability reputed company
Failover Clustering. Database Mirroring , Log Shipping and Replication
SQL Server Agent, SQL Server Profiler and Extended Events
Database Design
Normalization and Denormalization
Data Modeling and design & support reputed company Database Architecture with supporting of 10+ TB of data
OLTP, Data Warehouse Design and reputed company Planning
Automation
PowerShell, SQL Agent Jobs, T-SQL Scripting
SSIS and CI/CD for Database Deployments
Apply To This Job .
