Embedded Files
We are looking for a MS SQL developer who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work with other developers optimizing in-application SQL statements as necessary, and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.
How you can make a difference.
How you can make a difference.
Design, develop, and optimize complex stored procedures, functions, and triggers for performance and scalability.
Collaborate with developers to design efficient database schemas and write high-performance queries.
Analyze and optimize query execution plans, indexing strategies, and database partitioning to improve efficiency.
Troubleshoot and resolve performance bottlenecks in queries and stored procedures.
Implement best practices for data integrity, normalization, and indexing to ensure database efficiency.
Work closely with application developers to review and enhance database logic within applications.
Develop and maintain ETL processes using SSIS for data transformation and integration.
Assist in designing and implementing replication, partitioning, and archiving strategies for large datasets.
Provide expert-level SQL scripting support and mentor junior team members in writing efficient T-SQL.
Stay updated with emerging database technologies and best practices to enhance database performance.
What all you need.
What all you need.
5+ years of experience in Microsoft SQL Server development, focusing on stored procedures and database optimization.
Expert-level proficiency in T-SQL and writing complex stored procedures.
Strong knowledge of query optimization techniques, execution plans, and indexing strategies.
Experience in database normalization, table partitioning, and query tuning for large-scale applications.
Hands-on experience with SSIS (ETL), SSRS, and SSAS.
Familiarity with database performance monitoring tools and techniques.
Understanding of cloud-based database solutions (Azure SQL, AWS RDS)
Strong problem-solving and analytical skills.
Report abuse