Job Description

Below is Job description for SQL developer:

• Design, develop, and maintain MS SQL Server databases, including tables, stored procedures, functions, triggers, and indexes.
• Work with large and complex databases, ensuring high performance, scalability, and reliability.
• Perform query tuning and performance optimization using Execution Plans, indexing strategies, SQL Profiler, Activity Monitor, and tuning tools.
• Write efficient T-SQL, including dynamic SQL, CTEs, subqueries, temp tables, and advanced scripts for complex data processing.
• Handle JSON/XML parsing, data transformations, and integration with applications or APIs.
• Create and manage SQL Jobs, SSMS tasks, and automated schedules for system and data operations.
• Implement database security, backups, restores, and disaster recovery practices.
• Diagnose performance issues and resolve deadlocks, concurrency problems, and transaction-related challenges.
• Apply solid data modeling, ER design, normalization, and relational database concepts.
• Collaborate closely with developers, QA, and business teams to ensure data accuracy and system stability.
• Demonstrate strong analytical thinking and provide logical, efficient solutions to data challenges.