Newdream Data Systems
Website:
newdreamdatasystems.com
Job details:
Job Type: Full-Time
Experience: 4–8 Years
We are looking for skilled and experienced SQL Developers with strong expertise in Microsoft SQL Server, T-SQL development, database performance tuning, and query optimization.
Key Responsibilities:
• Design, develop, and maintain complex SQL queries, stored procedures, functions, views, and triggers.
• Perform SQL query optimization, execution plan analysis, and performance tuning.
• Work on indexing strategies, deadlocks, blocking, and database performance issues.
• Design and maintain database schemas, tables, and relationships.
• Develop and maintain ETL processes and perform data validation and reconciliation.
• Handle production support, troubleshooting, and database deployments.
Required Skills:
• Strong experience in Microsoft SQL Server and T-SQL.
• Expertise in Joins, CTEs, Subqueries, Window Functions, and Dynamic SQL.
• Strong knowledge of Stored Procedures, Functions, Views, and Triggers.
• Experience in Performance Tuning, Execution Plans, Indexing, and Deadlock Resolution.
• Knowledge of SQL Server Agent Jobs, Transactions, and Database Design.
• Experience with Git or other source control tools.
Good to Have:
• SSIS and ETL Development.
• Data Warehousing concepts (Fact Tables, Dimension Tables, SCD).
• SSRS / Power BI.
• Azure SQL Database / Azure Data Factory.
• CI/CD and database deployment practices.
Click on Apply to know more.