No more applications are being accepted for this job

Hiring SQL Dba Ahmedabad - Vagaro Technologies Private Limited

Vagaro Technologies Private Limited

Verified Company

Ahmedabad, India

1 month ago

Posted by:

Deepika Kaur

beBee Recuiter

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

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

Vagaro Technologies