Ms SQL Dba - Ahmedabad, India - Prudent Corporate Advisory Services

Prudent Corporate Advisory Services

Verified Company

Ahmedabad, India

3 weeks ago

Posted by:

Deepika Kaur

beBee Recuiter

Function:

MS SQL DBA

Location:

Ahmedabad

Description:

Responsibilities:

Manage SQL Server databases through multiple product lifecycle environments, from development to missioncritical 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 realtime, providing problem resolution endtoend.
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 onpremises 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

Desired Profile:

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
Improve performance using wait statistics.
Knowledge of SQL Server Integration Service (SSIS)
Must have knowledge of ETL.

Experience:

3 to 7