22 Aug
|
HealthAsyst
|
Bengaluru
22 Aug
HealthAsyst
Bengaluru
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 visualize database structure
- Design, plan, and develop programs to optimally extract, transform, and load data between data sources
📌 DB Developer (Bengaluru)
🏢 HealthAsyst
📍 Bengaluru