36 D-Techworks Jobs

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.

2. 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.

3. 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.

4. 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.

5. 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.

6. Handling Transactions & Concurrency :

- Implement and manage transactions to ensure data consistency.

- Handle concurrency issues like deadlocks, blocking, and isolation levels.

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

8. Troubleshooting & Debugging :

- Identify and resolve database-related issues and errors.

- Debug T-SQL code and troubleshoot connectivity issues.

9. 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