:
SQL Server architecture (memory management, IO, Backup-Restore mechanisms, High Availability options)
DB physical design structures: Table design, data types, Index design, Columnstore Index internals (mandatory!), functions, procedures, table partitioning and partition management
Manage and maintain database monitoring tools, backup software, and management agents to ensure system performance, data integrity, and availability. Proactively monitor, schedule backups, perform recovery tests, and update tools to support seamless and secure database operations.
Manage database consolidations and migrations from Oracle, MariaDB, and PostgreSQL. Configure and optimize monitoring setups using third-party tools to ensure performance, reliability, and smooth transition during projects.
Locking mechanisms
Query Performance Tuning: familiarity with Extended Events, Query Execution Plans,



Query Store and ability to use those to check and improve query performance.
SQL Server security configuration: Users and logins management, Audit, Certificates management, TDE
SQL Server Configuration Management: existing options and their meaning
Familiarity with Prometheus/Grafana stack to monitor MSSQL
Knowledge of python scripting is a plus.

Less significant skills (Basic knowledge is sufficient):
OpenShift/Kubernetes, Helm
Git, CI/CD
SaltStack (knowledge in this is a big plus), or other Desired State Configuration Management software.
Python Development with focus on data or automation
Experience with testing frameworks
Windows OS internals understanding
PowerShell straightforward coding for day-to-day activities

📌 Database Architect For Bangalore Bengaluru
🏢 RECEX
📍 Bengaluru