Database Developer SQL Server TSQL Queue Design

Job Title: Database Developer (SQL Server, T-SQL, Queue Design)

We are seeking a highly skilled Database Developer with expertise in SQL Server, T-SQL, performance tuning, query optimization, and queue design. The ideal candidate will focus on designing and optimizing database solutions to ensure high performance, scalability, and reliability.

Responsibilities:

�        Design, develop, and optimize T-SQL stored procedures, functions, and queries.

�        Implement performance tuning strategies to enhance database efficiency.

�        Develop and maintain queue-based processing solutions for scalable background processing.

�        Ensure error handling and retry mechanisms for resilient database operations.

�        Design database schemas and structures to support communication sets efficiently.

�        Perform query optimization to enhance data retrieval performance.

�        Collaborate with application developers to ensure seamless database integration.

�        Ensure data integrity, security, and compliance with best practices.

�        Troubleshoot and resolve database performance issues proactively.

 

Critical Skills to Possess:

�        6+ years of experience as a Database Developer with SQL Server.

�        Proficiency in data model design for microservices, database-based queue design, multitenant database, and schema design.

�        Strong experience in query optimization and performance tuning.

�        Expertise in T-SQL stored procedures, triggers, and functions.

�        Knowledge of queue design and processing mechanisms.

�        Understanding of database design best practices and indexing strategies.

�        Familiarity with scalable database architectures and high availability solutions.

�        Strong problem-solving skills and ability to work in a fast-paced environment.

 

Good-to-Have Skills:

�        Experience with cloud-based database services (AWS RDS, Azure SQL, etc.).

�        Knowledge of NoSQL databases (MongoDB, CosmosDB, etc.).

�        Experience in database security and encryption techniques.

Preferred Qualifications:

  • BS degree in Computer Science or Engineering or equivalent experience
Not sure where to start? Ask IVY.
IVY