D-TechWorks - T-SQL Developer (3-7 yrs)

Job Description :

Responsibilities :

- Design, develop, and optimize complex SQL queries and stored procedures

- Implement efficient indexing strategies to improve database performance

- Participate in database design and data modeling activities

- Collaborate with cross-functional teams to understand business requirements

- Provide technical guidance and mentorship to junior developers

- Troubleshoot and resolve production issues related to database performance

Database Design and Modeling :

- Analyze business requirements and translate them into an efficient database schema.

- Design logical and physical data models, ensuring data integrity, normalization, and scalability.

- Collaborate with stakeholders to refine the database structure and address any concerns.

T-SQL Development :

- Write and optimize complex T-SQL queries for data retrieval, manipulation, and management.

- Develop stored procedures, functions, triggers, and views to encapsulate business logic and improve performance.

- Implement error handling, logging, and exception management in your T-SQL code.

- Ensure code readability, maintainability, and adherence to best practices.

Performance Optimization :

- Analyze and optimize SQL queries for improved performance, including the use of indexes, query plans, and SQL Server features.

- Implement database design patterns, such as partitioning, indexing, and denormalization, to enhance performance.

- Monitor and troubleshoot database performance issues, identifying and resolving bottlenecks.

Database Automation and Scripting :

- Develop and maintain database automation scripts for tasks like database deployments, backups, and routine maintenance.

- Utilize SQL Server Management Studio (SSMS) or other tools to create and execute SQL scripts for various administrative tasks.

- Automate repetitive database operations to improve efficiency and reduce the risk of human error.

Database Administration and Maintenance :

- Assist in the administration of database servers, including user management, security configuration, and backup/restore procedures.

- Participate in database maintenance activities, such as index rebuilds, statistics updates, and log file management.

- Collaborate with the database administration team to ensure the overall health and stability of the database environment.

Collaboration and Documentation :

- Communicate effectively with cross-functional teams, including business analysts, project managers, and other developers.

- Document your work, including database schema, SQL code, and any relevant design decisions or best practices.

- Participate in code reviews, knowledge-sharing sessions, and technical discussions to foster continuous improvement.

Troubleshooting and Problem-Solving :

- Investigate and resolve database-related issues, such as data integrity problems, performance bottlenecks, or application-specific errors.

- Analyze and interpret database logs, performance counters, and other monitoring data to identify the root causes of problems.

- Provide technical support and guidance to end-users or other development teams regarding database-related concerns.

Required Qualifications :

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

- 3-5 years 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

- Strong communication and collaboration abilities.