21 Aug
|
HealthAsyst
|
Bengaluru
21 Aug
HealthAsyst
Bengaluru
Job Description
SQL Server Development/Programming, Performance Tuning, Indexing, Schema Design, TSQL(DDL & DML) scripts, stored procedures, functions and other database objects.
Scripting and Code management.
Minimum:
- Minimum 2+ years Experience on-
- Modernizing the old code, Advance Database coding, best practice.
- Code review and SQL query tuning
- Basic on Project Architecture level and data flow knowledge.
- Project level Data Auditing.
Must have experience with-
- SQL Server 2019 & 2022 and T-SQL in both OLAP and OLTP environments
- Experience in support in MS SQL Server environments. Must have experience on Tracing/debugging tool like SQL Profiler.
- Database Tuning/optimization and Monitoring, Performance tuning strategies and implementation.
- Design databases, ensuring high availability, business continuity, scalability, stability, security, performance and reliability to support business applications using MSSQL Server.
- Monitoring, tuning and performance optimization of OS/Storage/DB configuration/databases and related parameters like, table space utilization,
CPU utilization, Hard Disk Utilization,
- Performance tuning and query optimization experience using execution plans and performance tuning tools (eg, Perfmon, Pssdiag, Profiler, Extended Events and DMVs)
Good To Have:
- Experience with an agile development methodology, preferably Scrum.
- SSIS, SSRS other ETL, Valuable data Analysis skills and reporting knowledge.
- Experience in Data Modelling, Database design and we'll versed with SQL Server best practices
- Understand reporting requirements and map to Data Models
- Engage with ETL Developers to create or design extracts that feed visualizations
- Hands on experience in ETL tools for data flow transfer and management, Should have command on DDL and DML.
- Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations.
- Worked in Data Warehousing, Data Modeling
- Data modeling to visu
📌 DB Developer (Bengaluru)
🏢 HealthAsyst
📍 Bengaluru