Career Position

Current Openings

MS SQL DBA

Function:
MS SQL DBA
Location:
Ahmedabad
Description:

 

-     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

 

Desired Profile:

 

-      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 - 7 Years

Apply to this job