Hiring SQL DBA | Ahmedabad

Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

Configure and maintain database servers and processes, including monitoring system health and performance to ensure elevated performance levels, availability, and Security.

Analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.

Assist developers with complex query tuning and schema refinement.

Performance Tuning and Optimization (PTO)

Prevention of Deadlock and Timeouts

Create a recovery model for disaster recovery.

Manage ETL tools and Migration of the database from one server to another.

Configure SQL databases on Azure cloud.

Configuration of the database for on-premises and cloud

Automation process for backup / restore / cleanup.

Configure alerts for any DB related issues.

Design indexing strategies

Review database changes and design new database

Maintain Database Access, Database Security and do an audit

Configure Database Software

Designing coding guideline for SQL programming


Skills

MS SQL Server 2019 with Azure cloud SQL database.

Strong Technical and Interpersonal Communication

Work Closely with Development Teams with Regards to Database Updates and Design

Must write SP, function, Triggers, Tables, View etc.

Performance Tuning and Optimization for database and server level

How to solve the performance bottleneck using Query Store

Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.

Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.

Good knowledge of Indexes, Execution plan and missing indexes

Must know the DMV to find the culprit.

Improve performance using wait statistics.

Knowledge of SQL Server Integration Service (SSIS)

Create automation process for daily tasks.

Must have knowledge of ETL.

Comfortable Working with Production Servers