Mandatory skills : T-SQL, Stored Procedure ,Index ,Advanced SQL ,Joins

Roles And Responsibilities

Database Development :

• Design, develop, and maintain SQL Server databases.
• Write complex T-SQL queries, stored procedures, functions, triggers, and views.
• Implement business logic using T-SQL to process and manipulate data.
• Query Optimization & Performance Tuning :
• Optimize T-SQL queries for better performance using indexing, execution plans, and query refactoring.
• Identify and resolve slow-running queries and performance bottlenecks.
• Use SQL Profiler, Extended Events, and DMVs to analyze and improve query execution times.
• Data Modeling & Database Design
• Design normalized and denormalized database schemas based on business requirements.
• Define relationships, constraints, and indexes to improve data integrity and performance.
• Work with Entity-Relationship Diagrams (ERDs) and data modeling tools.
• Database Administration (DBA) Tasks :
• Manage database security, roles, and permissions.
• Perform backup and restore operations to ensure data safety.
• Monitor database health using SQL Server Management Studio (SSMS) and other monitoring tools.
• Data Integration & ETL Development :
• Develop and maintain ETL (Extract, Transform, Load) processes using T-SQL and SSIS (SQL Server Integration Services).
• Work with external data sources like APIs, flat files, or linked servers.
• Handling Transactions & Concurrency :
• Implement and manage transactions to ensure data consistency.
• Handle concurrency issues like deadlocks, blocking, and isolation levels.
• Reporting & Data Analysis :
  
  

Create stored procedures and queries for reporting tools like Power BI, SSRS (SQL Server Reporting Services), or Excel.

Assist in generating business reports and dashboards by providing optimized data sets.

• Troubleshooting & Debugging :
• Identify and resolve database-related issues and errors.
• Debug T-SQL code and troubleshoot connectivity issues.
• Collaboration & Documentation :
• Work closely with developers, business analysts, and data engineers to understand business needs.
• Document database structures, procedures, and best practices for future reference.
• Participate in code reviews and provide feedback on T-SQL scripts.
  
  

Required Skills For a T-SQL Developer

• Proficiency in T-SQL (writing efficient queries, stored procedures, triggers, views, and functions).
• Understanding of indexing, query execution plans, and performance tuning.
• Experience with SQL Server tools (SSMS, Profiler, Execution Plans, Extended Events).
• Knowledge of database normalization, relationships, and data integrity constraints.
• Experience in ETL processes and working with SSIS is a plus.
• Familiarity with reporting tools like Power BI or SSRS.
• Basic understanding of database administration and security.
  
  

Required Qualifications

Bachelor's degree in Computer Science, Information Technology, or a related field

• 5-8years of experience as a TSQL Developer or Database Developer
• Demonstrated proficiency in writing optimized T-SQL code, including advanced concepts like window functions, CTEs, and sub-queries
• Strong understanding of database design principles and data normalization
• Familiarity with SQL Server database administration and maintenance tasks
• Experience integrating databases with business applications
  
  

Preferred Qualifications

• Experience with cloud-based data platforms like Microsoft Azure SQL Database
• Knowledge of data modeling techniques and schema design
• Familiarity with BI tools and data visualization best practices
• Understanding of software development life cycle and Agile methodologies
• Excellent problem-solving and analytical skills
  
  

(ref:hirist.tech)